DS203_asgn_4.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "DS203_asgn_4.ipynb",
      "provenance": [],
      "authorship_tag": "ABX9TyPi3l/Iw6ofkxw/zr2JUDMp",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/Anway-Deshpande/Github-test-file/blob/main/DS203_asgn_4.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "colab": {
          "resources": {
            "http://localhost:8080/nbextensions/google.colab/files.js": {
              "data": "Ly8gQ29weXJpZ2h0IDIwMTcgR29vZ2xlIExMQwovLwovLyBMaWNlbnNlZCB1bmRlciB0aGUgQXBhY2hlIExpY2Vuc2UsIFZlcnNpb24gMi4wICh0aGUgIkxpY2Vuc2UiKTsKLy8geW91IG1heSBub3QgdXNlIHRoaXMgZmlsZSBleGNlcHQgaW4gY29tcGxpYW5jZSB3aXRoIHRoZSBMaWNlbnNlLgovLyBZb3UgbWF5IG9idGFpbiBhIGNvcHkgb2YgdGhlIExpY2Vuc2UgYXQKLy8KLy8gICAgICBodHRwOi8vd3d3LmFwYWNoZS5vcmcvbGljZW5zZXMvTElDRU5TRS0yLjAKLy8KLy8gVW5sZXNzIHJlcXVpcmVkIGJ5IGFwcGxpY2FibGUgbGF3IG9yIGFncmVlZCB0byBpbiB3cml0aW5nLCBzb2Z0d2FyZQovLyBkaXN0cmlidXRlZCB1bmRlciB0aGUgTGljZW5zZSBpcyBkaXN0cmlidXRlZCBvbiBhbiAiQVMgSVMiIEJBU0lTLAovLyBXSVRIT1VUIFdBUlJBTlRJRVMgT1IgQ09ORElUSU9OUyBPRiBBTlkgS0lORCwgZWl0aGVyIGV4cHJlc3Mgb3IgaW1wbGllZC4KLy8gU2VlIHRoZSBMaWNlbnNlIGZvciB0aGUgc3BlY2lmaWMgbGFuZ3VhZ2UgZ292ZXJuaW5nIHBlcm1pc3Npb25zIGFuZAovLyBsaW1pdGF0aW9ucyB1bmRlciB0aGUgTGljZW5zZS4KCi8qKgogKiBAZmlsZW92ZXJ2aWV3IEhlbHBlcnMgZm9yIGdvb2dsZS5jb2xhYiBQeXRob24gbW9kdWxlLgogKi8KKGZ1bmN0aW9uKHNjb3BlKSB7CmZ1bmN0aW9uIHNwYW4odGV4dCwgc3R5bGVBdHRyaWJ1dGVzID0ge30pIHsKICBjb25zdCBlbGVtZW50ID0gZG9jdW1lbnQuY3JlYXRlRWxlbWVudCgnc3BhbicpOwogIGVsZW1lbnQudGV4dENvbnRlbnQgPSB0ZXh0OwogIGZvciAoY29uc3Qga2V5IG9mIE9iamVjdC5rZXlzKHN0eWxlQXR0cmlidXRlcykpIHsKICAgIGVsZW1lbnQuc3R5bGVba2V5XSA9IHN0eWxlQXR0cmlidXRlc1trZXldOwogIH0KICByZXR1cm4gZWxlbWVudDsKfQoKLy8gTWF4IG51bWJlciBvZiBieXRlcyB3aGljaCB3aWxsIGJlIHVwbG9hZGVkIGF0IGEgdGltZS4KY29uc3QgTUFYX1BBWUxPQURfU0laRSA9IDEwMCAqIDEwMjQ7CgpmdW5jdGlvbiBfdXBsb2FkRmlsZXMoaW5wdXRJZCwgb3V0cHV0SWQpIHsKICBjb25zdCBzdGVwcyA9IHVwbG9hZEZpbGVzU3RlcChpbnB1dElkLCBvdXRwdXRJZCk7CiAgY29uc3Qgb3V0cHV0RWxlbWVudCA9IGRvY3VtZW50LmdldEVsZW1lbnRCeUlkKG91dHB1dElkKTsKICAvLyBDYWNoZSBzdGVwcyBvbiB0aGUgb3V0cHV0RWxlbWVudCB0byBtYWtlIGl0IGF2YWlsYWJsZSBmb3IgdGhlIG5leHQgY2FsbAogIC8vIHRvIHVwbG9hZEZpbGVzQ29udGludWUgZnJvbSBQeXRob24uCiAgb3V0cHV0RWxlbWVudC5zdGVwcyA9IHN0ZXBzOwoKICByZXR1cm4gX3VwbG9hZEZpbGVzQ29udGludWUob3V0cHV0SWQpOwp9CgovLyBUaGlzIGlzIHJvdWdobHkgYW4gYXN5bmMgZ2VuZXJhdG9yIChub3Qgc3VwcG9ydGVkIGluIHRoZSBicm93c2VyIHlldCksCi8vIHdoZXJlIHRoZXJlIGFyZSBtdWx0aXBsZSBhc3luY2hyb25vdXMgc3RlcHMgYW5kIHRoZSBQeXRob24gc2lkZSBpcyBnb2luZwovLyB0byBwb2xsIGZvciBjb21wbGV0aW9uIG9mIGVhY2ggc3RlcC4KLy8gVGhpcyB1c2VzIGEgUHJvbWlzZSB0byBibG9jayB0aGUgcHl0aG9uIHNpZGUgb24gY29tcGxldGlvbiBvZiBlYWNoIHN0ZXAsCi8vIHRoZW4gcGFzc2VzIHRoZSByZXN1bHQgb2YgdGhlIHByZXZpb3VzIHN0ZXAgYXMgdGhlIGlucHV0IHRvIHRoZSBuZXh0IHN0ZXAuCmZ1bmN0aW9uIF91cGxvYWRGaWxlc0NvbnRpbnVlKG91dHB1dElkKSB7CiAgY29uc3Qgb3V0cHV0RWxlbWVudCA9IGRvY3VtZW50LmdldEVsZW1lbnRCeUlkKG91dHB1dElkKTsKICBjb25zdCBzdGVwcyA9IG91dHB1dEVsZW1lbnQuc3RlcHM7CgogIGNvbnN0IG5leHQgPSBzdGVwcy5uZXh0KG91dHB1dEVsZW1lbnQubGFzdFByb21pc2VWYWx1ZSk7CiAgcmV0dXJuIFByb21pc2UucmVzb2x2ZShuZXh0LnZhbHVlLnByb21pc2UpLnRoZW4oKHZhbHVlKSA9PiB7CiAgICAvLyBDYWNoZSB0aGUgbGFzdCBwcm9taXNlIHZhbHVlIHRvIG1ha2UgaXQgYXZhaWxhYmxlIHRvIHRoZSBuZXh0CiAgICAvLyBzdGVwIG9mIHRoZSBnZW5lcmF0b3IuCiAgICBvdXRwdXRFbGVtZW50Lmxhc3RQcm9taXNlVmFsdWUgPSB2YWx1ZTsKICAgIHJldHVybiBuZXh0LnZhbHVlLnJlc3BvbnNlOwogIH0pOwp9CgovKioKICogR2VuZXJhdG9yIGZ1bmN0aW9uIHdoaWNoIGlzIGNhbGxlZCBiZXR3ZWVuIGVhY2ggYXN5bmMgc3RlcCBvZiB0aGUgdXBsb2FkCiAqIHByb2Nlc3MuCiAqIEBwYXJhbSB7c3RyaW5nfSBpbnB1dElkIEVsZW1lbnQgSUQgb2YgdGhlIGlucHV0IGZpbGUgcGlja2VyIGVsZW1lbnQuCiAqIEBwYXJhbSB7c3RyaW5nfSBvdXRwdXRJZCBFbGVtZW50IElEIG9mIHRoZSBvdXRwdXQgZGlzcGxheS4KICogQHJldHVybiB7IUl0ZXJhYmxlPCFPYmplY3Q+fSBJdGVyYWJsZSBvZiBuZXh0IHN0ZXBzLgogKi8KZnVuY3Rpb24qIHVwbG9hZEZpbGVzU3RlcChpbnB1dElkLCBvdXRwdXRJZCkgewogIGNvbnN0IGlucHV0RWxlbWVudCA9IGRvY3VtZW50LmdldEVsZW1lbnRCeUlkKGlucHV0SWQpOwogIGlucHV0RWxlbWVudC5kaXNhYmxlZCA9IGZhbHNlOwoKICBjb25zdCBvdXRwdXRFbGVtZW50ID0gZG9jdW1lbnQuZ2V0RWxlbWVudEJ5SWQob3V0cHV0SWQpOwogIG91dHB1dEVsZW1lbnQuaW5uZXJIVE1MID0gJyc7CgogIGNvbnN0IHBpY2tlZFByb21pc2UgPSBuZXcgUHJvbWlzZSgocmVzb2x2ZSkgPT4gewogICAgaW5wdXRFbGVtZW50LmFkZEV2ZW50TGlzdGVuZXIoJ2NoYW5nZScsIChlKSA9PiB7CiAgICAgIHJlc29sdmUoZS50YXJnZXQuZmlsZXMpOwogICAgfSk7CiAgfSk7CgogIGNvbnN0IGNhbmNlbCA9IGRvY3VtZW50LmNyZWF0ZUVsZW1lbnQoJ2J1dHRvbicpOwogIGlucHV0RWxlbWVudC5wYXJlbnRFbGVtZW50LmFwcGVuZENoaWxkKGNhbmNlbCk7CiAgY2FuY2VsLnRleHRDb250ZW50ID0gJ0NhbmNlbCB1cGxvYWQnOwogIGNvbnN0IGNhbmNlbFByb21pc2UgPSBuZXcgUHJvbWlzZSgocmVzb2x2ZSkgPT4gewogICAgY2FuY2VsLm9uY2xpY2sgPSAoKSA9PiB7CiAgICAgIHJlc29sdmUobnVsbCk7CiAgICB9OwogIH0pOwoKICAvLyBXYWl0IGZvciB0aGUgdXNlciB0byBwaWNrIHRoZSBmaWxlcy4KICBjb25zdCBmaWxlcyA9IHlpZWxkIHsKICAgIHByb21pc2U6IFByb21pc2UucmFjZShbcGlja2VkUHJvbWlzZSwgY2FuY2VsUHJvbWlzZV0pLAogICAgcmVzcG9uc2U6IHsKICAgICAgYWN0aW9uOiAnc3RhcnRpbmcnLAogICAgfQogIH07CgogIGNhbmNlbC5yZW1vdmUoKTsKCiAgLy8gRGlzYWJsZSB0aGUgaW5wdXQgZWxlbWVudCBzaW5jZSBmdXJ0aGVyIHBpY2tzIGFyZSBub3QgYWxsb3dlZC4KICBpbnB1dEVsZW1lbnQuZGlzYWJsZWQgPSB0cnVlOwoKICBpZiAoIWZpbGVzKSB7CiAgICByZXR1cm4gewogICAgICByZXNwb25zZTogewogICAgICAgIGFjdGlvbjogJ2NvbXBsZXRlJywKICAgICAgfQogICAgfTsKICB9CgogIGZvciAoY29uc3QgZmlsZSBvZiBmaWxlcykgewogICAgY29uc3QgbGkgPSBkb2N1bWVudC5jcmVhdGVFbGVtZW50KCdsaScpOwogICAgbGkuYXBwZW5kKHNwYW4oZmlsZS5uYW1lLCB7Zm9udFdlaWdodDogJ2JvbGQnfSkpOwogICAgbGkuYXBwZW5kKHNwYW4oCiAgICAgICAgYCgke2ZpbGUudHlwZSB8fCAnbi9hJ30pIC0gJHtmaWxlLnNpemV9IGJ5dGVzLCBgICsKICAgICAgICBgbGFzdCBtb2RpZmllZDogJHsKICAgICAgICAgICAgZmlsZS5sYXN0TW9kaWZpZWREYXRlID8gZmlsZS5sYXN0TW9kaWZpZWREYXRlLnRvTG9jYWxlRGF0ZVN0cmluZygpIDoKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgJ24vYSd9IC0gYCkpOwogICAgY29uc3QgcGVyY2VudCA9IHNwYW4oJzAlIGRvbmUnKTsKICAgIGxpLmFwcGVuZENoaWxkKHBlcmNlbnQpOwoKICAgIG91dHB1dEVsZW1lbnQuYXBwZW5kQ2hpbGQobGkpOwoKICAgIGNvbnN0IGZpbGVEYXRhUHJvbWlzZSA9IG5ldyBQcm9taXNlKChyZXNvbHZlKSA9PiB7CiAgICAgIGNvbnN0IHJlYWRlciA9IG5ldyBGaWxlUmVhZGVyKCk7CiAgICAgIHJlYWRlci5vbmxvYWQgPSAoZSkgPT4gewogICAgICAgIHJlc29sdmUoZS50YXJnZXQucmVzdWx0KTsKICAgICAgfTsKICAgICAgcmVhZGVyLnJlYWRBc0FycmF5QnVmZmVyKGZpbGUpOwogICAgfSk7CiAgICAvLyBXYWl0IGZvciB0aGUgZGF0YSB0byBiZSByZWFkeS4KICAgIGxldCBmaWxlRGF0YSA9IHlpZWxkIHsKICAgICAgcHJvbWlzZTogZmlsZURhdGFQcm9taXNlLAogICAgICByZXNwb25zZTogewogICAgICAgIGFjdGlvbjogJ2NvbnRpbnVlJywKICAgICAgfQogICAgfTsKCiAgICAvLyBVc2UgYSBjaHVua2VkIHNlbmRpbmcgdG8gYXZvaWQgbWVzc2FnZSBzaXplIGxpbWl0cy4gU2VlIGIvNjIxMTU2NjAuCiAgICBsZXQgcG9zaXRpb24gPSAwOwogICAgZG8gewogICAgICBjb25zdCBsZW5ndGggPSBNYXRoLm1pbihmaWxlRGF0YS5ieXRlTGVuZ3RoIC0gcG9zaXRpb24sIE1BWF9QQVlMT0FEX1NJWkUpOwogICAgICBjb25zdCBjaHVuayA9IG5ldyBVaW50OEFycmF5KGZpbGVEYXRhLCBwb3NpdGlvbiwgbGVuZ3RoKTsKICAgICAgcG9zaXRpb24gKz0gbGVuZ3RoOwoKICAgICAgY29uc3QgYmFzZTY0ID0gYnRvYShTdHJpbmcuZnJvbUNoYXJDb2RlLmFwcGx5KG51bGwsIGNodW5rKSk7CiAgICAgIHlpZWxkIHsKICAgICAgICByZXNwb25zZTogewogICAgICAgICAgYWN0aW9uOiAnYXBwZW5kJywKICAgICAgICAgIGZpbGU6IGZpbGUubmFtZSwKICAgICAgICAgIGRhdGE6IGJhc2U2NCwKICAgICAgICB9LAogICAgICB9OwoKICAgICAgbGV0IHBlcmNlbnREb25lID0gZmlsZURhdGEuYnl0ZUxlbmd0aCA9PT0gMCA/CiAgICAgICAgICAxMDAgOgogICAgICAgICAgTWF0aC5yb3VuZCgocG9zaXRpb24gLyBmaWxlRGF0YS5ieXRlTGVuZ3RoKSAqIDEwMCk7CiAgICAgIHBlcmNlbnQudGV4dENvbnRlbnQgPSBgJHtwZXJjZW50RG9uZX0lIGRvbmVgOwoKICAgIH0gd2hpbGUgKHBvc2l0aW9uIDwgZmlsZURhdGEuYnl0ZUxlbmd0aCk7CiAgfQoKICAvLyBBbGwgZG9uZS4KICB5aWVsZCB7CiAgICByZXNwb25zZTogewogICAgICBhY3Rpb246ICdjb21wbGV0ZScsCiAgICB9CiAgfTsKfQoKc2NvcGUuZ29vZ2xlID0gc2NvcGUuZ29vZ2xlIHx8IHt9OwpzY29wZS5nb29nbGUuY29sYWIgPSBzY29wZS5nb29nbGUuY29sYWIgfHwge307CnNjb3BlLmdvb2dsZS5jb2xhYi5fZmlsZXMgPSB7CiAgX3VwbG9hZEZpbGVzLAogIF91cGxvYWRGaWxlc0NvbnRpbnVlLAp9Owp9KShzZWxmKTsK",
              "ok": true,
              "headers": [
                [
                  "content-type",
                  "application/javascript"
                ]
              ],
              "status": 200,
              "status_text": ""
            }
          },
          "base_uri": "https://localhost:8080/",
          "height": 90
        },
        "id": "zXd4RqwWhEZg",
        "outputId": "797f1a6b-ef6c-4280-d9ac-36c7890f9572"
      },
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<IPython.core.display.HTML object>"
            ],
            "text/html": [
              "\n",
              "     <input type=\"file\" id=\"files-4b458230-b1bb-4fa3-89ef-35086e888e39\" name=\"files[]\" multiple disabled\n",
              "        style=\"border:none\" />\n",
              "     <output id=\"result-4b458230-b1bb-4fa3-89ef-35086e888e39\">\n",
              "      Upload widget is only available when the cell has been executed in the\n",
              "      current browser session. Please rerun this cell to enable.\n",
              "      </output>\n",
              "      <script src=\"/nbextensions/google.colab/files.js\"></script> "
            ]
          },
          "metadata": {}
        },
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Saving NDAP_REPORT_7004.xlsx to NDAP_REPORT_7004.xlsx\n",
            "User uploaded file \"{name}\" with length {length} bytes.\n"
          ]
        }
      ],
      "source": [
        "# Uploading data files \n",
        "\n",
        "from google.colab import files # importing files library from google colab\n",
        "\n",
        "upload = files.upload() # upload files\n",
        "\n",
        "for fn in upload.keys() :\n",
        "    print('User uploaded file \"{name}\" with length {length} bytes.') # print file name and its size\n"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# importing libraries\n",
        "\n",
        "import numpy as np\n",
        "import pandas as pd\n",
        "import seaborn as sb\n",
        "import matplotlib.pyplot as plt"
      ],
      "metadata": {
        "id": "5Me6r5I-jQE5"
      },
      "execution_count": 3,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "**Reading the file and displaying the information**"
      ],
      "metadata": {
        "id": "h_4tyec8jr21"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data_file = pd.read_excel('NDAP_REPORT_7004.xlsx')\n",
        "\n",
        "display(data_file)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "z1fLGhNvjz6q",
        "outputId": "beb85c02-1e5f-4c3a-e07a-aa22c8b259b6"
      },
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "      Rowid Country  State lgd code  \\\n",
              "0         1   India               1   \n",
              "1         2   India               1   \n",
              "2         3   India               1   \n",
              "3         4   India               1   \n",
              "4         5   India               1   \n",
              "...     ...     ...             ...   \n",
              "1468   1469   India              38   \n",
              "1469   1470   India              38   \n",
              "1470   1471   India              38   \n",
              "1471   1472   India              38   \n",
              "1472   1473   India              38   \n",
              "\n",
              "                                             State  District lgd code  \\\n",
              "0                                Jammu And Kashmir                  1   \n",
              "1                                Jammu And Kashmir                  1   \n",
              "2                                Jammu And Kashmir                  2   \n",
              "3                                Jammu And Kashmir                  2   \n",
              "4                                Jammu And Kashmir                  3   \n",
              "...                                            ...                ...   \n",
              "1468  The Dadra And Nagar Haveli And Daman And Diu                463   \n",
              "1469  The Dadra And Nagar Haveli And Daman And Diu                464   \n",
              "1470  The Dadra And Nagar Haveli And Daman And Diu                464   \n",
              "1471  The Dadra And Nagar Haveli And Daman And Diu                465   \n",
              "1472  The Dadra And Nagar Haveli And Daman And Diu                465   \n",
              "\n",
              "                    District  Year Type of residence namely rural or urban  \\\n",
              "0                   Anantnag  2011                                   Rural   \n",
              "1                   Anantnag  2011                                   Urban   \n",
              "2                     Budgam  2011                                   Rural   \n",
              "3                     Budgam  2011                                   Urban   \n",
              "4                  Baramulla  2011                                   Rural   \n",
              "...                      ...   ...                                     ...   \n",
              "1468                   Daman  2011                                   Urban   \n",
              "1469                     Diu  2011                                   Rural   \n",
              "1470                     Diu  2011                                   Urban   \n",
              "1471  Dadra And Nagar Haveli  2011                                   Rural   \n",
              "1472  Dadra And Nagar Haveli  2011                                   Urban   \n",
              "\n",
              "     Number of census houses  \\\n",
              "0                     109465   \n",
              "1                      33522   \n",
              "2                85561.57321   \n",
              "3                      13136   \n",
              "4                120312.4268   \n",
              "...                      ...   \n",
              "1468                   42352   \n",
              "1469                    5410   \n",
              "1470                    5279   \n",
              "1471                   35408   \n",
              "1472                   37655   \n",
              "\n",
              "     Houses having grass or thatch or bamboo etc. as material of wall  \\\n",
              "0                                                   270                 \n",
              "1                                                    69                 \n",
              "2                                             134.18227                 \n",
              "3                                                    49                 \n",
              "4                                             410.81773                 \n",
              "...                                                 ...                 \n",
              "1468                                                202                 \n",
              "1469                                                  6                 \n",
              "1470                                                 11                 \n",
              "1471                                              16428                 \n",
              "1472                                               2156                 \n",
              "\n",
              "     Houses having plastic or polythene as material of wall  \\\n",
              "0                                                  1331       \n",
              "1                                                   121       \n",
              "2                                            168.970266       \n",
              "3                                                    27       \n",
              "4                                            173.029734       \n",
              "...                                                 ...       \n",
              "1468                                                150       \n",
              "1469                                                  0       \n",
              "1470                                                  1       \n",
              "1471                                                 62       \n",
              "1472                                                140       \n",
              "\n",
              "      Houses having mud or unburnt brick as material of wall  \\\n",
              "0                                          22710.000000        \n",
              "1                                           6807.000000        \n",
              "2                                           7174.278724        \n",
              "3                                            935.000000        \n",
              "4                                          19207.721280        \n",
              "...                                                 ...        \n",
              "1468                                         426.000000        \n",
              "1469                                          50.000000        \n",
              "1470                                           6.000000        \n",
              "1471                                        4939.000000        \n",
              "1472                                        1667.000000        \n",
              "\n",
              "      Houses having wood as material of wall  \\\n",
              "0                                 3014.00000   \n",
              "1                                  123.00000   \n",
              "2                                  960.14869   \n",
              "3                                   24.00000   \n",
              "4                                 3227.85131   \n",
              "...                                      ...   \n",
              "1468                                95.00000   \n",
              "1469                                 2.00000   \n",
              "1470                                 0.00000   \n",
              "1471                               145.00000   \n",
              "1472                               142.00000   \n",
              "\n",
              "      Houses having stone not packed with mortar as material of wall  \\\n",
              "0                                           3034.000000                \n",
              "1                                            268.000000                \n",
              "2                                            748.438886                \n",
              "3                                            187.000000                \n",
              "4                                          12552.561110                \n",
              "...                                                 ...                \n",
              "1468                                          72.000000                \n",
              "1469                                         238.000000                \n",
              "1470                                         165.000000                \n",
              "1471                                         113.000000                \n",
              "1472                                         136.000000                \n",
              "\n",
              "      Houses having stone packed with mortar as material of wall  \\\n",
              "0                                            480.000000            \n",
              "1                                             93.000000            \n",
              "2                                            306.134365            \n",
              "3                                             30.000000            \n",
              "4                                           5479.865635            \n",
              "...                                                 ...            \n",
              "1468                                         185.000000            \n",
              "1469                                        5094.000000            \n",
              "1470                                        4820.000000            \n",
              "1471                                          74.000000            \n",
              "1472                                         157.000000            \n",
              "\n",
              "      Houses having galvanized iron (gi) sheets or metal or asbestos sheets as material of wall  \\\n",
              "0                                            229.000000                                           \n",
              "1                                             98.000000                                           \n",
              "2                                            214.691633                                           \n",
              "3                                             39.000000                                           \n",
              "4                                           1740.308367                                           \n",
              "...                                                 ...                                           \n",
              "1468                                         130.000000                                           \n",
              "1469                                           0.000000                                           \n",
              "1470                                          11.000000                                           \n",
              "1471                                          96.000000                                           \n",
              "1472                                         281.000000                                           \n",
              "\n",
              "      Houses having burnt brick as material of wall  \\\n",
              "0                                       76229.00000   \n",
              "1                                       23789.00000   \n",
              "2                                       73342.04111   \n",
              "3                                       11297.00000   \n",
              "4                                       72686.95889   \n",
              "...                                             ...   \n",
              "1468                                    39160.00000   \n",
              "1469                                        2.00000   \n",
              "1470                                      147.00000   \n",
              "1471                                    12642.00000   \n",
              "1472                                    31404.00000   \n",
              "\n",
              "      Houses having concrete as material of wall  \\\n",
              "0                                    1400.000000   \n",
              "1                                    1894.000000   \n",
              "2                                    1013.821599   \n",
              "3                                     454.000000   \n",
              "4                                    2118.178401   \n",
              "...                                          ...   \n",
              "1468                                 1927.000000   \n",
              "1469                                    5.000000   \n",
              "1470                                  116.000000   \n",
              "1471                                  897.000000   \n",
              "1472                                 1549.000000   \n",
              "\n",
              "      Houses having any other material of wall  \n",
              "0                                   768.000000  \n",
              "1                                   260.000000  \n",
              "2                                  1498.865657  \n",
              "3                                    94.000000  \n",
              "4                                  2715.134343  \n",
              "...                                        ...  \n",
              "1468                                  5.000000  \n",
              "1469                                 13.000000  \n",
              "1470                                  2.000000  \n",
              "1471                                 12.000000  \n",
              "1472                                 23.000000  \n",
              "\n",
              "[1473 rows x 19 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-e8239a0d-9aa2-4720-b964-6115cfd26665\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Rowid</th>\n",
              "      <th>Country</th>\n",
              "      <th>State lgd code</th>\n",
              "      <th>State</th>\n",
              "      <th>District lgd code</th>\n",
              "      <th>District</th>\n",
              "      <th>Year</th>\n",
              "      <th>Type of residence namely rural or urban</th>\n",
              "      <th>Number of census houses</th>\n",
              "      <th>Houses having grass or thatch or bamboo etc. as material of wall</th>\n",
              "      <th>Houses having plastic or polythene as material of wall</th>\n",
              "      <th>Houses having mud or unburnt brick as material of wall</th>\n",
              "      <th>Houses having wood as material of wall</th>\n",
              "      <th>Houses having stone not packed with mortar as material of wall</th>\n",
              "      <th>Houses having stone packed with mortar as material of wall</th>\n",
              "      <th>Houses having galvanized iron (gi) sheets or metal or asbestos sheets as material of wall</th>\n",
              "      <th>Houses having burnt brick as material of wall</th>\n",
              "      <th>Houses having concrete as material of wall</th>\n",
              "      <th>Houses having any other material of wall</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>India</td>\n",
              "      <td>1</td>\n",
              "      <td>Jammu And Kashmir</td>\n",
              "      <td>1</td>\n",
              "      <td>Anantnag</td>\n",
              "      <td>2011</td>\n",
              "      <td>Rural</td>\n",
              "      <td>109465</td>\n",
              "      <td>270</td>\n",
              "      <td>1331</td>\n",
              "      <td>22710.000000</td>\n",
              "      <td>3014.00000</td>\n",
              "      <td>3034.000000</td>\n",
              "      <td>480.000000</td>\n",
              "      <td>229.000000</td>\n",
              "      <td>76229.00000</td>\n",
              "      <td>1400.000000</td>\n",
              "      <td>768.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>India</td>\n",
              "      <td>1</td>\n",
              "      <td>Jammu And Kashmir</td>\n",
              "      <td>1</td>\n",
              "      <td>Anantnag</td>\n",
              "      <td>2011</td>\n",
              "      <td>Urban</td>\n",
              "      <td>33522</td>\n",
              "      <td>69</td>\n",
              "      <td>121</td>\n",
              "      <td>6807.000000</td>\n",
              "      <td>123.00000</td>\n",
              "      <td>268.000000</td>\n",
              "      <td>93.000000</td>\n",
              "      <td>98.000000</td>\n",
              "      <td>23789.00000</td>\n",
              "      <td>1894.000000</td>\n",
              "      <td>260.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>India</td>\n",
              "      <td>1</td>\n",
              "      <td>Jammu And Kashmir</td>\n",
              "      <td>2</td>\n",
              "      <td>Budgam</td>\n",
              "      <td>2011</td>\n",
              "      <td>Rural</td>\n",
              "      <td>85561.57321</td>\n",
              "      <td>134.18227</td>\n",
              "      <td>168.970266</td>\n",
              "      <td>7174.278724</td>\n",
              "      <td>960.14869</td>\n",
              "      <td>748.438886</td>\n",
              "      <td>306.134365</td>\n",
              "      <td>214.691633</td>\n",
              "      <td>73342.04111</td>\n",
              "      <td>1013.821599</td>\n",
              "      <td>1498.865657</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4</td>\n",
              "      <td>India</td>\n",
              "      <td>1</td>\n",
              "      <td>Jammu And Kashmir</td>\n",
              "      <td>2</td>\n",
              "      <td>Budgam</td>\n",
              "      <td>2011</td>\n",
              "      <td>Urban</td>\n",
              "      <td>13136</td>\n",
              "      <td>49</td>\n",
              "      <td>27</td>\n",
              "      <td>935.000000</td>\n",
              "      <td>24.00000</td>\n",
              "      <td>187.000000</td>\n",
              "      <td>30.000000</td>\n",
              "      <td>39.000000</td>\n",
              "      <td>11297.00000</td>\n",
              "      <td>454.000000</td>\n",
              "      <td>94.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5</td>\n",
              "      <td>India</td>\n",
              "      <td>1</td>\n",
              "      <td>Jammu And Kashmir</td>\n",
              "      <td>3</td>\n",
              "      <td>Baramulla</td>\n",
              "      <td>2011</td>\n",
              "      <td>Rural</td>\n",
              "      <td>120312.4268</td>\n",
              "      <td>410.81773</td>\n",
              "      <td>173.029734</td>\n",
              "      <td>19207.721280</td>\n",
              "      <td>3227.85131</td>\n",
              "      <td>12552.561110</td>\n",
              "      <td>5479.865635</td>\n",
              "      <td>1740.308367</td>\n",
              "      <td>72686.95889</td>\n",
              "      <td>2118.178401</td>\n",
              "      <td>2715.134343</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1468</th>\n",
              "      <td>1469</td>\n",
              "      <td>India</td>\n",
              "      <td>38</td>\n",
              "      <td>The Dadra And Nagar Haveli And Daman And Diu</td>\n",
              "      <td>463</td>\n",
              "      <td>Daman</td>\n",
              "      <td>2011</td>\n",
              "      <td>Urban</td>\n",
              "      <td>42352</td>\n",
              "      <td>202</td>\n",
              "      <td>150</td>\n",
              "      <td>426.000000</td>\n",
              "      <td>95.00000</td>\n",
              "      <td>72.000000</td>\n",
              "      <td>185.000000</td>\n",
              "      <td>130.000000</td>\n",
              "      <td>39160.00000</td>\n",
              "      <td>1927.000000</td>\n",
              "      <td>5.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1469</th>\n",
              "      <td>1470</td>\n",
              "      <td>India</td>\n",
              "      <td>38</td>\n",
              "      <td>The Dadra And Nagar Haveli And Daman And Diu</td>\n",
              "      <td>464</td>\n",
              "      <td>Diu</td>\n",
              "      <td>2011</td>\n",
              "      <td>Rural</td>\n",
              "      <td>5410</td>\n",
              "      <td>6</td>\n",
              "      <td>0</td>\n",
              "      <td>50.000000</td>\n",
              "      <td>2.00000</td>\n",
              "      <td>238.000000</td>\n",
              "      <td>5094.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>2.00000</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>13.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1470</th>\n",
              "      <td>1471</td>\n",
              "      <td>India</td>\n",
              "      <td>38</td>\n",
              "      <td>The Dadra And Nagar Haveli And Daman And Diu</td>\n",
              "      <td>464</td>\n",
              "      <td>Diu</td>\n",
              "      <td>2011</td>\n",
              "      <td>Urban</td>\n",
              "      <td>5279</td>\n",
              "      <td>11</td>\n",
              "      <td>1</td>\n",
              "      <td>6.000000</td>\n",
              "      <td>0.00000</td>\n",
              "      <td>165.000000</td>\n",
              "      <td>4820.000000</td>\n",
              "      <td>11.000000</td>\n",
              "      <td>147.00000</td>\n",
              "      <td>116.000000</td>\n",
              "      <td>2.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1471</th>\n",
              "      <td>1472</td>\n",
              "      <td>India</td>\n",
              "      <td>38</td>\n",
              "      <td>The Dadra And Nagar Haveli And Daman And Diu</td>\n",
              "      <td>465</td>\n",
              "      <td>Dadra And Nagar Haveli</td>\n",
              "      <td>2011</td>\n",
              "      <td>Rural</td>\n",
              "      <td>35408</td>\n",
              "      <td>16428</td>\n",
              "      <td>62</td>\n",
              "      <td>4939.000000</td>\n",
              "      <td>145.00000</td>\n",
              "      <td>113.000000</td>\n",
              "      <td>74.000000</td>\n",
              "      <td>96.000000</td>\n",
              "      <td>12642.00000</td>\n",
              "      <td>897.000000</td>\n",
              "      <td>12.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1472</th>\n",
              "      <td>1473</td>\n",
              "      <td>India</td>\n",
              "      <td>38</td>\n",
              "      <td>The Dadra And Nagar Haveli And Daman And Diu</td>\n",
              "      <td>465</td>\n",
              "      <td>Dadra And Nagar Haveli</td>\n",
              "      <td>2011</td>\n",
              "      <td>Urban</td>\n",
              "      <td>37655</td>\n",
              "      <td>2156</td>\n",
              "      <td>140</td>\n",
              "      <td>1667.000000</td>\n",
              "      <td>142.00000</td>\n",
              "      <td>136.000000</td>\n",
              "      <td>157.000000</td>\n",
              "      <td>281.000000</td>\n",
              "      <td>31404.00000</td>\n",
              "      <td>1549.000000</td>\n",
              "      <td>23.000000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1473 rows × 19 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-e8239a0d-9aa2-4720-b964-6115cfd26665')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-e8239a0d-9aa2-4720-b964-6115cfd26665 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-e8239a0d-9aa2-4720-b964-6115cfd26665');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "**Printing number of coulmns and rows in the file**"
      ],
      "metadata": {
        "id": "A3NIZj99krZw"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "print('number of rows: ',str(data_file.shape[0]))\n",
        "print('number of columns: ',str(data_file.shape[1]))"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ax9dzlv0k10Q",
        "outputId": "a7b27ae8-d392-46c3-e035-a61c08cdabd0"
      },
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "number of rows:  1473\n",
            "number of coulmns:  19\n"
          ]
        }
      ]
    }
  ]
}