{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "_cell_guid": "86391902-3911-9a12-7886-89a21a272c7f"
      },
      "source": [
        "My first EDA."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "4a08f806-a21e-144a-c1f8-64189311f836"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "import scipy.stats\n",
        "from scipy.stats import mode"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "c745f028-74e3-440a-7df6-90bbd89eb45e"
      },
      "outputs": [],
      "source": [
        "train=pd.read_csv(\"train.csv\")"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "d644f7d5-08cb-ff3c-9254-898063ef32c1"
      },
      "outputs": [],
      "source": [
        "train.drop([\"Name\",\"Ticket\",\"Cabin\"],axis=1,inplace=True)\n",
        "train.info()\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "8e2c67be-7ab1-fdb8-cb29-517db5b9e37c"
      },
      "outputs": [],
      "source": [
        "train.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "e63d8108-e8a7-acec-ea62-e8b364e5b085"
      },
      "outputs": [],
      "source": [
        "med_age=train.Age.median()\n",
        "train.Age=train.Age.fillna(med_age)\n",
        "train.Embarked=train.Embarked.fillna(train.Embarked.mode())\n",
        "train.info()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "1d45b9f2-995b-b384-70ee-c89b445883db"
      },
      "outputs": [],
      "source": [
        "a = []\n",
        "for i in range(1,len(train['Fare'])):\n",
        "    a.append(train['Embarked'][i])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "524544ff-1214-e840-3466-18aaa27c6c18"
      },
      "outputs": [],
      "source": [
        "mode(train.Embarked.tolist())[0][0]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "ded625df-5537-477c-8098-b2f9324c562e"
      },
      "outputs": [],
      "source": [
        "train.Embarked.value_counts()\n",
        "train.Embarked=train.Embarked.fillna(\"S\")\n",
        "train.info()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "b127e2cd-8713-2afc-4a93-b708d788e059"
      },
      "outputs": [],
      "source": [
        "train[\"Gender\"]=train.Sex.map({\"male\":1,\"female\":0})\n",
        "train[\"Port\"]=train.Embarked.map({\"S\":1,\"C\":2,\"Q\":3})\n",
        "train.info()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "087517a5-1d05-a828-e81b-c06646ac8eb6"
      },
      "outputs": [],
      "source": [
        "train.drop([\"Sex\",\"Embarked\"],axis=1,inplace=True)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "3333a9b1-0887-52f4-5e0c-58b29da3c7c4"
      },
      "outputs": [],
      "source": [
        "cols=train.columns.tolist()\n",
        "cols = cols[1:2] + cols[0:1] + cols[2:]\n",
        "train=train[cols]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "52b4d671-2006-3af8-75bd-af9994c750f7"
      },
      "outputs": [],
      "source": [
        "train_data=train.values"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "b46e14ba-414a-0873-d0c4-28bd914c5994"
      },
      "outputs": [],
      "source": [
        "from sklearn.ensemble import RandomForestClassifier\n",
        "model=RandomForestClassifier(n_estimators=100)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "747a6d52-622e-08c1-0d5c-204184496e3c"
      },
      "outputs": [],
      "source": [
        "model=model.fit(train_data[:,2:],train_data[:,0])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "da1939cc-4eb3-5e29-e281-7c449fdf62a6"
      },
      "outputs": [],
      "source": [
        "test=pd.read_csv(\"test.csv\")"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "f0a7bde0-a28a-e527-2127-3d3b50829823"
      },
      "outputs": [],
      "source": [
        "test.drop([\"Name\",\"Ticket\",\"Cabin\"],axis=1,inplace=True)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "989d3089-6ce7-7d58-3efa-3417b057d744"
      },
      "outputs": [],
      "source": [
        "test.Age=test.Age.fillna(med_age)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "c4306883-1bb2-2250-569e-c4e3f85a827a"
      },
      "outputs": [],
      "source": [
        "test.info()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "192e2984-5e7a-d8a1-a3c8-6aa6601d8f14"
      },
      "outputs": [],
      "source": [
        "mean_fare0=test.pivot_table(index=\"Pclass\",values=\"Fare\")\n",
        "mean_fare0"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "564e4b15-1613-4671-0488-48a1723b2d96"
      },
      "outputs": [],
      "source": [
        "test.Fare=test[[\"Fare\",\"Pclass\"]].apply(lambda row: mean_fare[row[\"Pclass\"]] if pd.isnull(row[\"Fare\"]) else row[\"Fare\"],axis=1)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "dbc62ad5-76f3-bff4-3a38-e300327cc414"
      },
      "outputs": [],
      "source": [
        "test[\"Gender\"]=test.Sex.map({\"male\":1,\"female\":0})\n",
        "test[\"Port\"]=test.Embarked.map({\"S\":1,\"C\":2,\"Q\":3})\n",
        "test.info()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "fdf9509b-7f5a-d998-c07c-90a8fa4cfdcd"
      },
      "outputs": [],
      "source": [
        "test.drop([\"Sex\",\"Embarked\"],axis=1,inplace=True)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "ce0b1e49-bd33-595e-72ab-02c99e6e125b"
      },
      "outputs": [],
      "source": [
        "test_data=test.values"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "a8a55122-a9ca-61dc-2913-7148a6381d6a"
      },
      "outputs": [],
      "source": [
        "output=model.predict(test_data[:,1:])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "3ae09ebb-9c28-9302-6906-31f9f7090411"
      },
      "outputs": [],
      "source": [
        "result=np.c_[test_data[:,0].astype(int),output.astype(int)]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "c01a7851-c399-4473-764b-ad204d2a14dc"
      },
      "outputs": [],
      "source": [
        "result_df=pd.DataFrame(result[:,0:2],columns=[\"Passenger_id\",\"Survived\"])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "cb4032c8-5d0b-9e11-7243-97ccb6ee4938"
      },
      "outputs": [],
      "source": [
        "result_df.to_csv(\"result1.csv\")"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "cd12c8b6-6c3f-a3ca-cd6d-cffd25f10530"
      },
      "outputs": [],
      "source": [
        "result_df.shape"
      ]
    }
  ],
  "metadata": {
    "_change_revision": 0,
    "_is_fork": false,
    "kernelspec": {
      "display_name": "Python 3",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.6.0"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}