Pandas_Tutorial.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 132,
   "id": "ae97003c",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "c5a20bba",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv('Business-employment-data-september-2022-quarter-csv.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "922dd138",
   "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>Series_reference</th>\n",
       "      <th>Period</th>\n",
       "      <th>Data_value</th>\n",
       "      <th>Suppressed</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>UNITS</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Subject</th>\n",
       "      <th>Group</th>\n",
       "      <th>Series_title_1</th>\n",
       "      <th>Series_title_2</th>\n",
       "      <th>Series_title_3</th>\n",
       "      <th>Series_title_4</th>\n",
       "      <th>Series_title_5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2011.06</td>\n",
       "      <td>80078.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2011.09</td>\n",
       "      <td>78324.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2011.12</td>\n",
       "      <td>85850.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2012.03</td>\n",
       "      <td>90743.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2012.06</td>\n",
       "      <td>81780.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20636</th>\n",
       "      <td>BDCQ.SEE3999A</td>\n",
       "      <td>2017.06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Y</td>\n",
       "      <td>C</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Territorial authority by employment variable</td>\n",
       "      <td>Filled jobs (workplace location based)</td>\n",
       "      <td>Area Outside Territorial Authority</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20637</th>\n",
       "      <td>BDCQ.SEE3999A</td>\n",
       "      <td>2017.09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Y</td>\n",
       "      <td>C</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Territorial authority by employment variable</td>\n",
       "      <td>Filled jobs (workplace location based)</td>\n",
       "      <td>Area Outside Territorial Authority</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20638</th>\n",
       "      <td>BDCQ.SEE3999A</td>\n",
       "      <td>2017.12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Y</td>\n",
       "      <td>C</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Territorial authority by employment variable</td>\n",
       "      <td>Filled jobs (workplace location based)</td>\n",
       "      <td>Area Outside Territorial Authority</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20639</th>\n",
       "      <td>BDCQ.SEE3999A</td>\n",
       "      <td>2018.03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Y</td>\n",
       "      <td>C</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Territorial authority by employment variable</td>\n",
       "      <td>Filled jobs (workplace location based)</td>\n",
       "      <td>Area Outside Territorial Authority</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20640</th>\n",
       "      <td>BDCQ.SEE3999A</td>\n",
       "      <td>2018.06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Y</td>\n",
       "      <td>C</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Territorial authority by employment variable</td>\n",
       "      <td>Filled jobs (workplace location based)</td>\n",
       "      <td>Area Outside Territorial Authority</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20641 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Series_reference   Period  Data_value Suppressed STATUS   UNITS  \\\n",
       "0          BDCQ.SEA1AA  2011.06     80078.0        NaN      F  Number   \n",
       "1          BDCQ.SEA1AA  2011.09     78324.0        NaN      F  Number   \n",
       "2          BDCQ.SEA1AA  2011.12     85850.0        NaN      F  Number   \n",
       "3          BDCQ.SEA1AA  2012.03     90743.0        NaN      F  Number   \n",
       "4          BDCQ.SEA1AA  2012.06     81780.0        NaN      F  Number   \n",
       "...                ...      ...         ...        ...    ...     ...   \n",
       "20636    BDCQ.SEE3999A  2017.06         NaN          Y      C  Number   \n",
       "20637    BDCQ.SEE3999A  2017.09         NaN          Y      C  Number   \n",
       "20638    BDCQ.SEE3999A  2017.12         NaN          Y      C  Number   \n",
       "20639    BDCQ.SEE3999A  2018.03         NaN          Y      C  Number   \n",
       "20640    BDCQ.SEE3999A  2018.06         NaN          Y      C  Number   \n",
       "\n",
       "       Magnitude                         Subject  \\\n",
       "0              0  Business Data Collection - BDC   \n",
       "1              0  Business Data Collection - BDC   \n",
       "2              0  Business Data Collection - BDC   \n",
       "3              0  Business Data Collection - BDC   \n",
       "4              0  Business Data Collection - BDC   \n",
       "...          ...                             ...   \n",
       "20636          0  Business Data Collection - BDC   \n",
       "20637          0  Business Data Collection - BDC   \n",
       "20638          0  Business Data Collection - BDC   \n",
       "20639          0  Business Data Collection - BDC   \n",
       "20640          0  Business Data Collection - BDC   \n",
       "\n",
       "                                              Group  \\\n",
       "0                   Industry by employment variable   \n",
       "1                   Industry by employment variable   \n",
       "2                   Industry by employment variable   \n",
       "3                   Industry by employment variable   \n",
       "4                   Industry by employment variable   \n",
       "...                                             ...   \n",
       "20636  Territorial authority by employment variable   \n",
       "20637  Territorial authority by employment variable   \n",
       "20638  Territorial authority by employment variable   \n",
       "20639  Territorial authority by employment variable   \n",
       "20640  Territorial authority by employment variable   \n",
       "\n",
       "                               Series_title_1  \\\n",
       "0                                 Filled jobs   \n",
       "1                                 Filled jobs   \n",
       "2                                 Filled jobs   \n",
       "3                                 Filled jobs   \n",
       "4                                 Filled jobs   \n",
       "...                                       ...   \n",
       "20636  Filled jobs (workplace location based)   \n",
       "20637  Filled jobs (workplace location based)   \n",
       "20638  Filled jobs (workplace location based)   \n",
       "20639  Filled jobs (workplace location based)   \n",
       "20640  Filled jobs (workplace location based)   \n",
       "\n",
       "                           Series_title_2 Series_title_3  Series_title_4  \\\n",
       "0       Agriculture, Forestry and Fishing         Actual             NaN   \n",
       "1       Agriculture, Forestry and Fishing         Actual             NaN   \n",
       "2       Agriculture, Forestry and Fishing         Actual             NaN   \n",
       "3       Agriculture, Forestry and Fishing         Actual             NaN   \n",
       "4       Agriculture, Forestry and Fishing         Actual             NaN   \n",
       "...                                   ...            ...             ...   \n",
       "20636  Area Outside Territorial Authority         Actual             NaN   \n",
       "20637  Area Outside Territorial Authority         Actual             NaN   \n",
       "20638  Area Outside Territorial Authority         Actual             NaN   \n",
       "20639  Area Outside Territorial Authority         Actual             NaN   \n",
       "20640  Area Outside Territorial Authority         Actual             NaN   \n",
       "\n",
       "       Series_title_5  \n",
       "0                 NaN  \n",
       "1                 NaN  \n",
       "2                 NaN  \n",
       "3                 NaN  \n",
       "4                 NaN  \n",
       "...               ...  \n",
       "20636             NaN  \n",
       "20637             NaN  \n",
       "20638             NaN  \n",
       "20639             NaN  \n",
       "20640             NaN  \n",
       "\n",
       "[20641 rows x 14 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "441864db",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.frame.DataFrame"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "51f98a0e",
   "metadata": {
    "scrolled": false
   },
   "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>Series_reference</th>\n",
       "      <th>Period</th>\n",
       "      <th>Data_value</th>\n",
       "      <th>Suppressed</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>UNITS</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Subject</th>\n",
       "      <th>Group</th>\n",
       "      <th>Series_title_1</th>\n",
       "      <th>Series_title_2</th>\n",
       "      <th>Series_title_3</th>\n",
       "      <th>Series_title_4</th>\n",
       "      <th>Series_title_5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2011.06</td>\n",
       "      <td>80078.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2011.09</td>\n",
       "      <td>78324.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2011.12</td>\n",
       "      <td>85850.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2012.03</td>\n",
       "      <td>90743.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2012.06</td>\n",
       "      <td>81780.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Series_reference   Period  Data_value Suppressed STATUS   UNITS  Magnitude  \\\n",
       "0      BDCQ.SEA1AA  2011.06     80078.0        NaN      F  Number          0   \n",
       "1      BDCQ.SEA1AA  2011.09     78324.0        NaN      F  Number          0   \n",
       "2      BDCQ.SEA1AA  2011.12     85850.0        NaN      F  Number          0   \n",
       "3      BDCQ.SEA1AA  2012.03     90743.0        NaN      F  Number          0   \n",
       "4      BDCQ.SEA1AA  2012.06     81780.0        NaN      F  Number          0   \n",
       "\n",
       "                          Subject                            Group  \\\n",
       "0  Business Data Collection - BDC  Industry by employment variable   \n",
       "1  Business Data Collection - BDC  Industry by employment variable   \n",
       "2  Business Data Collection - BDC  Industry by employment variable   \n",
       "3  Business Data Collection - BDC  Industry by employment variable   \n",
       "4  Business Data Collection - BDC  Industry by employment variable   \n",
       "\n",
       "  Series_title_1                     Series_title_2 Series_title_3  \\\n",
       "0    Filled jobs  Agriculture, Forestry and Fishing         Actual   \n",
       "1    Filled jobs  Agriculture, Forestry and Fishing         Actual   \n",
       "2    Filled jobs  Agriculture, Forestry and Fishing         Actual   \n",
       "3    Filled jobs  Agriculture, Forestry and Fishing         Actual   \n",
       "4    Filled jobs  Agriculture, Forestry and Fishing         Actual   \n",
       "\n",
       "   Series_title_4  Series_title_5  \n",
       "0             NaN             NaN  \n",
       "1             NaN             NaN  \n",
       "2             NaN             NaN  \n",
       "3             NaN             NaN  \n",
       "4             NaN             NaN  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "4f14d320",
   "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>Series_reference</th>\n",
       "      <th>Period</th>\n",
       "      <th>Data_value</th>\n",
       "      <th>Suppressed</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>UNITS</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Subject</th>\n",
       "      <th>Group</th>\n",
       "      <th>Series_title_1</th>\n",
       "      <th>Series_title_2</th>\n",
       "      <th>Series_title_3</th>\n",
       "      <th>Series_title_4</th>\n",
       "      <th>Series_title_5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>20636</th>\n",
       "      <td>BDCQ.SEE3999A</td>\n",
       "      <td>2017.06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Y</td>\n",
       "      <td>C</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Territorial authority by employment variable</td>\n",
       "      <td>Filled jobs (workplace location based)</td>\n",
       "      <td>Area Outside Territorial Authority</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20637</th>\n",
       "      <td>BDCQ.SEE3999A</td>\n",
       "      <td>2017.09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Y</td>\n",
       "      <td>C</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Territorial authority by employment variable</td>\n",
       "      <td>Filled jobs (workplace location based)</td>\n",
       "      <td>Area Outside Territorial Authority</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20638</th>\n",
       "      <td>BDCQ.SEE3999A</td>\n",
       "      <td>2017.12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Y</td>\n",
       "      <td>C</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Territorial authority by employment variable</td>\n",
       "      <td>Filled jobs (workplace location based)</td>\n",
       "      <td>Area Outside Territorial Authority</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20639</th>\n",
       "      <td>BDCQ.SEE3999A</td>\n",
       "      <td>2018.03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Y</td>\n",
       "      <td>C</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Territorial authority by employment variable</td>\n",
       "      <td>Filled jobs (workplace location based)</td>\n",
       "      <td>Area Outside Territorial Authority</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20640</th>\n",
       "      <td>BDCQ.SEE3999A</td>\n",
       "      <td>2018.06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Y</td>\n",
       "      <td>C</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Territorial authority by employment variable</td>\n",
       "      <td>Filled jobs (workplace location based)</td>\n",
       "      <td>Area Outside Territorial Authority</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Series_reference   Period  Data_value Suppressed STATUS   UNITS  \\\n",
       "20636    BDCQ.SEE3999A  2017.06         NaN          Y      C  Number   \n",
       "20637    BDCQ.SEE3999A  2017.09         NaN          Y      C  Number   \n",
       "20638    BDCQ.SEE3999A  2017.12         NaN          Y      C  Number   \n",
       "20639    BDCQ.SEE3999A  2018.03         NaN          Y      C  Number   \n",
       "20640    BDCQ.SEE3999A  2018.06         NaN          Y      C  Number   \n",
       "\n",
       "       Magnitude                         Subject  \\\n",
       "20636          0  Business Data Collection - BDC   \n",
       "20637          0  Business Data Collection - BDC   \n",
       "20638          0  Business Data Collection - BDC   \n",
       "20639          0  Business Data Collection - BDC   \n",
       "20640          0  Business Data Collection - BDC   \n",
       "\n",
       "                                              Group  \\\n",
       "20636  Territorial authority by employment variable   \n",
       "20637  Territorial authority by employment variable   \n",
       "20638  Territorial authority by employment variable   \n",
       "20639  Territorial authority by employment variable   \n",
       "20640  Territorial authority by employment variable   \n",
       "\n",
       "                               Series_title_1  \\\n",
       "20636  Filled jobs (workplace location based)   \n",
       "20637  Filled jobs (workplace location based)   \n",
       "20638  Filled jobs (workplace location based)   \n",
       "20639  Filled jobs (workplace location based)   \n",
       "20640  Filled jobs (workplace location based)   \n",
       "\n",
       "                           Series_title_2 Series_title_3  Series_title_4  \\\n",
       "20636  Area Outside Territorial Authority         Actual             NaN   \n",
       "20637  Area Outside Territorial Authority         Actual             NaN   \n",
       "20638  Area Outside Territorial Authority         Actual             NaN   \n",
       "20639  Area Outside Territorial Authority         Actual             NaN   \n",
       "20640  Area Outside Territorial Authority         Actual             NaN   \n",
       "\n",
       "       Series_title_5  \n",
       "20636             NaN  \n",
       "20637             NaN  \n",
       "20638             NaN  \n",
       "20639             NaN  \n",
       "20640             NaN  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "53d3c89b",
   "metadata": {},
   "outputs": [],
   "source": [
    "df1=df.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "ff57931b",
   "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>Series_reference</th>\n",
       "      <th>Period</th>\n",
       "      <th>Data_value</th>\n",
       "      <th>Suppressed</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>UNITS</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Subject</th>\n",
       "      <th>Group</th>\n",
       "      <th>Series_title_1</th>\n",
       "      <th>Series_title_2</th>\n",
       "      <th>Series_title_3</th>\n",
       "      <th>Series_title_4</th>\n",
       "      <th>Series_title_5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>20639</th>\n",
       "      <td>BDCQ.SEE3999A</td>\n",
       "      <td>2018.03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Y</td>\n",
       "      <td>C</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Territorial authority by employment variable</td>\n",
       "      <td>Filled jobs (workplace location based)</td>\n",
       "      <td>Area Outside Territorial Authority</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20640</th>\n",
       "      <td>BDCQ.SEE3999A</td>\n",
       "      <td>2018.06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Y</td>\n",
       "      <td>C</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Territorial authority by employment variable</td>\n",
       "      <td>Filled jobs (workplace location based)</td>\n",
       "      <td>Area Outside Territorial Authority</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Series_reference   Period  Data_value Suppressed STATUS   UNITS  \\\n",
       "20639    BDCQ.SEE3999A  2018.03         NaN          Y      C  Number   \n",
       "20640    BDCQ.SEE3999A  2018.06         NaN          Y      C  Number   \n",
       "\n",
       "       Magnitude                         Subject  \\\n",
       "20639          0  Business Data Collection - BDC   \n",
       "20640          0  Business Data Collection - BDC   \n",
       "\n",
       "                                              Group  \\\n",
       "20639  Territorial authority by employment variable   \n",
       "20640  Territorial authority by employment variable   \n",
       "\n",
       "                               Series_title_1  \\\n",
       "20639  Filled jobs (workplace location based)   \n",
       "20640  Filled jobs (workplace location based)   \n",
       "\n",
       "                           Series_title_2 Series_title_3  Series_title_4  \\\n",
       "20639  Area Outside Territorial Authority         Actual             NaN   \n",
       "20640  Area Outside Territorial Authority         Actual             NaN   \n",
       "\n",
       "       Series_title_5  \n",
       "20639             NaN  \n",
       "20640             NaN  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "295f42fe",
   "metadata": {},
   "outputs": [],
   "source": [
    "df1.to_csv(\"test.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "b367728d",
   "metadata": {},
   "outputs": [],
   "source": [
    "df2= pd.read_csv(\"test.csv\",sep='@',header=None,skiprows=[0,1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "a1e334e8",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>11</th>\n",
       "      <th>12</th>\n",
       "      <th>13</th>\n",
       "      <th>14</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2011.09</td>\n",
       "      <td>78324.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture@ Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   0            1        2        3   4  5       6   7   \\\n",
       "0   1  BDCQ.SEA1AA  2011.09  78324.0 NaN  F  Number   0   \n",
       "\n",
       "                               8                                9   \\\n",
       "0  Business Data Collection - BDC  Industry by employment variable   \n",
       "\n",
       "            10                                 11      12  13  14  \n",
       "0  Filled jobs  Agriculture@ Forestry and Fishing  Actual NaN NaN  "
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "d67ce0ba",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.frame.DataFrame"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(df2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "57780484",
   "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>Series_reference</th>\n",
       "      <th>Period</th>\n",
       "      <th>Data_value</th>\n",
       "      <th>Suppressed</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>UNITS</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Subject</th>\n",
       "      <th>Group</th>\n",
       "      <th>Series_title_1</th>\n",
       "      <th>Series_title_2</th>\n",
       "      <th>Series_title_3</th>\n",
       "      <th>Series_title_4</th>\n",
       "      <th>Series_title_5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2011.06</td>\n",
       "      <td>80078.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2011.09</td>\n",
       "      <td>78324.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2011.12</td>\n",
       "      <td>85850.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2012.03</td>\n",
       "      <td>90743.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2012.06</td>\n",
       "      <td>81780.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Series_reference   Period  Data_value Suppressed STATUS   UNITS  Magnitude  \\\n",
       "0      BDCQ.SEA1AA  2011.06     80078.0        NaN      F  Number          0   \n",
       "1      BDCQ.SEA1AA  2011.09     78324.0        NaN      F  Number          0   \n",
       "2      BDCQ.SEA1AA  2011.12     85850.0        NaN      F  Number          0   \n",
       "3      BDCQ.SEA1AA  2012.03     90743.0        NaN      F  Number          0   \n",
       "4      BDCQ.SEA1AA  2012.06     81780.0        NaN      F  Number          0   \n",
       "\n",
       "                          Subject                            Group  \\\n",
       "0  Business Data Collection - BDC  Industry by employment variable   \n",
       "1  Business Data Collection - BDC  Industry by employment variable   \n",
       "2  Business Data Collection - BDC  Industry by employment variable   \n",
       "3  Business Data Collection - BDC  Industry by employment variable   \n",
       "4  Business Data Collection - BDC  Industry by employment variable   \n",
       "\n",
       "  Series_title_1                     Series_title_2 Series_title_3  \\\n",
       "0    Filled jobs  Agriculture, Forestry and Fishing         Actual   \n",
       "1    Filled jobs  Agriculture, Forestry and Fishing         Actual   \n",
       "2    Filled jobs  Agriculture, Forestry and Fishing         Actual   \n",
       "3    Filled jobs  Agriculture, Forestry and Fishing         Actual   \n",
       "4    Filled jobs  Agriculture, Forestry and Fishing         Actual   \n",
       "\n",
       "   Series_title_4  Series_title_5  \n",
       "0             NaN             NaN  \n",
       "1             NaN             NaN  \n",
       "2             NaN             NaN  \n",
       "3             NaN             NaN  \n",
       "4             NaN             NaN  "
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "c3b750da",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv(\"Business-employment-data-september-2022-quarter-csv.csv\",skiprows=[0,2,4,5])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "50110b45",
   "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>BDCQ.SEA1AA</th>\n",
       "      <th>2011.06</th>\n",
       "      <th>80078</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>F</th>\n",
       "      <th>Number</th>\n",
       "      <th>0</th>\n",
       "      <th>Business Data Collection - BDC</th>\n",
       "      <th>Industry by employment variable</th>\n",
       "      <th>Filled jobs</th>\n",
       "      <th>Agriculture, Forestry and Fishing</th>\n",
       "      <th>Actual</th>\n",
       "      <th>Unnamed: 12</th>\n",
       "      <th>Unnamed: 13</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2011.12</td>\n",
       "      <td>85850.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2012.09</td>\n",
       "      <td>79261.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2012.12</td>\n",
       "      <td>87793.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2013.03</td>\n",
       "      <td>91571.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2013.06</td>\n",
       "      <td>81687.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2013.09</td>\n",
       "      <td>81471.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2013.12</td>\n",
       "      <td>93950.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2014.03</td>\n",
       "      <td>97208.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2014.06</td>\n",
       "      <td>85879.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2014.09</td>\n",
       "      <td>84447.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   BDCQ.SEA1AA  2011.06    80078 Unnamed: 3  F  Number  0  \\\n",
       "0  BDCQ.SEA1AA  2011.12  85850.0        NaN  F  Number  0   \n",
       "1  BDCQ.SEA1AA  2012.09  79261.0        NaN  F  Number  0   \n",
       "2  BDCQ.SEA1AA  2012.12  87793.0        NaN  F  Number  0   \n",
       "3  BDCQ.SEA1AA  2013.03  91571.0        NaN  F  Number  0   \n",
       "4  BDCQ.SEA1AA  2013.06  81687.0        NaN  F  Number  0   \n",
       "5  BDCQ.SEA1AA  2013.09  81471.0        NaN  F  Number  0   \n",
       "6  BDCQ.SEA1AA  2013.12  93950.0        NaN  F  Number  0   \n",
       "7  BDCQ.SEA1AA  2014.03  97208.0        NaN  F  Number  0   \n",
       "8  BDCQ.SEA1AA  2014.06  85879.0        NaN  F  Number  0   \n",
       "9  BDCQ.SEA1AA  2014.09  84447.0        NaN  F  Number  0   \n",
       "\n",
       "   Business Data Collection - BDC  Industry by employment variable  \\\n",
       "0  Business Data Collection - BDC  Industry by employment variable   \n",
       "1  Business Data Collection - BDC  Industry by employment variable   \n",
       "2  Business Data Collection - BDC  Industry by employment variable   \n",
       "3  Business Data Collection - BDC  Industry by employment variable   \n",
       "4  Business Data Collection - BDC  Industry by employment variable   \n",
       "5  Business Data Collection - BDC  Industry by employment variable   \n",
       "6  Business Data Collection - BDC  Industry by employment variable   \n",
       "7  Business Data Collection - BDC  Industry by employment variable   \n",
       "8  Business Data Collection - BDC  Industry by employment variable   \n",
       "9  Business Data Collection - BDC  Industry by employment variable   \n",
       "\n",
       "   Filled jobs  Agriculture, Forestry and Fishing  Actual  Unnamed: 12  \\\n",
       "0  Filled jobs  Agriculture, Forestry and Fishing  Actual          NaN   \n",
       "1  Filled jobs  Agriculture, Forestry and Fishing  Actual          NaN   \n",
       "2  Filled jobs  Agriculture, Forestry and Fishing  Actual          NaN   \n",
       "3  Filled jobs  Agriculture, Forestry and Fishing  Actual          NaN   \n",
       "4  Filled jobs  Agriculture, Forestry and Fishing  Actual          NaN   \n",
       "5  Filled jobs  Agriculture, Forestry and Fishing  Actual          NaN   \n",
       "6  Filled jobs  Agriculture, Forestry and Fishing  Actual          NaN   \n",
       "7  Filled jobs  Agriculture, Forestry and Fishing  Actual          NaN   \n",
       "8  Filled jobs  Agriculture, Forestry and Fishing  Actual          NaN   \n",
       "9  Filled jobs  Agriculture, Forestry and Fishing  Actual          NaN   \n",
       "\n",
       "   Unnamed: 13  \n",
       "0          NaN  \n",
       "1          NaN  \n",
       "2          NaN  \n",
       "3          NaN  \n",
       "4          NaN  \n",
       "5          NaN  \n",
       "6          NaN  \n",
       "7          NaN  \n",
       "8          NaN  \n",
       "9          NaN  "
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "f33ec6bb",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv(\"Business-employment-data-september-2022-quarter-csv.csv\",skiprows=[0,2,4,5],na_values=['Number'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "ba428e11",
   "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>BDCQ.SEA1AA</th>\n",
       "      <th>2011.06</th>\n",
       "      <th>80078</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>F</th>\n",
       "      <th>Number</th>\n",
       "      <th>0</th>\n",
       "      <th>Business Data Collection - BDC</th>\n",
       "      <th>Industry by employment variable</th>\n",
       "      <th>Filled jobs</th>\n",
       "      <th>Agriculture, Forestry and Fishing</th>\n",
       "      <th>Actual</th>\n",
       "      <th>Unnamed: 12</th>\n",
       "      <th>Unnamed: 13</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2011.12</td>\n",
       "      <td>85850.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2012.09</td>\n",
       "      <td>79261.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2012.12</td>\n",
       "      <td>87793.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2013.03</td>\n",
       "      <td>91571.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2013.06</td>\n",
       "      <td>81687.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   BDCQ.SEA1AA  2011.06    80078 Unnamed: 3  F  Number  0  \\\n",
       "0  BDCQ.SEA1AA  2011.12  85850.0        NaN  F  Number  0   \n",
       "1  BDCQ.SEA1AA  2012.09  79261.0        NaN  F  Number  0   \n",
       "2  BDCQ.SEA1AA  2012.12  87793.0        NaN  F  Number  0   \n",
       "3  BDCQ.SEA1AA  2013.03  91571.0        NaN  F  Number  0   \n",
       "4  BDCQ.SEA1AA  2013.06  81687.0        NaN  F  Number  0   \n",
       "\n",
       "   Business Data Collection - BDC  Industry by employment variable  \\\n",
       "0  Business Data Collection - BDC  Industry by employment variable   \n",
       "1  Business Data Collection - BDC  Industry by employment variable   \n",
       "2  Business Data Collection - BDC  Industry by employment variable   \n",
       "3  Business Data Collection - BDC  Industry by employment variable   \n",
       "4  Business Data Collection - BDC  Industry by employment variable   \n",
       "\n",
       "   Filled jobs  Agriculture, Forestry and Fishing  Actual  Unnamed: 12  \\\n",
       "0  Filled jobs  Agriculture, Forestry and Fishing  Actual          NaN   \n",
       "1  Filled jobs  Agriculture, Forestry and Fishing  Actual          NaN   \n",
       "2  Filled jobs  Agriculture, Forestry and Fishing  Actual          NaN   \n",
       "3  Filled jobs  Agriculture, Forestry and Fishing  Actual          NaN   \n",
       "4  Filled jobs  Agriculture, Forestry and Fishing  Actual          NaN   \n",
       "\n",
       "   Unnamed: 13  \n",
       "0          NaN  \n",
       "1          NaN  \n",
       "2          NaN  \n",
       "3          NaN  \n",
       "4          NaN  "
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "8612caf0",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv(\"Business-employment-data-september-2022-quarter-csv.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "c46a6bc5",
   "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>Series_reference</th>\n",
       "      <th>Period</th>\n",
       "      <th>Data_value</th>\n",
       "      <th>Suppressed</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>UNITS</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Subject</th>\n",
       "      <th>Group</th>\n",
       "      <th>Series_title_1</th>\n",
       "      <th>Series_title_2</th>\n",
       "      <th>Series_title_3</th>\n",
       "      <th>Series_title_4</th>\n",
       "      <th>Series_title_5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2011.06</td>\n",
       "      <td>80078.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2011.09</td>\n",
       "      <td>78324.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2011.12</td>\n",
       "      <td>85850.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2012.03</td>\n",
       "      <td>90743.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2012.06</td>\n",
       "      <td>81780.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Series_reference   Period  Data_value Suppressed STATUS   UNITS  Magnitude  \\\n",
       "0      BDCQ.SEA1AA  2011.06     80078.0        NaN      F  Number          0   \n",
       "1      BDCQ.SEA1AA  2011.09     78324.0        NaN      F  Number          0   \n",
       "2      BDCQ.SEA1AA  2011.12     85850.0        NaN      F  Number          0   \n",
       "3      BDCQ.SEA1AA  2012.03     90743.0        NaN      F  Number          0   \n",
       "4      BDCQ.SEA1AA  2012.06     81780.0        NaN      F  Number          0   \n",
       "\n",
       "                          Subject                            Group  \\\n",
       "0  Business Data Collection - BDC  Industry by employment variable   \n",
       "1  Business Data Collection - BDC  Industry by employment variable   \n",
       "2  Business Data Collection - BDC  Industry by employment variable   \n",
       "3  Business Data Collection - BDC  Industry by employment variable   \n",
       "4  Business Data Collection - BDC  Industry by employment variable   \n",
       "\n",
       "  Series_title_1                     Series_title_2 Series_title_3  \\\n",
       "0    Filled jobs  Agriculture, Forestry and Fishing         Actual   \n",
       "1    Filled jobs  Agriculture, Forestry and Fishing         Actual   \n",
       "2    Filled jobs  Agriculture, Forestry and Fishing         Actual   \n",
       "3    Filled jobs  Agriculture, Forestry and Fishing         Actual   \n",
       "4    Filled jobs  Agriculture, Forestry and Fishing         Actual   \n",
       "\n",
       "   Series_title_4  Series_title_5  \n",
       "0             NaN             NaN  \n",
       "1             NaN             NaN  \n",
       "2             NaN             NaN  \n",
       "3             NaN             NaN  \n",
       "4             NaN             NaN  "
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "id": "e0a580cb",
   "metadata": {},
   "outputs": [],
   "source": [
    "df1=pd.read_csv(\"Business-employment-data-september-2022-quarter-csv.csv\",)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "53ccd8ea",
   "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>Period</th>\n",
       "      <th>Data_value</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Series_title_4</th>\n",
       "      <th>Series_title_5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>20641.000000</td>\n",
       "      <td>1.614600e+04</td>\n",
       "      <td>20641.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2016.451399</td>\n",
       "      <td>6.174902e+04</td>\n",
       "      <td>2.367618</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>3.279618</td>\n",
       "      <td>1.865759e+05</td>\n",
       "      <td>2.932663</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>2011.060000</td>\n",
       "      <td>1.225683e+00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2014.030000</td>\n",
       "      <td>1.237843e+03</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2016.120000</td>\n",
       "      <td>1.064250e+04</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>2019.090000</td>\n",
       "      <td>4.353525e+04</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2022.090000</td>\n",
       "      <td>2.207151e+06</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Period    Data_value     Magnitude  Series_title_4  \\\n",
       "count  20641.000000  1.614600e+04  20641.000000             0.0   \n",
       "mean    2016.451399  6.174902e+04      2.367618             NaN   \n",
       "std        3.279618  1.865759e+05      2.932663             NaN   \n",
       "min     2011.060000  1.225683e+00      0.000000             NaN   \n",
       "25%     2014.030000  1.237843e+03      0.000000             NaN   \n",
       "50%     2016.120000  1.064250e+04      0.000000             NaN   \n",
       "75%     2019.090000  4.353525e+04      6.000000             NaN   \n",
       "max     2022.090000  2.207151e+06      6.000000             NaN   \n",
       "\n",
       "       Series_title_5  \n",
       "count             0.0  \n",
       "mean              NaN  \n",
       "std               NaN  \n",
       "min               NaN  \n",
       "25%               NaN  \n",
       "50%               NaN  \n",
       "75%               NaN  \n",
       "max               NaN  "
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "7e1ac77d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Series_reference     object\n",
       "Period              float64\n",
       "Data_value          float64\n",
       "Suppressed           object\n",
       "STATUS               object\n",
       "UNITS                object\n",
       "Magnitude             int64\n",
       "Subject              object\n",
       "Group                object\n",
       "Series_title_1       object\n",
       "Series_title_2       object\n",
       "Series_title_3       object\n",
       "Series_title_4      float64\n",
       "Series_title_5      float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "bbb53ac3",
   "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>Series_reference</th>\n",
       "      <th>Period</th>\n",
       "      <th>Data_value</th>\n",
       "      <th>Suppressed</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>UNITS</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Subject</th>\n",
       "      <th>Group</th>\n",
       "      <th>Series_title_1</th>\n",
       "      <th>Series_title_2</th>\n",
       "      <th>Series_title_3</th>\n",
       "      <th>Series_title_4</th>\n",
       "      <th>Series_title_5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2011.06</td>\n",
       "      <td>80078.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BDCQ.SEA1AA</td>\n",
       "      <td>2011.09</td>\n",
       "      <td>78324.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "      <td>Industry by employment variable</td>\n",
       "      <td>Filled jobs</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>Actual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Series_reference   Period  Data_value Suppressed STATUS   UNITS  Magnitude  \\\n",
       "0      BDCQ.SEA1AA  2011.06     80078.0        NaN      F  Number          0   \n",
       "1      BDCQ.SEA1AA  2011.09     78324.0        NaN      F  Number          0   \n",
       "\n",
       "                          Subject                            Group  \\\n",
       "0  Business Data Collection - BDC  Industry by employment variable   \n",
       "1  Business Data Collection - BDC  Industry by employment variable   \n",
       "\n",
       "  Series_title_1                     Series_title_2 Series_title_3  \\\n",
       "0    Filled jobs  Agriculture, Forestry and Fishing         Actual   \n",
       "1    Filled jobs  Agriculture, Forestry and Fishing         Actual   \n",
       "\n",
       "   Series_title_4  Series_title_5  \n",
       "0             NaN             NaN  \n",
       "1             NaN             NaN  "
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "id": "c206b22f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('result.csv',index=False,columns=['Magnitude','Subject'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "id": "df84a9ee",
   "metadata": {},
   "outputs": [],
   "source": [
    "df1=pd.read_csv('result.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "65d5a303",
   "metadata": {},
   "source": [
    "# "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "id": "174c4e2e",
   "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>Magnitude</th>\n",
       "      <th>Subject</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Magnitude                         Subject\n",
       "0          0  Business Data Collection - BDC\n",
       "1          0  Business Data Collection - BDC\n",
       "2          0  Business Data Collection - BDC\n",
       "3          0  Business Data Collection - BDC\n",
       "4          0  Business Data Collection - BDC"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "id": "31c346a0",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv(\"result.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "id": "5f1127de",
   "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>Magnitude</th>\n",
       "      <th>Subject</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Magnitude                         Subject\n",
       "0          0  Business Data Collection - BDC\n",
       "1          0  Business Data Collection - BDC\n",
       "2          0  Business Data Collection - BDC\n",
       "3          0  Business Data Collection - BDC\n",
       "4          0  Business Data Collection - BDC"
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "id": "b01a1aae",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Magnitude', 'Subject'], dtype='object')"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "id": "6b7d1b72",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.series.Series"
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(df['Magnitude'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "id": "929b6432",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        Business Data Collection - BDC\n",
       "1        Business Data Collection - BDC\n",
       "2        Business Data Collection - BDC\n",
       "3        Business Data Collection - BDC\n",
       "4        Business Data Collection - BDC\n",
       "                      ...              \n",
       "20636    Business Data Collection - BDC\n",
       "20637    Business Data Collection - BDC\n",
       "20638    Business Data Collection - BDC\n",
       "20639    Business Data Collection - BDC\n",
       "20640    Business Data Collection - BDC\n",
       "Name: Subject, Length: 20641, dtype: object"
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Subject']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "id": "dff3b2e8",
   "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>Magnitude</th>\n",
       "      <th>Subject</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20636</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20637</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20638</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20639</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20640</th>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20641 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Magnitude                         Subject\n",
       "0              0  Business Data Collection - BDC\n",
       "1              0  Business Data Collection - BDC\n",
       "2              0  Business Data Collection - BDC\n",
       "3              0  Business Data Collection - BDC\n",
       "4              0  Business Data Collection - BDC\n",
       "...          ...                             ...\n",
       "20636          0  Business Data Collection - BDC\n",
       "20637          0  Business Data Collection - BDC\n",
       "20638          0  Business Data Collection - BDC\n",
       "20639          0  Business Data Collection - BDC\n",
       "20640          0  Business Data Collection - BDC\n",
       "\n",
       "[20641 rows x 2 columns]"
      ]
     },
     "execution_count": 98,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[['Magnitude','Subject']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "id": "e22adb94",
   "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>STATUS</th>\n",
       "      <th>UNITS</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Subject</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>F</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20636</th>\n",
       "      <td>C</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20637</th>\n",
       "      <td>C</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20638</th>\n",
       "      <td>C</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20639</th>\n",
       "      <td>C</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20640</th>\n",
       "      <td>C</td>\n",
       "      <td>Number</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Data Collection - BDC</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20641 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      STATUS   UNITS  Magnitude                         Subject\n",
       "0          F  Number          0  Business Data Collection - BDC\n",
       "1          F  Number          0  Business Data Collection - BDC\n",
       "2          F  Number          0  Business Data Collection - BDC\n",
       "3          F  Number          0  Business Data Collection - BDC\n",
       "4          F  Number          0  Business Data Collection - BDC\n",
       "...      ...     ...        ...                             ...\n",
       "20636      C  Number          0  Business Data Collection - BDC\n",
       "20637      C  Number          0  Business Data Collection - BDC\n",
       "20638      C  Number          0  Business Data Collection - BDC\n",
       "20639      C  Number          0  Business Data Collection - BDC\n",
       "20640      C  Number          0  Business Data Collection - BDC\n",
       "\n",
       "[20641 rows x 4 columns]"
      ]
     },
     "execution_count": 100,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1[['STATUS','UNITS','Magnitude','Subject']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "id": "4544d492",
   "metadata": {},
   "outputs": [],
   "source": [
    "data =pd.read_excel('Book1.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "id": "ffad6624",
   "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>House Age (years)</th>\n",
       "      <th>Distance to Station (meters)</th>\n",
       "      <th>Price per Square Foot</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Sum</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>32.0</td>\n",
       "      <td>84.87882</td>\n",
       "      <td>75.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mean</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>19.5</td>\n",
       "      <td>306.59470</td>\n",
       "      <td>84.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Median</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>13.3</td>\n",
       "      <td>561.98450</td>\n",
       "      <td>94.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mode</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>13.3</td>\n",
       "      <td>561.98450</td>\n",
       "      <td>109.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>St. Deviation</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5.0</td>\n",
       "      <td>390.56840</td>\n",
       "      <td>86.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Variance</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   House Age (years)  Distance to Station (meters)  Price per Square Foot  \\\n",
       "0               32.0                      84.87882                   75.8   \n",
       "1               19.5                     306.59470                   84.4   \n",
       "2               13.3                     561.98450                   94.6   \n",
       "3               13.3                     561.98450                  109.6   \n",
       "4                5.0                     390.56840                   86.2   \n",
       "\n",
       "   Unnamed: 3            Sum  Unnamed: 5  \n",
       "0         NaN           Mean         NaN  \n",
       "1         NaN         Median         NaN  \n",
       "2         NaN           Mode         NaN  \n",
       "3         NaN  St. Deviation         NaN  \n",
       "4         NaN       Variance         NaN  "
      ]
     },
     "execution_count": 103,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "id": "dea10b04",
   "metadata": {},
   "outputs": [],
   "source": [
    "data1=pd.read_excel('sampledatafoodsales.xlsx', sheet_name='FoodSales')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "id": "88093a1c",
   "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>OrderDate</th>\n",
       "      <th>Region</th>\n",
       "      <th>City</th>\n",
       "      <th>Category</th>\n",
       "      <th>Product</th>\n",
       "      <th>Quantity</th>\n",
       "      <th>UnitPrice</th>\n",
       "      <th>TotalPrice</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-01-01</td>\n",
       "      <td>East</td>\n",
       "      <td>Boston</td>\n",
       "      <td>Bars</td>\n",
       "      <td>Carrot</td>\n",
       "      <td>33</td>\n",
       "      <td>1.77</td>\n",
       "      <td>58.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-01-04</td>\n",
       "      <td>East</td>\n",
       "      <td>Boston</td>\n",
       "      <td>Crackers</td>\n",
       "      <td>Whole Wheat</td>\n",
       "      <td>87</td>\n",
       "      <td>3.49</td>\n",
       "      <td>303.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-01-07</td>\n",
       "      <td>West</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>Cookies</td>\n",
       "      <td>Chocolate Chip</td>\n",
       "      <td>58</td>\n",
       "      <td>1.87</td>\n",
       "      <td>108.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-01-10</td>\n",
       "      <td>East</td>\n",
       "      <td>New York</td>\n",
       "      <td>Cookies</td>\n",
       "      <td>Chocolate Chip</td>\n",
       "      <td>82</td>\n",
       "      <td>1.87</td>\n",
       "      <td>153.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-01-13</td>\n",
       "      <td>East</td>\n",
       "      <td>Boston</td>\n",
       "      <td>Cookies</td>\n",
       "      <td>Arrowroot</td>\n",
       "      <td>38</td>\n",
       "      <td>2.18</td>\n",
       "      <td>82.84</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   OrderDate Region         City  Category         Product  Quantity  \\\n",
       "0 2020-01-01   East       Boston      Bars          Carrot        33   \n",
       "1 2020-01-04   East       Boston  Crackers     Whole Wheat        87   \n",
       "2 2020-01-07   West  Los Angeles   Cookies  Chocolate Chip        58   \n",
       "3 2020-01-10   East     New York   Cookies  Chocolate Chip        82   \n",
       "4 2020-01-13   East       Boston   Cookies       Arrowroot        38   \n",
       "\n",
       "   UnitPrice  TotalPrice  \n",
       "0       1.77       58.41  \n",
       "1       3.49      303.63  \n",
       "2       1.87      108.46  \n",
       "3       1.87      153.34  \n",
       "4       2.18       82.84  "
      ]
     },
     "execution_count": 105,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "id": "8f91b23f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    Carrot\n",
       "dtype: object"
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data1['Product'].mode()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "id": "17ee9f8b",
   "metadata": {},
   "outputs": [],
   "source": [
    "df4=pd.read_html(\"https://www.bbc.com/sport/basketball/nba/table\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "id": "1f081008",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "list"
      ]
     },
     "execution_count": 116,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(df4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "id": "9aa71dce",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "6"
      ]
     },
     "execution_count": 117,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "id": "da4eebef",
   "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>Rank</th>\n",
       "      <th>Team</th>\n",
       "      <th>PlayedP</th>\n",
       "      <th>WonW</th>\n",
       "      <th>LostL</th>\n",
       "      <th>Home</th>\n",
       "      <th>Away</th>\n",
       "      <th>Win PercentagePct</th>\n",
       "      <th>ForPF</th>\n",
       "      <th>AgainstPA</th>\n",
       "      <th>Unnamed: 10</th>\n",
       "      <th>Unnamed: 11</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11</td>\n",
       "      <td>Boston CelticsBoston Celtics</td>\n",
       "      <td>6868</td>\n",
       "      <td>4747</td>\n",
       "      <td>2121</td>\n",
       "      <td>26-926-9</td>\n",
       "      <td>21-1221-12</td>\n",
       "      <td>0.6910.691</td>\n",
       "      <td>80148014</td>\n",
       "      <td>76417641</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>22</td>\n",
       "      <td>Philadelphia 76ersPhiladelphia 76ers</td>\n",
       "      <td>6666</td>\n",
       "      <td>4444</td>\n",
       "      <td>2222</td>\n",
       "      <td>25-1025-10</td>\n",
       "      <td>19-1219-12</td>\n",
       "      <td>0.6670.667</td>\n",
       "      <td>75967596</td>\n",
       "      <td>73277327</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Rank                                  Team PlayedP  WonW LostL        Home  \\\n",
       "0   11          Boston CelticsBoston Celtics    6868  4747  2121    26-926-9   \n",
       "1   22  Philadelphia 76ersPhiladelphia 76ers    6666  4444  2222  25-1025-10   \n",
       "\n",
       "         Away Win PercentagePct     ForPF AgainstPA Unnamed: 10 Unnamed: 11  \n",
       "0  21-1221-12        0.6910.691  80148014  76417641         NaN         NaN  \n",
       "1  19-1219-12        0.6670.667  75967596  73277327         NaN         NaN  "
      ]
     },
     "execution_count": 120,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4[0].head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "id": "7b8d773a",
   "metadata": {},
   "outputs": [],
   "source": [
    "df4[0].to_csv(\"Football_league.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "id": "d802658f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df4[2].to_excel('Football_league_table.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 124,
   "id": "c8a22438",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_tita=pd.read_csv('https://raw.githubusercontent.com/ashishpatel26/Titanic-Machine-Learning-from-Disaster/master/Submission_titanic.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "id": "0ec5afb8",
   "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>Unnamed: 0</th>\n",
       "      <th>PassengerId</th>\n",
       "      <th>Sex</th>\n",
       "      <th>Age</th>\n",
       "      <th>Fare</th>\n",
       "      <th>Cabin</th>\n",
       "      <th>Embarked</th>\n",
       "      <th>Title</th>\n",
       "      <th>FamilySize</th>\n",
       "      <th>Survived</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>892</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>893</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>894</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>895</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>896</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  PassengerId  Sex  Age  Fare  Cabin  Embarked  Title  \\\n",
       "0           0          892    0    2     0    2.0         2      0   \n",
       "1           1          893    1    3     0    2.0         0      2   \n",
       "2           2          894    0    3     0    2.0         2      0   \n",
       "3           3          895    0    2     0    2.0         0      0   \n",
       "4           4          896    1    1     0    2.0         0      2   \n",
       "\n",
       "   FamilySize  Survived  \n",
       "0         0.0         0  \n",
       "1         0.4         1  \n",
       "2         0.0         0  \n",
       "3         0.0         0  \n",
       "4         0.8         1  "
      ]
     },
     "execution_count": 126,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_tita.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 170,
   "id": "44d25282",
   "metadata": {},
   "outputs": [],
   "source": [
    "s = \"\"\"{\n",
    "\"name\":\"naman\",\n",
    "\"age\":25,\n",
    "\"company\":\"Maruti\"\n",
    "}\n",
    "\"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 171,
   "id": "f52d1f7e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'{\\n\"name\":\"naman\",\\n\"age\":25,\\n\"company\":\"Maruti\"\\n}\\n'"
      ]
     },
     "execution_count": 171,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 172,
   "id": "67bed115",
   "metadata": {},
   "outputs": [],
   "source": [
    "p=json.loads(s)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 173,
   "id": "1ddd6a13",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'name': 'naman', 'age': 25, 'company': 'Maruti'}"
      ]
     },
     "execution_count": 173,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "p"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 177,
   "id": "d308d912",
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 179,
   "id": "7b7552e4",
   "metadata": {},
   "outputs": [],
   "source": [
    "rea=requests.get('https://api.github.com/repos/pandas-dev/pandas/issues')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 199,
   "id": "78f76d2b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'login': 'rmhowe425',\n",
       " 'id': 45905457,\n",
       " 'node_id': 'MDQ6VXNlcjQ1OTA1NDU3',\n",
       " 'avatar_url': 'https://avatars.githubusercontent.com/u/45905457?v=4',\n",
       " 'gravatar_id': '',\n",
       " 'url': 'https://api.github.com/users/rmhowe425',\n",
       " 'html_url': 'https://github.com/rmhowe425',\n",
       " 'followers_url': 'https://api.github.com/users/rmhowe425/followers',\n",
       " 'following_url': 'https://api.github.com/users/rmhowe425/following{/other_user}',\n",
       " 'gists_url': 'https://api.github.com/users/rmhowe425/gists{/gist_id}',\n",
       " 'starred_url': 'https://api.github.com/users/rmhowe425/starred{/owner}{/repo}',\n",
       " 'subscriptions_url': 'https://api.github.com/users/rmhowe425/subscriptions',\n",
       " 'organizations_url': 'https://api.github.com/users/rmhowe425/orgs',\n",
       " 'repos_url': 'https://api.github.com/users/rmhowe425/repos',\n",
       " 'events_url': 'https://api.github.com/users/rmhowe425/events{/privacy}',\n",
       " 'received_events_url': 'https://api.github.com/users/rmhowe425/received_events',\n",
       " 'type': 'User',\n",
       " 'site_admin': False}"
      ]
     },
     "execution_count": 199,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "p=rea.json()\n",
    "p[0]['user']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 198,
   "id": "8b15625d",
   "metadata": {},
   "outputs": [],
   "source": [
    "pp=pd.DataFrame(p)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "78681ff8",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 201,
   "id": "f25e737d",
   "metadata": {},
   "outputs": [],
   "source": [
    "l=[]\n",
    "for i in range(len(p)):\n",
    "    l.append(p[i]['user'])\n",
    "p_user=pd.DataFrame(l)    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 203,
   "id": "be29979b",
   "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>login</th>\n",
       "      <th>id</th>\n",
       "      <th>node_id</th>\n",
       "      <th>avatar_url</th>\n",
       "      <th>gravatar_id</th>\n",
       "      <th>url</th>\n",
       "      <th>html_url</th>\n",
       "      <th>followers_url</th>\n",
       "      <th>following_url</th>\n",
       "      <th>gists_url</th>\n",
       "      <th>starred_url</th>\n",
       "      <th>subscriptions_url</th>\n",
       "      <th>organizations_url</th>\n",
       "      <th>repos_url</th>\n",
       "      <th>events_url</th>\n",
       "      <th>received_events_url</th>\n",
       "      <th>type</th>\n",
       "      <th>site_admin</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>rmhowe425</td>\n",
       "      <td>45905457</td>\n",
       "      <td>MDQ6VXNlcjQ1OTA1NDU3</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/459054...</td>\n",
       "      <td></td>\n",
       "      <td>https://api.github.com/users/rmhowe425</td>\n",
       "      <td>https://github.com/rmhowe425</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/followers</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/followi...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/gists{/...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/starred...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/subscri...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/orgs</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/repos</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/events{...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/receive...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>hugovk</td>\n",
       "      <td>1324225</td>\n",
       "      <td>MDQ6VXNlcjEzMjQyMjU=</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/132422...</td>\n",
       "      <td></td>\n",
       "      <td>https://api.github.com/users/hugovk</td>\n",
       "      <td>https://github.com/hugovk</td>\n",
       "      <td>https://api.github.com/users/hugovk/followers</td>\n",
       "      <td>https://api.github.com/users/hugovk/following{...</td>\n",
       "      <td>https://api.github.com/users/hugovk/gists{/gis...</td>\n",
       "      <td>https://api.github.com/users/hugovk/starred{/o...</td>\n",
       "      <td>https://api.github.com/users/hugovk/subscriptions</td>\n",
       "      <td>https://api.github.com/users/hugovk/orgs</td>\n",
       "      <td>https://api.github.com/users/hugovk/repos</td>\n",
       "      <td>https://api.github.com/users/hugovk/events{/pr...</td>\n",
       "      <td>https://api.github.com/users/hugovk/received_e...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>dannyi96</td>\n",
       "      <td>15380498</td>\n",
       "      <td>MDQ6VXNlcjE1MzgwNDk4</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/153804...</td>\n",
       "      <td></td>\n",
       "      <td>https://api.github.com/users/dannyi96</td>\n",
       "      <td>https://github.com/dannyi96</td>\n",
       "      <td>https://api.github.com/users/dannyi96/followers</td>\n",
       "      <td>https://api.github.com/users/dannyi96/followin...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/gists{/g...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/starred{...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/subscrip...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/orgs</td>\n",
       "      <td>https://api.github.com/users/dannyi96/repos</td>\n",
       "      <td>https://api.github.com/users/dannyi96/events{/...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/received...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>DeaMariaLeon</td>\n",
       "      <td>11835246</td>\n",
       "      <td>MDQ6VXNlcjExODM1MjQ2</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/118352...</td>\n",
       "      <td></td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon</td>\n",
       "      <td>https://github.com/DeaMariaLeon</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/foll...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/foll...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/gist...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/star...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/subs...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/orgs</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/repos</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/even...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/rece...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>uzzell</td>\n",
       "      <td>72205435</td>\n",
       "      <td>MDQ6VXNlcjcyMjA1NDM1</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/722054...</td>\n",
       "      <td></td>\n",
       "      <td>https://api.github.com/users/uzzell</td>\n",
       "      <td>https://github.com/uzzell</td>\n",
       "      <td>https://api.github.com/users/uzzell/followers</td>\n",
       "      <td>https://api.github.com/users/uzzell/following{...</td>\n",
       "      <td>https://api.github.com/users/uzzell/gists{/gis...</td>\n",
       "      <td>https://api.github.com/users/uzzell/starred{/o...</td>\n",
       "      <td>https://api.github.com/users/uzzell/subscriptions</td>\n",
       "      <td>https://api.github.com/users/uzzell/orgs</td>\n",
       "      <td>https://api.github.com/users/uzzell/repos</td>\n",
       "      <td>https://api.github.com/users/uzzell/events{/pr...</td>\n",
       "      <td>https://api.github.com/users/uzzell/received_e...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          login        id               node_id  \\\n",
       "0     rmhowe425  45905457  MDQ6VXNlcjQ1OTA1NDU3   \n",
       "1        hugovk   1324225  MDQ6VXNlcjEzMjQyMjU=   \n",
       "2      dannyi96  15380498  MDQ6VXNlcjE1MzgwNDk4   \n",
       "3  DeaMariaLeon  11835246  MDQ6VXNlcjExODM1MjQ2   \n",
       "4        uzzell  72205435  MDQ6VXNlcjcyMjA1NDM1   \n",
       "\n",
       "                                          avatar_url gravatar_id  \\\n",
       "0  https://avatars.githubusercontent.com/u/459054...               \n",
       "1  https://avatars.githubusercontent.com/u/132422...               \n",
       "2  https://avatars.githubusercontent.com/u/153804...               \n",
       "3  https://avatars.githubusercontent.com/u/118352...               \n",
       "4  https://avatars.githubusercontent.com/u/722054...               \n",
       "\n",
       "                                         url                         html_url  \\\n",
       "0     https://api.github.com/users/rmhowe425     https://github.com/rmhowe425   \n",
       "1        https://api.github.com/users/hugovk        https://github.com/hugovk   \n",
       "2      https://api.github.com/users/dannyi96      https://github.com/dannyi96   \n",
       "3  https://api.github.com/users/DeaMariaLeon  https://github.com/DeaMariaLeon   \n",
       "4        https://api.github.com/users/uzzell        https://github.com/uzzell   \n",
       "\n",
       "                                       followers_url  \\\n",
       "0   https://api.github.com/users/rmhowe425/followers   \n",
       "1      https://api.github.com/users/hugovk/followers   \n",
       "2    https://api.github.com/users/dannyi96/followers   \n",
       "3  https://api.github.com/users/DeaMariaLeon/foll...   \n",
       "4      https://api.github.com/users/uzzell/followers   \n",
       "\n",
       "                                       following_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/followi...   \n",
       "1  https://api.github.com/users/hugovk/following{...   \n",
       "2  https://api.github.com/users/dannyi96/followin...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/foll...   \n",
       "4  https://api.github.com/users/uzzell/following{...   \n",
       "\n",
       "                                           gists_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/gists{/...   \n",
       "1  https://api.github.com/users/hugovk/gists{/gis...   \n",
       "2  https://api.github.com/users/dannyi96/gists{/g...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/gist...   \n",
       "4  https://api.github.com/users/uzzell/gists{/gis...   \n",
       "\n",
       "                                         starred_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/starred...   \n",
       "1  https://api.github.com/users/hugovk/starred{/o...   \n",
       "2  https://api.github.com/users/dannyi96/starred{...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/star...   \n",
       "4  https://api.github.com/users/uzzell/starred{/o...   \n",
       "\n",
       "                                   subscriptions_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/subscri...   \n",
       "1  https://api.github.com/users/hugovk/subscriptions   \n",
       "2  https://api.github.com/users/dannyi96/subscrip...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/subs...   \n",
       "4  https://api.github.com/users/uzzell/subscriptions   \n",
       "\n",
       "                                organizations_url  \\\n",
       "0     https://api.github.com/users/rmhowe425/orgs   \n",
       "1        https://api.github.com/users/hugovk/orgs   \n",
       "2      https://api.github.com/users/dannyi96/orgs   \n",
       "3  https://api.github.com/users/DeaMariaLeon/orgs   \n",
       "4        https://api.github.com/users/uzzell/orgs   \n",
       "\n",
       "                                         repos_url  \\\n",
       "0     https://api.github.com/users/rmhowe425/repos   \n",
       "1        https://api.github.com/users/hugovk/repos   \n",
       "2      https://api.github.com/users/dannyi96/repos   \n",
       "3  https://api.github.com/users/DeaMariaLeon/repos   \n",
       "4        https://api.github.com/users/uzzell/repos   \n",
       "\n",
       "                                          events_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/events{...   \n",
       "1  https://api.github.com/users/hugovk/events{/pr...   \n",
       "2  https://api.github.com/users/dannyi96/events{/...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/even...   \n",
       "4  https://api.github.com/users/uzzell/events{/pr...   \n",
       "\n",
       "                                 received_events_url  type  site_admin  \n",
       "0  https://api.github.com/users/rmhowe425/receive...  User       False  \n",
       "1  https://api.github.com/users/hugovk/received_e...  User       False  \n",
       "2  https://api.github.com/users/dannyi96/received...  User       False  \n",
       "3  https://api.github.com/users/DeaMariaLeon/rece...  User       False  \n",
       "4  https://api.github.com/users/uzzell/received_e...  User       False  "
      ]
     },
     "execution_count": 203,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "p_user.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 205,
   "id": "4fd6bd7d",
   "metadata": {},
   "outputs": [],
   "source": [
    "p_user.to_csv(\"Response.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 207,
   "id": "3133c49b",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv('Response.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 208,
   "id": "073ebf8a",
   "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>Unnamed: 0</th>\n",
       "      <th>login</th>\n",
       "      <th>id</th>\n",
       "      <th>node_id</th>\n",
       "      <th>avatar_url</th>\n",
       "      <th>gravatar_id</th>\n",
       "      <th>url</th>\n",
       "      <th>html_url</th>\n",
       "      <th>followers_url</th>\n",
       "      <th>following_url</th>\n",
       "      <th>gists_url</th>\n",
       "      <th>starred_url</th>\n",
       "      <th>subscriptions_url</th>\n",
       "      <th>organizations_url</th>\n",
       "      <th>repos_url</th>\n",
       "      <th>events_url</th>\n",
       "      <th>received_events_url</th>\n",
       "      <th>type</th>\n",
       "      <th>site_admin</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>rmhowe425</td>\n",
       "      <td>45905457</td>\n",
       "      <td>MDQ6VXNlcjQ1OTA1NDU3</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/459054...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/rmhowe425</td>\n",
       "      <td>https://github.com/rmhowe425</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/followers</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/followi...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/gists{/...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/starred...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/subscri...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/orgs</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/repos</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/events{...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/receive...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>hugovk</td>\n",
       "      <td>1324225</td>\n",
       "      <td>MDQ6VXNlcjEzMjQyMjU=</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/132422...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/hugovk</td>\n",
       "      <td>https://github.com/hugovk</td>\n",
       "      <td>https://api.github.com/users/hugovk/followers</td>\n",
       "      <td>https://api.github.com/users/hugovk/following{...</td>\n",
       "      <td>https://api.github.com/users/hugovk/gists{/gis...</td>\n",
       "      <td>https://api.github.com/users/hugovk/starred{/o...</td>\n",
       "      <td>https://api.github.com/users/hugovk/subscriptions</td>\n",
       "      <td>https://api.github.com/users/hugovk/orgs</td>\n",
       "      <td>https://api.github.com/users/hugovk/repos</td>\n",
       "      <td>https://api.github.com/users/hugovk/events{/pr...</td>\n",
       "      <td>https://api.github.com/users/hugovk/received_e...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>dannyi96</td>\n",
       "      <td>15380498</td>\n",
       "      <td>MDQ6VXNlcjE1MzgwNDk4</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/153804...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/dannyi96</td>\n",
       "      <td>https://github.com/dannyi96</td>\n",
       "      <td>https://api.github.com/users/dannyi96/followers</td>\n",
       "      <td>https://api.github.com/users/dannyi96/followin...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/gists{/g...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/starred{...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/subscrip...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/orgs</td>\n",
       "      <td>https://api.github.com/users/dannyi96/repos</td>\n",
       "      <td>https://api.github.com/users/dannyi96/events{/...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/received...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>DeaMariaLeon</td>\n",
       "      <td>11835246</td>\n",
       "      <td>MDQ6VXNlcjExODM1MjQ2</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/118352...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon</td>\n",
       "      <td>https://github.com/DeaMariaLeon</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/foll...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/foll...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/gist...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/star...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/subs...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/orgs</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/repos</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/even...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/rece...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>uzzell</td>\n",
       "      <td>72205435</td>\n",
       "      <td>MDQ6VXNlcjcyMjA1NDM1</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/722054...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/uzzell</td>\n",
       "      <td>https://github.com/uzzell</td>\n",
       "      <td>https://api.github.com/users/uzzell/followers</td>\n",
       "      <td>https://api.github.com/users/uzzell/following{...</td>\n",
       "      <td>https://api.github.com/users/uzzell/gists{/gis...</td>\n",
       "      <td>https://api.github.com/users/uzzell/starred{/o...</td>\n",
       "      <td>https://api.github.com/users/uzzell/subscriptions</td>\n",
       "      <td>https://api.github.com/users/uzzell/orgs</td>\n",
       "      <td>https://api.github.com/users/uzzell/repos</td>\n",
       "      <td>https://api.github.com/users/uzzell/events{/pr...</td>\n",
       "      <td>https://api.github.com/users/uzzell/received_e...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0         login        id               node_id  \\\n",
       "0           0     rmhowe425  45905457  MDQ6VXNlcjQ1OTA1NDU3   \n",
       "1           1        hugovk   1324225  MDQ6VXNlcjEzMjQyMjU=   \n",
       "2           2      dannyi96  15380498  MDQ6VXNlcjE1MzgwNDk4   \n",
       "3           3  DeaMariaLeon  11835246  MDQ6VXNlcjExODM1MjQ2   \n",
       "4           4        uzzell  72205435  MDQ6VXNlcjcyMjA1NDM1   \n",
       "\n",
       "                                          avatar_url  gravatar_id  \\\n",
       "0  https://avatars.githubusercontent.com/u/459054...          NaN   \n",
       "1  https://avatars.githubusercontent.com/u/132422...          NaN   \n",
       "2  https://avatars.githubusercontent.com/u/153804...          NaN   \n",
       "3  https://avatars.githubusercontent.com/u/118352...          NaN   \n",
       "4  https://avatars.githubusercontent.com/u/722054...          NaN   \n",
       "\n",
       "                                         url                         html_url  \\\n",
       "0     https://api.github.com/users/rmhowe425     https://github.com/rmhowe425   \n",
       "1        https://api.github.com/users/hugovk        https://github.com/hugovk   \n",
       "2      https://api.github.com/users/dannyi96      https://github.com/dannyi96   \n",
       "3  https://api.github.com/users/DeaMariaLeon  https://github.com/DeaMariaLeon   \n",
       "4        https://api.github.com/users/uzzell        https://github.com/uzzell   \n",
       "\n",
       "                                       followers_url  \\\n",
       "0   https://api.github.com/users/rmhowe425/followers   \n",
       "1      https://api.github.com/users/hugovk/followers   \n",
       "2    https://api.github.com/users/dannyi96/followers   \n",
       "3  https://api.github.com/users/DeaMariaLeon/foll...   \n",
       "4      https://api.github.com/users/uzzell/followers   \n",
       "\n",
       "                                       following_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/followi...   \n",
       "1  https://api.github.com/users/hugovk/following{...   \n",
       "2  https://api.github.com/users/dannyi96/followin...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/foll...   \n",
       "4  https://api.github.com/users/uzzell/following{...   \n",
       "\n",
       "                                           gists_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/gists{/...   \n",
       "1  https://api.github.com/users/hugovk/gists{/gis...   \n",
       "2  https://api.github.com/users/dannyi96/gists{/g...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/gist...   \n",
       "4  https://api.github.com/users/uzzell/gists{/gis...   \n",
       "\n",
       "                                         starred_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/starred...   \n",
       "1  https://api.github.com/users/hugovk/starred{/o...   \n",
       "2  https://api.github.com/users/dannyi96/starred{...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/star...   \n",
       "4  https://api.github.com/users/uzzell/starred{/o...   \n",
       "\n",
       "                                   subscriptions_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/subscri...   \n",
       "1  https://api.github.com/users/hugovk/subscriptions   \n",
       "2  https://api.github.com/users/dannyi96/subscrip...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/subs...   \n",
       "4  https://api.github.com/users/uzzell/subscriptions   \n",
       "\n",
       "                                organizations_url  \\\n",
       "0     https://api.github.com/users/rmhowe425/orgs   \n",
       "1        https://api.github.com/users/hugovk/orgs   \n",
       "2      https://api.github.com/users/dannyi96/orgs   \n",
       "3  https://api.github.com/users/DeaMariaLeon/orgs   \n",
       "4        https://api.github.com/users/uzzell/orgs   \n",
       "\n",
       "                                         repos_url  \\\n",
       "0     https://api.github.com/users/rmhowe425/repos   \n",
       "1        https://api.github.com/users/hugovk/repos   \n",
       "2      https://api.github.com/users/dannyi96/repos   \n",
       "3  https://api.github.com/users/DeaMariaLeon/repos   \n",
       "4        https://api.github.com/users/uzzell/repos   \n",
       "\n",
       "                                          events_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/events{...   \n",
       "1  https://api.github.com/users/hugovk/events{/pr...   \n",
       "2  https://api.github.com/users/dannyi96/events{/...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/even...   \n",
       "4  https://api.github.com/users/uzzell/events{/pr...   \n",
       "\n",
       "                                 received_events_url  type  site_admin  \n",
       "0  https://api.github.com/users/rmhowe425/receive...  User       False  \n",
       "1  https://api.github.com/users/hugovk/received_e...  User       False  \n",
       "2  https://api.github.com/users/dannyi96/received...  User       False  \n",
       "3  https://api.github.com/users/DeaMariaLeon/rece...  User       False  \n",
       "4  https://api.github.com/users/uzzell/received_e...  User       False  "
      ]
     },
     "execution_count": 208,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 209,
   "id": "d8eb3ddf",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_pickle(\"my_pickle\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8c73cbd8",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 211,
   "id": "047dbc23",
   "metadata": {},
   "outputs": [],
   "source": [
    "h5_data=pd.HDFStore('test.h5')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 212,
   "id": "184152f8",
   "metadata": {},
   "outputs": [],
   "source": [
    "h5_data['col1']=df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 214,
   "id": "4512f84d",
   "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>Unnamed: 0</th>\n",
       "      <th>login</th>\n",
       "      <th>id</th>\n",
       "      <th>node_id</th>\n",
       "      <th>avatar_url</th>\n",
       "      <th>gravatar_id</th>\n",
       "      <th>url</th>\n",
       "      <th>html_url</th>\n",
       "      <th>followers_url</th>\n",
       "      <th>following_url</th>\n",
       "      <th>gists_url</th>\n",
       "      <th>starred_url</th>\n",
       "      <th>subscriptions_url</th>\n",
       "      <th>organizations_url</th>\n",
       "      <th>repos_url</th>\n",
       "      <th>events_url</th>\n",
       "      <th>received_events_url</th>\n",
       "      <th>type</th>\n",
       "      <th>site_admin</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>rmhowe425</td>\n",
       "      <td>45905457</td>\n",
       "      <td>MDQ6VXNlcjQ1OTA1NDU3</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/459054...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/rmhowe425</td>\n",
       "      <td>https://github.com/rmhowe425</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/followers</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/followi...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/gists{/...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/starred...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/subscri...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/orgs</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/repos</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/events{...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/receive...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>hugovk</td>\n",
       "      <td>1324225</td>\n",
       "      <td>MDQ6VXNlcjEzMjQyMjU=</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/132422...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/hugovk</td>\n",
       "      <td>https://github.com/hugovk</td>\n",
       "      <td>https://api.github.com/users/hugovk/followers</td>\n",
       "      <td>https://api.github.com/users/hugovk/following{...</td>\n",
       "      <td>https://api.github.com/users/hugovk/gists{/gis...</td>\n",
       "      <td>https://api.github.com/users/hugovk/starred{/o...</td>\n",
       "      <td>https://api.github.com/users/hugovk/subscriptions</td>\n",
       "      <td>https://api.github.com/users/hugovk/orgs</td>\n",
       "      <td>https://api.github.com/users/hugovk/repos</td>\n",
       "      <td>https://api.github.com/users/hugovk/events{/pr...</td>\n",
       "      <td>https://api.github.com/users/hugovk/received_e...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>dannyi96</td>\n",
       "      <td>15380498</td>\n",
       "      <td>MDQ6VXNlcjE1MzgwNDk4</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/153804...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/dannyi96</td>\n",
       "      <td>https://github.com/dannyi96</td>\n",
       "      <td>https://api.github.com/users/dannyi96/followers</td>\n",
       "      <td>https://api.github.com/users/dannyi96/followin...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/gists{/g...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/starred{...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/subscrip...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/orgs</td>\n",
       "      <td>https://api.github.com/users/dannyi96/repos</td>\n",
       "      <td>https://api.github.com/users/dannyi96/events{/...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/received...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>DeaMariaLeon</td>\n",
       "      <td>11835246</td>\n",
       "      <td>MDQ6VXNlcjExODM1MjQ2</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/118352...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon</td>\n",
       "      <td>https://github.com/DeaMariaLeon</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/foll...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/foll...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/gist...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/star...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/subs...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/orgs</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/repos</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/even...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/rece...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>uzzell</td>\n",
       "      <td>72205435</td>\n",
       "      <td>MDQ6VXNlcjcyMjA1NDM1</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/722054...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/uzzell</td>\n",
       "      <td>https://github.com/uzzell</td>\n",
       "      <td>https://api.github.com/users/uzzell/followers</td>\n",
       "      <td>https://api.github.com/users/uzzell/following{...</td>\n",
       "      <td>https://api.github.com/users/uzzell/gists{/gis...</td>\n",
       "      <td>https://api.github.com/users/uzzell/starred{/o...</td>\n",
       "      <td>https://api.github.com/users/uzzell/subscriptions</td>\n",
       "      <td>https://api.github.com/users/uzzell/orgs</td>\n",
       "      <td>https://api.github.com/users/uzzell/repos</td>\n",
       "      <td>https://api.github.com/users/uzzell/events{/pr...</td>\n",
       "      <td>https://api.github.com/users/uzzell/received_e...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0         login        id               node_id  \\\n",
       "0           0     rmhowe425  45905457  MDQ6VXNlcjQ1OTA1NDU3   \n",
       "1           1        hugovk   1324225  MDQ6VXNlcjEzMjQyMjU=   \n",
       "2           2      dannyi96  15380498  MDQ6VXNlcjE1MzgwNDk4   \n",
       "3           3  DeaMariaLeon  11835246  MDQ6VXNlcjExODM1MjQ2   \n",
       "4           4        uzzell  72205435  MDQ6VXNlcjcyMjA1NDM1   \n",
       "\n",
       "                                          avatar_url  gravatar_id  \\\n",
       "0  https://avatars.githubusercontent.com/u/459054...          NaN   \n",
       "1  https://avatars.githubusercontent.com/u/132422...          NaN   \n",
       "2  https://avatars.githubusercontent.com/u/153804...          NaN   \n",
       "3  https://avatars.githubusercontent.com/u/118352...          NaN   \n",
       "4  https://avatars.githubusercontent.com/u/722054...          NaN   \n",
       "\n",
       "                                         url                         html_url  \\\n",
       "0     https://api.github.com/users/rmhowe425     https://github.com/rmhowe425   \n",
       "1        https://api.github.com/users/hugovk        https://github.com/hugovk   \n",
       "2      https://api.github.com/users/dannyi96      https://github.com/dannyi96   \n",
       "3  https://api.github.com/users/DeaMariaLeon  https://github.com/DeaMariaLeon   \n",
       "4        https://api.github.com/users/uzzell        https://github.com/uzzell   \n",
       "\n",
       "                                       followers_url  \\\n",
       "0   https://api.github.com/users/rmhowe425/followers   \n",
       "1      https://api.github.com/users/hugovk/followers   \n",
       "2    https://api.github.com/users/dannyi96/followers   \n",
       "3  https://api.github.com/users/DeaMariaLeon/foll...   \n",
       "4      https://api.github.com/users/uzzell/followers   \n",
       "\n",
       "                                       following_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/followi...   \n",
       "1  https://api.github.com/users/hugovk/following{...   \n",
       "2  https://api.github.com/users/dannyi96/followin...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/foll...   \n",
       "4  https://api.github.com/users/uzzell/following{...   \n",
       "\n",
       "                                           gists_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/gists{/...   \n",
       "1  https://api.github.com/users/hugovk/gists{/gis...   \n",
       "2  https://api.github.com/users/dannyi96/gists{/g...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/gist...   \n",
       "4  https://api.github.com/users/uzzell/gists{/gis...   \n",
       "\n",
       "                                         starred_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/starred...   \n",
       "1  https://api.github.com/users/hugovk/starred{/o...   \n",
       "2  https://api.github.com/users/dannyi96/starred{...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/star...   \n",
       "4  https://api.github.com/users/uzzell/starred{/o...   \n",
       "\n",
       "                                   subscriptions_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/subscri...   \n",
       "1  https://api.github.com/users/hugovk/subscriptions   \n",
       "2  https://api.github.com/users/dannyi96/subscrip...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/subs...   \n",
       "4  https://api.github.com/users/uzzell/subscriptions   \n",
       "\n",
       "                                organizations_url  \\\n",
       "0     https://api.github.com/users/rmhowe425/orgs   \n",
       "1        https://api.github.com/users/hugovk/orgs   \n",
       "2      https://api.github.com/users/dannyi96/orgs   \n",
       "3  https://api.github.com/users/DeaMariaLeon/orgs   \n",
       "4        https://api.github.com/users/uzzell/orgs   \n",
       "\n",
       "                                         repos_url  \\\n",
       "0     https://api.github.com/users/rmhowe425/repos   \n",
       "1        https://api.github.com/users/hugovk/repos   \n",
       "2      https://api.github.com/users/dannyi96/repos   \n",
       "3  https://api.github.com/users/DeaMariaLeon/repos   \n",
       "4        https://api.github.com/users/uzzell/repos   \n",
       "\n",
       "                                          events_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/events{...   \n",
       "1  https://api.github.com/users/hugovk/events{/pr...   \n",
       "2  https://api.github.com/users/dannyi96/events{/...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/even...   \n",
       "4  https://api.github.com/users/uzzell/events{/pr...   \n",
       "\n",
       "                                 received_events_url  type  site_admin  \n",
       "0  https://api.github.com/users/rmhowe425/receive...  User       False  \n",
       "1  https://api.github.com/users/hugovk/received_e...  User       False  \n",
       "2  https://api.github.com/users/dannyi96/received...  User       False  \n",
       "3  https://api.github.com/users/DeaMariaLeon/rece...  User       False  \n",
       "4  https://api.github.com/users/uzzell/received_e...  User       False  "
      ]
     },
     "execution_count": 214,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "h5_data['col1'].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 215,
   "id": "118a48c0",
   "metadata": {},
   "outputs": [],
   "source": [
    "h5_data.put('obj2',df, format='table')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 218,
   "id": "337ad8c7",
   "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>Unnamed: 0</th>\n",
       "      <th>login</th>\n",
       "      <th>id</th>\n",
       "      <th>node_id</th>\n",
       "      <th>avatar_url</th>\n",
       "      <th>gravatar_id</th>\n",
       "      <th>url</th>\n",
       "      <th>html_url</th>\n",
       "      <th>followers_url</th>\n",
       "      <th>following_url</th>\n",
       "      <th>gists_url</th>\n",
       "      <th>starred_url</th>\n",
       "      <th>subscriptions_url</th>\n",
       "      <th>organizations_url</th>\n",
       "      <th>repos_url</th>\n",
       "      <th>events_url</th>\n",
       "      <th>received_events_url</th>\n",
       "      <th>type</th>\n",
       "      <th>site_admin</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>rmhowe425</td>\n",
       "      <td>45905457</td>\n",
       "      <td>MDQ6VXNlcjQ1OTA1NDU3</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/459054...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/rmhowe425</td>\n",
       "      <td>https://github.com/rmhowe425</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/followers</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/followi...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/gists{/...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/starred...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/subscri...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/orgs</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/repos</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/events{...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/receive...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>hugovk</td>\n",
       "      <td>1324225</td>\n",
       "      <td>MDQ6VXNlcjEzMjQyMjU=</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/132422...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/hugovk</td>\n",
       "      <td>https://github.com/hugovk</td>\n",
       "      <td>https://api.github.com/users/hugovk/followers</td>\n",
       "      <td>https://api.github.com/users/hugovk/following{...</td>\n",
       "      <td>https://api.github.com/users/hugovk/gists{/gis...</td>\n",
       "      <td>https://api.github.com/users/hugovk/starred{/o...</td>\n",
       "      <td>https://api.github.com/users/hugovk/subscriptions</td>\n",
       "      <td>https://api.github.com/users/hugovk/orgs</td>\n",
       "      <td>https://api.github.com/users/hugovk/repos</td>\n",
       "      <td>https://api.github.com/users/hugovk/events{/pr...</td>\n",
       "      <td>https://api.github.com/users/hugovk/received_e...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>dannyi96</td>\n",
       "      <td>15380498</td>\n",
       "      <td>MDQ6VXNlcjE1MzgwNDk4</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/153804...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/dannyi96</td>\n",
       "      <td>https://github.com/dannyi96</td>\n",
       "      <td>https://api.github.com/users/dannyi96/followers</td>\n",
       "      <td>https://api.github.com/users/dannyi96/followin...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/gists{/g...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/starred{...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/subscrip...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/orgs</td>\n",
       "      <td>https://api.github.com/users/dannyi96/repos</td>\n",
       "      <td>https://api.github.com/users/dannyi96/events{/...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/received...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>DeaMariaLeon</td>\n",
       "      <td>11835246</td>\n",
       "      <td>MDQ6VXNlcjExODM1MjQ2</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/118352...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon</td>\n",
       "      <td>https://github.com/DeaMariaLeon</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/foll...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/foll...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/gist...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/star...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/subs...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/orgs</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/repos</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/even...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/rece...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>uzzell</td>\n",
       "      <td>72205435</td>\n",
       "      <td>MDQ6VXNlcjcyMjA1NDM1</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/722054...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/uzzell</td>\n",
       "      <td>https://github.com/uzzell</td>\n",
       "      <td>https://api.github.com/users/uzzell/followers</td>\n",
       "      <td>https://api.github.com/users/uzzell/following{...</td>\n",
       "      <td>https://api.github.com/users/uzzell/gists{/gis...</td>\n",
       "      <td>https://api.github.com/users/uzzell/starred{/o...</td>\n",
       "      <td>https://api.github.com/users/uzzell/subscriptions</td>\n",
       "      <td>https://api.github.com/users/uzzell/orgs</td>\n",
       "      <td>https://api.github.com/users/uzzell/repos</td>\n",
       "      <td>https://api.github.com/users/uzzell/events{/pr...</td>\n",
       "      <td>https://api.github.com/users/uzzell/received_e...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0         login        id               node_id  \\\n",
       "0           0     rmhowe425  45905457  MDQ6VXNlcjQ1OTA1NDU3   \n",
       "1           1        hugovk   1324225  MDQ6VXNlcjEzMjQyMjU=   \n",
       "2           2      dannyi96  15380498  MDQ6VXNlcjE1MzgwNDk4   \n",
       "3           3  DeaMariaLeon  11835246  MDQ6VXNlcjExODM1MjQ2   \n",
       "4           4        uzzell  72205435  MDQ6VXNlcjcyMjA1NDM1   \n",
       "\n",
       "                                          avatar_url  gravatar_id  \\\n",
       "0  https://avatars.githubusercontent.com/u/459054...          NaN   \n",
       "1  https://avatars.githubusercontent.com/u/132422...          NaN   \n",
       "2  https://avatars.githubusercontent.com/u/153804...          NaN   \n",
       "3  https://avatars.githubusercontent.com/u/118352...          NaN   \n",
       "4  https://avatars.githubusercontent.com/u/722054...          NaN   \n",
       "\n",
       "                                         url                         html_url  \\\n",
       "0     https://api.github.com/users/rmhowe425     https://github.com/rmhowe425   \n",
       "1        https://api.github.com/users/hugovk        https://github.com/hugovk   \n",
       "2      https://api.github.com/users/dannyi96      https://github.com/dannyi96   \n",
       "3  https://api.github.com/users/DeaMariaLeon  https://github.com/DeaMariaLeon   \n",
       "4        https://api.github.com/users/uzzell        https://github.com/uzzell   \n",
       "\n",
       "                                       followers_url  \\\n",
       "0   https://api.github.com/users/rmhowe425/followers   \n",
       "1      https://api.github.com/users/hugovk/followers   \n",
       "2    https://api.github.com/users/dannyi96/followers   \n",
       "3  https://api.github.com/users/DeaMariaLeon/foll...   \n",
       "4      https://api.github.com/users/uzzell/followers   \n",
       "\n",
       "                                       following_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/followi...   \n",
       "1  https://api.github.com/users/hugovk/following{...   \n",
       "2  https://api.github.com/users/dannyi96/followin...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/foll...   \n",
       "4  https://api.github.com/users/uzzell/following{...   \n",
       "\n",
       "                                           gists_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/gists{/...   \n",
       "1  https://api.github.com/users/hugovk/gists{/gis...   \n",
       "2  https://api.github.com/users/dannyi96/gists{/g...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/gist...   \n",
       "4  https://api.github.com/users/uzzell/gists{/gis...   \n",
       "\n",
       "                                         starred_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/starred...   \n",
       "1  https://api.github.com/users/hugovk/starred{/o...   \n",
       "2  https://api.github.com/users/dannyi96/starred{...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/star...   \n",
       "4  https://api.github.com/users/uzzell/starred{/o...   \n",
       "\n",
       "                                   subscriptions_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/subscri...   \n",
       "1  https://api.github.com/users/hugovk/subscriptions   \n",
       "2  https://api.github.com/users/dannyi96/subscrip...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/subs...   \n",
       "4  https://api.github.com/users/uzzell/subscriptions   \n",
       "\n",
       "                                organizations_url  \\\n",
       "0     https://api.github.com/users/rmhowe425/orgs   \n",
       "1        https://api.github.com/users/hugovk/orgs   \n",
       "2      https://api.github.com/users/dannyi96/orgs   \n",
       "3  https://api.github.com/users/DeaMariaLeon/orgs   \n",
       "4        https://api.github.com/users/uzzell/orgs   \n",
       "\n",
       "                                         repos_url  \\\n",
       "0     https://api.github.com/users/rmhowe425/repos   \n",
       "1        https://api.github.com/users/hugovk/repos   \n",
       "2      https://api.github.com/users/dannyi96/repos   \n",
       "3  https://api.github.com/users/DeaMariaLeon/repos   \n",
       "4        https://api.github.com/users/uzzell/repos   \n",
       "\n",
       "                                          events_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/events{...   \n",
       "1  https://api.github.com/users/hugovk/events{/pr...   \n",
       "2  https://api.github.com/users/dannyi96/events{/...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/even...   \n",
       "4  https://api.github.com/users/uzzell/events{/pr...   \n",
       "\n",
       "                                 received_events_url  type  site_admin  \n",
       "0  https://api.github.com/users/rmhowe425/receive...  User       False  \n",
       "1  https://api.github.com/users/hugovk/received_e...  User       False  \n",
       "2  https://api.github.com/users/dannyi96/received...  User       False  \n",
       "3  https://api.github.com/users/DeaMariaLeon/rece...  User       False  \n",
       "4  https://api.github.com/users/uzzell/received_e...  User       False  "
      ]
     },
     "execution_count": 218,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "h5_data['obj2'].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 219,
   "id": "65b74151",
   "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>Unnamed: 0</th>\n",
       "      <th>login</th>\n",
       "      <th>id</th>\n",
       "      <th>node_id</th>\n",
       "      <th>avatar_url</th>\n",
       "      <th>gravatar_id</th>\n",
       "      <th>url</th>\n",
       "      <th>html_url</th>\n",
       "      <th>followers_url</th>\n",
       "      <th>following_url</th>\n",
       "      <th>gists_url</th>\n",
       "      <th>starred_url</th>\n",
       "      <th>subscriptions_url</th>\n",
       "      <th>organizations_url</th>\n",
       "      <th>repos_url</th>\n",
       "      <th>events_url</th>\n",
       "      <th>received_events_url</th>\n",
       "      <th>type</th>\n",
       "      <th>site_admin</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>natmokval</td>\n",
       "      <td>91160475</td>\n",
       "      <td>MDQ6VXNlcjkxMTYwNDc1</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/911604...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/natmokval</td>\n",
       "      <td>https://github.com/natmokval</td>\n",
       "      <td>https://api.github.com/users/natmokval/followers</td>\n",
       "      <td>https://api.github.com/users/natmokval/followi...</td>\n",
       "      <td>https://api.github.com/users/natmokval/gists{/...</td>\n",
       "      <td>https://api.github.com/users/natmokval/starred...</td>\n",
       "      <td>https://api.github.com/users/natmokval/subscri...</td>\n",
       "      <td>https://api.github.com/users/natmokval/orgs</td>\n",
       "      <td>https://api.github.com/users/natmokval/repos</td>\n",
       "      <td>https://api.github.com/users/natmokval/events{...</td>\n",
       "      <td>https://api.github.com/users/natmokval/receive...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>dannyi96</td>\n",
       "      <td>15380498</td>\n",
       "      <td>MDQ6VXNlcjE1MzgwNDk4</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/153804...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/dannyi96</td>\n",
       "      <td>https://github.com/dannyi96</td>\n",
       "      <td>https://api.github.com/users/dannyi96/followers</td>\n",
       "      <td>https://api.github.com/users/dannyi96/followin...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/gists{/g...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/starred{...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/subscrip...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/orgs</td>\n",
       "      <td>https://api.github.com/users/dannyi96/repos</td>\n",
       "      <td>https://api.github.com/users/dannyi96/events{/...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/received...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>jameslamb</td>\n",
       "      <td>7608904</td>\n",
       "      <td>MDQ6VXNlcjc2MDg5MDQ=</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/760890...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/jameslamb</td>\n",
       "      <td>https://github.com/jameslamb</td>\n",
       "      <td>https://api.github.com/users/jameslamb/followers</td>\n",
       "      <td>https://api.github.com/users/jameslamb/followi...</td>\n",
       "      <td>https://api.github.com/users/jameslamb/gists{/...</td>\n",
       "      <td>https://api.github.com/users/jameslamb/starred...</td>\n",
       "      <td>https://api.github.com/users/jameslamb/subscri...</td>\n",
       "      <td>https://api.github.com/users/jameslamb/orgs</td>\n",
       "      <td>https://api.github.com/users/jameslamb/repos</td>\n",
       "      <td>https://api.github.com/users/jameslamb/events{...</td>\n",
       "      <td>https://api.github.com/users/jameslamb/receive...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>jayendra-patil33</td>\n",
       "      <td>43951088</td>\n",
       "      <td>MDQ6VXNlcjQzOTUxMDg4</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/439510...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/jayendra-patil33</td>\n",
       "      <td>https://github.com/jayendra-patil33</td>\n",
       "      <td>https://api.github.com/users/jayendra-patil33/...</td>\n",
       "      <td>https://api.github.com/users/jayendra-patil33/...</td>\n",
       "      <td>https://api.github.com/users/jayendra-patil33/...</td>\n",
       "      <td>https://api.github.com/users/jayendra-patil33/...</td>\n",
       "      <td>https://api.github.com/users/jayendra-patil33/...</td>\n",
       "      <td>https://api.github.com/users/jayendra-patil33/...</td>\n",
       "      <td>https://api.github.com/users/jayendra-patil33/...</td>\n",
       "      <td>https://api.github.com/users/jayendra-patil33/...</td>\n",
       "      <td>https://api.github.com/users/jayendra-patil33/...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>jbrockmendel</td>\n",
       "      <td>8078968</td>\n",
       "      <td>MDQ6VXNlcjgwNzg5Njg=</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/807896...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel</td>\n",
       "      <td>https://github.com/jbrockmendel</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel/foll...</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel/foll...</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel/gist...</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel/star...</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel/subs...</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel/orgs</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel/repos</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel/even...</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel/rece...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>jbrockmendel</td>\n",
       "      <td>8078968</td>\n",
       "      <td>MDQ6VXNlcjgwNzg5Njg=</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/807896...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel</td>\n",
       "      <td>https://github.com/jbrockmendel</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel/foll...</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel/foll...</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel/gist...</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel/star...</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel/subs...</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel/orgs</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel/repos</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel/even...</td>\n",
       "      <td>https://api.github.com/users/jbrockmendel/rece...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0             login        id               node_id  \\\n",
       "10          10         natmokval  91160475  MDQ6VXNlcjkxMTYwNDc1   \n",
       "11          11          dannyi96  15380498  MDQ6VXNlcjE1MzgwNDk4   \n",
       "12          12         jameslamb   7608904  MDQ6VXNlcjc2MDg5MDQ=   \n",
       "13          13  jayendra-patil33  43951088  MDQ6VXNlcjQzOTUxMDg4   \n",
       "14          14      jbrockmendel   8078968  MDQ6VXNlcjgwNzg5Njg=   \n",
       "15          15      jbrockmendel   8078968  MDQ6VXNlcjgwNzg5Njg=   \n",
       "\n",
       "                                           avatar_url  gravatar_id  \\\n",
       "10  https://avatars.githubusercontent.com/u/911604...          NaN   \n",
       "11  https://avatars.githubusercontent.com/u/153804...          NaN   \n",
       "12  https://avatars.githubusercontent.com/u/760890...          NaN   \n",
       "13  https://avatars.githubusercontent.com/u/439510...          NaN   \n",
       "14  https://avatars.githubusercontent.com/u/807896...          NaN   \n",
       "15  https://avatars.githubusercontent.com/u/807896...          NaN   \n",
       "\n",
       "                                              url  \\\n",
       "10         https://api.github.com/users/natmokval   \n",
       "11          https://api.github.com/users/dannyi96   \n",
       "12         https://api.github.com/users/jameslamb   \n",
       "13  https://api.github.com/users/jayendra-patil33   \n",
       "14      https://api.github.com/users/jbrockmendel   \n",
       "15      https://api.github.com/users/jbrockmendel   \n",
       "\n",
       "                               html_url  \\\n",
       "10         https://github.com/natmokval   \n",
       "11          https://github.com/dannyi96   \n",
       "12         https://github.com/jameslamb   \n",
       "13  https://github.com/jayendra-patil33   \n",
       "14      https://github.com/jbrockmendel   \n",
       "15      https://github.com/jbrockmendel   \n",
       "\n",
       "                                        followers_url  \\\n",
       "10   https://api.github.com/users/natmokval/followers   \n",
       "11    https://api.github.com/users/dannyi96/followers   \n",
       "12   https://api.github.com/users/jameslamb/followers   \n",
       "13  https://api.github.com/users/jayendra-patil33/...   \n",
       "14  https://api.github.com/users/jbrockmendel/foll...   \n",
       "15  https://api.github.com/users/jbrockmendel/foll...   \n",
       "\n",
       "                                        following_url  \\\n",
       "10  https://api.github.com/users/natmokval/followi...   \n",
       "11  https://api.github.com/users/dannyi96/followin...   \n",
       "12  https://api.github.com/users/jameslamb/followi...   \n",
       "13  https://api.github.com/users/jayendra-patil33/...   \n",
       "14  https://api.github.com/users/jbrockmendel/foll...   \n",
       "15  https://api.github.com/users/jbrockmendel/foll...   \n",
       "\n",
       "                                            gists_url  \\\n",
       "10  https://api.github.com/users/natmokval/gists{/...   \n",
       "11  https://api.github.com/users/dannyi96/gists{/g...   \n",
       "12  https://api.github.com/users/jameslamb/gists{/...   \n",
       "13  https://api.github.com/users/jayendra-patil33/...   \n",
       "14  https://api.github.com/users/jbrockmendel/gist...   \n",
       "15  https://api.github.com/users/jbrockmendel/gist...   \n",
       "\n",
       "                                          starred_url  \\\n",
       "10  https://api.github.com/users/natmokval/starred...   \n",
       "11  https://api.github.com/users/dannyi96/starred{...   \n",
       "12  https://api.github.com/users/jameslamb/starred...   \n",
       "13  https://api.github.com/users/jayendra-patil33/...   \n",
       "14  https://api.github.com/users/jbrockmendel/star...   \n",
       "15  https://api.github.com/users/jbrockmendel/star...   \n",
       "\n",
       "                                    subscriptions_url  \\\n",
       "10  https://api.github.com/users/natmokval/subscri...   \n",
       "11  https://api.github.com/users/dannyi96/subscrip...   \n",
       "12  https://api.github.com/users/jameslamb/subscri...   \n",
       "13  https://api.github.com/users/jayendra-patil33/...   \n",
       "14  https://api.github.com/users/jbrockmendel/subs...   \n",
       "15  https://api.github.com/users/jbrockmendel/subs...   \n",
       "\n",
       "                                    organizations_url  \\\n",
       "10        https://api.github.com/users/natmokval/orgs   \n",
       "11         https://api.github.com/users/dannyi96/orgs   \n",
       "12        https://api.github.com/users/jameslamb/orgs   \n",
       "13  https://api.github.com/users/jayendra-patil33/...   \n",
       "14     https://api.github.com/users/jbrockmendel/orgs   \n",
       "15     https://api.github.com/users/jbrockmendel/orgs   \n",
       "\n",
       "                                            repos_url  \\\n",
       "10       https://api.github.com/users/natmokval/repos   \n",
       "11        https://api.github.com/users/dannyi96/repos   \n",
       "12       https://api.github.com/users/jameslamb/repos   \n",
       "13  https://api.github.com/users/jayendra-patil33/...   \n",
       "14    https://api.github.com/users/jbrockmendel/repos   \n",
       "15    https://api.github.com/users/jbrockmendel/repos   \n",
       "\n",
       "                                           events_url  \\\n",
       "10  https://api.github.com/users/natmokval/events{...   \n",
       "11  https://api.github.com/users/dannyi96/events{/...   \n",
       "12  https://api.github.com/users/jameslamb/events{...   \n",
       "13  https://api.github.com/users/jayendra-patil33/...   \n",
       "14  https://api.github.com/users/jbrockmendel/even...   \n",
       "15  https://api.github.com/users/jbrockmendel/even...   \n",
       "\n",
       "                                  received_events_url  type  site_admin  \n",
       "10  https://api.github.com/users/natmokval/receive...  User       False  \n",
       "11  https://api.github.com/users/dannyi96/received...  User       False  \n",
       "12  https://api.github.com/users/jameslamb/receive...  User       False  \n",
       "13  https://api.github.com/users/jayendra-patil33/...  User       False  \n",
       "14  https://api.github.com/users/jbrockmendel/rece...  User       False  \n",
       "15  https://api.github.com/users/jbrockmendel/rece...  User       False  "
      ]
     },
     "execution_count": 219,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "h5_data.select('obj2', where=['index >=10 and index <= 15'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 220,
   "id": "4e05dec1",
   "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>Unnamed: 0</th>\n",
       "      <th>login</th>\n",
       "      <th>id</th>\n",
       "      <th>node_id</th>\n",
       "      <th>avatar_url</th>\n",
       "      <th>gravatar_id</th>\n",
       "      <th>url</th>\n",
       "      <th>html_url</th>\n",
       "      <th>followers_url</th>\n",
       "      <th>following_url</th>\n",
       "      <th>gists_url</th>\n",
       "      <th>starred_url</th>\n",
       "      <th>subscriptions_url</th>\n",
       "      <th>organizations_url</th>\n",
       "      <th>repos_url</th>\n",
       "      <th>events_url</th>\n",
       "      <th>received_events_url</th>\n",
       "      <th>type</th>\n",
       "      <th>site_admin</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>rmhowe425</td>\n",
       "      <td>45905457</td>\n",
       "      <td>MDQ6VXNlcjQ1OTA1NDU3</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/459054...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/rmhowe425</td>\n",
       "      <td>https://github.com/rmhowe425</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/followers</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/followi...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/gists{/...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/starred...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/subscri...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/orgs</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/repos</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/events{...</td>\n",
       "      <td>https://api.github.com/users/rmhowe425/receive...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>hugovk</td>\n",
       "      <td>1324225</td>\n",
       "      <td>MDQ6VXNlcjEzMjQyMjU=</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/132422...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/hugovk</td>\n",
       "      <td>https://github.com/hugovk</td>\n",
       "      <td>https://api.github.com/users/hugovk/followers</td>\n",
       "      <td>https://api.github.com/users/hugovk/following{...</td>\n",
       "      <td>https://api.github.com/users/hugovk/gists{/gis...</td>\n",
       "      <td>https://api.github.com/users/hugovk/starred{/o...</td>\n",
       "      <td>https://api.github.com/users/hugovk/subscriptions</td>\n",
       "      <td>https://api.github.com/users/hugovk/orgs</td>\n",
       "      <td>https://api.github.com/users/hugovk/repos</td>\n",
       "      <td>https://api.github.com/users/hugovk/events{/pr...</td>\n",
       "      <td>https://api.github.com/users/hugovk/received_e...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>dannyi96</td>\n",
       "      <td>15380498</td>\n",
       "      <td>MDQ6VXNlcjE1MzgwNDk4</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/153804...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/dannyi96</td>\n",
       "      <td>https://github.com/dannyi96</td>\n",
       "      <td>https://api.github.com/users/dannyi96/followers</td>\n",
       "      <td>https://api.github.com/users/dannyi96/followin...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/gists{/g...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/starred{...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/subscrip...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/orgs</td>\n",
       "      <td>https://api.github.com/users/dannyi96/repos</td>\n",
       "      <td>https://api.github.com/users/dannyi96/events{/...</td>\n",
       "      <td>https://api.github.com/users/dannyi96/received...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>DeaMariaLeon</td>\n",
       "      <td>11835246</td>\n",
       "      <td>MDQ6VXNlcjExODM1MjQ2</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/118352...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon</td>\n",
       "      <td>https://github.com/DeaMariaLeon</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/foll...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/foll...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/gist...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/star...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/subs...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/orgs</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/repos</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/even...</td>\n",
       "      <td>https://api.github.com/users/DeaMariaLeon/rece...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>uzzell</td>\n",
       "      <td>72205435</td>\n",
       "      <td>MDQ6VXNlcjcyMjA1NDM1</td>\n",
       "      <td>https://avatars.githubusercontent.com/u/722054...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://api.github.com/users/uzzell</td>\n",
       "      <td>https://github.com/uzzell</td>\n",
       "      <td>https://api.github.com/users/uzzell/followers</td>\n",
       "      <td>https://api.github.com/users/uzzell/following{...</td>\n",
       "      <td>https://api.github.com/users/uzzell/gists{/gis...</td>\n",
       "      <td>https://api.github.com/users/uzzell/starred{/o...</td>\n",
       "      <td>https://api.github.com/users/uzzell/subscriptions</td>\n",
       "      <td>https://api.github.com/users/uzzell/orgs</td>\n",
       "      <td>https://api.github.com/users/uzzell/repos</td>\n",
       "      <td>https://api.github.com/users/uzzell/events{/pr...</td>\n",
       "      <td>https://api.github.com/users/uzzell/received_e...</td>\n",
       "      <td>User</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0         login        id               node_id  \\\n",
       "0           0     rmhowe425  45905457  MDQ6VXNlcjQ1OTA1NDU3   \n",
       "1           1        hugovk   1324225  MDQ6VXNlcjEzMjQyMjU=   \n",
       "2           2      dannyi96  15380498  MDQ6VXNlcjE1MzgwNDk4   \n",
       "3           3  DeaMariaLeon  11835246  MDQ6VXNlcjExODM1MjQ2   \n",
       "4           4        uzzell  72205435  MDQ6VXNlcjcyMjA1NDM1   \n",
       "\n",
       "                                          avatar_url  gravatar_id  \\\n",
       "0  https://avatars.githubusercontent.com/u/459054...          NaN   \n",
       "1  https://avatars.githubusercontent.com/u/132422...          NaN   \n",
       "2  https://avatars.githubusercontent.com/u/153804...          NaN   \n",
       "3  https://avatars.githubusercontent.com/u/118352...          NaN   \n",
       "4  https://avatars.githubusercontent.com/u/722054...          NaN   \n",
       "\n",
       "                                         url                         html_url  \\\n",
       "0     https://api.github.com/users/rmhowe425     https://github.com/rmhowe425   \n",
       "1        https://api.github.com/users/hugovk        https://github.com/hugovk   \n",
       "2      https://api.github.com/users/dannyi96      https://github.com/dannyi96   \n",
       "3  https://api.github.com/users/DeaMariaLeon  https://github.com/DeaMariaLeon   \n",
       "4        https://api.github.com/users/uzzell        https://github.com/uzzell   \n",
       "\n",
       "                                       followers_url  \\\n",
       "0   https://api.github.com/users/rmhowe425/followers   \n",
       "1      https://api.github.com/users/hugovk/followers   \n",
       "2    https://api.github.com/users/dannyi96/followers   \n",
       "3  https://api.github.com/users/DeaMariaLeon/foll...   \n",
       "4      https://api.github.com/users/uzzell/followers   \n",
       "\n",
       "                                       following_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/followi...   \n",
       "1  https://api.github.com/users/hugovk/following{...   \n",
       "2  https://api.github.com/users/dannyi96/followin...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/foll...   \n",
       "4  https://api.github.com/users/uzzell/following{...   \n",
       "\n",
       "                                           gists_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/gists{/...   \n",
       "1  https://api.github.com/users/hugovk/gists{/gis...   \n",
       "2  https://api.github.com/users/dannyi96/gists{/g...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/gist...   \n",
       "4  https://api.github.com/users/uzzell/gists{/gis...   \n",
       "\n",
       "                                         starred_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/starred...   \n",
       "1  https://api.github.com/users/hugovk/starred{/o...   \n",
       "2  https://api.github.com/users/dannyi96/starred{...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/star...   \n",
       "4  https://api.github.com/users/uzzell/starred{/o...   \n",
       "\n",
       "                                   subscriptions_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/subscri...   \n",
       "1  https://api.github.com/users/hugovk/subscriptions   \n",
       "2  https://api.github.com/users/dannyi96/subscrip...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/subs...   \n",
       "4  https://api.github.com/users/uzzell/subscriptions   \n",
       "\n",
       "                                organizations_url  \\\n",
       "0     https://api.github.com/users/rmhowe425/orgs   \n",
       "1        https://api.github.com/users/hugovk/orgs   \n",
       "2      https://api.github.com/users/dannyi96/orgs   \n",
       "3  https://api.github.com/users/DeaMariaLeon/orgs   \n",
       "4        https://api.github.com/users/uzzell/orgs   \n",
       "\n",
       "                                         repos_url  \\\n",
       "0     https://api.github.com/users/rmhowe425/repos   \n",
       "1        https://api.github.com/users/hugovk/repos   \n",
       "2      https://api.github.com/users/dannyi96/repos   \n",
       "3  https://api.github.com/users/DeaMariaLeon/repos   \n",
       "4        https://api.github.com/users/uzzell/repos   \n",
       "\n",
       "                                          events_url  \\\n",
       "0  https://api.github.com/users/rmhowe425/events{...   \n",
       "1  https://api.github.com/users/hugovk/events{/pr...   \n",
       "2  https://api.github.com/users/dannyi96/events{/...   \n",
       "3  https://api.github.com/users/DeaMariaLeon/even...   \n",
       "4  https://api.github.com/users/uzzell/events{/pr...   \n",
       "\n",
       "                                 received_events_url  type  site_admin  \n",
       "0  https://api.github.com/users/rmhowe425/receive...  User       False  \n",
       "1  https://api.github.com/users/hugovk/received_e...  User       False  \n",
       "2  https://api.github.com/users/dannyi96/received...  User       False  \n",
       "3  https://api.github.com/users/DeaMariaLeon/rece...  User       False  \n",
       "4  https://api.github.com/users/uzzell/received_e...  User       False  "
      ]
     },
     "execution_count": 220,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 222,
   "id": "aa33e4a3",
   "metadata": {},
   "outputs": [
    {
     "ename": "KeyError",
     "evalue": "'Sex'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "File \u001b[1;32m~\\anaconda3\\lib\\site-packages\\pandas\\core\\indexes\\base.py:3080\u001b[0m, in \u001b[0;36mIndex.get_loc\u001b[1;34m(self, key, method, tolerance)\u001b[0m\n\u001b[0;32m   3079\u001b[0m \u001b[38;5;28;01mtry\u001b[39;00m:\n\u001b[1;32m-> 3080\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_engine\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mget_loc\u001b[49m\u001b[43m(\u001b[49m\u001b[43mcasted_key\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m   3081\u001b[0m \u001b[38;5;28;01mexcept\u001b[39;00m \u001b[38;5;167;01mKeyError\u001b[39;00m \u001b[38;5;28;01mas\u001b[39;00m err:\n",
      "File \u001b[1;32mpandas\\_libs\\index.pyx:70\u001b[0m, in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[1;34m()\u001b[0m\n",
      "File \u001b[1;32mpandas\\_libs\\index.pyx:101\u001b[0m, in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[1;34m()\u001b[0m\n",
      "File \u001b[1;32mpandas\\_libs\\hashtable_class_helper.pxi:4554\u001b[0m, in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[1;34m()\u001b[0m\n",
      "File \u001b[1;32mpandas\\_libs\\hashtable_class_helper.pxi:4562\u001b[0m, in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;31mKeyError\u001b[0m: 'Sex'",
      "\nThe above exception was the direct cause of the following exception:\n",
      "\u001b[1;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "Cell \u001b[1;32mIn[222], line 1\u001b[0m\n\u001b[1;32m----> 1\u001b[0m \u001b[43mdf\u001b[49m\u001b[43m[\u001b[49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[38;5;124;43mSex\u001b[39;49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[43m]\u001b[49m\n",
      "File \u001b[1;32m~\\anaconda3\\lib\\site-packages\\pandas\\core\\frame.py:3024\u001b[0m, in \u001b[0;36mDataFrame.__getitem__\u001b[1;34m(self, key)\u001b[0m\n\u001b[0;32m   3022\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mcolumns\u001b[38;5;241m.\u001b[39mnlevels \u001b[38;5;241m>\u001b[39m \u001b[38;5;241m1\u001b[39m:\n\u001b[0;32m   3023\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_getitem_multilevel(key)\n\u001b[1;32m-> 3024\u001b[0m indexer \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mcolumns\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mget_loc\u001b[49m\u001b[43m(\u001b[49m\u001b[43mkey\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m   3025\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m is_integer(indexer):\n\u001b[0;32m   3026\u001b[0m     indexer \u001b[38;5;241m=\u001b[39m [indexer]\n",
      "File \u001b[1;32m~\\anaconda3\\lib\\site-packages\\pandas\\core\\indexes\\base.py:3082\u001b[0m, in \u001b[0;36mIndex.get_loc\u001b[1;34m(self, key, method, tolerance)\u001b[0m\n\u001b[0;32m   3080\u001b[0m         \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_engine\u001b[38;5;241m.\u001b[39mget_loc(casted_key)\n\u001b[0;32m   3081\u001b[0m     \u001b[38;5;28;01mexcept\u001b[39;00m \u001b[38;5;167;01mKeyError\u001b[39;00m \u001b[38;5;28;01mas\u001b[39;00m err:\n\u001b[1;32m-> 3082\u001b[0m         \u001b[38;5;28;01mraise\u001b[39;00m \u001b[38;5;167;01mKeyError\u001b[39;00m(key) \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01merr\u001b[39;00m\n\u001b[0;32m   3084\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m tolerance \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;129;01mnot\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m:\n\u001b[0;32m   3085\u001b[0m     tolerance \u001b[38;5;241m=\u001b[39m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_convert_tolerance(tolerance, np\u001b[38;5;241m.\u001b[39masarray(key))\n",
      "\u001b[1;31mKeyError\u001b[0m: 'Sex'"
     ]
    }
   ],
   "source": [
    "df['Sex']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "7c2f889e",
   "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}