{"cells":[{"metadata":{"trusted":true,"_uuid":"a645c1f358e0eda86f8417180cc60a56ff27b9e7"},"cell_type":"code","source":"import os\nimport matplotlib.pyplot as plt\nimport numpy as np\nimport pandas as pd\nimport seaborn as sns\nimport os\nprint(os.listdir(\"../input\"))\n\n%matplotlib inline","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"a704419fc6a84fc32d0092c501ebaaecd4b175be"},"cell_type":"code","source":"train_data=pd.read_csv(\"../input/train.csv\")\ntest_data=pd.read_csv(\"../input/test.csv\")\ntrain_data.describe()\n","execution_count":null,"outputs":[]},{"metadata":{"trusted":false,"_uuid":"c8ed4b56a0710ffecd317d69c9320447c323a5ed"},"cell_type":"code","source":"pd.isna(train_data).sum()\n","execution_count":null,"outputs":[]},{"metadata":{"trusted":false,"_uuid":"68067b6b0a645b108ec3c4010f73f7f91bf5c0a4"},"cell_type":"code","source":"train_data.head()\n","execution_count":null,"outputs":[]},{"metadata":{"trusted":false,"_uuid":"1ab7e3dc159bd3e8ecc68ef5161f00b9101a509b"},"cell_type":"code","source":"test_data.head()\n","execution_count":null,"outputs":[]},{"metadata":{"trusted":false,"_uuid":"fa6cd1d10732a57c93b92f3c8a44af3c5ddff7b9"},"cell_type":"code","source":"print(test_data.shape)\nprint(train_data.shape)","execution_count":null,"outputs":[]},{"metadata":{"trusted":false,"_uuid":"a825ccaf9b1e2b984d59d3ba53cda1070cfbd02b"},"cell_type":"code","source":"train_data['pickup_datetime'] = pd.to_datetime(train_data['pickup_datetime'])\ntrain_data['dropoff_datetime'] = pd.to_datetime(train_data['dropoff_datetime'])\ntrain_data.info()","execution_count":null,"outputs":[]},{"metadata":{"trusted":false,"_uuid":"2210e2bc700c2a227c3325686cbd08a026cc97d5"},"cell_type":"code","source":"train_data[\"store_and_fwd_flag\"]=np.where(train_data[\"store_and_fwd_flag\"] == \"N\",0,1)\ntrain_data.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":false,"_uuid":"d212b34230ec92988487a9bcdfcab919f5714bd5"},"cell_type":"code","source":"X=train_data[['vendor_id',\n       'passenger_count', 'pickup_longitude', 'pickup_latitude',\n       'dropoff_longitude', 'dropoff_latitude']]\nX.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":false,"_uuid":"ac9213ab2c7729a1070400e60a8c5c88389e6361"},"cell_type":"code","source":"y=train_data['trip_duration']\ny.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":false,"_uuid":"2e74ef83f46019d99976a9c4c245790c84b01f17"},"cell_type":"code","source":"from sklearn.ensemble import RandomForestRegressor\nfrom sklearn.model_selection import train_test_split, cross_val_score;","execution_count":null,"outputs":[]},{"metadata":{"trusted":false,"_uuid":"e7f4984bca9846885d5840678cadf13692a60708"},"cell_type":"code","source":"X_train, X_test, y_train, y_test = train_test_split(X,y, test_size=0.2, random_state=42)\nX_train.shape, y_train.shape, X_test.shape, y_test.shape","execution_count":null,"outputs":[]},{"metadata":{"trusted":false,"_uuid":"ccc9cb3b0ceef7398d2c02481a33c4e9909cea8e"},"cell_type":"code","source":"rf = RandomForestRegressor()","execution_count":null,"outputs":[]},{"metadata":{"trusted":false,"_uuid":"681c004f447702831d0e9d7e106e5e7fe3b00edc"},"cell_type":"code","source":"rf.fit(X_train,y_train)","execution_count":null,"outputs":[]},{"metadata":{"trusted":false,"_uuid":"96fbcbcbebbbcbc0ed7a5a65e2d8446493ff6790"},"cell_type":"code","source":"pred = rf.predict(X_test)\npred","execution_count":null,"outputs":[]},{"metadata":{"trusted":false,"_uuid":"f6abadeb0f5f5218dc9a9b95f214c213ce367f5f"},"cell_type":"code","source":"from sklearn.metrics import mean_squared_log_error ","execution_count":null,"outputs":[]},{"metadata":{"trusted":false,"_uuid":"47043a9ea344032b9643e9c10c7c5eb1d62e4ae1"},"cell_type":"code","source":"print(mean_squared_log_error(y_test,pred))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"350870301c74035ab80862af580008718bb11f72"},"cell_type":"code","source":"submission =pd.read_csv(\"../input/sample_submission.csv\")\nsubmission.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":false,"_uuid":"c860b4776e039957d3a72d06e45331a6c343503f"},"cell_type":"code","source":"test_pred = rf.predict(test_data[['vendor_id',\n       'passenger_count', 'pickup_longitude', 'pickup_latitude',\n       'dropoff_longitude', 'dropoff_latitude']])\nprint(test_pred)","execution_count":null,"outputs":[]},{"metadata":{"trusted":false,"_uuid":"5ec4e5311d93953e6eaad49b060ccf87c0e24f38"},"cell_type":"code","source":"my_submission = pd.DataFrame({'id': test_data.id, 'trip_duration': test_pred})\nmy_submission.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":false,"_uuid":"6f34b4c3d71e17d5663857a8d5a2f487c44a535e"},"cell_type":"code","source":"my_submission.to_csv('submiss.csv', index=False)","execution_count":null,"outputs":[]}],"metadata":{"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.7.0"}},"nbformat":4,"nbformat_minor":1}