{"cells": [{"metadata": {}, "source": ["Kernel related to this discussion: [https://www.kaggle.com/c/favorita-grocery-sales-forecasting/discussion/42077](https://www.kaggle.com/c/favorita-grocery-sales-forecasting/discussion/42077)"], "cell_type": "markdown"}, {"outputs": [], "execution_count": null, "metadata": {"collapsed": true}, "source": ["# IMPORT\n", "import numpy as np\n", "import pandas as pd\n", "\n", "import matplotlib.pyplot as plt\n", "%matplotlib inline"], "cell_type": "code"}, {"outputs": [], "execution_count": null, "metadata": {"_cell_guid": "99c31092-22d3-47dd-94aa-a052f8fad651", "_uuid": "2d706d06121767b071879f0baadf054b314e6042"}, "source": ["# LOAD TRANSACTIONS AND TRAIN\n", "df_transactions= pd.read_csv(\"../input/transactions.csv\", parse_dates = ['date'], infer_datetime_format = True)\n", "types = {'id': 'int64','item_nbr': 'int32','store_nbr': 'int8','unit_sales': 'float32','onpromotion': bool,}\n", "df_train= pd.read_csv(\"../input/train.csv\", parse_dates = ['date'], dtype = types, infer_datetime_format = True)"], "cell_type": "code"}, {"outputs": [], "execution_count": null, "metadata": {"collapsed": true}, "source": ["# GROUP BY DATE AND CALCULATE RATIO\n", "df_us = df_train.groupby(by='date').agg({'unit_sales':'sum'})\n", "df_tr = df_transactions.groupby(by='date').agg({'transactions':'sum'})\n", "df_ratio = df_us.merge(df_tr, how='outer', left_index=True, right_index=True)\n", "df_ratio['ratio'] = df_ratio['unit_sales'] / df_ratio['transactions']"], "cell_type": "code"}, {"outputs": [], "execution_count": null, "metadata": {}, "source": ["# COMPARE 2 SATURDAY 4 YEARS APART\n", "print(df_ratio.loc['2013-04-06']) #Saturday\n", "print(df_ratio.loc['2017-04-08']) #Saturday"], "cell_type": "code"}, {"outputs": [], "execution_count": null, "metadata": {}, "source": ["# PLOT\n", "f, ax = plt.subplots(3, 1, figsize=(20, 21))\n", "df_ratio['unit_sales'].plot(ax=ax[0], title='unit_sales')\n", "df_ratio['transactions'].plot(ax=ax[1], title='transactions')\n", "df_ratio['ratio'].plot(ax=ax[2], title='ratio', ylim=(0,15))"], "cell_type": "code"}], "nbformat": 4, "nbformat_minor": 1, "metadata": {"kernelspec": {"display_name": "Python 3", "language": "python", "name": "python3"}, "language_info": {"codemirror_mode": {"name": "ipython", "version": 3}, "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "name": "python", "file_extension": ".py", "version": "3.6.3", "mimetype": "text/x-python"}}}