{"cells":[{"metadata":{"_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","trusted":true},"cell_type":"code","source":"import math\nimport seaborn as sns\nsns.set(style=\"whitegrid\", color_codes=True)\n\n\nfrom wordcloud import WordCloud, STOPWORDS\n\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\nimport numpy as np # linear algebra\nimport matplotlib \nimport matplotlib.pyplot as plt\nimport sklearn\n%matplotlib inline\nimport matplotlib.pyplot as plt \nplt.rcParams[\"figure.figsize\"] = [16, 12]\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.\nfilenames = check_output([\"ls\", \"../input/\"]).decode(\"utf8\").strip()\n# helpful character encoding module\nimport chardet\n\n# set seed for reproducibility\nnp.random.seed(0)","execution_count":1,"outputs":[]},{"metadata":{"_cell_guid":"79c7e3d0-c299-4dcb-8224-4455121ee9b0","_uuid":"d629ff2d2480ee46fbb7e2d37f6b5fab8052498a","trusted":true},"cell_type":"code","source":"df = pd.read_csv('../input/train.csv')\ndg = pd.read_csv('../input/test.csv')\ndh = pd.read_csv('../input/sample_submission.csv')\ndi = pd.read_csv('../input/stores.csv')\ndj = pd.read_csv('../input/oil.csv')\ndk = pd.read_csv('../input/items.csv')\ndl = pd.read_csv('../input/holidays_events.csv')\ndm = pd.read_csv('../input/transactions.csv') \ndf.date = pd.to_datetime(df.date, format = '%Y-%m-%d')\ndg.date = pd.to_datetime(dg.date, format = '%Y-%m-%d')\ndj.date = pd.to_datetime(dj.date, format = '%Y-%m-%d')\ndl.date = pd.to_datetime(dl.date, format = '%Y-%m-%d')\ndm.date = pd.to_datetime(dm.date, format = '%Y-%m-%d') ","execution_count":2,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"995355678f1eff2377ddafb7212c81e3f3741db8"},"cell_type":"code","source":"dm.head()","execution_count":3,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"ed9ac8fe9a1b20e551d6a11399070065cdb73088"},"cell_type":"code","source":"dm.groupby('date').transactions.sum().plot.line()","execution_count":17,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"774d1ea5fcd54bed43244a97b51f78bc5bb651bf"},"cell_type":"code","source":"dl.head()","execution_count":4,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"95009fe61b42e8a6be16de4975a1cc8fdfd109cc"},"cell_type":"code","source":"dk.head()","execution_count":5,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"5fb270e693d5267dcf24c90e3d6790a67be57a67"},"cell_type":"code","source":"dk['class'].value_counts().plot.bar()","execution_count":16,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"468fb384efc76acd2305c89a1390000b277dec45"},"cell_type":"code","source":"dk.family.value_counts().plot.bar()","execution_count":15,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"1be8677d600f1b81d1b50e93c4948c0833f5d7ca"},"cell_type":"code","source":"dj.head()","execution_count":6,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"aeb532ee2658287d41867b642e4aedbd50457cab"},"cell_type":"code","source":"di.head()","execution_count":7,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"37c43fb0d387189f5d184496cb03ae263b38537f"},"cell_type":"code","source":"di.describe(include = 'O').transpose()","execution_count":12,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"d5634102fb1f9680d5d39ecf8d6dfe6c7a27b709"},"cell_type":"code","source":"di.type.value_counts().plot.bar()","execution_count":14,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"22e2361f97b255a4de2ad7624c5abd06864682ce"},"cell_type":"code","source":"dh.head()","execution_count":8,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"c98557429185eadb39d41b6c63a3a14e6cf6d361"},"cell_type":"code","source":"dg.head()","execution_count":9,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"686449ba683a7f092f093973da92a6a6e8b02641"},"cell_type":"code","source":"df.head()","execution_count":10,"outputs":[]},{"metadata":{"trusted":true,"collapsed":true,"_uuid":"14b71ffc5773a434d92e2046611d842b92773694"},"cell_type":"code","source":"","execution_count":11,"outputs":[]},{"metadata":{"trusted":true,"collapsed":true,"_uuid":"4e8c42d92647818831a64dfdb029c6f8a0988a4d"},"cell_type":"code","source":"","execution_count":null,"outputs":[]}],"metadata":{"kernelspec":{"display_name":"Python 3","language":"python","name":"python3"},"language_info":{"name":"python","version":"3.6.5","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"}},"nbformat":4,"nbformat_minor":1}