{"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 pandas as pd\nimport numpy as np\nimport matplotlib.pyplot as plt","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"my_data=pd.read_csv(\"/kaggle/input/tlvmc-parkinsons-freezing-gait-prediction/events.csv\")\nmy_data.head()","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"data=pd.DataFrame(my_data)\ndata","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_Turn = data.loc[data['Type'] == 'Turn']\nprint(df_Turn)","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_Turn=df_Turn.drop(['Init','Completion', 'Kinetic'], axis=1)\ndf_Turn  ","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_Walking = data.loc[data['Type'] == 'Walking']\ndf_Walking=df_Walking.drop(['Init','Completion', 'Kinetic'], axis=1)\ndf_Walking  ","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_Hesitation = data.loc[data['Type'] == 'StartHesitation']\ndf_Hesitation=df_Hesitation.drop(['Init','Completion', 'Kinetic'], axis=1)\ndf_Hesitation  ","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_Walking.rename(columns = {'Type':'Walking'}, inplace = True)\ndf_Walking","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_Hesitation.rename(columns = {'Type':'StartHesitation'}, inplace = True)\ndf_Hesitation","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_Turn.rename(columns = {'Type':'Turn'}, inplace = True)\ndf_Turn","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"result=pd.merge(df_Hesitation,df_Turn,how=\"outer\",on=\"Id\")\nprint(result)\n","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"result1=pd.merge(result,df_Walking,how=\"outer\",on=\"Id\")\nresult1\n","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"result1.to_csv(\"submission.csv\",index=None)","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"pd.read_csv(\"submission.csv\")","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]}]}