{"cells":[{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"9baea794-f69b-f5a1-e49b-899c91d466c8"},"outputs":[],"source":"# This Python 3 environment comes with many helpful analytics libraries installed\n# It is defined by the kaggle/python docker image: https://github.com/kaggle/docker-python\n# For example, here's several helpful packages to load in \n\nimport numpy as np # linear algebra\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\n\n# Input data files are available in the \"../input/\" directory.\n# For example, running this (by clicking run or pressing Shift+Enter) will list the files in the input directory\n\nfrom subprocess import check_output\nprint(check_output([\"ls\", \"../input\"]).decode(\"utf8\"))\n\n# Any results you write to the current directory are saved as output."},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"85c99056-00fc-44a1-fe95-91f7d5f058c6"},"outputs":[],"source":"train = pd.read_csv('../input/train.csv', usecols=['Canal_ID', 'Producto_ID', 'Cliente_ID', 'Demanda_uni_equil'])"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"499f4de0-930b-b696-0743-6d488aaeff2b"},"outputs":[],"source":"net = train.groupby('Producto_ID')['Demanda_uni_equil'].sum()"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"f141765c-4fcc-e0b2-a66a-e653c2bdb7b9"},"outputs":[],"source":"cliente_vc = train.Cliente_ID.value_counts()"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"a2261981-7bd5-d3af-9c28-cfebe91c0d90"},"outputs":[],"source":"train.Cliente_ID.isin(cliente_vc.index[:500]).sum()"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"79f44c08-1716-a2b9-5dd5-3e3c09173bb5"},"outputs":[],"source":"train.shape"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"314cf8c2-5a22-0715-2a36-bb4a75910427"},"outputs":[],"source":"train.Cliente_ID.nunique()"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"e55e01ef-6c2f-3c29-3f11-9b8b7d573ee4"},"outputs":[],"source":"train.loc[train.Canal_ID != 1, ]"}],"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}