{"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"pygments_lexer":"ipython3","nbconvert_exporter":"python","version":"3.6.4","file_extension":".py","codemirror_mode":{"name":"ipython","version":3},"name":"python","mimetype":"text/x-python"}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"code","source":"import matplotlib.pyplot as plt\nimport seaborn as sns\nimport numpy as np\n\nimport pandas as pd","metadata":{"execution":{"iopub.status.busy":"2022-08-19T16:06:12.175883Z","iopub.execute_input":"2022-08-19T16:06:12.176254Z","iopub.status.idle":"2022-08-19T16:06:12.867946Z","shell.execute_reply.started":"2022-08-19T16:06:12.176220Z","shell.execute_reply":"2022-08-19T16:06:12.866589Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df = pd.read_csv('../input/big-data-derby-2022/nyra_2019_complete.csv', low_memory=False)","metadata":{"execution":{"iopub.status.busy":"2022-08-19T16:06:12.870131Z","iopub.execute_input":"2022-08-19T16:06:12.870634Z","iopub.status.idle":"2022-08-19T16:06:30.140644Z","shell.execute_reply.started":"2022-08-19T16:06:12.870586Z","shell.execute_reply":"2022-08-19T16:06:30.139605Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":" #                                                  Data Distribution","metadata":{}},{"cell_type":"markdown","source":"# 1.Data distribution of \"race_type\"","metadata":{}},{"cell_type":"code","source":"sns.set_style(\"whitegrid\")\nsns.catplot(x='race_type',data=df, kind = 'count')\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2022-08-19T16:06:30.141857Z","iopub.execute_input":"2022-08-19T16:06:30.142705Z","iopub.status.idle":"2022-08-19T16:06:43.306803Z","shell.execute_reply.started":"2022-08-19T16:06:30.142654Z","shell.execute_reply":"2022-08-19T16:06:43.304395Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"# 2. Data distribution of \"course_type\"","metadata":{}},{"cell_type":"code","source":"sns.countplot(data=df, x='course_type',hue= 'course_type')\n\n\nplt.show()\n","metadata":{"execution":{"iopub.status.busy":"2022-08-19T16:06:43.310934Z","iopub.execute_input":"2022-08-19T16:06:43.312008Z","iopub.status.idle":"2022-08-19T16:06:51.214553Z","shell.execute_reply.started":"2022-08-19T16:06:43.311936Z","shell.execute_reply":"2022-08-19T16:06:51.213108Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"# 3. Data distribution of \"track_condition\"","metadata":{}},{"cell_type":"code","source":"sns.catplot(data=df, x='track_condition',kind= 'count')\n\n\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2022-08-19T16:06:51.216091Z","iopub.execute_input":"2022-08-19T16:06:51.216458Z","iopub.status.idle":"2022-08-19T16:07:05.282865Z","shell.execute_reply.started":"2022-08-19T16:06:51.216426Z","shell.execute_reply":"2022-08-19T16:07:05.281509Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"# 4. Data distribution of \"track_id\"","metadata":{}},{"cell_type":"code","source":"sns.catplot(data=df, x='track_id',kind= 'count')\n\n\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2022-08-19T16:07:05.284567Z","iopub.execute_input":"2022-08-19T16:07:05.285081Z","iopub.status.idle":"2022-08-19T16:07:15.967100Z","shell.execute_reply.started":"2022-08-19T16:07:05.285047Z","shell.execute_reply":"2022-08-19T16:07:15.965738Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"# correlation among  variables","metadata":{}},{"cell_type":"markdown","source":"# Correlation between \"weight_carried\" and \"odds\"","metadata":{}},{"cell_type":"code","source":"sns.scatterplot(x ='weight_carried' ,y='odds',data = df,hue = 'track_id')\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2022-08-19T16:07:15.968776Z","iopub.execute_input":"2022-08-19T16:07:15.969273Z","iopub.status.idle":"2022-08-19T16:09:20.646818Z","shell.execute_reply.started":"2022-08-19T16:07:15.969224Z","shell.execute_reply":"2022-08-19T16:09:20.645178Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"# Correlation between \"weight_carried\" and \"purse\"","metadata":{}},{"cell_type":"code","source":"sns.scatterplot(x ='weight_carried' ,y='purse',data = df,hue = 'track_id')\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2022-08-19T16:09:20.648265Z","iopub.execute_input":"2022-08-19T16:09:20.648921Z","iopub.status.idle":"2022-08-19T16:11:22.325110Z","shell.execute_reply.started":"2022-08-19T16:09:20.648884Z","shell.execute_reply":"2022-08-19T16:11:22.323826Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"# Correlation between \"purse\" and \"odds\"","metadata":{}},{"cell_type":"code","source":"sns.scatterplot(x ='purse' ,y='odds',data = df,hue = 'track_id')\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2022-08-19T16:11:22.327500Z","iopub.execute_input":"2022-08-19T16:11:22.328254Z","iopub.status.idle":"2022-08-19T16:13:24.789444Z","shell.execute_reply.started":"2022-08-19T16:11:22.328192Z","shell.execute_reply":"2022-08-19T16:13:24.788065Z"},"trusted":true},"execution_count":null,"outputs":[]}]}