{"cells":[
 {
  "cell_type": "code",
  "execution_count": null,
  "metadata": {
   "collapsed": false
  },
  "outputs": [],
  "source": "import numpy as np\nimport pandas as pd\n\ntrain_data = pd.read_csv(\"../input/train.csv\", nrows=20)\nprint(train_data)\ntest_data = pd.read_csv(\"../input/test.csv\",nrows=20)\nprint(test_data)\nproduct_data=pd.read_csv(\"../input/producto_tabla.csv\",nrows=20)\nprint(product_data)\nclient_data=pd.read_csv(\"../input/cliente_tabla.csv\",nrows=20)\nprint(client_data)\nsample=pd.read_csv(\"../input/sample_submission.csv\")\nprint(sample)\n\n\n\n"
 },
 {
  "cell_type": "code",
  "execution_count": null,
  "metadata": {
   "collapsed": false
  },
  "outputs": [],
  "source": "import numpy as np\nimport pandas as pd\nimport matplotlib.pyplot as plt\nimport seaborn as sns\ncolumn_Semana = pd.read_csv(\"../input/train.csv\", usecols=['Semana'])\nprint(column_Semana.describe())\nplt.hist(column_Semana['Semana'].tolist())\nplt.title('Distribution of Semana')\nplt.xlabel('Semana')\nplt.ylabel('count')\nplt.show()\n"
 },
 {
  "cell_type": "code",
  "execution_count": null,
  "metadata": {
   "collapsed": false
  },
  "outputs": [],
  "source": "for i in range(9):\n    print(i+1)\n    print(column_Semana['Semana'].tolist().count(i+1))"
 },
 {
  "cell_type": "code",
  "execution_count": null,
  "metadata": {
   "collapsed": false
  },
  "outputs": [],
  "source": "colum_target=pd.read_csv(\"../input/train.csv\",usecols=['Demanda_uni_equil'])\nprint(colum_target.describe())\nplt.hist(colum_target['Demanda_uni_equil'].tolist())\nplt.title('Distribution of Target')\nplt.xlabel('target')\nplt.ylabel('count')\nplt.show()\nsns.distplot(colum_target['Demanda_uni_equil'].tolist())"
 },
 {
  "cell_type": "code",
  "execution_count": null,
  "metadata": {
   "collapsed": false
  },
  "outputs": [],
  "source": "m=colum_target['Demanda_uni_equil'].mean()\nresult_mean=pd.read_csv(\"../input/test.csv\",usecols=['id'])\nresult_mean['Demanda_uni_equil']=m\nresult_mean.to_csv('result_mean.csv',index=False)\n"
 }
],"metadata":{"kernelspec":{"display_name":"Python 3","language":"python","name":"python3"}}, "nbformat": 4, "nbformat_minor": 0}