{"cells":[{"cell_type":"markdown","metadata":{"_cell_guid":"04af6be3-f842-d86a-7e25-34f847aa63a9"},"source":"### Transforming data into rows of features   "},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"424c5550-1255-72ac-4b1a-d28e0de7d81b"},"outputs":[],"source":""},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"73077ead-ff5d-d5ce-744a-29283955f996"},"outputs":[],"source":"types = {'Semana':np.uint8, #'Agencia_ID':np.uint16, 'Canal_ID':np.uint8, 'Ruta_SAK':np.uint16,\n         'Cliente_ID':np.uint32, 'Producto_ID':np.uint16, 'Demanda_uni_equil':np.uint32}\n\ndf = pd.read_csv('../input/train.csv', usecols=types.keys(),\n                 dtype=types)\n\nweeks = np.unique(df.Semana.values)\nweek_labs = ['W'+str(i) for i in weeks]"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"18084466-df78-293f-8ff9-b72bdce9262c"},"outputs":[],"source":"np."},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"80b9d882-9526-3e45-0b9f-c25ca6ce94b9"},"outputs":[],"source":"# Initialize training dataframe\ndf_train = df[(df.Semana == weeks[0])]\\\n    .drop('Semana', axis=1)\\\n    .rename(columns={'Demanda_uni_equil': week_labs[0]})\n# Cut down other df to save memory\ndf = df[(df.Semana != weeks[0])]\n\nfor w, w_label in zip(weeks[1:4], week_labs[1:4]):\n    df_train = df_train.merge(\n        df[(df.Semana == w)]\\\n            .drop('Semana', axis=1)\\\n            .rename(columns={'Demanda_uni_equil': w_label}),\n        how='outer',\n        on=['Cliente_ID', 'Producto_ID'])\n    df = df[(df.Semana != w)]"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"ab0c7725-f835-137c-8882-75eb65f8512e"},"outputs":[],"source":"df_train.to_csv('train_df.csv')"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"98fd19c1-871a-3069-0758-71912b8cca44"},"outputs":[],"source":"np.random.random(3)"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"0abaf251-840e-d6f1-efa1-cb4238af5fac"},"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}