{"cells":[{"metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","trusted":true},"cell_type":"code","source":"import numpy as np\nimport pandas as pd\nimport matplotlib.pyplot as plt","execution_count":null,"outputs":[]},{"metadata":{"_uuid":"4e5e3cfba47735d18fd2600098de3919f4854d90"},"cell_type":"markdown","source":"**EXTRACTING, CLEANING TRAINING DATASET**"},{"metadata":{"trusted":true,"_uuid":"dfd121c198225d763db350cc9cbb046b459b34ef"},"cell_type":"code","source":"df=pd.read_csv(\"../input/train.csv\")","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"b8d0d9686cd604fac8aa6d1c7ac70f5732504ad4"},"cell_type":"code","source":"df.replace('male',0,inplace= True)\ndf.replace('female',1,inplace= True)","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"5556ab84fc8df79e998e3c4f11975a26c874a871"},"cell_type":"code","source":"for dataset in range(len(df)):\n    df['title']=df['Name'].str.extract('([A-Za-z]+)\\.',expand=False)","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"dc81ed3445d8af58b1f9814e253eb51ac2a5cecb"},"cell_type":"code","source":"df['title'].value_counts()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"edab1f1482768a861cd5f9dc69869c8e73b6c747"},"cell_type":"code","source":"title_mapping={\"Mr\":0,\"Miss\":1,\"Mrs\":2,\"Master\":3,\"Dr\":3,\"Rev\":3,\"Col\":3,\"Mlle\":3,\"Major\":3,\"Don\":3,\"Lady\":3,\"Capt\":3,\"Jonkheer\":3,\"Sir\":3,\"Countess\":3,\"Mme\":3,\"Ms\":3,\"Name\":3}\ndf['title']=df['title'].map(title_mapping)","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"a6d486606916d228a8f085d5803d58c2bd5755e2"},"cell_type":"code","source":"df.isnull().any(axis=0)","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"fc19c1e25d11ea7f72c092c80978628e37d5d052"},"cell_type":"code","source":"df['Age'].fillna(df.groupby('title')['Age'].transform(\"median\"),inplace=True)","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"31c732a646a9178ef4097c5beee8cb7a16bc2566"},"cell_type":"code","source":"df.loc[df['Age']<=16,'Age']=0\ndf.loc[(df['Age'] >16) & (df['Age']<=26),'Age']=1\ndf.loc[(df['Age'] >26)&( df['Age']<=36 ),'Age']=2\ndf.loc[(df['Age']>36)&( df['Age'] <=62),'Age']=3\ndf.loc[df['Age']>62,'Age']=4","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"e3dd3fcf03322e8cae2042e163216990f8a33159"},"cell_type":"code","source":"df.loc[df['Fare']<=17,'Fare']=0\ndf.loc[(df['Fare'] >17) & (df['Fare']<=30),'Fare']=1\ndf.loc[(df['Fare'] >30)&( df['Fare']<=100 ),'Fare']=2\ndf.loc[df['Fare']>100,'Fare']=3","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"41a942a42f0b0092cabec6c3cddf91e3deab9572"},"cell_type":"code","source":"df['Embarked'].fillna('S',inplace=True)","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"20a1c4d88881ca85cd2938907d54b71a701c9122"},"cell_type":"code","source":"del df['Cabin']","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"c03927296bccb34a1288289705cc6a7ed5c413ce"},"cell_type":"code","source":"df['Familysize']=df['SibSp']+df['Parch']+1","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"ad24124ccaad837648d15602847175e9a8326739"},"cell_type":"code","source":"del df['Ticket']\ndel df['PassengerId']\ndel df['SibSp']\ndel df['Parch']\ndel df['Name']","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"ef475845295a406b2cd5756930857dcb9c8e7a0c"},"cell_type":"code","source":"embarked_mapping={'S':0,'C':1,'Q':2}\ndf['Embarked']=df['Embarked'].map(embarked_mapping)","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"d0df49eff944e8ffd8c80bca1043180df79eac6f"},"cell_type":"code","source":"family_size={0:0.0,1:0.2,2:0.4,3:0.8,4:1.2,5:1.6,6:2.0,7:2.4,8:2.8,9:3.2,10:3.6,11:4.0}\ndf['Familysize']=df['Familysize'].map(family_size)\ndf.isnull().any(axis=0)","execution_count":null,"outputs":[]},{"metadata":{"_uuid":"015d27feeddca4bf08f1e00bd56b2f656dd5607e"},"cell_type":"markdown","source":"**EXTRACTING, CLEANING TESTING DATASET**"},{"metadata":{"trusted":true,"_uuid":"376141507a9706bbb39c66f980ed01e6f564caca"},"cell_type":"code","source":"test=pd.read_csv(\"../input/test.csv\")","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"39f8eb29b8634bdf4609731abe08c86deb2bfb80"},"cell_type":"code","source":"test.replace('male',0,inplace= True)\ntest.replace('female',1,inplace= True)","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"12b5051c856d25f272014fe09e6de28530a70129"},"cell_type":"code","source":"for dataset in range(len(test)):\n    test['title']=test['Name'].str.extract('([A-Za-z]+)\\.',expand=False)\ntest['title'].value_counts()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"c7a0cfadb0d4471ae2c585007f0cda9aedc150dd"},"cell_type":"code","source":"title_mapping={\"Mr\":0,\"Miss\":1,\"Mrs\":2,\"Master\":3,\"Dr\":3,\"Rev\":3,\"Col\":3,\"Mlle\":3,\"Major\":3,\"Dona\":3,\"Lady\":3,\"Capt\":3,\"Jonkheer\":3,\"Sir\":3,\"Countess\":3,\"Mme\":3,\"Ms\":3,\"Name\":3}\ntest['title']=test['title'].map(title_mapping)","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"8b9d72411d510208884b66228827f86265efbbcb"},"cell_type":"code","source":"test.isnull().any(axis=0)","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"bcb2db1fb82cedbea7d8d14d24d0188ab1cff961"},"cell_type":"code","source":"test['Age'].fillna(test.groupby('title')['Age'].transform(\"median\"),inplace=True)\ntest.loc[test['Age']<=16,'Age']=0\ntest.loc[(test['Age'] >16) & (test['Age']<=26),'Age']=1\ntest.loc[(test['Age'] >26)&( test['Age']<=36 ),'Age']=2\ntest.loc[(test['Age']>36)&( test['Age'] <=62),'Age']=3\ntest.loc[test['Age']>62,'Age']=4","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"9e34f7054be1289c5345b448c1abd8b226d7b11c"},"cell_type":"code","source":"test['Fare'].fillna(test.groupby('title')['Fare'].transform(\"median\"),inplace=True)\ntest.loc[test['Fare']<=17,'Fare']=0\ntest.loc[(test['Fare'] >17) & (test['Fare']<=30),'Fare']=1\ntest.loc[(df['Fare'] >30)&( test['Fare']<=100 ),'Fare']=2\ntest.loc[test['Fare']>100,'Fare']=3","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"4715e6b61817f97b49fe2a0ffe3db5129c8bd1f6"},"cell_type":"code","source":"test['Familysize']=test['SibSp']+test['Parch']+1","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"677af105a8f719d2dc211d8d4bfd1d1497171251"},"cell_type":"code","source":"del test['Ticket']\ndel test['SibSp']\ndel test['Parch']\ndel test['Name']\n","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"53747830775089c006fd8acbc0bfe66e0e0b842a"},"cell_type":"code","source":"del test['Cabin']","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"60d0a3936d7ed04ef931b5d6422f42eba9ddd398"},"cell_type":"code","source":"test['Embarked'].fillna('S',inplace=True)\nembarked_mapping={'S':0,'C':1,'Q':2}\ntest['Embarked']=test['Embarked'].map(embarked_mapping)","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"2d3f85f190552b6e896d38aa3c768da119f17d50"},"cell_type":"code","source":"family_size={0:0,1:0.2,2:0.4,3:0.8,4:1.2,5:1.6,6:2.0,7:2.4,8:2.8,9:3.2,10:3.6,11:4.0,12:4.5,13:5.0,14:5.5,15:6.0}\ntest['Familysize']=test['Familysize'].map(family_size)\ntest.isnull().any(axis=0)","execution_count":null,"outputs":[]},{"metadata":{"_uuid":"85f6ab7f6a7a64130b7f023e62b98945a4bb55f0"},"cell_type":"markdown","source":"**Splitting training set into two features and class label**"},{"metadata":{"trusted":true,"_uuid":"86fa0be266b0068e5df98ca8454fbfecbfd2b9c3"},"cell_type":"code","source":"feature_column_names=['Pclass','Sex','Age','Fare','Embarked','title','Familysize']\npredicted_class_names=['Survived']","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"06404a2395a998d365464f157545ad3121d90b3d"},"cell_type":"code","source":"x=df[feature_column_names].values\ny=df[predicted_class_names].values","execution_count":null,"outputs":[]},{"metadata":{"_uuid":"a47571de1e131b6e02088d7aedc90a376870ef1a"},"cell_type":"markdown","source":"**Applying Random Forest Classifier on Training Dataset**"},{"metadata":{"trusted":true,"_uuid":"fa078ed38cc0c3a8bf7e0a551fc16de31268bfd2"},"cell_type":"code","source":"from sklearn.ensemble import RandomForestClassifier\nfrom sklearn.metrics import accuracy_score\nfrom sklearn.model_selection import cross_val_score\nfrom sklearn.metrics import confusion_matrix\nfrom sklearn.metrics import classification_report\nrf_model=RandomForestClassifier(n_estimators=13,random_state=42)  #create random object\n#score=cross_val_score(rf_model,x,y,cv=10,n_jobs=1)\n#print(score)\nrf_model.fit(x,y.ravel())\nrf_train_predict=rf_model.predict(x)\nprint(\"confusion_matrix\")\nprint(confusion_matrix(y,rf_train_predict))\nprint(\"\")\nprint(\"classification report\")\nprint(classification_report(y,rf_train_predict))\nprint(accuracy_score(y,rf_train_predict))","execution_count":null,"outputs":[]},{"metadata":{"_uuid":"f64a33071546ca959c3880827b39a2c8e75e3a1d"},"cell_type":"markdown","source":"**Creating submission.csv named file for submitting in competition**"},{"metadata":{"trusted":true,"_uuid":"9f4d2a41b343d913479675942a80faf657e4cd7c"},"cell_type":"code","source":"x1=test[feature_column_names].values\nrf_test_predict=rf_model.predict(x1)\nsubmission=pd.DataFrame({\"PassengerId\":test['PassengerId'],\"Survived\":rf_test_predict})\nsubmission.to_csv('submission.csv',index=False)\nsubmission=pd.read_csv('submission.csv')","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"b68edf1540e514baf5d94b555c5470b44b3fc97f"},"cell_type":"code","source":"","execution_count":null,"outputs":[]}],"metadata":{"kernelspec":{"display_name":"Python 3","language":"python","name":"python3"},"language_info":{"name":"python","version":"3.6.6","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"}},"nbformat":4,"nbformat_minor":1}