{"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"name":"python","version":"3.10.14","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"},"kaggle":{"accelerator":"none","dataSources":[{"sourceId":81933,"databundleVersionId":9643020,"sourceType":"competition"}],"dockerImageVersionId":30804,"isInternetEnabled":true,"language":"python","sourceType":"notebook","isGpuEnabled":false}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"markdown","source":"Hello Kaggle comunity, in this time im gona try again a new notebook to pratice mi skils in data science.\nThere are less than 20 day until this competition ends and thats why i belief this is my last notebook of this competition, an thats why i want to put all my effor to conclude the project with a good resul or in instance a good information that we can get to our minds beause i think that this kind of work is for find the truth about the that.\n\n","metadata":{}},{"cell_type":"markdown","source":"# Investigation question.\n\nfirst of all I know that the competition has a purposo but the data give to us some kind a information that can give to use a useful concluson to our lives.\n\nThere is a question that i want to answer:\n\nThe consumption of internet have a significat impact in the quality sleep, academic, emotional, social and fisic?","metadata":{}},{"cell_type":"markdown","source":"# Prepare the dataset","metadata":{}},{"cell_type":"code","source":"import matplotlib.pyplot as plt","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2024-12-03T05:34:01.431628Z","iopub.execute_input":"2024-12-03T05:34:01.432200Z","iopub.status.idle":"2024-12-03T05:34:01.466563Z","shell.execute_reply.started":"2024-12-03T05:34:01.432159Z","shell.execute_reply":"2024-12-03T05:34:01.465456Z"}},"outputs":[],"execution_count":null},{"cell_type":"code","source":"import pandas as pd\ntrain = pd.read_csv('/kaggle/input/child-mind-institute-problematic-internet-use/train.csv')\ntest = pd.read_csv('/kaggle/input/child-mind-institute-problematic-internet-use/test.csv')","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2024-12-03T05:34:22.974367Z","iopub.execute_input":"2024-12-03T05:34:22.974786Z","iopub.status.idle":"2024-12-03T05:34:23.031609Z","shell.execute_reply.started":"2024-12-03T05:34:22.974749Z","shell.execute_reply":"2024-12-03T05:34:23.030126Z"}},"outputs":[],"execution_count":null},{"cell_type":"code","source":"# Crear histogramas para todas las variables del DataFrame\ntrain.hist(bins=10, figsize=(20, 16))\nplt.tight_layout()\nplt.show()","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2024-12-03T05:35:30.878261Z","iopub.execute_input":"2024-12-03T05:35:30.878635Z","iopub.status.idle":"2024-12-03T05:35:41.374254Z","shell.execute_reply.started":"2024-12-03T05:35:30.878604Z","shell.execute_reply":"2024-12-03T05:35:41.373127Z"}},"outputs":[],"execution_count":null},{"cell_type":"code","source":"#Contar valores  nulos por cada variable\nnull_counts = train.isnull().sum()\nprint(null_counts)\nnull_counts.to_excel('/kaggle/working/null_counts.xlsx')","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2024-12-03T05:40:47.619186Z","iopub.execute_input":"2024-12-03T05:40:47.620159Z","iopub.status.idle":"2024-12-03T05:40:48.000462Z","shell.execute_reply.started":"2024-12-03T05:40:47.620118Z","shell.execute_reply":"2024-12-03T05:40:47.999377Z"}},"outputs":[],"execution_count":null},{"cell_type":"code","source":"null_counts.plot(kind='bar',figsize=(20,16))\nplt.xlabel('variables')\nplt.ylabel('numero de datos nulos')\nplt.title('Datos nulos por variable')\nplt.show()","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2024-12-03T05:44:43.755141Z","iopub.execute_input":"2024-12-03T05:44:43.755531Z","iopub.status.idle":"2024-12-03T05:44:44.621553Z","shell.execute_reply.started":"2024-12-03T05:44:43.755496Z","shell.execute_reply":"2024-12-03T05:44:44.620464Z"}},"outputs":[],"execution_count":null}]}