weather_train_label_1_5.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                xid           yid       date_id          hour          wind  \\\n",
      "count  2.076372e+07  2.076372e+07  2.076372e+07  2.076372e+07  2.076372e+07   \n",
      "mean   2.745000e+02  2.110000e+02  3.000000e+00  1.150000e+01           NaN   \n",
      "std    1.581937e+02  1.215319e+02  1.414214e+00  5.188128e+00  0.000000e+00   \n",
      "min    1.000000e+00  1.000000e+00  1.000000e+00  3.000000e+00  0.000000e+00   \n",
      "25%    1.377500e+02  1.060000e+02  2.000000e+00  7.000000e+00  8.773438e+00   \n",
      "50%    2.745000e+02  2.110000e+02  3.000000e+00  1.150000e+01  1.239844e+01   \n",
      "75%    4.112500e+02  3.160000e+02  4.000000e+00  1.600000e+01  1.570312e+01   \n",
      "max    5.480000e+02  4.210000e+02  5.000000e+00  2.000000e+01  3.409375e+01   \n",
      "\n",
      "           rainfall  \n",
      "count  2.076372e+07  \n",
      "mean            NaN  \n",
      "std    0.000000e+00  \n",
      "min    0.000000e+00  \n",
      "25%    0.000000e+00  \n",
      "50%    0.000000e+00  \n",
      "75%    6.801758e-01  \n",
      "max    2.310000e+02  \n",
      "    xid  yid  date_id  hour       wind  rainfall\n",
      "0     1    1        1     3   9.273438       0.0\n",
      "1     1    2        1     3   9.242188       0.0\n",
      "2     1    3        1     3   9.242188       0.0\n",
      "3     1    4        1     3   9.242188       0.0\n",
      "4     1    5        1     3   9.343750       0.0\n",
      "5     1    6        1     3   9.343750       0.0\n",
      "6     1    7        1     3   9.359375       0.0\n",
      "7     1    8        1     3   9.492188       0.0\n",
      "8     1    9        1     3   9.492188       0.0\n",
      "9     1   10        1     3   9.492188       0.0\n",
      "10    1   11        1     3   9.609375       0.0\n",
      "11    1   12        1     3   9.640625       0.0\n",
      "12    1   13        1     3   9.640625       0.0\n",
      "13    1   14        1     3   9.671875       0.0\n",
      "14    1   15        1     3   9.820312       0.0\n",
      "15    1   16        1     3   9.968750       0.0\n",
      "16    1   17        1     3  10.101562       0.0\n",
      "17    1   18        1     3  10.296875       0.0\n",
      "18    1   19        1     3  10.398438       0.0\n",
      "19    1   20        1     3  10.500000       0.0\n",
      "20    1   21        1     3  10.703125       0.0\n",
      "21    1   22        1     3  10.601562       0.0\n",
      "22    1   23        1     3  10.601562       0.0\n",
      "23    1   24        1     3  10.500000       0.0\n",
      "24    1   25        1     3  10.398438       0.0\n",
      "25    1   26        1     3  10.203125       0.0\n",
      "26    1   27        1     3  10.101562       0.0\n",
      "27    1   28        1     3   9.921875       0.0\n",
      "28    1   29        1     3   9.906250       0.0\n",
      "29    1   30        1     3   9.921875       0.0\n",
      "         xid    yid    date_id       hour       wind   rainfall\n",
      "count   90.0   90.0  90.000000  90.000000  90.000000  90.000000\n",
      "mean   142.0  328.0   3.000000  11.500000  10.468750   0.020889\n",
      "std      0.0    0.0   1.422136   5.217193   2.755859   0.040192\n",
      "min    142.0  328.0   1.000000   3.000000   1.459961   0.000000\n",
      "25%    142.0  328.0   2.000000   7.000000   9.515625   0.000000\n",
      "50%    142.0  328.0   3.000000  11.500000  10.898438   0.000000\n",
      "75%    142.0  328.0   4.000000  16.000000  12.474609   0.000000\n",
      "max    142.0  328.0   5.000000  20.000000  15.796875   0.140015\n",
      "20763720\n",
      "          xid  yid  date_id  hour       wind  rainfall\n",
      "0           1    1        1     3   9.273438   0.00000\n",
      "1           1    2        1     3   9.242188   0.00000\n",
      "2           1    3        1     3   9.242188   0.00000\n",
      "3           1    4        1     3   9.242188   0.00000\n",
      "4           1    5        1     3   9.343750   0.00000\n",
      "5           1    6        1     3   9.343750   0.00000\n",
      "6           1    7        1     3   9.359375   0.00000\n",
      "7           1    8        1     3   9.492188   0.00000\n",
      "8           1    9        1     3   9.492188   0.00000\n",
      "9           1   10        1     3   9.492188   0.00000\n",
      "10          1   11        1     3   9.609375   0.00000\n",
      "11          1   12        1     3   9.640625   0.00000\n",
      "12          1   13        1     3   9.640625   0.00000\n",
      "13          1   14        1     3   9.671875   0.00000\n",
      "14          1   15        1     3   9.820312   0.00000\n",
      "15          1   16        1     3   9.968750   0.00000\n",
      "16          1   17        1     3  10.101562   0.00000\n",
      "17          1   18        1     3  10.296875   0.00000\n",
      "18          1   19        1     3  10.398438   0.00000\n",
      "19          1   20        1     3  10.500000   0.00000\n",
      "20          1   21        1     3  10.703125   0.00000\n",
      "21          1   22        1     3  10.601562   0.00000\n",
      "22          1   23        1     3  10.601562   0.00000\n",
      "23          1   24        1     3  10.500000   0.00000\n",
      "24          1   25        1     3  10.398438   0.00000\n",
      "25          1   26        1     3  10.203125   0.00000\n",
      "26          1   27        1     3  10.101562   0.00000\n",
      "27          1   28        1     3   9.921875   0.00000\n",
      "28          1   29        1     3   9.906250   0.00000\n",
      "29          1   30        1     3   9.921875   0.00000\n",
      "...       ...  ...      ...   ...        ...       ...\n",
      "20763690  548  392        5    20   7.050781  41.50000\n",
      "20763691  548  393        5    20   6.789062  39.81250\n",
      "20763692  548  394        5    20   6.539062  38.18750\n",
      "20763693  548  395        5    20   6.550781  37.40625\n",
      "20763694  548  396        5    20   6.429688  37.31250\n",
      "20763695  548  397        5    20   6.449219  37.59375\n",
      "20763696  548  398        5    20   6.320312  37.90625\n",
      "20763697  548  399        5    20   6.351562  38.18750\n",
      "20763698  548  400        5    20   6.250000  38.68750\n",
      "20763699  548  401        5    20   6.121094  39.31250\n",
      "20763700  548  402        5    20   5.878906  39.68750\n",
      "20763701  548  403        5    20   5.488281  39.81250\n",
      "20763702  548  404        5    20   5.050781  39.59375\n",
      "20763703  548  405        5    20   4.761719  39.31250\n",
      "20763704  548  406        5    20   4.621094  39.40625\n",
      "20763705  548  407        5    20   4.871094  39.90625\n",
      "20763706  548  408        5    20   5.000000  40.68750\n",
      "20763707  548  409        5    20   5.378906  41.18750\n",
      "20763708  548  410        5    20   5.519531  41.18750\n",
      "20763709  548  411        5    20   5.671875  40.40625\n",
      "20763710  548  412        5    20   5.828125  39.59375\n",
      "20763711  548  413        5    20   5.878906  39.31250\n",
      "20763712  548  414        5    20   5.941406  39.09375\n",
      "20763713  548  415        5    20   5.890625  38.81250\n",
      "20763714  548  416        5    20   5.691406  39.31250\n",
      "20763715  548  417        5    20   5.500000  39.59375\n",
      "20763716  548  418        5    20   5.308594  39.90625\n",
      "20763717  548  419        5    20   5.308594  40.68750\n",
      "20763718  548  420        5    20   5.148438  41.68750\n",
      "20763719  548  421        5    20   5.058594  42.00000\n",
      "\n",
      "[20763720 rows x 6 columns]\n"
     ]
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "20763720it [30:30, 11343.82it/s]\n"
     ]
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "real_weather = pd.read_csv(real_weather_name,dtype=np.float16)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "real_weather[de  ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "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": 2
}