Pandas Functions.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Functions and methods"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Dataframe/ Series.head() function"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>id</th>\n",
       "      <th>case_in_country</th>\n",
       "      <th>reporting date</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>summary</th>\n",
       "      <th>location</th>\n",
       "      <th>country</th>\n",
       "      <th>gender</th>\n",
       "      <th>age</th>\n",
       "      <th>symptom_onset</th>\n",
       "      <th>...</th>\n",
       "      <th>recovered</th>\n",
       "      <th>symptom</th>\n",
       "      <th>source</th>\n",
       "      <th>link</th>\n",
       "      <th>Unnamed: 21</th>\n",
       "      <th>Unnamed: 22</th>\n",
       "      <th>Unnamed: 23</th>\n",
       "      <th>Unnamed: 24</th>\n",
       "      <th>Unnamed: 25</th>\n",
       "      <th>Unnamed: 26</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/20/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>First confirmed imported COVID-19 pneumonia pa...</td>\n",
       "      <td>Shenzhen, Guangdong</td>\n",
       "      <td>China</td>\n",
       "      <td>male</td>\n",
       "      <td>66.0</td>\n",
       "      <td>01/03/20</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Shenzhen Municipal Health Commission</td>\n",
       "      <td>http://wjw.sz.gov.cn/wzx/202001/t20200120_1898...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/20/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>First confirmed imported COVID-19 pneumonia pa...</td>\n",
       "      <td>Shanghai</td>\n",
       "      <td>China</td>\n",
       "      <td>female</td>\n",
       "      <td>56.0</td>\n",
       "      <td>1/15/2020</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Official Weibo of Shanghai Municipal Health Co...</td>\n",
       "      <td>https://www.weibo.com/2372649470/IqogQhgfa?fro...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/21/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>First confirmed imported cases in Zhejiang: pa...</td>\n",
       "      <td>Zhejiang</td>\n",
       "      <td>China</td>\n",
       "      <td>male</td>\n",
       "      <td>46.0</td>\n",
       "      <td>01/04/20</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Health Commission of Zhejiang Province</td>\n",
       "      <td>http://www.zjwjw.gov.cn/art/2020/1/21/art_1202...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/21/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new confirmed imported COVID-19 pneumonia in T...</td>\n",
       "      <td>Tianjin</td>\n",
       "      <td>China</td>\n",
       "      <td>female</td>\n",
       "      <td>60.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>人民日报官方微博</td>\n",
       "      <td>https://m.weibo.cn/status/4463235401268457?</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/21/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new confirmed imported COVID-19 pneumonia in T...</td>\n",
       "      <td>Tianjin</td>\n",
       "      <td>China</td>\n",
       "      <td>male</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>人民日报官方微博</td>\n",
       "      <td>https://m.weibo.cn/status/4463235401268457?</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   id  case_in_country reporting date  Unnamed: 3  \\\n",
       "0   1              NaN      1/20/2020         NaN   \n",
       "1   2              NaN      1/20/2020         NaN   \n",
       "2   3              NaN      1/21/2020         NaN   \n",
       "3   4              NaN      1/21/2020         NaN   \n",
       "4   5              NaN      1/21/2020         NaN   \n",
       "\n",
       "                                             summary             location  \\\n",
       "0  First confirmed imported COVID-19 pneumonia pa...  Shenzhen, Guangdong   \n",
       "1  First confirmed imported COVID-19 pneumonia pa...             Shanghai   \n",
       "2  First confirmed imported cases in Zhejiang: pa...             Zhejiang   \n",
       "3  new confirmed imported COVID-19 pneumonia in T...              Tianjin   \n",
       "4  new confirmed imported COVID-19 pneumonia in T...              Tianjin   \n",
       "\n",
       "  country  gender   age symptom_onset  ...  recovered symptom  \\\n",
       "0   China    male  66.0      01/03/20  ...          0     NaN   \n",
       "1   China  female  56.0     1/15/2020  ...          0     NaN   \n",
       "2   China    male  46.0      01/04/20  ...          0     NaN   \n",
       "3   China  female  60.0           NaN  ...          0     NaN   \n",
       "4   China    male  58.0           NaN  ...          0     NaN   \n",
       "\n",
       "                                              source  \\\n",
       "0               Shenzhen Municipal Health Commission   \n",
       "1  Official Weibo of Shanghai Municipal Health Co...   \n",
       "2             Health Commission of Zhejiang Province   \n",
       "3                                           人民日报官方微博   \n",
       "4                                           人民日报官方微博   \n",
       "\n",
       "                                                link  Unnamed: 21  \\\n",
       "0  http://wjw.sz.gov.cn/wzx/202001/t20200120_1898...          NaN   \n",
       "1  https://www.weibo.com/2372649470/IqogQhgfa?fro...          NaN   \n",
       "2  http://www.zjwjw.gov.cn/art/2020/1/21/art_1202...          NaN   \n",
       "3        https://m.weibo.cn/status/4463235401268457?          NaN   \n",
       "4        https://m.weibo.cn/status/4463235401268457?          NaN   \n",
       "\n",
       "   Unnamed: 22 Unnamed: 23 Unnamed: 24 Unnamed: 25 Unnamed: 26  \n",
       "0          NaN         NaN         NaN         NaN         NaN  \n",
       "1          NaN         NaN         NaN         NaN         NaN  \n",
       "2          NaN         NaN         NaN         NaN         NaN  \n",
       "3          NaN         NaN         NaN         NaN         NaN  \n",
       "4          NaN         NaN         NaN         NaN         NaN  \n",
       "\n",
       "[5 rows x 27 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "\n",
    "import pandas as pd\n",
    "data = pd.read_csv(\"COVID19_line_list_data.csv\")\n",
    "d = data.head()\n",
    "d"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    Shenzhen, Guangdong\n",
       "1               Shanghai\n",
       "2               Zhejiang\n",
       "3                Tianjin\n",
       "4                Tianjin\n",
       "5              Chongqing\n",
       "6                Sichuan\n",
       "7                Beijing\n",
       "8                Beijing\n",
       "Name: location, dtype: object"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Setting n value in .head() function\n",
    "\n",
    "import pandas as pd\n",
    "data = pd.read_csv(\"COVID19_line_list_data.csv\")\n",
    "df = data[\"location\"]\n",
    "d = df.head(9)\n",
    "d"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Dataframe/ Series.describe() function"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>case_in_country</th>\n",
       "      <th>reporting date</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>summary</th>\n",
       "      <th>location</th>\n",
       "      <th>country</th>\n",
       "      <th>gender</th>\n",
       "      <th>age</th>\n",
       "      <th>symptom_onset</th>\n",
       "      <th>If_onset_approximated</th>\n",
       "      <th>...</th>\n",
       "      <th>recovered</th>\n",
       "      <th>symptom</th>\n",
       "      <th>source</th>\n",
       "      <th>link</th>\n",
       "      <th>Unnamed: 21</th>\n",
       "      <th>Unnamed: 22</th>\n",
       "      <th>Unnamed: 23</th>\n",
       "      <th>Unnamed: 24</th>\n",
       "      <th>Unnamed: 25</th>\n",
       "      <th>Unnamed: 26</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique</th>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>top</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>freq</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30%</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70%</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90%</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        case_in_country reporting date  Unnamed: 3 summary location country  \\\n",
       "count               0.0              0         0.0       0        0       0   \n",
       "unique              NaN              0         NaN       0        0       0   \n",
       "top                 NaN            NaN         NaN     NaN      NaN     NaN   \n",
       "freq                NaN            NaN         NaN     NaN      NaN     NaN   \n",
       "mean                NaN            NaN         NaN     NaN      NaN     NaN   \n",
       "std                 NaN            NaN         NaN     NaN      NaN     NaN   \n",
       "min                 NaN            NaN         NaN     NaN      NaN     NaN   \n",
       "30%                 NaN            NaN         NaN     NaN      NaN     NaN   \n",
       "50%                 NaN            NaN         NaN     NaN      NaN     NaN   \n",
       "70%                 NaN            NaN         NaN     NaN      NaN     NaN   \n",
       "90%                 NaN            NaN         NaN     NaN      NaN     NaN   \n",
       "max                 NaN            NaN         NaN     NaN      NaN     NaN   \n",
       "\n",
       "       gender  age symptom_onset  If_onset_approximated  ... recovered  \\\n",
       "count       0  0.0             0                    0.0  ...         0   \n",
       "unique      0  NaN             0                    NaN  ...         0   \n",
       "top       NaN  NaN           NaN                    NaN  ...       NaN   \n",
       "freq      NaN  NaN           NaN                    NaN  ...       NaN   \n",
       "mean      NaN  NaN           NaN                    NaN  ...       NaN   \n",
       "std       NaN  NaN           NaN                    NaN  ...       NaN   \n",
       "min       NaN  NaN           NaN                    NaN  ...       NaN   \n",
       "30%       NaN  NaN           NaN                    NaN  ...       NaN   \n",
       "50%       NaN  NaN           NaN                    NaN  ...       NaN   \n",
       "70%       NaN  NaN           NaN                    NaN  ...       NaN   \n",
       "90%       NaN  NaN           NaN                    NaN  ...       NaN   \n",
       "max       NaN  NaN           NaN                    NaN  ...       NaN   \n",
       "\n",
       "       symptom source  link Unnamed: 21 Unnamed: 22 Unnamed: 23 Unnamed: 24  \\\n",
       "count        0      0     0         0.0         0.0         0.0         0.0   \n",
       "unique       0      0     0         NaN         NaN         NaN         NaN   \n",
       "top        NaN    NaN   NaN         NaN         NaN         NaN         NaN   \n",
       "freq       NaN    NaN   NaN         NaN         NaN         NaN         NaN   \n",
       "mean       NaN    NaN   NaN         NaN         NaN         NaN         NaN   \n",
       "std        NaN    NaN   NaN         NaN         NaN         NaN         NaN   \n",
       "min        NaN    NaN   NaN         NaN         NaN         NaN         NaN   \n",
       "30%        NaN    NaN   NaN         NaN         NaN         NaN         NaN   \n",
       "50%        NaN    NaN   NaN         NaN         NaN         NaN         NaN   \n",
       "70%        NaN    NaN   NaN         NaN         NaN         NaN         NaN   \n",
       "90%        NaN    NaN   NaN         NaN         NaN         NaN         NaN   \n",
       "max        NaN    NaN   NaN         NaN         NaN         NaN         NaN   \n",
       "\n",
       "       Unnamed: 25  Unnamed: 26  \n",
       "count          0.0          0.0  \n",
       "unique         NaN          NaN  \n",
       "top            NaN          NaN  \n",
       "freq           NaN          NaN  \n",
       "mean           NaN          NaN  \n",
       "std            NaN          NaN  \n",
       "min            NaN          NaN  \n",
       "30%            NaN          NaN  \n",
       "50%            NaN          NaN  \n",
       "70%            NaN          NaN  \n",
       "90%            NaN          NaN  \n",
       "max            NaN          NaN  \n",
       "\n",
       "[12 rows x 25 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# importing pandas module  \n",
    "import pandas as pd  \n",
    "  \n",
    "# importing regex module \n",
    "import re \n",
    "    \n",
    "# making data frame  \n",
    "data = pd.read_csv(\"COVID19_line_list_data.csv\")  \n",
    "    \n",
    "# removing null values to avoid errors  \n",
    "data.dropna(inplace = True)  \n",
    "  \n",
    "# percentile list \n",
    "perc =[.30, .50, .70, .90] \n",
    "  \n",
    "# list of dtypes to include \n",
    "include =['object', 'float', 'int'] \n",
    "  \n",
    "# calling describe method \n",
    "desc = data.describe(percentiles = perc, include = include) \n",
    "  \n",
    "# display \n",
    "desc"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Dataframe/Series.loc() method"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "           id  case_in_country reporting date  Unnamed: 3  \\\n",
      "location                                                    \n",
      "Beijing     8              NaN      1/21/2020         NaN   \n",
      "Beijing     9              NaN      1/21/2020         NaN   \n",
      "Beijing    10              NaN      1/21/2020         NaN   \n",
      "Beijing    11              NaN      1/21/2020         NaN   \n",
      "Beijing    12              NaN      1/21/2020         NaN   \n",
      "Beijing    36              NaN      1/22/2020         NaN   \n",
      "Beijing    37              NaN      1/22/2020         NaN   \n",
      "Beijing    38              NaN      1/22/2020         NaN   \n",
      "Beijing    39              NaN      1/22/2020         NaN   \n",
      "Beijing    92              NaN      1/24/2020         NaN   \n",
      "Beijing   117              NaN      1/25/2020         NaN   \n",
      "Beijing   146              NaN      1/21/2020         NaN   \n",
      "Beijing   147              NaN      1/21/2020         NaN   \n",
      "Beijing   148              NaN      1/25/2020         NaN   \n",
      "Beijing   170              NaN      1/27/2020         NaN   \n",
      "Beijing   171              NaN      1/27/2020         NaN   \n",
      "Beijing   172              NaN      1/27/2020         NaN   \n",
      "Beijing   173              NaN      1/27/2020         NaN   \n",
      "\n",
      "                                                    summary country  gender  \\\n",
      "location                                                                      \n",
      "Beijing   new confirmed imported COVID-19 pneumonia pati...   China    male   \n",
      "Beijing   new confirmed imported COVID-19 pneumonia pati...   China    male   \n",
      "Beijing   new confirmed imported COVID-19 pneumonia pati...   China    male   \n",
      "Beijing   new confirmed imported COVID-19 pneumonia pati...   China  female   \n",
      "Beijing   new confirmed imported COVID-19 pneumonia pati...   China  female   \n",
      "Beijing   new confirmed imported COVID-19 pneumonia pati...   China    male   \n",
      "Beijing   new confirmed imported COVID-19 pneumonia pati...   China    male   \n",
      "Beijing   new confirmed imported COVID-19 pneumonia pati...   China  female   \n",
      "Beijing   new confirmed imported COVID-19 pneumonia pati...   China  female   \n",
      "Beijing   new recovered imported COVID-19 pneumonia pati...   China  female   \n",
      "Beijing   new recovered imported COVID-19 pneumonia pati...   China    male   \n",
      "Beijing   new confirmed imported COVID-19 pneumonia pati...   China    male   \n",
      "Beijing   new confirmed imported COVID-19 pneumonia pati...   China    male   \n",
      "Beijing   new confirmed imported COVID-19 pneumonia pati...   China    male   \n",
      "Beijing                                                 NaN   China    male   \n",
      "Beijing                                                 NaN   China  female   \n",
      "Beijing                                                 NaN   China    male   \n",
      "Beijing                                                 NaN   China  female   \n",
      "\n",
      "           age symptom_onset  If_onset_approximated  ... recovered symptom  \\\n",
      "location                                             ...                     \n",
      "Beijing   37.0     1/14/2020                    0.0  ...         0     NaN   \n",
      "Beijing   39.0      01/09/20                    0.0  ...         0     NaN   \n",
      "Beijing   56.0     1/16/2020                    0.0  ...         0     NaN   \n",
      "Beijing   18.0     1/19/2020                    0.0  ...         0     NaN   \n",
      "Beijing   32.0    01/15/2020                    0.0  ...         0     NaN   \n",
      "Beijing   45.0     1/19/2020                    0.0  ...         0     NaN   \n",
      "Beijing   42.0     1/20/2020                    0.0  ...         0     NaN   \n",
      "Beijing   33.0           NaN                    NaN  ...         0     NaN   \n",
      "Beijing   33.0           NaN                    NaN  ...         0     NaN   \n",
      "Beijing    NaN           NaN                    NaN  ...         0     NaN   \n",
      "Beijing    NaN           NaN                    NaN  ...         0     NaN   \n",
      "Beijing    NaN     1/16/2020                    0.0  ...         0     NaN   \n",
      "Beijing    NaN     1/14/2020                    0.0  ...         0     NaN   \n",
      "Beijing    NaN     1/18/2020                    0.0  ...         0     NaN   \n",
      "Beijing   35.0     1/18/2020                    0.0  ...         0     NaN   \n",
      "Beijing    4.0     1/18/2020                    0.0  ...         0     NaN   \n",
      "Beijing   38.0     1/22/2020                    0.0  ...         0     NaN   \n",
      "Beijing   69.0      01/10/20                    0.0  ...         0     NaN   \n",
      "\n",
      "                                       source  \\\n",
      "location                                        \n",
      "Beijing   Beijing Municipal Health Commission   \n",
      "Beijing   Beijing Municipal Health Commission   \n",
      "Beijing   Beijing Municipal Health Commission   \n",
      "Beijing   Beijing Municipal Health Commission   \n",
      "Beijing   Beijing Municipal Health Commission   \n",
      "Beijing                                  央视新闻   \n",
      "Beijing                                  央视新闻   \n",
      "Beijing                                  央视新闻   \n",
      "Beijing                                  央视新闻   \n",
      "Beijing                                  人民日报   \n",
      "Beijing                                  央视新闻   \n",
      "Beijing                                  央视新闻   \n",
      "Beijing                                  央视新闻   \n",
      "Beijing                                  央视新闻   \n",
      "Beijing                                  央视新闻   \n",
      "Beijing                                  央视新闻   \n",
      "Beijing                                  央视新闻   \n",
      "Beijing                                  央视新闻   \n",
      "\n",
      "                                                       link  Unnamed: 21  \\\n",
      "location                                                                   \n",
      "Beijing   http://wjw.beijing.gov.cn/xwzx_20031/wnxw/2020...          NaN   \n",
      "Beijing   http://wjw.beijing.gov.cn/xwzx_20031/wnxw/2020...          NaN   \n",
      "Beijing   http://wjw.beijing.gov.cn/xwzx_20031/wnxw/2020...          NaN   \n",
      "Beijing   http://wjw.beijing.gov.cn/xwzx_20031/wnxw/2020...          NaN   \n",
      "Beijing   http://wjw.beijing.gov.cn/xwzx_20031/wnxw/2020...          NaN   \n",
      "Beijing         https://m.weibo.cn/status/4463681624289721?          NaN   \n",
      "Beijing         https://m.weibo.cn/status/4463681624289721?          NaN   \n",
      "Beijing         https://m.weibo.cn/status/4463681624289721?          NaN   \n",
      "Beijing         https://m.weibo.cn/status/4463681624289721?          NaN   \n",
      "Beijing         https://m.weibo.cn/status/4464259805726673?          NaN   \n",
      "Beijing         https://m.weibo.cn/status/4464576223073059?          NaN   \n",
      "Beijing         https://m.weibo.cn/status/4464865911441959?          NaN   \n",
      "Beijing         https://m.weibo.cn/status/4464865911441959?          NaN   \n",
      "Beijing         https://m.weibo.cn/status/4464865911441959?          NaN   \n",
      "Beijing         https://m.weibo.cn/status/4465361728673224?          NaN   \n",
      "Beijing         https://m.weibo.cn/status/4465361728673224?          NaN   \n",
      "Beijing         https://m.weibo.cn/status/4465361728673224?          NaN   \n",
      "Beijing         https://m.weibo.cn/status/4465361728673224?          NaN   \n",
      "\n",
      "         Unnamed: 22 Unnamed: 23 Unnamed: 24 Unnamed: 25 Unnamed: 26  \n",
      "location                                                              \n",
      "Beijing          NaN         NaN         NaN         NaN         NaN  \n",
      "Beijing          NaN         NaN         NaN         NaN         NaN  \n",
      "Beijing          NaN         NaN         NaN         NaN         NaN  \n",
      "Beijing          NaN         NaN         NaN         NaN         NaN  \n",
      "Beijing          NaN         NaN         NaN         NaN         NaN  \n",
      "Beijing          NaN         NaN         NaN         NaN         NaN  \n",
      "Beijing          NaN         NaN         NaN         NaN         NaN  \n",
      "Beijing          NaN         NaN         NaN         NaN         NaN  \n",
      "Beijing          NaN         NaN         NaN         NaN         NaN  \n",
      "Beijing          NaN         NaN         NaN         NaN         NaN  \n",
      "Beijing          NaN         NaN         NaN         NaN         NaN  \n",
      "Beijing          NaN         NaN         NaN         NaN         NaN  \n",
      "Beijing          NaN         NaN         NaN         NaN         NaN  \n",
      "Beijing          NaN         NaN         NaN         NaN         NaN  \n",
      "Beijing          NaN         NaN         NaN         NaN         NaN  \n",
      "Beijing          NaN         NaN         NaN         NaN         NaN  \n",
      "Beijing          NaN         NaN         NaN         NaN         NaN  \n",
      "Beijing          NaN         NaN         NaN         NaN         NaN  \n",
      "\n",
      "[18 rows x 26 columns] \n",
      "\n",
      "\n",
      "           id  case_in_country reporting date  Unnamed: 3  \\\n",
      "location                                                   \n",
      "Shanghai   2              NaN      1/20/2020         NaN   \n",
      "Shanghai  95              NaN      1/24/2020         NaN   \n",
      "\n",
      "                                                    summary country  gender  \\\n",
      "location                                                                      \n",
      "Shanghai  First confirmed imported COVID-19 pneumonia pa...   China  female   \n",
      "Shanghai  First recovered imported COVID-19 pneumonia pa...   China  female   \n",
      "\n",
      "           age symptom_onset  If_onset_approximated  ... recovered symptom  \\\n",
      "location                                             ...                     \n",
      "Shanghai  56.0     1/15/2020                    0.0  ...         0     NaN   \n",
      "Shanghai  56.0      01/10/20                    0.0  ...         0     NaN   \n",
      "\n",
      "                                                     source  \\\n",
      "location                                                      \n",
      "Shanghai  Official Weibo of Shanghai Municipal Health Co...   \n",
      "Shanghai                                               人民日报   \n",
      "\n",
      "                                                       link  Unnamed: 21  \\\n",
      "location                                                                   \n",
      "Shanghai  https://www.weibo.com/2372649470/IqogQhgfa?fro...          NaN   \n",
      "Shanghai        https://m.weibo.cn/status/4464354512805408?          NaN   \n",
      "\n",
      "         Unnamed: 22 Unnamed: 23 Unnamed: 24 Unnamed: 25 Unnamed: 26  \n",
      "location                                                              \n",
      "Shanghai         NaN         NaN         NaN         NaN         NaN  \n",
      "Shanghai         NaN         NaN         NaN         NaN         NaN  \n",
      "\n",
      "[2 rows x 26 columns]\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "data = pd.read_csv(\"COVID19_line_list_data.csv\", index_col =\"location\")\n",
    "first = data.loc[\"Beijing\"]\n",
    "second = data.loc[\"Shanghai\"]\n",
    "\n",
    "print(first, \"\\n\\n\\n\", second)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Dataframe/Series.iloc[] method"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "id                        True\n",
       "case_in_country          False\n",
       "reporting date            True\n",
       "Unnamed: 3               False\n",
       "summary                   True\n",
       "location                  True\n",
       "country                   True\n",
       "gender                    True\n",
       "age                       True\n",
       "symptom_onset             True\n",
       "If_onset_approximated     True\n",
       "hosp_visit_date           True\n",
       "exposure_start           False\n",
       "exposure_end              True\n",
       "visiting Wuhan            True\n",
       "from Wuhan                True\n",
       "death                     True\n",
       "recovered                 True\n",
       "symptom                  False\n",
       "source                    True\n",
       "link                      True\n",
       "Unnamed: 21              False\n",
       "Unnamed: 22              False\n",
       "Unnamed: 23              False\n",
       "Unnamed: 24              False\n",
       "Unnamed: 25              False\n",
       "Unnamed: 26              False\n",
       "Name: 2, dtype: bool"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# importing pandas package \n",
    "import pandas as pd \n",
    "  \n",
    "# making data frame from csv file  \n",
    "data = pd.read_csv(\"COVID19_line_list_data.csv\") \n",
    "  \n",
    "# retrieving rows by loc method  \n",
    "row1 = data.loc[2]\n",
    "  \n",
    "# retrieving rows by iloc method \n",
    "row2 = data.iloc[2] \n",
    "# checking if values are equal \n",
    "row1 == row2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>id</th>\n",
       "      <th>case_in_country</th>\n",
       "      <th>reporting date</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>summary</th>\n",
       "      <th>location</th>\n",
       "      <th>country</th>\n",
       "      <th>gender</th>\n",
       "      <th>age</th>\n",
       "      <th>symptom_onset</th>\n",
       "      <th>...</th>\n",
       "      <th>recovered</th>\n",
       "      <th>symptom</th>\n",
       "      <th>source</th>\n",
       "      <th>link</th>\n",
       "      <th>Unnamed: 21</th>\n",
       "      <th>Unnamed: 22</th>\n",
       "      <th>Unnamed: 23</th>\n",
       "      <th>Unnamed: 24</th>\n",
       "      <th>Unnamed: 25</th>\n",
       "      <th>Unnamed: 26</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id  case_in_country  reporting date  Unnamed: 3  summary  location  \\\n",
       "14  True            False            True       False     True      True   \n",
       "15  True            False            True       False     True      True   \n",
       "16  True            False            True       False     True      True   \n",
       "17  True            False            True       False     True      True   \n",
       "\n",
       "    country  gender   age  symptom_onset  ...  recovered  symptom  source  \\\n",
       "14     True    True  True           True  ...       True    False    True   \n",
       "15     True    True  True           True  ...       True    False    True   \n",
       "16     True    True  True           True  ...       True    False    True   \n",
       "17     True    True  True           True  ...       True    False    True   \n",
       "\n",
       "    link  Unnamed: 21  Unnamed: 22  Unnamed: 23  Unnamed: 24  Unnamed: 25  \\\n",
       "14  True        False        False        False        False        False   \n",
       "15  True        False        False        False        False        False   \n",
       "16  True        False        False        False        False        False   \n",
       "17  True        False        False        False        False        False   \n",
       "\n",
       "    Unnamed: 26  \n",
       "14        False  \n",
       "15        False  \n",
       "16        False  \n",
       "17        False  \n",
       "\n",
       "[4 rows x 27 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# importing pandas package \n",
    "import pandas as pd \n",
    "  \n",
    "# making data frame from csv file  \n",
    "data = pd.read_csv(\"COVID19_line_list_data.csv\") \n",
    "  \n",
    "# retrieving rows by loc method  \n",
    "row1 = data.iloc[[14, 15, 16, 17]] \n",
    "  \n",
    "# retrieving rows by loc method  \n",
    "row2 = data.iloc[14:18] \n",
    "  \n",
    "# comparing values\n",
    "row1 == row2"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Pandas.read_csv() method"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>id</th>\n",
       "      <th>case_in_country</th>\n",
       "      <th>reporting date</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>summary</th>\n",
       "      <th>location</th>\n",
       "      <th>country</th>\n",
       "      <th>gender</th>\n",
       "      <th>age</th>\n",
       "      <th>symptom_onset</th>\n",
       "      <th>...</th>\n",
       "      <th>recovered</th>\n",
       "      <th>symptom</th>\n",
       "      <th>source</th>\n",
       "      <th>link</th>\n",
       "      <th>Unnamed: 21</th>\n",
       "      <th>Unnamed: 22</th>\n",
       "      <th>Unnamed: 23</th>\n",
       "      <th>Unnamed: 24</th>\n",
       "      <th>Unnamed: 25</th>\n",
       "      <th>Unnamed: 26</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/20/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>First confirmed imported COVID-19 pneumonia pa...</td>\n",
       "      <td>Shenzhen, Guangdong</td>\n",
       "      <td>China</td>\n",
       "      <td>male</td>\n",
       "      <td>66.0</td>\n",
       "      <td>01/03/20</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Shenzhen Municipal Health Commission</td>\n",
       "      <td>http://wjw.sz.gov.cn/wzx/202001/t20200120_1898...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/20/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>First confirmed imported COVID-19 pneumonia pa...</td>\n",
       "      <td>Shanghai</td>\n",
       "      <td>China</td>\n",
       "      <td>female</td>\n",
       "      <td>56.0</td>\n",
       "      <td>1/15/2020</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Official Weibo of Shanghai Municipal Health Co...</td>\n",
       "      <td>https://www.weibo.com/2372649470/IqogQhgfa?fro...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/21/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>First confirmed imported cases in Zhejiang: pa...</td>\n",
       "      <td>Zhejiang</td>\n",
       "      <td>China</td>\n",
       "      <td>male</td>\n",
       "      <td>46.0</td>\n",
       "      <td>01/04/20</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Health Commission of Zhejiang Province</td>\n",
       "      <td>http://www.zjwjw.gov.cn/art/2020/1/21/art_1202...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/21/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new confirmed imported COVID-19 pneumonia in T...</td>\n",
       "      <td>Tianjin</td>\n",
       "      <td>China</td>\n",
       "      <td>female</td>\n",
       "      <td>60.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>人民日报官方微博</td>\n",
       "      <td>https://m.weibo.cn/status/4463235401268457?</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/21/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new confirmed imported COVID-19 pneumonia in T...</td>\n",
       "      <td>Tianjin</td>\n",
       "      <td>China</td>\n",
       "      <td>male</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>人民日报官方微博</td>\n",
       "      <td>https://m.weibo.cn/status/4463235401268457?</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <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>1080</th>\n",
       "      <td>1081</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2/25/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Austria: 24,...</td>\n",
       "      <td>Innsbruck</td>\n",
       "      <td>Austria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jakarta Post</td>\n",
       "      <td>https://www.thejakartapost.com/news/2020/02/25...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1081</th>\n",
       "      <td>1082</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/24/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Afghanistan:...</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fox News</td>\n",
       "      <td>https://www.foxnews.com/health/afghanistan-fir...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1082</th>\n",
       "      <td>1083</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/26/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Algeria: mal...</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>male</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>South China Morning Post</td>\n",
       "      <td>https://www.scmp.com/news/china/society/articl...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1083</th>\n",
       "      <td>1084</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/25/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Croatia: mal...</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>male</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Reuters</td>\n",
       "      <td>https://www.reuters.com/article/us-croatia-cor...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1084</th>\n",
       "      <td>1085</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/25/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Switzerland:...</td>\n",
       "      <td>Bern</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>male</td>\n",
       "      <td>70.0</td>\n",
       "      <td>2/17/2020</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Reuters</td>\n",
       "      <td>https://www.reuters.com/article/uk-switzerland...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1085 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        id  case_in_country reporting date  Unnamed: 3  \\\n",
       "0        1              NaN      1/20/2020         NaN   \n",
       "1        2              NaN      1/20/2020         NaN   \n",
       "2        3              NaN      1/21/2020         NaN   \n",
       "3        4              NaN      1/21/2020         NaN   \n",
       "4        5              NaN      1/21/2020         NaN   \n",
       "...    ...              ...            ...         ...   \n",
       "1080  1081              2.0      2/25/2020         NaN   \n",
       "1081  1082              1.0      2/24/2020         NaN   \n",
       "1082  1083              1.0      2/26/2020         NaN   \n",
       "1083  1084              1.0      2/25/2020         NaN   \n",
       "1084  1085              1.0      2/25/2020         NaN   \n",
       "\n",
       "                                                summary             location  \\\n",
       "0     First confirmed imported COVID-19 pneumonia pa...  Shenzhen, Guangdong   \n",
       "1     First confirmed imported COVID-19 pneumonia pa...             Shanghai   \n",
       "2     First confirmed imported cases in Zhejiang: pa...             Zhejiang   \n",
       "3     new confirmed imported COVID-19 pneumonia in T...              Tianjin   \n",
       "4     new confirmed imported COVID-19 pneumonia in T...              Tianjin   \n",
       "...                                                 ...                  ...   \n",
       "1080  new COVID-19 patient confirmed in Austria: 24,...            Innsbruck   \n",
       "1081  new COVID-19 patient confirmed in Afghanistan:...          Afghanistan   \n",
       "1082  new COVID-19 patient confirmed in Algeria: mal...              Algeria   \n",
       "1083  new COVID-19 patient confirmed in Croatia: mal...              Croatia   \n",
       "1084  new COVID-19 patient confirmed in Switzerland:...                 Bern   \n",
       "\n",
       "          country  gender   age symptom_onset  ...  recovered symptom  \\\n",
       "0           China    male  66.0      01/03/20  ...          0     NaN   \n",
       "1           China  female  56.0     1/15/2020  ...          0     NaN   \n",
       "2           China    male  46.0      01/04/20  ...          0     NaN   \n",
       "3           China  female  60.0           NaN  ...          0     NaN   \n",
       "4           China    male  58.0           NaN  ...          0     NaN   \n",
       "...           ...     ...   ...           ...  ...        ...     ...   \n",
       "1080      Austria     NaN  24.0           NaN  ...          0     NaN   \n",
       "1081  Afghanistan     NaN  35.0           NaN  ...          0     NaN   \n",
       "1082      Algeria    male   NaN           NaN  ...          0     NaN   \n",
       "1083      Croatia    male   NaN           NaN  ...          0     NaN   \n",
       "1084  Switzerland    male  70.0     2/17/2020  ...          0     NaN   \n",
       "\n",
       "                                                 source  \\\n",
       "0                  Shenzhen Municipal Health Commission   \n",
       "1     Official Weibo of Shanghai Municipal Health Co...   \n",
       "2                Health Commission of Zhejiang Province   \n",
       "3                                              人民日报官方微博   \n",
       "4                                              人民日报官方微博   \n",
       "...                                                 ...   \n",
       "1080                                       Jakarta Post   \n",
       "1081                                           Fox News   \n",
       "1082                           South China Morning Post   \n",
       "1083                                            Reuters   \n",
       "1084                                            Reuters   \n",
       "\n",
       "                                                   link  Unnamed: 21  \\\n",
       "0     http://wjw.sz.gov.cn/wzx/202001/t20200120_1898...          NaN   \n",
       "1     https://www.weibo.com/2372649470/IqogQhgfa?fro...          NaN   \n",
       "2     http://www.zjwjw.gov.cn/art/2020/1/21/art_1202...          NaN   \n",
       "3           https://m.weibo.cn/status/4463235401268457?          NaN   \n",
       "4           https://m.weibo.cn/status/4463235401268457?          NaN   \n",
       "...                                                 ...          ...   \n",
       "1080  https://www.thejakartapost.com/news/2020/02/25...          NaN   \n",
       "1081  https://www.foxnews.com/health/afghanistan-fir...          NaN   \n",
       "1082  https://www.scmp.com/news/china/society/articl...          NaN   \n",
       "1083  https://www.reuters.com/article/us-croatia-cor...          NaN   \n",
       "1084  https://www.reuters.com/article/uk-switzerland...          NaN   \n",
       "\n",
       "      Unnamed: 22 Unnamed: 23 Unnamed: 24 Unnamed: 25 Unnamed: 26  \n",
       "0             NaN         NaN         NaN         NaN         NaN  \n",
       "1             NaN         NaN         NaN         NaN         NaN  \n",
       "2             NaN         NaN         NaN         NaN         NaN  \n",
       "3             NaN         NaN         NaN         NaN         NaN  \n",
       "4             NaN         NaN         NaN         NaN         NaN  \n",
       "...           ...         ...         ...         ...         ...  \n",
       "1080          NaN         NaN         NaN         NaN         NaN  \n",
       "1081          NaN         NaN         NaN         NaN         NaN  \n",
       "1082          NaN         NaN         NaN         NaN         NaN  \n",
       "1083          NaN         NaN         NaN         NaN         NaN  \n",
       "1084          NaN         NaN         NaN         NaN         NaN  \n",
       "\n",
       "[1085 rows x 27 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Import pandas\n",
    "import pandas as pd\n",
    "\n",
    "#reading a csv file\n",
    "pd.read_csv(\"COVID19_line_list_data.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>id</th>\n",
       "      <th>case_in_country</th>\n",
       "      <th>reporting date</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>summary</th>\n",
       "      <th>location</th>\n",
       "      <th>country</th>\n",
       "      <th>gender</th>\n",
       "      <th>age</th>\n",
       "      <th>symptom_onset</th>\n",
       "      <th>...</th>\n",
       "      <th>recovered</th>\n",
       "      <th>symptom</th>\n",
       "      <th>source</th>\n",
       "      <th>link</th>\n",
       "      <th>Unnamed: 21</th>\n",
       "      <th>Unnamed: 22</th>\n",
       "      <th>Unnamed: 23</th>\n",
       "      <th>Unnamed: 24</th>\n",
       "      <th>Unnamed: 25</th>\n",
       "      <th>Unnamed: 26</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/20/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>First confirmed imported COVID-19 pneumonia pa...</td>\n",
       "      <td>Shenzhen, Guangdong</td>\n",
       "      <td>China</td>\n",
       "      <td>male</td>\n",
       "      <td>66.0</td>\n",
       "      <td>01/03/20</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Shenzhen Municipal Health Commission</td>\n",
       "      <td>http://wjw.sz.gov.cn/wzx/202001/t20200120_1898...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/20/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>First confirmed imported COVID-19 pneumonia pa...</td>\n",
       "      <td>Shanghai</td>\n",
       "      <td>China</td>\n",
       "      <td>female</td>\n",
       "      <td>56.0</td>\n",
       "      <td>1/15/2020</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Official Weibo of Shanghai Municipal Health Co...</td>\n",
       "      <td>https://www.weibo.com/2372649470/IqogQhgfa?fro...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/21/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>First confirmed imported cases in Zhejiang: pa...</td>\n",
       "      <td>Zhejiang</td>\n",
       "      <td>China</td>\n",
       "      <td>male</td>\n",
       "      <td>46.0</td>\n",
       "      <td>01/04/20</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Health Commission of Zhejiang Province</td>\n",
       "      <td>http://www.zjwjw.gov.cn/art/2020/1/21/art_1202...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/21/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new confirmed imported COVID-19 pneumonia in T...</td>\n",
       "      <td>Tianjin</td>\n",
       "      <td>China</td>\n",
       "      <td>female</td>\n",
       "      <td>60.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>人民日报官方微博</td>\n",
       "      <td>https://m.weibo.cn/status/4463235401268457?</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/21/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new confirmed imported COVID-19 pneumonia in T...</td>\n",
       "      <td>Tianjin</td>\n",
       "      <td>China</td>\n",
       "      <td>male</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>人民日报官方微博</td>\n",
       "      <td>https://m.weibo.cn/status/4463235401268457?</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <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>1080</th>\n",
       "      <td>1081</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2/25/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Austria: 24,...</td>\n",
       "      <td>Innsbruck</td>\n",
       "      <td>Austria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jakarta Post</td>\n",
       "      <td>https://www.thejakartapost.com/news/2020/02/25...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1081</th>\n",
       "      <td>1082</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/24/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Afghanistan:...</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fox News</td>\n",
       "      <td>https://www.foxnews.com/health/afghanistan-fir...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1082</th>\n",
       "      <td>1083</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/26/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Algeria: mal...</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>male</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>South China Morning Post</td>\n",
       "      <td>https://www.scmp.com/news/china/society/articl...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1083</th>\n",
       "      <td>1084</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/25/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Croatia: mal...</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>male</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Reuters</td>\n",
       "      <td>https://www.reuters.com/article/us-croatia-cor...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1084</th>\n",
       "      <td>1085</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/25/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Switzerland:...</td>\n",
       "      <td>Bern</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>male</td>\n",
       "      <td>70.0</td>\n",
       "      <td>2/17/2020</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Reuters</td>\n",
       "      <td>https://www.reuters.com/article/uk-switzerland...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1085 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        id  case_in_country reporting date  Unnamed: 3  \\\n",
       "0        1              NaN      1/20/2020         NaN   \n",
       "1        2              NaN      1/20/2020         NaN   \n",
       "2        3              NaN      1/21/2020         NaN   \n",
       "3        4              NaN      1/21/2020         NaN   \n",
       "4        5              NaN      1/21/2020         NaN   \n",
       "...    ...              ...            ...         ...   \n",
       "1080  1081              2.0      2/25/2020         NaN   \n",
       "1081  1082              1.0      2/24/2020         NaN   \n",
       "1082  1083              1.0      2/26/2020         NaN   \n",
       "1083  1084              1.0      2/25/2020         NaN   \n",
       "1084  1085              1.0      2/25/2020         NaN   \n",
       "\n",
       "                                                summary             location  \\\n",
       "0     First confirmed imported COVID-19 pneumonia pa...  Shenzhen, Guangdong   \n",
       "1     First confirmed imported COVID-19 pneumonia pa...             Shanghai   \n",
       "2     First confirmed imported cases in Zhejiang: pa...             Zhejiang   \n",
       "3     new confirmed imported COVID-19 pneumonia in T...              Tianjin   \n",
       "4     new confirmed imported COVID-19 pneumonia in T...              Tianjin   \n",
       "...                                                 ...                  ...   \n",
       "1080  new COVID-19 patient confirmed in Austria: 24,...            Innsbruck   \n",
       "1081  new COVID-19 patient confirmed in Afghanistan:...          Afghanistan   \n",
       "1082  new COVID-19 patient confirmed in Algeria: mal...              Algeria   \n",
       "1083  new COVID-19 patient confirmed in Croatia: mal...              Croatia   \n",
       "1084  new COVID-19 patient confirmed in Switzerland:...                 Bern   \n",
       "\n",
       "          country  gender   age symptom_onset  ...  recovered symptom  \\\n",
       "0           China    male  66.0      01/03/20  ...          0     NaN   \n",
       "1           China  female  56.0     1/15/2020  ...          0     NaN   \n",
       "2           China    male  46.0      01/04/20  ...          0     NaN   \n",
       "3           China  female  60.0           NaN  ...          0     NaN   \n",
       "4           China    male  58.0           NaN  ...          0     NaN   \n",
       "...           ...     ...   ...           ...  ...        ...     ...   \n",
       "1080      Austria     NaN  24.0           NaN  ...          0     NaN   \n",
       "1081  Afghanistan     NaN  35.0           NaN  ...          0     NaN   \n",
       "1082      Algeria    male   NaN           NaN  ...          0     NaN   \n",
       "1083      Croatia    male   NaN           NaN  ...          0     NaN   \n",
       "1084  Switzerland    male  70.0     2/17/2020  ...          0     NaN   \n",
       "\n",
       "                                                 source  \\\n",
       "0                  Shenzhen Municipal Health Commission   \n",
       "1     Official Weibo of Shanghai Municipal Health Co...   \n",
       "2                Health Commission of Zhejiang Province   \n",
       "3                                              人民日报官方微博   \n",
       "4                                              人民日报官方微博   \n",
       "...                                                 ...   \n",
       "1080                                       Jakarta Post   \n",
       "1081                                           Fox News   \n",
       "1082                           South China Morning Post   \n",
       "1083                                            Reuters   \n",
       "1084                                            Reuters   \n",
       "\n",
       "                                                   link  Unnamed: 21  \\\n",
       "0     http://wjw.sz.gov.cn/wzx/202001/t20200120_1898...          NaN   \n",
       "1     https://www.weibo.com/2372649470/IqogQhgfa?fro...          NaN   \n",
       "2     http://www.zjwjw.gov.cn/art/2020/1/21/art_1202...          NaN   \n",
       "3           https://m.weibo.cn/status/4463235401268457?          NaN   \n",
       "4           https://m.weibo.cn/status/4463235401268457?          NaN   \n",
       "...                                                 ...          ...   \n",
       "1080  https://www.thejakartapost.com/news/2020/02/25...          NaN   \n",
       "1081  https://www.foxnews.com/health/afghanistan-fir...          NaN   \n",
       "1082  https://www.scmp.com/news/china/society/articl...          NaN   \n",
       "1083  https://www.reuters.com/article/us-croatia-cor...          NaN   \n",
       "1084  https://www.reuters.com/article/uk-switzerland...          NaN   \n",
       "\n",
       "      Unnamed: 22 Unnamed: 23 Unnamed: 24 Unnamed: 25 Unnamed: 26  \n",
       "0             NaN         NaN         NaN         NaN         NaN  \n",
       "1             NaN         NaN         NaN         NaN         NaN  \n",
       "2             NaN         NaN         NaN         NaN         NaN  \n",
       "3             NaN         NaN         NaN         NaN         NaN  \n",
       "4             NaN         NaN         NaN         NaN         NaN  \n",
       "...           ...         ...         ...         ...         ...  \n",
       "1080          NaN         NaN         NaN         NaN         NaN  \n",
       "1081          NaN         NaN         NaN         NaN         NaN  \n",
       "1082          NaN         NaN         NaN         NaN         NaN  \n",
       "1083          NaN         NaN         NaN         NaN         NaN  \n",
       "1084          NaN         NaN         NaN         NaN         NaN  \n",
       "\n",
       "[1085 rows x 27 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Example 2\n",
    "# importing Pandas library \n",
    "import pandas as pd \n",
    "  \n",
    "pd.read_csv(filepath_or_buffer = \"COVID19_line_list_data.csv\") \n",
    "  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>11</th>\n",
       "      <th>Unnamed: 1_level_0</th>\n",
       "      <th>1/21/2020</th>\n",
       "      <th>Unnamed: 3_level_0</th>\n",
       "      <th>new confirmed imported COVID-19 pneumonia patient in Beijing: female, 18, visited Wuhan on 01/12/2020, return to Beijing on 01/17/2020, symptoms onset on 01/19/2020, hospitalized on 01/20/2020.</th>\n",
       "      <th>Beijing</th>\n",
       "      <th>China</th>\n",
       "      <th>female</th>\n",
       "      <th>18</th>\n",
       "      <th>1/19/2020</th>\n",
       "      <th>...</th>\n",
       "      <th>0</th>\n",
       "      <th>Unnamed: 18_level_0</th>\n",
       "      <th>Beijing Municipal Health Commission</th>\n",
       "      <th>http://wjw.beijing.gov.cn/xwzx_20031/wnxw/202001/t20200121_1620353.html</th>\n",
       "      <th>Unnamed: 21_level_0</th>\n",
       "      <th>Unnamed: 22_level_0</th>\n",
       "      <th>Unnamed: 23_level_0</th>\n",
       "      <th>Unnamed: 24_level_0</th>\n",
       "      <th>Unnamed: 25_level_0</th>\n",
       "      <th>Unnamed: 26_level_0</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>12</th>\n",
       "      <th>Unnamed: 1_level_1</th>\n",
       "      <th>1/21/2020</th>\n",
       "      <th>Unnamed: 3_level_1</th>\n",
       "      <th>new confirmed imported COVID-19 pneumonia patient in Beijing: female, 32, visited Wuhan on 01/13/2020, return to Beijing on 01/17/2020, symptoms onset while in Wuhan, hospitalized on 01/20/2020.</th>\n",
       "      <th>Beijing</th>\n",
       "      <th>China</th>\n",
       "      <th>female</th>\n",
       "      <th>32</th>\n",
       "      <th>01/15/2020</th>\n",
       "      <th>...</th>\n",
       "      <th>0.3</th>\n",
       "      <th>Unnamed: 18_level_1</th>\n",
       "      <th>Beijing Municipal Health Commission</th>\n",
       "      <th>http://wjw.beijing.gov.cn/xwzx_20031/wnxw/202001/t20200121_1620353.html</th>\n",
       "      <th>Unnamed: 21_level_1</th>\n",
       "      <th>Unnamed: 22_level_1</th>\n",
       "      <th>Unnamed: 23_level_1</th>\n",
       "      <th>Unnamed: 24_level_1</th>\n",
       "      <th>Unnamed: 25_level_1</th>\n",
       "      <th>Unnamed: 26_level_1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/21/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>First confirmed imported COVID-19 pneumonia pa...</td>\n",
       "      <td>Shandong</td>\n",
       "      <td>China</td>\n",
       "      <td>male</td>\n",
       "      <td>37.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>央视新闻</td>\n",
       "      <td>https://m.weibo.cn/status/4463323540564718?</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/21/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>First confirmed imported COVID-19 pneumonia pa...</td>\n",
       "      <td>Yunnan</td>\n",
       "      <td>China</td>\n",
       "      <td>male</td>\n",
       "      <td>51.0</td>\n",
       "      <td>1/16/2020</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>央视新闻</td>\n",
       "      <td>https://m.weibo.cn/status/4463321081961974?</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/22/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Second confirmed imported COVID-19 pneumonia p...</td>\n",
       "      <td>Sichuan</td>\n",
       "      <td>China</td>\n",
       "      <td>male</td>\n",
       "      <td>57.0</td>\n",
       "      <td>1/16/2020</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>央视新闻</td>\n",
       "      <td>https://www.weibo.com/2656274875/IqzRU3150?fro...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/22/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new confirmed imported COVID-19 pneumonia pati...</td>\n",
       "      <td>Jiangxi</td>\n",
       "      <td>China</td>\n",
       "      <td>male</td>\n",
       "      <td>56.0</td>\n",
       "      <td>01/10/20</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>央视新闻</td>\n",
       "      <td>https://www.weibo.com/2656274875/IqAcyp3Jr?fro...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/22/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new confirmed imported COVID-19 pneumonia pati...</td>\n",
       "      <td>Jiangxi</td>\n",
       "      <td>China</td>\n",
       "      <td>male</td>\n",
       "      <td>50.0</td>\n",
       "      <td>01/10/20</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>央视新闻</td>\n",
       "      <td>https://www.weibo.com/2656274875/IqAcyp3Jr?fro...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <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>1068</th>\n",
       "      <td>1081</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2/25/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Austria: 24,...</td>\n",
       "      <td>Innsbruck</td>\n",
       "      <td>Austria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jakarta Post</td>\n",
       "      <td>https://www.thejakartapost.com/news/2020/02/25...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1069</th>\n",
       "      <td>1082</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/24/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Afghanistan:...</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fox News</td>\n",
       "      <td>https://www.foxnews.com/health/afghanistan-fir...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1070</th>\n",
       "      <td>1083</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/26/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Algeria: mal...</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>male</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>South China Morning Post</td>\n",
       "      <td>https://www.scmp.com/news/china/society/articl...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1071</th>\n",
       "      <td>1084</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/25/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Croatia: mal...</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>male</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Reuters</td>\n",
       "      <td>https://www.reuters.com/article/us-croatia-cor...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1072</th>\n",
       "      <td>1085</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/25/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Switzerland:...</td>\n",
       "      <td>Bern</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>male</td>\n",
       "      <td>70.0</td>\n",
       "      <td>2/17/2020</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Reuters</td>\n",
       "      <td>https://www.reuters.com/article/uk-switzerland...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1073 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        11 Unnamed: 1_level_0  1/21/2020 Unnamed: 3_level_0  \\\n",
       "        12 Unnamed: 1_level_1  1/21/2020 Unnamed: 3_level_1   \n",
       "0       13                NaN  1/21/2020                NaN   \n",
       "1       14                NaN  1/21/2020                NaN   \n",
       "2       15                NaN  1/22/2020                NaN   \n",
       "3       16                NaN  1/22/2020                NaN   \n",
       "4       17                NaN  1/22/2020                NaN   \n",
       "...    ...                ...        ...                ...   \n",
       "1068  1081                2.0  2/25/2020                NaN   \n",
       "1069  1082                1.0  2/24/2020                NaN   \n",
       "1070  1083                1.0  2/26/2020                NaN   \n",
       "1071  1084                1.0  2/25/2020                NaN   \n",
       "1072  1085                1.0  2/25/2020                NaN   \n",
       "\n",
       "      new confirmed imported COVID-19 pneumonia patient in Beijing: female, 18, visited Wuhan on 01/12/2020, return to Beijing on 01/17/2020, symptoms onset on 01/19/2020, hospitalized on 01/20/2020.  \\\n",
       "     new confirmed imported COVID-19 pneumonia patient in Beijing: female, 32, visited Wuhan on 01/13/2020, return to Beijing on 01/17/2020, symptoms onset while in Wuhan, hospitalized on 01/20/2020.   \n",
       "0     First confirmed imported COVID-19 pneumonia pa...                                                                                                                                                   \n",
       "1     First confirmed imported COVID-19 pneumonia pa...                                                                                                                                                   \n",
       "2     Second confirmed imported COVID-19 pneumonia p...                                                                                                                                                   \n",
       "3     new confirmed imported COVID-19 pneumonia pati...                                                                                                                                                   \n",
       "4     new confirmed imported COVID-19 pneumonia pati...                                                                                                                                                   \n",
       "...                                                 ...                                                                                                                                                   \n",
       "1068  new COVID-19 patient confirmed in Austria: 24,...                                                                                                                                                   \n",
       "1069  new COVID-19 patient confirmed in Afghanistan:...                                                                                                                                                   \n",
       "1070  new COVID-19 patient confirmed in Algeria: mal...                                                                                                                                                   \n",
       "1071  new COVID-19 patient confirmed in Croatia: mal...                                                                                                                                                   \n",
       "1072  new COVID-19 patient confirmed in Switzerland:...                                                                                                                                                   \n",
       "\n",
       "          Beijing        China female    18  1/19/2020  ...   0  \\\n",
       "          Beijing        China female    32 01/15/2020  ... 0.3   \n",
       "0        Shandong        China   male  37.0        NaN  ...   0   \n",
       "1          Yunnan        China   male  51.0  1/16/2020  ...   0   \n",
       "2         Sichuan        China   male  57.0  1/16/2020  ...   0   \n",
       "3         Jiangxi        China   male  56.0   01/10/20  ...   0   \n",
       "4         Jiangxi        China   male  50.0   01/10/20  ...   0   \n",
       "...           ...          ...    ...   ...        ...  ...  ..   \n",
       "1068    Innsbruck      Austria    NaN  24.0        NaN  ...   0   \n",
       "1069  Afghanistan  Afghanistan    NaN  35.0        NaN  ...   0   \n",
       "1070      Algeria      Algeria   male   NaN        NaN  ...   0   \n",
       "1071      Croatia      Croatia   male   NaN        NaN  ...   0   \n",
       "1072         Bern  Switzerland   male  70.0  2/17/2020  ...   0   \n",
       "\n",
       "     Unnamed: 18_level_0 Beijing Municipal Health Commission  \\\n",
       "     Unnamed: 18_level_1 Beijing Municipal Health Commission   \n",
       "0                    NaN                                央视新闻   \n",
       "1                    NaN                                央视新闻   \n",
       "2                    NaN                                央视新闻   \n",
       "3                    NaN                                央视新闻   \n",
       "4                    NaN                                央视新闻   \n",
       "...                  ...                                 ...   \n",
       "1068                 NaN                        Jakarta Post   \n",
       "1069                 NaN                            Fox News   \n",
       "1070                 NaN            South China Morning Post   \n",
       "1071                 NaN                             Reuters   \n",
       "1072                 NaN                             Reuters   \n",
       "\n",
       "     http://wjw.beijing.gov.cn/xwzx_20031/wnxw/202001/t20200121_1620353.html  \\\n",
       "     http://wjw.beijing.gov.cn/xwzx_20031/wnxw/202001/t20200121_1620353.html   \n",
       "0           https://m.weibo.cn/status/4463323540564718?                        \n",
       "1           https://m.weibo.cn/status/4463321081961974?                        \n",
       "2     https://www.weibo.com/2656274875/IqzRU3150?fro...                        \n",
       "3     https://www.weibo.com/2656274875/IqAcyp3Jr?fro...                        \n",
       "4     https://www.weibo.com/2656274875/IqAcyp3Jr?fro...                        \n",
       "...                                                 ...                        \n",
       "1068  https://www.thejakartapost.com/news/2020/02/25...                        \n",
       "1069  https://www.foxnews.com/health/afghanistan-fir...                        \n",
       "1070  https://www.scmp.com/news/china/society/articl...                        \n",
       "1071  https://www.reuters.com/article/us-croatia-cor...                        \n",
       "1072  https://www.reuters.com/article/uk-switzerland...                        \n",
       "\n",
       "     Unnamed: 21_level_0 Unnamed: 22_level_0 Unnamed: 23_level_0  \\\n",
       "     Unnamed: 21_level_1 Unnamed: 22_level_1 Unnamed: 23_level_1   \n",
       "0                    NaN                 NaN                 NaN   \n",
       "1                    NaN                 NaN                 NaN   \n",
       "2                    NaN                 NaN                 NaN   \n",
       "3                    NaN                 NaN                 NaN   \n",
       "4                    NaN                 NaN                 NaN   \n",
       "...                  ...                 ...                 ...   \n",
       "1068                 NaN                 NaN                 NaN   \n",
       "1069                 NaN                 NaN                 NaN   \n",
       "1070                 NaN                 NaN                 NaN   \n",
       "1071                 NaN                 NaN                 NaN   \n",
       "1072                 NaN                 NaN                 NaN   \n",
       "\n",
       "     Unnamed: 24_level_0 Unnamed: 25_level_0 Unnamed: 26_level_0  \n",
       "     Unnamed: 24_level_1 Unnamed: 25_level_1 Unnamed: 26_level_1  \n",
       "0                    NaN                 NaN                 NaN  \n",
       "1                    NaN                 NaN                 NaN  \n",
       "2                    NaN                 NaN                 NaN  \n",
       "3                    NaN                 NaN                 NaN  \n",
       "4                    NaN                 NaN                 NaN  \n",
       "...                  ...                 ...                 ...  \n",
       "1068                 NaN                 NaN                 NaN  \n",
       "1069                 NaN                 NaN                 NaN  \n",
       "1070                 NaN                 NaN                 NaN  \n",
       "1071                 NaN                 NaN                 NaN  \n",
       "1072                 NaN                 NaN                 NaN  \n",
       "\n",
       "[1073 rows x 27 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# makes the passed rows header \n",
    "pd.read_csv( \"COVID19_line_list_data.csv\",header =[11, 12]) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>id</th>\n",
       "      <th>case_in_country</th>\n",
       "      <th>reporting date</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>summary</th>\n",
       "      <th>location</th>\n",
       "      <th>gender</th>\n",
       "      <th>age</th>\n",
       "      <th>symptom_onset</th>\n",
       "      <th>If_onset_approximated</th>\n",
       "      <th>...</th>\n",
       "      <th>recovered</th>\n",
       "      <th>symptom</th>\n",
       "      <th>source</th>\n",
       "      <th>link</th>\n",
       "      <th>Unnamed: 21</th>\n",
       "      <th>Unnamed: 22</th>\n",
       "      <th>Unnamed: 23</th>\n",
       "      <th>Unnamed: 24</th>\n",
       "      <th>Unnamed: 25</th>\n",
       "      <th>Unnamed: 26</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>China</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/20/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>First confirmed imported COVID-19 pneumonia pa...</td>\n",
       "      <td>Shenzhen, Guangdong</td>\n",
       "      <td>male</td>\n",
       "      <td>66.0</td>\n",
       "      <td>01/03/20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Shenzhen Municipal Health Commission</td>\n",
       "      <td>http://wjw.sz.gov.cn/wzx/202001/t20200120_1898...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>China</th>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/20/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>First confirmed imported COVID-19 pneumonia pa...</td>\n",
       "      <td>Shanghai</td>\n",
       "      <td>female</td>\n",
       "      <td>56.0</td>\n",
       "      <td>1/15/2020</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Official Weibo of Shanghai Municipal Health Co...</td>\n",
       "      <td>https://www.weibo.com/2372649470/IqogQhgfa?fro...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>China</th>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/21/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>First confirmed imported cases in Zhejiang: pa...</td>\n",
       "      <td>Zhejiang</td>\n",
       "      <td>male</td>\n",
       "      <td>46.0</td>\n",
       "      <td>01/04/20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Health Commission of Zhejiang Province</td>\n",
       "      <td>http://www.zjwjw.gov.cn/art/2020/1/21/art_1202...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>China</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/21/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new confirmed imported COVID-19 pneumonia in T...</td>\n",
       "      <td>Tianjin</td>\n",
       "      <td>female</td>\n",
       "      <td>60.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>人民日报官方微博</td>\n",
       "      <td>https://m.weibo.cn/status/4463235401268457?</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>China</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/21/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new confirmed imported COVID-19 pneumonia in T...</td>\n",
       "      <td>Tianjin</td>\n",
       "      <td>male</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>人民日报官方微博</td>\n",
       "      <td>https://m.weibo.cn/status/4463235401268457?</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <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>Austria</th>\n",
       "      <td>1081</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2/25/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Austria: 24,...</td>\n",
       "      <td>Innsbruck</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jakarta Post</td>\n",
       "      <td>https://www.thejakartapost.com/news/2020/02/25...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>1082</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/24/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Afghanistan:...</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fox News</td>\n",
       "      <td>https://www.foxnews.com/health/afghanistan-fir...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>1083</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/26/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Algeria: mal...</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>male</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>South China Morning Post</td>\n",
       "      <td>https://www.scmp.com/news/china/society/articl...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Croatia</th>\n",
       "      <td>1084</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/25/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Croatia: mal...</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>male</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Reuters</td>\n",
       "      <td>https://www.reuters.com/article/us-croatia-cor...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Switzerland</th>\n",
       "      <td>1085</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/25/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Switzerland:...</td>\n",
       "      <td>Bern</td>\n",
       "      <td>male</td>\n",
       "      <td>70.0</td>\n",
       "      <td>2/17/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Reuters</td>\n",
       "      <td>https://www.reuters.com/article/uk-switzerland...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1085 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               id  case_in_country reporting date  Unnamed: 3  \\\n",
       "country                                                         \n",
       "China           1              NaN      1/20/2020         NaN   \n",
       "China           2              NaN      1/20/2020         NaN   \n",
       "China           3              NaN      1/21/2020         NaN   \n",
       "China           4              NaN      1/21/2020         NaN   \n",
       "China           5              NaN      1/21/2020         NaN   \n",
       "...           ...              ...            ...         ...   \n",
       "Austria      1081              2.0      2/25/2020         NaN   \n",
       "Afghanistan  1082              1.0      2/24/2020         NaN   \n",
       "Algeria      1083              1.0      2/26/2020         NaN   \n",
       "Croatia      1084              1.0      2/25/2020         NaN   \n",
       "Switzerland  1085              1.0      2/25/2020         NaN   \n",
       "\n",
       "                                                       summary  \\\n",
       "country                                                          \n",
       "China        First confirmed imported COVID-19 pneumonia pa...   \n",
       "China        First confirmed imported COVID-19 pneumonia pa...   \n",
       "China        First confirmed imported cases in Zhejiang: pa...   \n",
       "China        new confirmed imported COVID-19 pneumonia in T...   \n",
       "China        new confirmed imported COVID-19 pneumonia in T...   \n",
       "...                                                        ...   \n",
       "Austria      new COVID-19 patient confirmed in Austria: 24,...   \n",
       "Afghanistan  new COVID-19 patient confirmed in Afghanistan:...   \n",
       "Algeria      new COVID-19 patient confirmed in Algeria: mal...   \n",
       "Croatia      new COVID-19 patient confirmed in Croatia: mal...   \n",
       "Switzerland  new COVID-19 patient confirmed in Switzerland:...   \n",
       "\n",
       "                        location  gender   age symptom_onset  \\\n",
       "country                                                        \n",
       "China        Shenzhen, Guangdong    male  66.0      01/03/20   \n",
       "China                   Shanghai  female  56.0     1/15/2020   \n",
       "China                   Zhejiang    male  46.0      01/04/20   \n",
       "China                    Tianjin  female  60.0           NaN   \n",
       "China                    Tianjin    male  58.0           NaN   \n",
       "...                          ...     ...   ...           ...   \n",
       "Austria                Innsbruck     NaN  24.0           NaN   \n",
       "Afghanistan          Afghanistan     NaN  35.0           NaN   \n",
       "Algeria                  Algeria    male   NaN           NaN   \n",
       "Croatia                  Croatia    male   NaN           NaN   \n",
       "Switzerland                 Bern    male  70.0     2/17/2020   \n",
       "\n",
       "             If_onset_approximated  ... recovered symptom  \\\n",
       "country                             ...                     \n",
       "China                          0.0  ...         0     NaN   \n",
       "China                          0.0  ...         0     NaN   \n",
       "China                          0.0  ...         0     NaN   \n",
       "China                          NaN  ...         0     NaN   \n",
       "China                          NaN  ...         0     NaN   \n",
       "...                            ...  ...       ...     ...   \n",
       "Austria                        NaN  ...         0     NaN   \n",
       "Afghanistan                    NaN  ...         0     NaN   \n",
       "Algeria                        NaN  ...         0     NaN   \n",
       "Croatia                        NaN  ...         0     NaN   \n",
       "Switzerland                    NaN  ...         0     NaN   \n",
       "\n",
       "                                                        source  \\\n",
       "country                                                          \n",
       "China                     Shenzhen Municipal Health Commission   \n",
       "China        Official Weibo of Shanghai Municipal Health Co...   \n",
       "China                   Health Commission of Zhejiang Province   \n",
       "China                                                 人民日报官方微博   \n",
       "China                                                 人民日报官方微博   \n",
       "...                                                        ...   \n",
       "Austria                                           Jakarta Post   \n",
       "Afghanistan                                           Fox News   \n",
       "Algeria                               South China Morning Post   \n",
       "Croatia                                                Reuters   \n",
       "Switzerland                                            Reuters   \n",
       "\n",
       "                                                          link  Unnamed: 21  \\\n",
       "country                                                                       \n",
       "China        http://wjw.sz.gov.cn/wzx/202001/t20200120_1898...          NaN   \n",
       "China        https://www.weibo.com/2372649470/IqogQhgfa?fro...          NaN   \n",
       "China        http://www.zjwjw.gov.cn/art/2020/1/21/art_1202...          NaN   \n",
       "China              https://m.weibo.cn/status/4463235401268457?          NaN   \n",
       "China              https://m.weibo.cn/status/4463235401268457?          NaN   \n",
       "...                                                        ...          ...   \n",
       "Austria      https://www.thejakartapost.com/news/2020/02/25...          NaN   \n",
       "Afghanistan  https://www.foxnews.com/health/afghanistan-fir...          NaN   \n",
       "Algeria      https://www.scmp.com/news/china/society/articl...          NaN   \n",
       "Croatia      https://www.reuters.com/article/us-croatia-cor...          NaN   \n",
       "Switzerland  https://www.reuters.com/article/uk-switzerland...          NaN   \n",
       "\n",
       "            Unnamed: 22 Unnamed: 23 Unnamed: 24 Unnamed: 25 Unnamed: 26  \n",
       "country                                                                  \n",
       "China               NaN         NaN         NaN         NaN         NaN  \n",
       "China               NaN         NaN         NaN         NaN         NaN  \n",
       "China               NaN         NaN         NaN         NaN         NaN  \n",
       "China               NaN         NaN         NaN         NaN         NaN  \n",
       "China               NaN         NaN         NaN         NaN         NaN  \n",
       "...                 ...         ...         ...         ...         ...  \n",
       "Austria             NaN         NaN         NaN         NaN         NaN  \n",
       "Afghanistan         NaN         NaN         NaN         NaN         NaN  \n",
       "Algeria             NaN         NaN         NaN         NaN         NaN  \n",
       "Croatia             NaN         NaN         NaN         NaN         NaN  \n",
       "Switzerland         NaN         NaN         NaN         NaN         NaN  \n",
       "\n",
       "[1085 rows x 26 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# make the passed column as index instead of 0, 1, 2, 3.... \n",
    "pd.read_csv(\"COVID19_line_list_data.csv\", index_col ='country') \n",
    "  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>country</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>China</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>China</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>China</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>China</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>China</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1080</th>\n",
       "      <td>Austria</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1081</th>\n",
       "      <td>Afghanistan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1082</th>\n",
       "      <td>Algeria</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1083</th>\n",
       "      <td>Croatia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1084</th>\n",
       "      <td>Switzerland</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1085 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          country\n",
       "0           China\n",
       "1           China\n",
       "2           China\n",
       "3           China\n",
       "4           China\n",
       "...           ...\n",
       "1080      Austria\n",
       "1081  Afghanistan\n",
       "1082      Algeria\n",
       "1083      Croatia\n",
       "1084  Switzerland\n",
       "\n",
       "[1085 rows x 1 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# uses passed cols only for data frame \n",
    "pd.read_csv(\"COVID19_line_list_data.csv\", usecols =[\"country\"]) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0             China\n",
       "1             China\n",
       "2             China\n",
       "3             China\n",
       "4             China\n",
       "           ...     \n",
       "1080        Austria\n",
       "1081    Afghanistan\n",
       "1082        Algeria\n",
       "1083        Croatia\n",
       "1084    Switzerland\n",
       "Name: country, Length: 1085, dtype: object"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# reutruns pandas series if there is only one colunmn \n",
    "pd.read_csv(\"COVID19_line_list_data.csv\", usecols =[\"country\"], squeeze = True) \n",
    "                                \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>id</th>\n",
       "      <th>case_in_country</th>\n",
       "      <th>reporting date</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>summary</th>\n",
       "      <th>location</th>\n",
       "      <th>country</th>\n",
       "      <th>gender</th>\n",
       "      <th>age</th>\n",
       "      <th>symptom_onset</th>\n",
       "      <th>...</th>\n",
       "      <th>recovered</th>\n",
       "      <th>symptom</th>\n",
       "      <th>source</th>\n",
       "      <th>link</th>\n",
       "      <th>Unnamed: 21</th>\n",
       "      <th>Unnamed: 22</th>\n",
       "      <th>Unnamed: 23</th>\n",
       "      <th>Unnamed: 24</th>\n",
       "      <th>Unnamed: 25</th>\n",
       "      <th>Unnamed: 26</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/21/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new confirmed imported COVID-19 pneumonia pati...</td>\n",
       "      <td>Beijing</td>\n",
       "      <td>China</td>\n",
       "      <td>male</td>\n",
       "      <td>56.0</td>\n",
       "      <td>1/16/2020</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Beijing Municipal Health Commission</td>\n",
       "      <td>http://wjw.beijing.gov.cn/xwzx_20031/wnxw/2020...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/21/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new confirmed imported COVID-19 pneumonia pati...</td>\n",
       "      <td>Beijing</td>\n",
       "      <td>China</td>\n",
       "      <td>female</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1/19/2020</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Beijing Municipal Health Commission</td>\n",
       "      <td>http://wjw.beijing.gov.cn/xwzx_20031/wnxw/2020...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/21/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new confirmed imported COVID-19 pneumonia pati...</td>\n",
       "      <td>Beijing</td>\n",
       "      <td>China</td>\n",
       "      <td>female</td>\n",
       "      <td>32.0</td>\n",
       "      <td>01/15/2020</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Beijing Municipal Health Commission</td>\n",
       "      <td>http://wjw.beijing.gov.cn/xwzx_20031/wnxw/2020...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/21/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>First confirmed imported COVID-19 pneumonia pa...</td>\n",
       "      <td>Shandong</td>\n",
       "      <td>China</td>\n",
       "      <td>male</td>\n",
       "      <td>37.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>央视新闻</td>\n",
       "      <td>https://m.weibo.cn/status/4463323540564718?</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1/21/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>First confirmed imported COVID-19 pneumonia pa...</td>\n",
       "      <td>Yunnan</td>\n",
       "      <td>China</td>\n",
       "      <td>male</td>\n",
       "      <td>51.0</td>\n",
       "      <td>1/16/2020</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>央视新闻</td>\n",
       "      <td>https://m.weibo.cn/status/4463321081961974?</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <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>1071</th>\n",
       "      <td>1081</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2/25/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Austria: 24,...</td>\n",
       "      <td>Innsbruck</td>\n",
       "      <td>Austria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jakarta Post</td>\n",
       "      <td>https://www.thejakartapost.com/news/2020/02/25...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1072</th>\n",
       "      <td>1082</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/24/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Afghanistan:...</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fox News</td>\n",
       "      <td>https://www.foxnews.com/health/afghanistan-fir...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1073</th>\n",
       "      <td>1083</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/26/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Algeria: mal...</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>male</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>South China Morning Post</td>\n",
       "      <td>https://www.scmp.com/news/china/society/articl...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1074</th>\n",
       "      <td>1084</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/25/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Croatia: mal...</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>male</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Reuters</td>\n",
       "      <td>https://www.reuters.com/article/us-croatia-cor...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1075</th>\n",
       "      <td>1085</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2/25/2020</td>\n",
       "      <td>NaN</td>\n",
       "      <td>new COVID-19 patient confirmed in Switzerland:...</td>\n",
       "      <td>Bern</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>male</td>\n",
       "      <td>70.0</td>\n",
       "      <td>2/17/2020</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Reuters</td>\n",
       "      <td>https://www.reuters.com/article/uk-switzerland...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1076 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        id  case_in_country reporting date  Unnamed: 3  \\\n",
       "0       10              NaN      1/21/2020         NaN   \n",
       "1       11              NaN      1/21/2020         NaN   \n",
       "2       12              NaN      1/21/2020         NaN   \n",
       "3       13              NaN      1/21/2020         NaN   \n",
       "4       14              NaN      1/21/2020         NaN   \n",
       "...    ...              ...            ...         ...   \n",
       "1071  1081              2.0      2/25/2020         NaN   \n",
       "1072  1082              1.0      2/24/2020         NaN   \n",
       "1073  1083              1.0      2/26/2020         NaN   \n",
       "1074  1084              1.0      2/25/2020         NaN   \n",
       "1075  1085              1.0      2/25/2020         NaN   \n",
       "\n",
       "                                                summary     location  \\\n",
       "0     new confirmed imported COVID-19 pneumonia pati...      Beijing   \n",
       "1     new confirmed imported COVID-19 pneumonia pati...      Beijing   \n",
       "2     new confirmed imported COVID-19 pneumonia pati...      Beijing   \n",
       "3     First confirmed imported COVID-19 pneumonia pa...     Shandong   \n",
       "4     First confirmed imported COVID-19 pneumonia pa...       Yunnan   \n",
       "...                                                 ...          ...   \n",
       "1071  new COVID-19 patient confirmed in Austria: 24,...    Innsbruck   \n",
       "1072  new COVID-19 patient confirmed in Afghanistan:...  Afghanistan   \n",
       "1073  new COVID-19 patient confirmed in Algeria: mal...      Algeria   \n",
       "1074  new COVID-19 patient confirmed in Croatia: mal...      Croatia   \n",
       "1075  new COVID-19 patient confirmed in Switzerland:...         Bern   \n",
       "\n",
       "          country  gender   age symptom_onset  ...  recovered symptom  \\\n",
       "0           China    male  56.0     1/16/2020  ...          0     NaN   \n",
       "1           China  female  18.0     1/19/2020  ...          0     NaN   \n",
       "2           China  female  32.0    01/15/2020  ...          0     NaN   \n",
       "3           China    male  37.0           NaN  ...          0     NaN   \n",
       "4           China    male  51.0     1/16/2020  ...          0     NaN   \n",
       "...           ...     ...   ...           ...  ...        ...     ...   \n",
       "1071      Austria     NaN  24.0           NaN  ...          0     NaN   \n",
       "1072  Afghanistan     NaN  35.0           NaN  ...          0     NaN   \n",
       "1073      Algeria    male   NaN           NaN  ...          0     NaN   \n",
       "1074      Croatia    male   NaN           NaN  ...          0     NaN   \n",
       "1075  Switzerland    male  70.0     2/17/2020  ...          0     NaN   \n",
       "\n",
       "                                   source  \\\n",
       "0     Beijing Municipal Health Commission   \n",
       "1     Beijing Municipal Health Commission   \n",
       "2     Beijing Municipal Health Commission   \n",
       "3                                    央视新闻   \n",
       "4                                    央视新闻   \n",
       "...                                   ...   \n",
       "1071                         Jakarta Post   \n",
       "1072                             Fox News   \n",
       "1073             South China Morning Post   \n",
       "1074                              Reuters   \n",
       "1075                              Reuters   \n",
       "\n",
       "                                                   link  Unnamed: 21  \\\n",
       "0     http://wjw.beijing.gov.cn/xwzx_20031/wnxw/2020...          NaN   \n",
       "1     http://wjw.beijing.gov.cn/xwzx_20031/wnxw/2020...          NaN   \n",
       "2     http://wjw.beijing.gov.cn/xwzx_20031/wnxw/2020...          NaN   \n",
       "3           https://m.weibo.cn/status/4463323540564718?          NaN   \n",
       "4           https://m.weibo.cn/status/4463321081961974?          NaN   \n",
       "...                                                 ...          ...   \n",
       "1071  https://www.thejakartapost.com/news/2020/02/25...          NaN   \n",
       "1072  https://www.foxnews.com/health/afghanistan-fir...          NaN   \n",
       "1073  https://www.scmp.com/news/china/society/articl...          NaN   \n",
       "1074  https://www.reuters.com/article/us-croatia-cor...          NaN   \n",
       "1075  https://www.reuters.com/article/uk-switzerland...          NaN   \n",
       "\n",
       "      Unnamed: 22 Unnamed: 23 Unnamed: 24 Unnamed: 25 Unnamed: 26  \n",
       "0             NaN         NaN         NaN         NaN         NaN  \n",
       "1             NaN         NaN         NaN         NaN         NaN  \n",
       "2             NaN         NaN         NaN         NaN         NaN  \n",
       "3             NaN         NaN         NaN         NaN         NaN  \n",
       "4             NaN         NaN         NaN         NaN         NaN  \n",
       "...           ...         ...         ...         ...         ...  \n",
       "1071          NaN         NaN         NaN         NaN         NaN  \n",
       "1072          NaN         NaN         NaN         NaN         NaN  \n",
       "1073          NaN         NaN         NaN         NaN         NaN  \n",
       "1074          NaN         NaN         NaN         NaN         NaN  \n",
       "1075          NaN         NaN         NaN         NaN         NaN  \n",
       "\n",
       "[1076 rows x 27 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# skips the passed rows in new series \n",
    "pd.read_csv(\"COVID19_line_list_data.csv\", skiprows = [1,2,3,4,5,6,7,8,9])"
   ]
  }
 ],
 "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.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}