{"nbformat_minor": 1, "cells": [{"cell_type": "code", "metadata": {"_uuid": "7ffd5a9da25bd6812d6a98bae755bdf83ce8b01f", "_cell_guid": "da69ef9e-4149-489b-aa22-4e8978047342", "collapsed": true}, "execution_count": null, "source": ["from datetime import date, timedelta\n", "import pandas as pd\n", "import numpy as np"], "outputs": []}, {"cell_type": "code", "metadata": {"_uuid": "6f5b38bdbb993f34f78f664d84beb61cfef40ce8", "_cell_guid": "c77b2421-adf1-4bdc-b211-21e4eb9ea5fa"}, "execution_count": null, "source": ["train = pd.read_csv(\n", "    '../input/train.csv', usecols=[1, 2, 3, 4, 5],\n", "    dtype={'onpromotion': bool},\n", "    parse_dates=[\"date\"],\n", ")"], "outputs": []}, {"cell_type": "code", "metadata": {"_uuid": "f5533bda18d5d0ae9f942826ead337e28da6971c", "_cell_guid": "d3aaf2d6-6b22-4ed6-a778-94785fa915cd"}, "execution_count": null, "source": ["print( train.shape )\n", "train.tail()"], "outputs": []}, {"cell_type": "code", "metadata": {"_uuid": "a4a6dfe9aa363544de06953462a9f6103f9143e8", "_cell_guid": "178136c5-2c4b-42a7-87d0-13aa219026d4", "collapsed": true}, "execution_count": null, "source": ["item_dates = train[['date','item_nbr']]"], "outputs": []}, {"cell_type": "code", "metadata": {"_uuid": "dacc3d262e0de04dfd1087dbc154e5ce52f1ae60", "_cell_guid": "d05f6100-8a8b-408b-b73f-4010e0b13e14"}, "execution_count": null, "source": ["print( item_dates.shape )\n", "item_dates.tail()"], "outputs": []}, {"cell_type": "code", "metadata": {"_uuid": "8567f819d839140602e25fcc2cd735b9af1beb31", "_cell_guid": "6f944c22-113c-4127-8603-7c557b12250e"}, "execution_count": null, "source": ["item_first_dates = item_dates.groupby('item_nbr').min().sort_values('date')\n", "print( item_first_dates.shape )\n", "item_first_dates.tail()"], "outputs": []}, {"cell_type": "code", "metadata": {"_uuid": "6dc97fc6a012bd6a6677ef1fdb2bb45fe6b9dd8b", "_cell_guid": "4aa16dfa-9930-4704-8305-8c7d43ae3ed0"}, "execution_count": null, "source": ["item_dates_7 = item_first_dates['date'] + pd.DateOffset(days=7)\n", "item_dates_7.tail()"], "outputs": []}, {"cell_type": "code", "metadata": {"_uuid": "fc32ff9d4337bbf83651a49f3442aac940ac5655", "_cell_guid": "17d9ab2b-c726-4c7b-a5ca-7975e41a7b26"}, "execution_count": null, "source": ["item_dates_8 = item_first_dates['date'] + pd.DateOffset(days=8)\n", "item_dates_9 = item_first_dates['date'] + pd.DateOffset(days=9)\n", "item_dates_10 = item_first_dates['date'] + pd.DateOffset(days=10)\n", "item_dates_11 = item_first_dates['date'] + pd.DateOffset(days=11)\n", "item_dates_12 = item_first_dates['date'] + pd.DateOffset(days=12)\n", "item_dates_13 = item_first_dates['date'] + pd.DateOffset(days=13)\n", "item_dates_14 = item_first_dates['date'] + pd.DateOffset(days=14)\n", "item_dates_14.shape"], "outputs": []}, {"cell_type": "code", "metadata": {"_uuid": "f88c7011ce096da9d52b096f02625d2da9e5f920", "_cell_guid": "9051b6ca-2026-4c8b-90b9-f728d47399a3"}, "execution_count": null, "source": ["item_dates_2nd_week = pd.DataFrame( pd.concat([item_dates_7, item_dates_8, item_dates_9, \n", "                                               item_dates_10, item_dates_11, item_dates_12, \n", "                                               item_dates_13], axis=0)).reset_index()\n", "print( item_dates_2nd_week.shape )\n", "item_dates_2nd_week.head()"], "outputs": []}, {"cell_type": "code", "metadata": {"_uuid": "46800c115d8abfa003c4d1dd0d4c5beec3931f52", "_cell_guid": "5ba7bb3a-5096-4802-9f0d-e914d87123ba"}, "execution_count": null, "source": ["train_2nd_week = train.merge( item_dates_2nd_week, on=['date','item_nbr'], how='inner')\n", "train_2nd_week.shape"], "outputs": []}, {"cell_type": "code", "metadata": {"_uuid": "38afe508766871222a99c7ce70c2e85fa15cf149", "_cell_guid": "7541551a-5032-4d2f-9b83-b4ac31abacf3"}, "execution_count": null, "source": ["train_2nd_week.head()"], "outputs": []}, {"cell_type": "code", "metadata": {"_uuid": "8d664b78e4f0e082625977052073a7bbba9623c3", "_cell_guid": "1792610a-9d00-49e5-b19b-f2d0ad140811", "collapsed": true}, "execution_count": null, "source": ["train_2nd_week.to_csv('train_2nd_week.csv', float_format='%.1f', index=None)"], "outputs": []}, {"cell_type": "code", "metadata": {"_uuid": "4392fa980ad4d1e47d153fb712666ab641e5524e", "_cell_guid": "2c7008c2-bdfe-4412-8286-1e5e04016c1f", "collapsed": true}, "execution_count": null, "source": ["item_dates_2nd_week.to_csv('items_2nd_week.csv', index=None)"], "outputs": []}, {"cell_type": "code", "metadata": {"_uuid": "1fc8ba3cfcf57f258aa2fc063a244fc578267405", "_cell_guid": "41f7fe2f-2a00-427b-8acf-782ab88ebc12"}, "execution_count": null, "source": ["items_train = train[['item_nbr']].drop_duplicates().item_nbr.values\n", "items_test = pd.read_csv( \"../input/test.csv\", usecols=[3] ).drop_duplicates().item_nbr.values\n", "items_new = set(items_test) - set(items_train)\n", "new_df = pd.DataFrame([i for i in items_new])\n", "new_df.columns=['item_nbr']\n", "print(new_df.shape)\n", "new_df.head()"], "outputs": []}, {"cell_type": "code", "metadata": {"_uuid": "dd433e11913bf6ed72e72d27140118f0f862e422", "_cell_guid": "30c50846-1e1a-4abb-9ecd-6510182c72e9", "collapsed": true}, "execution_count": null, "source": ["new_df.to_csv('new_items.csv',index=None)"], "outputs": []}, {"cell_type": "code", "metadata": {"collapsed": true}, "execution_count": null, "source": [], "outputs": []}], "metadata": {"kernelspec": {"display_name": "Python 3", "language": "python", "name": "python3"}, "language_info": {"file_extension": ".py", "codemirror_mode": {"version": 3, "name": "ipython"}, "mimetype": "text/x-python", "nbconvert_exporter": "python", "version": "3.6.4", "name": "python", "pygments_lexer": "ipython3"}}, "nbformat": 4}