Untitled.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('Crop_per_month_egypt_2010.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                           area(1000 ha)    Jan 2010   Feb 2010   March 2010   \\\n",
      "Wheat                               1 261        35.0       35.0         35.0   \n",
      "Rice                                  452         0.0        0.0          0.0   \n",
      "Maize                                 927         0.0        0.0          0.0   \n",
      "Other cereals                         351        10.0       10.0         10.0   \n",
      "Vegetables one                        388         0.0        0.0          0.0   \n",
      "Vegetables two                        388         0.0        0.0          0.0   \n",
      "Fruits                                389        11.0       11.0         11.0   \n",
      "Mangoes                                64         2.0        2.0          2.0   \n",
      "Figs                                   32         1.0        1.0          1.0   \n",
      "Dates                                  42         1.0        1.0          1.0   \n",
      "Citrus                                157         4.0        4.0          4.0   \n",
      "Grapes                                 64         2.0        2.0          2.0   \n",
      "Olives                                 50         1.0        1.0          1.0   \n",
      "Groundnuts                             38         0.0        0.0          0.0   \n",
      "Sesame                                 28         0.0        0.0          0.0   \n",
      "Other oil crops                        66         0.0        0.0          0.0   \n",
      "Potatoes and other tubers*            158         0.0        0.0          0.0   \n",
      "Pulses                                 98         0.0        0.0          0.0   \n",
      "Sugarcane                             131         4.0        4.0          4.0   \n",
      "Sugar beets                           162         0.0        0.0          0.0   \n",
      "Fodder temporary                      932        26.0       26.0         26.0   \n",
      "Cotton                                155         0.0        0.0          0.0   \n",
      "\n",
      "                            April 2010   May 2010   June 2010   Jul 2010   \\\n",
      "Wheat                              35.0       35.0         0.0        0.0   \n",
      "Rice                                0.0        0.0        13.0       13.0   \n",
      "Maize                               0.0        0.0        26.0       26.0   \n",
      "Other cereals                      10.0        0.0         0.0        0.0   \n",
      "Vegetables one                     11.0       11.0        11.0        0.0   \n",
      "Vegetables two                      0.0        0.0         0.0       11.0   \n",
      "Fruits                             11.0       11.0        11.0       11.0   \n",
      "Mangoes                             2.0        2.0         2.0        2.0   \n",
      "Figs                                1.0        1.0         1.0        1.0   \n",
      "Dates                               1.0        1.0         1.0        1.0   \n",
      "Citrus                              4.0        4.0         4.0        4.0   \n",
      "Grapes                              2.0        2.0         2.0        2.0   \n",
      "Olives                              1.0        1.0         1.0        1.0   \n",
      "Groundnuts                          0.0        1.0         1.0        1.0   \n",
      "Sesame                              0.0        1.0         1.0        1.0   \n",
      "Other oil crops                     0.0        2.0         2.0        2.0   \n",
      "Potatoes and other tubers*          0.0        4.0         4.0        4.0   \n",
      "Pulses                              0.0        3.0         3.0        3.0   \n",
      "Sugarcane                           4.0        4.0         4.0        4.0   \n",
      "Sugar beets                         0.0        4.0         4.0        4.0   \n",
      "Fodder temporary                    0.0        0.0         0.0        0.0   \n",
      "Cotton                              0.0        4.0         4.0        4.0   \n",
      "\n",
      "                            Aug 2010   Sep 2010   Oct 2010   Nov 2010   \\\n",
      "Wheat                             0.0        0.0        0.0       35.0   \n",
      "Rice                             13.0       13.0       13.0        0.0   \n",
      "Maize                            26.0       26.0       26.0        0.0   \n",
      "Other cereals                     0.0        0.0        0.0       10.0   \n",
      "Vegetables one                    0.0        0.0        0.0        0.0   \n",
      "Vegetables two                   11.0       11.0       11.0        0.0   \n",
      "Fruits                           11.0       11.0       11.0       11.0   \n",
      "Mangoes                           2.0        2.0        2.0        2.0   \n",
      "Figs                              1.0        1.0        1.0        1.0   \n",
      "Dates                             1.0        1.0        1.0        1.0   \n",
      "Citrus                            4.0        4.0        4.0        4.0   \n",
      "Grapes                            2.0        2.0        2.0        2.0   \n",
      "Olives                            1.0        1.0        1.0        1.0   \n",
      "Groundnuts                        1.0        1.0        0.0        0.0   \n",
      "Sesame                            1.0        1.0        0.0        0.0   \n",
      "Other oil crops                   2.0        2.0        0.0        0.0   \n",
      "Potatoes and other tubers*        4.0        4.0        0.0        0.0   \n",
      "Pulses                            3.0        3.0        0.0        0.0   \n",
      "Sugarcane                         4.0        4.0        4.0        4.0   \n",
      "Sugar beets                       4.0        4.0        4.0        0.0   \n",
      "Fodder temporary                  0.0        0.0        0.0       26.0   \n",
      "Cotton                            4.0        4.0        4.0        0.0   \n",
      "\n",
      "                            Dec 2010  \n",
      "Wheat                           35.0  \n",
      "Rice                             0.0  \n",
      "Maize                            0.0  \n",
      "Other cereals                   10.0  \n",
      "Vegetables one                   0.0  \n",
      "Vegetables two                   0.0  \n",
      "Fruits                          11.0  \n",
      "Mangoes                          2.0  \n",
      "Figs                             1.0  \n",
      "Dates                            1.0  \n",
      "Citrus                           4.0  \n",
      "Grapes                           2.0  \n",
      "Olives                           1.0  \n",
      "Groundnuts                       0.0  \n",
      "Sesame                           0.0  \n",
      "Other oil crops                  0.0  \n",
      "Potatoes and other tubers*       0.0  \n",
      "Pulses                           0.0  \n",
      "Sugarcane                        4.0  \n",
      "Sugar beets                      0.0  \n",
      "Fodder temporary                26.0  \n",
      "Cotton                           0.0  \n"
     ]
    }
   ],
   "source": [
    "df1 = df.fillna(0)\n",
    "print(df1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>area(1000 ha)</th>\n",
       "      <th>Jan 2010</th>\n",
       "      <th>Feb 2010</th>\n",
       "      <th>March 2010</th>\n",
       "      <th>April 2010</th>\n",
       "      <th>May 2010</th>\n",
       "      <th>June 2010</th>\n",
       "      <th>Jul 2010</th>\n",
       "      <th>Aug 2010</th>\n",
       "      <th>Sep 2010</th>\n",
       "      <th>Oct 2010</th>\n",
       "      <th>Nov 2010</th>\n",
       "      <th>Dec 2010</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Wheat</th>\n",
       "      <td>1 261</td>\n",
       "      <td>35.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rice</th>\n",
       "      <td>452</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Maize</th>\n",
       "      <td>927</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other cereals</th>\n",
       "      <td>351</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vegetables one</th>\n",
       "      <td>388</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vegetables two</th>\n",
       "      <td>388</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fruits</th>\n",
       "      <td>389</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mangoes</th>\n",
       "      <td>64</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Figs</th>\n",
       "      <td>32</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dates</th>\n",
       "      <td>42</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Citrus</th>\n",
       "      <td>157</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Grapes</th>\n",
       "      <td>64</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Olives</th>\n",
       "      <td>50</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Groundnuts</th>\n",
       "      <td>38</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sesame</th>\n",
       "      <td>28</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other oil crops</th>\n",
       "      <td>66</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Potatoes and other tubers*</th>\n",
       "      <td>158</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pulses</th>\n",
       "      <td>98</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sugarcane</th>\n",
       "      <td>131</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sugar beets</th>\n",
       "      <td>162</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fodder temporary</th>\n",
       "      <td>932</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cotton</th>\n",
       "      <td>155</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           area(1000 ha)    Jan 2010   Feb 2010   March 2010   \\\n",
       "Wheat                               1 261        35.0       35.0         35.0   \n",
       "Rice                                  452         0.0        0.0          0.0   \n",
       "Maize                                 927         0.0        0.0          0.0   \n",
       "Other cereals                         351        10.0       10.0         10.0   \n",
       "Vegetables one                        388         0.0        0.0          0.0   \n",
       "Vegetables two                        388         0.0        0.0          0.0   \n",
       "Fruits                                389        11.0       11.0         11.0   \n",
       "Mangoes                                64         2.0        2.0          2.0   \n",
       "Figs                                   32         1.0        1.0          1.0   \n",
       "Dates                                  42         1.0        1.0          1.0   \n",
       "Citrus                                157         4.0        4.0          4.0   \n",
       "Grapes                                 64         2.0        2.0          2.0   \n",
       "Olives                                 50         1.0        1.0          1.0   \n",
       "Groundnuts                             38         0.0        0.0          0.0   \n",
       "Sesame                                 28         0.0        0.0          0.0   \n",
       "Other oil crops                        66         0.0        0.0          0.0   \n",
       "Potatoes and other tubers*            158         0.0        0.0          0.0   \n",
       "Pulses                                 98         0.0        0.0          0.0   \n",
       "Sugarcane                             131         4.0        4.0          4.0   \n",
       "Sugar beets                           162         0.0        0.0          0.0   \n",
       "Fodder temporary                      932        26.0       26.0         26.0   \n",
       "Cotton                                155         0.0        0.0          0.0   \n",
       "\n",
       "                            April 2010   May 2010   June 2010   Jul 2010   \\\n",
       "Wheat                              35.0       35.0         0.0        0.0   \n",
       "Rice                                0.0        0.0        13.0       13.0   \n",
       "Maize                               0.0        0.0        26.0       26.0   \n",
       "Other cereals                      10.0        0.0         0.0        0.0   \n",
       "Vegetables one                     11.0       11.0        11.0        0.0   \n",
       "Vegetables two                      0.0        0.0         0.0       11.0   \n",
       "Fruits                             11.0       11.0        11.0       11.0   \n",
       "Mangoes                             2.0        2.0         2.0        2.0   \n",
       "Figs                                1.0        1.0         1.0        1.0   \n",
       "Dates                               1.0        1.0         1.0        1.0   \n",
       "Citrus                              4.0        4.0         4.0        4.0   \n",
       "Grapes                              2.0        2.0         2.0        2.0   \n",
       "Olives                              1.0        1.0         1.0        1.0   \n",
       "Groundnuts                          0.0        1.0         1.0        1.0   \n",
       "Sesame                              0.0        1.0         1.0        1.0   \n",
       "Other oil crops                     0.0        2.0         2.0        2.0   \n",
       "Potatoes and other tubers*          0.0        4.0         4.0        4.0   \n",
       "Pulses                              0.0        3.0         3.0        3.0   \n",
       "Sugarcane                           4.0        4.0         4.0        4.0   \n",
       "Sugar beets                         0.0        4.0         4.0        4.0   \n",
       "Fodder temporary                    0.0        0.0         0.0        0.0   \n",
       "Cotton                              0.0        4.0         4.0        4.0   \n",
       "\n",
       "                            Aug 2010   Sep 2010   Oct 2010   Nov 2010   \\\n",
       "Wheat                             0.0        0.0        0.0       35.0   \n",
       "Rice                             13.0       13.0       13.0        0.0   \n",
       "Maize                            26.0       26.0       26.0        0.0   \n",
       "Other cereals                     0.0        0.0        0.0       10.0   \n",
       "Vegetables one                    0.0        0.0        0.0        0.0   \n",
       "Vegetables two                   11.0       11.0       11.0        0.0   \n",
       "Fruits                           11.0       11.0       11.0       11.0   \n",
       "Mangoes                           2.0        2.0        2.0        2.0   \n",
       "Figs                              1.0        1.0        1.0        1.0   \n",
       "Dates                             1.0        1.0        1.0        1.0   \n",
       "Citrus                            4.0        4.0        4.0        4.0   \n",
       "Grapes                            2.0        2.0        2.0        2.0   \n",
       "Olives                            1.0        1.0        1.0        1.0   \n",
       "Groundnuts                        1.0        1.0        0.0        0.0   \n",
       "Sesame                            1.0        1.0        0.0        0.0   \n",
       "Other oil crops                   2.0        2.0        0.0        0.0   \n",
       "Potatoes and other tubers*        4.0        4.0        0.0        0.0   \n",
       "Pulses                            3.0        3.0        0.0        0.0   \n",
       "Sugarcane                         4.0        4.0        4.0        4.0   \n",
       "Sugar beets                       4.0        4.0        4.0        0.0   \n",
       "Fodder temporary                  0.0        0.0        0.0       26.0   \n",
       "Cotton                            4.0        4.0        4.0        0.0   \n",
       "\n",
       "                            Dec 2010  \n",
       "Wheat                           35.0  \n",
       "Rice                             0.0  \n",
       "Maize                            0.0  \n",
       "Other cereals                   10.0  \n",
       "Vegetables one                   0.0  \n",
       "Vegetables two                   0.0  \n",
       "Fruits                          11.0  \n",
       "Mangoes                          2.0  \n",
       "Figs                             1.0  \n",
       "Dates                            1.0  \n",
       "Citrus                           4.0  \n",
       "Grapes                           2.0  \n",
       "Olives                           1.0  \n",
       "Groundnuts                       0.0  \n",
       "Sesame                           0.0  \n",
       "Other oil crops                  0.0  \n",
       "Potatoes and other tubers*       0.0  \n",
       "Pulses                           0.0  \n",
       "Sugarcane                        4.0  \n",
       "Sugar beets                      0.0  \n",
       "Fodder temporary                26.0  \n",
       "Cotton                           0.0  "
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Wheat</th>\n",
       "      <th>Rice</th>\n",
       "      <th>Maize</th>\n",
       "      <th>Other cereals</th>\n",
       "      <th>Vegetables one</th>\n",
       "      <th>Vegetables two</th>\n",
       "      <th>Fruits</th>\n",
       "      <th>Mangoes</th>\n",
       "      <th>Figs</th>\n",
       "      <th>Dates</th>\n",
       "      <th>...</th>\n",
       "      <th>Olives</th>\n",
       "      <th>Groundnuts</th>\n",
       "      <th>Sesame</th>\n",
       "      <th>Other oil crops</th>\n",
       "      <th>Potatoes and other tubers*</th>\n",
       "      <th>Pulses</th>\n",
       "      <th>Sugarcane</th>\n",
       "      <th>Sugar beets</th>\n",
       "      <th>Fodder temporary</th>\n",
       "      <th>Cotton</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>area(1000 ha)</th>\n",
       "      <td>1 261</td>\n",
       "      <td>452</td>\n",
       "      <td>927</td>\n",
       "      <td>351</td>\n",
       "      <td>388</td>\n",
       "      <td>388</td>\n",
       "      <td>389</td>\n",
       "      <td>64</td>\n",
       "      <td>32</td>\n",
       "      <td>42</td>\n",
       "      <td>...</td>\n",
       "      <td>50</td>\n",
       "      <td>38</td>\n",
       "      <td>28</td>\n",
       "      <td>66</td>\n",
       "      <td>158</td>\n",
       "      <td>98</td>\n",
       "      <td>131</td>\n",
       "      <td>162</td>\n",
       "      <td>932</td>\n",
       "      <td>155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jan 2010</th>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Feb 2010</th>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>March 2010</th>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>April 2010</th>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Wheat  Rice Maize Other cereals Vegetables one Vegetables two  \\\n",
       "area(1000 ha)    1 261  452   927           351            388            388   \n",
       " Jan 2010           35    0     0            10              0              0   \n",
       "Feb 2010            35    0     0            10              0              0   \n",
       "March 2010          35    0     0            10              0              0   \n",
       "April 2010          35    0     0            10             11              0   \n",
       "\n",
       "               Fruits Mangoes Figs Dates  ... Olives Groundnuts Sesame  \\\n",
       "area(1000 ha)     389      64   32    42  ...     50         38     28   \n",
       " Jan 2010          11       2    1     1  ...      1          0      0   \n",
       "Feb 2010           11       2    1     1  ...      1          0      0   \n",
       "March 2010         11       2    1     1  ...      1          0      0   \n",
       "April 2010         11       2    1     1  ...      1          0      0   \n",
       "\n",
       "               Other oil crops Potatoes and other tubers* Pulses  Sugarcane   \\\n",
       "area(1000 ha)               66                        158      98        131   \n",
       " Jan 2010                    0                          0       0          4   \n",
       "Feb 2010                     0                          0       0          4   \n",
       "March 2010                   0                          0       0          4   \n",
       "April 2010                   0                          0       0          4   \n",
       "\n",
       "               Sugar beets  Fodder temporary Cotton  \n",
       "area(1000 ha)           162              932    155  \n",
       " Jan 2010                 0               26      0  \n",
       "Feb 2010                  0               26      0  \n",
       "March 2010                0               26      0  \n",
       "April 2010                0                0      0  \n",
       "\n",
       "[5 rows x 22 columns]"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.transpose().head()"
   ]
  },
  {
   "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.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}