{"cells": [{"cell_type": "markdown", "source": ["Importing libraries for data processing"], "metadata": {"_uuid": "2d71758e2343cf6acbe688c7f8b4990cba0a6c52", "_cell_guid": "b6022ba3-edcf-4f10-9ebd-4abfc4568ce4"}}, {"cell_type": "code", "source": ["import numpy as np\n", "import pandas as pd"], "outputs": [], "execution_count": null, "metadata": {"_uuid": "3a2b0274866469152950be185ac30b8fc24ded30", "_cell_guid": "90aa11fd-b96f-4161-a328-b52d7cd06e93", "collapsed": true}}, {"cell_type": "code", "source": ["members = pd.read_csv('../input/members.csv')"], "outputs": [], "execution_count": null, "metadata": {"_uuid": "3769b09a440229c5ae26ac09aa36f2d200e1bbfe", "_cell_guid": "0ec73a81-4c58-419f-a67f-584ce88ee3b0"}}, {"cell_type": "markdown", "source": ["Checking the dataset for nulls"], "metadata": {"_uuid": "ad977c87c9443c88d9ea6f7c7dd6daff1989a312", "_cell_guid": "b26b289e-2843-4b08-9661-878ec7065ca2"}}, {"cell_type": "code", "source": ["members.shape"], "outputs": [], "execution_count": null, "metadata": {"_uuid": "5ec49987e0ba27ebd2c82e8e0a18ff77003ce876", "_cell_guid": "1d4ad5af-9d10-4271-80a1-d4a18fd4837f"}}, {"cell_type": "markdown", "source": ["The data set contains 5, 116, 194 rows and has 7 columns"], "metadata": {"_uuid": "61f123bbcdb15ae19192cd4ae16566850a66b312", "_cell_guid": "4212e1b2-9b0e-4c87-918a-2d4bf8e3481c"}}, {"cell_type": "code", "source": ["members.isnull().sum()"], "outputs": [], "execution_count": null, "metadata": {"_uuid": "5e04b2edb39b65ade4a327f6a77c505330a59a4b", "_cell_guid": "9d832962-5e65-45a6-83fc-edb63b12459a"}}, {"cell_type": "markdown", "source": ["There are missing data for gender almost "], "metadata": {"_uuid": "4c3590da76b9ce6c83e12d2a8987f18ee6320208", "_cell_guid": "b50b5691-98f9-4ba7-89e4-3f3e97cb01f1"}}, {"cell_type": "code", "source": ["print(\"{0:.2f}% data for gender is missing\".format(3354778 / 5116194 * 100))"], "outputs": [], "execution_count": null, "metadata": {"_uuid": "1b9b38c5b205914277ec4266609e0d4d2d6264d4", "_cell_guid": "0595da3d-dcc8-4050-b77c-f73ee8c76722"}}, {"cell_type": "code", "source": ["transactions = pd.read_csv('../input/transactions.csv')"], "outputs": [], "execution_count": null, "metadata": {"_uuid": "9afe3f7746123c5bbfc81e1a32a4bcda13f5d115", "_cell_guid": "da5a4260-66f1-4fe2-bf52-14cc411c256c", "collapsed": true}}, {"cell_type": "code", "source": ["transactions.shape"], "outputs": [], "execution_count": null, "metadata": {"_uuid": "b9b857ea9f61526ba086767bc20f403062d491ed", "_cell_guid": "45ba1660-c585-43b2-8c61-2c51ea2481c1"}}, {"cell_type": "code", "source": ["transactions.isnull().sum()"], "outputs": [], "execution_count": null, "metadata": {"_uuid": "ca20a2180ac3e1c09d24058bd6a4ceca48058f34", "_cell_guid": "177feeec-cdf4-45e5-8261-d626bd31419f"}}, {"cell_type": "code", "source": ["train = pd.read_csv('../input/train.csv')"], "outputs": [], "execution_count": null, "metadata": {"_uuid": "e8702555d259a45a7b4160d5281c91b0670a0428", "_cell_guid": "323afa71-a56c-4d5e-9ccc-2bd67e826e18", "collapsed": true}}, {"cell_type": "code", "source": ["train.shape"], "outputs": [], "execution_count": null, "metadata": {"_uuid": "5f5d45180fdce95bc442e6b58beb4f6f02c2d9bd", "_cell_guid": "5092ae36-5353-4a64-beb8-fd7d78900111"}}, {"cell_type": "code", "source": ["train.isnull().sum()"], "outputs": [], "execution_count": null, "metadata": {"_uuid": "f4354a377a8bc036cc735e9d91a629a0314fe372", "_cell_guid": "542018b9-0ec5-46cb-9d2f-57ba71334870"}}, {"cell_type": "code", "source": ["''''train = pd.read_csv('../input/train.csv')\n", "sample = pd.read_csv('../input/sample_submission_zero.csv')\n", "transactions = pd.read_csv('../input/transactions.csv')\n", "'''"], "outputs": [], "execution_count": null, "metadata": {"_uuid": "68f5b89f905489746ff2d984c64b95b2b1ae1032", "_cell_guid": "435caef2-cde8-417f-b777-dba3aebfc782", "collapsed": true}}], "nbformat_minor": 1, "nbformat": 4, "metadata": {"kernelspec": {"language": "python", "name": "python3", "display_name": "Python 3"}, "language_info": {"version": "3.6.1", "file_extension": ".py", "name": "python", "codemirror_mode": {"name": "ipython", "version": 3}, "mimetype": "text/x-python", "pygments_lexer": "ipython3", "nbconvert_exporter": "python"}}}