{"cells":[{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"d5ebf109-c069-356d-a9ac-92ae63fb3744"},"outputs":[],"source":"import numpy as np # linear algebra\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\n\n%matplotlib inline\nimport matplotlib.pyplot as plt"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"5b620877-7364-a574-54c6-5bfe07f66c49"},"outputs":[],"source":"types = {'Semana':np.uint8, \n         'Agencia_ID':np.uint16, \n         'Canal_ID':np.uint8,\n         'Ruta_SAK':np.uint16, \n         'Cliente_ID':np.uint32, \n         'Producto_ID':np.uint16,\n         'Demanda_uni_equil':np.uint32}\n\ntrain = pd.read_csv(\"../input/train.csv\",\n                    usecols=types.keys(),\n                    dtype=types)"},{"cell_type":"markdown","metadata":{"_cell_guid":"2bc09e27-de49-dd80-719a-531a94d5731f"},"source":"Average sales per week."},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"267da413-cebc-373d-2e7f-4e2c266d9b80"},"outputs":[],"source":"train['Demanda_uni_equil'].groupby(train.Semana).mean().plot()"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"448e2947-6851-2dfd-f393-a4b247731a89"},"outputs":[],"source":"train['Demanda_uni_equil'].groupby(train.Cliente_ID).mean().plot()"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"42bdd575-cbb6-0cf6-28b1-34fca0ea88ba"},"outputs":[],"source":""}],"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.5.2"}},"nbformat":4,"nbformat_minor":0}