python-tutorial/pandas_tutorial.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Pandas tutorial\n",
    "Thư viện pandas python - Hướng dẫn sử dụng thư viện pandas trong python cho người mới bắt đầu\n",
    "\n",
    "Đây là source code của bài học thư viện pandas của blog học lập trình cùng Nguyễn Văn Hiếu\n",
    "\n",
    "Xem chi tiết tại: https://nguyenvanhieu.vn/thu-vien-pandas-python"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Render our plots inline\n",
    "%matplotlib inline\n",
    "\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import random"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Đọc file csv"
   ]
  },
  {
   "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>person_ID</th>\n",
       "      <th>name</th>\n",
       "      <th>first</th>\n",
       "      <th>last</th>\n",
       "      <th>middle</th>\n",
       "      <th>email</th>\n",
       "      <th>phone</th>\n",
       "      <th>fax</th>\n",
       "      <th>title</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3130</td>\n",
       "      <td>Burks, Rosella</td>\n",
       "      <td>Rosella</td>\n",
       "      <td>Burks</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BurksR@univ.edu</td>\n",
       "      <td>963.555.1253</td>\n",
       "      <td>963.777.4065</td>\n",
       "      <td>Professor</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3297</td>\n",
       "      <td>Avila, Damien</td>\n",
       "      <td>Damien</td>\n",
       "      <td>Avila</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AvilaD@univ.edu</td>\n",
       "      <td>963.555.1352</td>\n",
       "      <td>963.777.7914</td>\n",
       "      <td>Professor</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3547</td>\n",
       "      <td>Olsen, Robin</td>\n",
       "      <td>Robin</td>\n",
       "      <td>Olsen</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OlsenR@univ.edu</td>\n",
       "      <td>963.555.1378</td>\n",
       "      <td>963.777.9262</td>\n",
       "      <td>Assistant Professor</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1538</td>\n",
       "      <td>Moises, Edgar Estes</td>\n",
       "      <td>Edgar</td>\n",
       "      <td>Moises</td>\n",
       "      <td>Estes</td>\n",
       "      <td>MoisesE@univ.edu</td>\n",
       "      <td>963.555.2731x3565</td>\n",
       "      <td>963.777.8264</td>\n",
       "      <td>Professor</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2941</td>\n",
       "      <td>Brian, Heath Pruitt</td>\n",
       "      <td>Heath</td>\n",
       "      <td>Brian</td>\n",
       "      <td>Pruitt</td>\n",
       "      <td>BrianH@univ.edu</td>\n",
       "      <td>963.555.2800</td>\n",
       "      <td>963.777.7249</td>\n",
       "      <td>Associate Curator</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   person_ID                 name    first    last  middle             email  \\\n",
       "0       3130      Burks, Rosella   Rosella   Burks     NaN   BurksR@univ.edu   \n",
       "1       3297       Avila, Damien    Damien   Avila     NaN   AvilaD@univ.edu   \n",
       "2       3547        Olsen, Robin     Robin   Olsen     NaN   OlsenR@univ.edu   \n",
       "3       1538  Moises, Edgar Estes    Edgar  Moises   Estes  MoisesE@univ.edu   \n",
       "4       2941  Brian, Heath Pruitt    Heath   Brian  Pruitt   BrianH@univ.edu   \n",
       "\n",
       "               phone           fax                title  age  \n",
       "0       963.555.1253  963.777.4065            Professor   25  \n",
       "1       963.555.1352  963.777.7914           Professor    23  \n",
       "2       963.555.1378  963.777.9262  Assistant Professor   21  \n",
       "3  963.555.2731x3565  963.777.8264            Professor   18  \n",
       "4       963.555.2800  963.777.7249   Associate Curator    30  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "peoples_df = pd.read_csv('./people.csv')\n",
    "peoples_df.head(5)"
   ]
  },
  {
   "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>person_ID</th>\n",
       "      <th>name</th>\n",
       "      <th>first</th>\n",
       "      <th>last</th>\n",
       "      <th>middle</th>\n",
       "      <th>email</th>\n",
       "      <th>phone</th>\n",
       "      <th>fax</th>\n",
       "      <th>title</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3130</td>\n",
       "      <td>Burks, Rosella</td>\n",
       "      <td>Rosella</td>\n",
       "      <td>Burks</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BurksR@univ.edu</td>\n",
       "      <td>963.555.1253</td>\n",
       "      <td>963.777.4065</td>\n",
       "      <td>Professor</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3297</td>\n",
       "      <td>Avila, Damien</td>\n",
       "      <td>Damien</td>\n",
       "      <td>Avila</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AvilaD@univ.edu</td>\n",
       "      <td>963.555.1352</td>\n",
       "      <td>963.777.7914</td>\n",
       "      <td>Professor</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3547</td>\n",
       "      <td>Olsen, Robin</td>\n",
       "      <td>Robin</td>\n",
       "      <td>Olsen</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OlsenR@univ.edu</td>\n",
       "      <td>963.555.1378</td>\n",
       "      <td>963.777.9262</td>\n",
       "      <td>Assistant Professor</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1538</td>\n",
       "      <td>Moises, Edgar Estes</td>\n",
       "      <td>Edgar</td>\n",
       "      <td>Moises</td>\n",
       "      <td>Estes</td>\n",
       "      <td>MoisesE@univ.edu</td>\n",
       "      <td>963.555.2731x3565</td>\n",
       "      <td>963.777.8264</td>\n",
       "      <td>Professor</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2941</td>\n",
       "      <td>Brian, Heath Pruitt</td>\n",
       "      <td>Heath</td>\n",
       "      <td>Brian</td>\n",
       "      <td>Pruitt</td>\n",
       "      <td>BrianH@univ.edu</td>\n",
       "      <td>963.555.2800</td>\n",
       "      <td>963.777.7249</td>\n",
       "      <td>Associate Curator</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   person_ID                 name    first    last  middle             email  \\\n",
       "0       3130      Burks, Rosella   Rosella   Burks     NaN   BurksR@univ.edu   \n",
       "1       3297       Avila, Damien    Damien   Avila     NaN   AvilaD@univ.edu   \n",
       "2       3547        Olsen, Robin     Robin   Olsen     NaN   OlsenR@univ.edu   \n",
       "3       1538  Moises, Edgar Estes    Edgar  Moises   Estes  MoisesE@univ.edu   \n",
       "4       2941  Brian, Heath Pruitt    Heath   Brian  Pruitt   BrianH@univ.edu   \n",
       "\n",
       "               phone           fax                title  age  \n",
       "0       963.555.1253  963.777.4065            Professor   25  \n",
       "1       963.555.1352  963.777.7914           Professor    23  \n",
       "2       963.555.1378  963.777.9262  Assistant Professor   21  \n",
       "3  963.555.2731x3565  963.777.8264            Professor   18  \n",
       "4       963.555.2800  963.777.7249   Associate Curator    30  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "peoples_df = pd.read_csv('./people.csv', encoding='utf-8', header='infer', sep=',')\n",
    "# Lấy 5 bản ghi đầu tiên\n",
    "peoples_df.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Len: 40\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 40 entries, 0 to 39\n",
      "Data columns (total 11 columns):\n",
      "person_ID    40 non-null int64\n",
      "name         40 non-null object\n",
      "first        40 non-null object\n",
      "last         40 non-null object\n",
      "middle       15 non-null object\n",
      "email        40 non-null object\n",
      "phone        40 non-null object\n",
      "fax          40 non-null object\n",
      "title        40 non-null object\n",
      "age          40 non-null int64\n",
      "is_young     40 non-null bool\n",
      "dtypes: bool(1), int64(2), object(8)\n",
      "memory usage: 3.2+ KB\n",
      "Shape: (40, 11)\n"
     ]
    }
   ],
   "source": [
    "# Xem thông tin dataframe vừa đọc được\n",
    "print('Len:', len(peoples_df))\n",
    "peoples_df.info()\n",
    "# Xem kích thước của dataframe\n",
    "print('Shape:', peoples_df.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     25\n",
       "1     23\n",
       "2     21\n",
       "3     18\n",
       "4     30\n",
       "5     35\n",
       "6     35\n",
       "7     35\n",
       "8     29\n",
       "9     29\n",
       "10    28\n",
       "11    23\n",
       "12    22\n",
       "13    22\n",
       "14    25\n",
       "15    24\n",
       "16    25\n",
       "17    25\n",
       "18    25\n",
       "19    25\n",
       "20    28\n",
       "21    28\n",
       "22    28\n",
       "23    28\n",
       "24    28\n",
       "25    25\n",
       "26    25\n",
       "27    25\n",
       "28    25\n",
       "29    25\n",
       "30    25\n",
       "31    25\n",
       "32    25\n",
       "33    25\n",
       "34    25\n",
       "35    25\n",
       "36    25\n",
       "37    25\n",
       "38    25\n",
       "39    25\n",
       "Name: age, dtype: int64"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Lấy một cột của dataframe\n",
    "peoples_df['age']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Lấy nhiều cột"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "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>name</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Burks, Rosella</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Avila, Damien</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Olsen, Robin</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Moises, Edgar Estes</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Brian, Heath Pruitt</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  name  age\n",
       "0      Burks, Rosella    25\n",
       "1       Avila, Damien    23\n",
       "2        Olsen, Robin    21\n",
       "3  Moises, Edgar Estes   18\n",
       "4  Brian, Heath Pruitt   30"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "peoples_df[['name', 'age']].head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "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>person_ID</th>\n",
       "      <th>name</th>\n",
       "      <th>first</th>\n",
       "      <th>last</th>\n",
       "      <th>middle</th>\n",
       "      <th>email</th>\n",
       "      <th>phone</th>\n",
       "      <th>fax</th>\n",
       "      <th>title</th>\n",
       "      <th>age</th>\n",
       "      <th>is_young</th>\n",
       "      <th>birthday</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3130</td>\n",
       "      <td>None</td>\n",
       "      <td>Rosella</td>\n",
       "      <td>Burks</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BurksR@univ.edu</td>\n",
       "      <td>963.555.1253</td>\n",
       "      <td>963.777.4065</td>\n",
       "      <td>Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>False</td>\n",
       "      <td>1985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3297</td>\n",
       "      <td>None</td>\n",
       "      <td>Damien</td>\n",
       "      <td>Avila</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AvilaD@univ.edu</td>\n",
       "      <td>963.555.1352</td>\n",
       "      <td>963.777.7914</td>\n",
       "      <td>Professor</td>\n",
       "      <td>23</td>\n",
       "      <td>True</td>\n",
       "      <td>1980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3547</td>\n",
       "      <td>None</td>\n",
       "      <td>Robin</td>\n",
       "      <td>Olsen</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OlsenR@univ.edu</td>\n",
       "      <td>963.555.1378</td>\n",
       "      <td>963.777.9262</td>\n",
       "      <td>Assistant Professor</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "      <td>1983</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1538</td>\n",
       "      <td>None</td>\n",
       "      <td>Edgar</td>\n",
       "      <td>Moises</td>\n",
       "      <td>Estes</td>\n",
       "      <td>MoisesE@univ.edu</td>\n",
       "      <td>963.555.2731x3565</td>\n",
       "      <td>963.777.8264</td>\n",
       "      <td>Professor</td>\n",
       "      <td>18</td>\n",
       "      <td>True</td>\n",
       "      <td>1984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2941</td>\n",
       "      <td>None</td>\n",
       "      <td>Heath</td>\n",
       "      <td>Brian</td>\n",
       "      <td>Pruitt</td>\n",
       "      <td>BrianH@univ.edu</td>\n",
       "      <td>963.555.2800</td>\n",
       "      <td>963.777.7249</td>\n",
       "      <td>Associate Curator</td>\n",
       "      <td>30</td>\n",
       "      <td>False</td>\n",
       "      <td>1997</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   person_ID  name    first    last  middle             email  \\\n",
       "0       3130  None  Rosella   Burks     NaN   BurksR@univ.edu   \n",
       "1       3297  None   Damien   Avila     NaN   AvilaD@univ.edu   \n",
       "2       3547  None    Robin   Olsen     NaN   OlsenR@univ.edu   \n",
       "3       1538  None    Edgar  Moises   Estes  MoisesE@univ.edu   \n",
       "4       2941  None    Heath   Brian  Pruitt   BrianH@univ.edu   \n",
       "\n",
       "               phone           fax                title  age  is_young  \\\n",
       "0       963.555.1253  963.777.4065            Professor   25     False   \n",
       "1       963.555.1352  963.777.7914           Professor    23      True   \n",
       "2       963.555.1378  963.777.9262  Assistant Professor   21      True   \n",
       "3  963.555.2731x3565  963.777.8264            Professor   18      True   \n",
       "4       963.555.2800  963.777.7249   Associate Curator    30     False   \n",
       "\n",
       "   birthday  \n",
       "0      1985  \n",
       "1      1980  \n",
       "2      1983  \n",
       "3      1984  \n",
       "4      1997  "
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Sử dụng slice để lấy các bản ghi\n",
    "peoples_df[0:5]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Kết hợp lấy nhiều cột và bản ghi"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "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>name</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>None</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>None</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>None</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>None</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>None</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   name  age\n",
       "0  None   25\n",
       "1  None   23\n",
       "2  None   21\n",
       "3  None   18\n",
       "4  None   30"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "peoples_df[['name', 'age']][:5]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Sử dụng kết hợp điều kiện"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "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>person_ID</th>\n",
       "      <th>name</th>\n",
       "      <th>first</th>\n",
       "      <th>last</th>\n",
       "      <th>middle</th>\n",
       "      <th>email</th>\n",
       "      <th>phone</th>\n",
       "      <th>fax</th>\n",
       "      <th>title</th>\n",
       "      <th>age</th>\n",
       "      <th>is_young</th>\n",
       "      <th>birthday</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3297</td>\n",
       "      <td>None</td>\n",
       "      <td>Damien</td>\n",
       "      <td>Avila</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AvilaD@univ.edu</td>\n",
       "      <td>963.555.1352</td>\n",
       "      <td>963.777.7914</td>\n",
       "      <td>Professor</td>\n",
       "      <td>23</td>\n",
       "      <td>True</td>\n",
       "      <td>1980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3547</td>\n",
       "      <td>None</td>\n",
       "      <td>Robin</td>\n",
       "      <td>Olsen</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OlsenR@univ.edu</td>\n",
       "      <td>963.555.1378</td>\n",
       "      <td>963.777.9262</td>\n",
       "      <td>Assistant Professor</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "      <td>1983</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1538</td>\n",
       "      <td>None</td>\n",
       "      <td>Edgar</td>\n",
       "      <td>Moises</td>\n",
       "      <td>Estes</td>\n",
       "      <td>MoisesE@univ.edu</td>\n",
       "      <td>963.555.2731x3565</td>\n",
       "      <td>963.777.8264</td>\n",
       "      <td>Professor</td>\n",
       "      <td>18</td>\n",
       "      <td>True</td>\n",
       "      <td>1984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2755</td>\n",
       "      <td>None</td>\n",
       "      <td>Reba</td>\n",
       "      <td>Kendrick</td>\n",
       "      <td>Alford</td>\n",
       "      <td>KendrickR@univ.edu</td>\n",
       "      <td>963.555.4618x7744</td>\n",
       "      <td>963.777.4371</td>\n",
       "      <td>Associate Curator</td>\n",
       "      <td>23</td>\n",
       "      <td>True</td>\n",
       "      <td>1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>4150</td>\n",
       "      <td>None</td>\n",
       "      <td>Angelina</td>\n",
       "      <td>Sims</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SimsA@univ.edu</td>\n",
       "      <td>963.555.5278</td>\n",
       "      <td>963.777.4400</td>\n",
       "      <td>Professor</td>\n",
       "      <td>22</td>\n",
       "      <td>True</td>\n",
       "      <td>1983</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    person_ID  name     first      last  middle               email  \\\n",
       "1        3297  None    Damien     Avila     NaN     AvilaD@univ.edu   \n",
       "2        3547  None     Robin     Olsen     NaN     OlsenR@univ.edu   \n",
       "3        1538  None     Edgar    Moises   Estes    MoisesE@univ.edu   \n",
       "11       2755  None      Reba  Kendrick  Alford  KendrickR@univ.edu   \n",
       "12       4150  None  Angelina      Sims     NaN      SimsA@univ.edu   \n",
       "\n",
       "                phone           fax                title  age  is_young  \\\n",
       "1        963.555.1352  963.777.7914           Professor    23      True   \n",
       "2        963.555.1378  963.777.9262  Assistant Professor   21      True   \n",
       "3   963.555.2731x3565  963.777.8264            Professor   18      True   \n",
       "11  963.555.4618x7744  963.777.4371   Associate Curator    23      True   \n",
       "12       963.555.5278  963.777.4400            Professor   22      True   \n",
       "\n",
       "    birthday  \n",
       "1       1980  \n",
       "2       1983  \n",
       "3       1984  \n",
       "11      1993  \n",
       "12      1983  "
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "young_pp = peoples_df[peoples_df['age'] < 25]\n",
    "young_pp[:5]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Thêm bản ghi dựa vào dữ liệu gốc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>person_ID</th>\n",
       "      <th>name</th>\n",
       "      <th>first</th>\n",
       "      <th>last</th>\n",
       "      <th>middle</th>\n",
       "      <th>email</th>\n",
       "      <th>phone</th>\n",
       "      <th>fax</th>\n",
       "      <th>title</th>\n",
       "      <th>age</th>\n",
       "      <th>is_young</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3130</td>\n",
       "      <td>Burks, Rosella</td>\n",
       "      <td>Rosella</td>\n",
       "      <td>Burks</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BurksR@univ.edu</td>\n",
       "      <td>963.555.1253</td>\n",
       "      <td>963.777.4065</td>\n",
       "      <td>Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3297</td>\n",
       "      <td>Avila, Damien</td>\n",
       "      <td>Damien</td>\n",
       "      <td>Avila</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AvilaD@univ.edu</td>\n",
       "      <td>963.555.1352</td>\n",
       "      <td>963.777.7914</td>\n",
       "      <td>Professor</td>\n",
       "      <td>23</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3547</td>\n",
       "      <td>Olsen, Robin</td>\n",
       "      <td>Robin</td>\n",
       "      <td>Olsen</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OlsenR@univ.edu</td>\n",
       "      <td>963.555.1378</td>\n",
       "      <td>963.777.9262</td>\n",
       "      <td>Assistant Professor</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1538</td>\n",
       "      <td>Moises, Edgar Estes</td>\n",
       "      <td>Edgar</td>\n",
       "      <td>Moises</td>\n",
       "      <td>Estes</td>\n",
       "      <td>MoisesE@univ.edu</td>\n",
       "      <td>963.555.2731x3565</td>\n",
       "      <td>963.777.8264</td>\n",
       "      <td>Professor</td>\n",
       "      <td>18</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2941</td>\n",
       "      <td>Brian, Heath Pruitt</td>\n",
       "      <td>Heath</td>\n",
       "      <td>Brian</td>\n",
       "      <td>Pruitt</td>\n",
       "      <td>BrianH@univ.edu</td>\n",
       "      <td>963.555.2800</td>\n",
       "      <td>963.777.7249</td>\n",
       "      <td>Associate Curator</td>\n",
       "      <td>30</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   person_ID                 name    first    last  middle             email  \\\n",
       "0       3130      Burks, Rosella   Rosella   Burks     NaN   BurksR@univ.edu   \n",
       "1       3297       Avila, Damien    Damien   Avila     NaN   AvilaD@univ.edu   \n",
       "2       3547        Olsen, Robin     Robin   Olsen     NaN   OlsenR@univ.edu   \n",
       "3       1538  Moises, Edgar Estes    Edgar  Moises   Estes  MoisesE@univ.edu   \n",
       "4       2941  Brian, Heath Pruitt    Heath   Brian  Pruitt   BrianH@univ.edu   \n",
       "\n",
       "               phone           fax                title  age  is_young  \n",
       "0       963.555.1253  963.777.4065            Professor   25     False  \n",
       "1       963.555.1352  963.777.7914           Professor    23      True  \n",
       "2       963.555.1378  963.777.9262  Assistant Professor   21      True  \n",
       "3  963.555.2731x3565  963.777.8264            Professor   18      True  \n",
       "4       963.555.2800  963.777.7249   Associate Curator    30     False  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "peoples_df['is_young'] = peoples_df['age'] < 25\n",
    "peoples_df.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Tìm kiếm bản ghi thỏa mãn điều kiện"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "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>person_ID</th>\n",
       "      <th>name</th>\n",
       "      <th>first</th>\n",
       "      <th>last</th>\n",
       "      <th>middle</th>\n",
       "      <th>email</th>\n",
       "      <th>phone</th>\n",
       "      <th>fax</th>\n",
       "      <th>title</th>\n",
       "      <th>age</th>\n",
       "      <th>is_young</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3130</td>\n",
       "      <td>Burks, Rosella</td>\n",
       "      <td>Rosella</td>\n",
       "      <td>Burks</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BurksR@univ.edu</td>\n",
       "      <td>963.555.1253</td>\n",
       "      <td>963.777.4065</td>\n",
       "      <td>Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1538</td>\n",
       "      <td>Moises, Edgar Estes</td>\n",
       "      <td>Edgar</td>\n",
       "      <td>Moises</td>\n",
       "      <td>Estes</td>\n",
       "      <td>MoisesE@univ.edu</td>\n",
       "      <td>963.555.2731x3565</td>\n",
       "      <td>963.777.8264</td>\n",
       "      <td>Professor</td>\n",
       "      <td>18</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1625</td>\n",
       "      <td>Hawkins, Callie</td>\n",
       "      <td>Callie</td>\n",
       "      <td>Hawkins</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HawkinsC@univ.edu</td>\n",
       "      <td>963.555.3350x6480</td>\n",
       "      <td>963.777.4949</td>\n",
       "      <td>Professor</td>\n",
       "      <td>29</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1307</td>\n",
       "      <td>Pate, Andrea</td>\n",
       "      <td>Andrea</td>\n",
       "      <td>Pate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PateA@univ.edu</td>\n",
       "      <td>963.555.3723</td>\n",
       "      <td>963.777.5049</td>\n",
       "      <td>Professor</td>\n",
       "      <td>29</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>4150</td>\n",
       "      <td>Sims, Angelina</td>\n",
       "      <td>Angelina</td>\n",
       "      <td>Sims</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SimsA@univ.edu</td>\n",
       "      <td>963.555.5278</td>\n",
       "      <td>963.777.4400</td>\n",
       "      <td>Professor</td>\n",
       "      <td>22</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    person_ID                 name     first     last middle  \\\n",
       "0        3130      Burks, Rosella    Rosella    Burks    NaN   \n",
       "3        1538  Moises, Edgar Estes     Edgar   Moises  Estes   \n",
       "8        1625     Hawkins, Callie     Callie  Hawkins    NaN   \n",
       "9        1307        Pate, Andrea     Andrea     Pate    NaN   \n",
       "12       4150      Sims, Angelina   Angelina     Sims    NaN   \n",
       "\n",
       "                email              phone           fax      title  age  \\\n",
       "0     BurksR@univ.edu       963.555.1253  963.777.4065  Professor   25   \n",
       "3    MoisesE@univ.edu  963.555.2731x3565  963.777.8264  Professor   18   \n",
       "8   HawkinsC@univ.edu  963.555.3350x6480  963.777.4949  Professor   29   \n",
       "9      PateA@univ.edu       963.555.3723  963.777.5049  Professor   29   \n",
       "12     SimsA@univ.edu       963.555.5278  963.777.4400  Professor   22   \n",
       "\n",
       "    is_young  \n",
       "0      False  \n",
       "3       True  \n",
       "8      False  \n",
       "9      False  \n",
       "12      True  "
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "professor = peoples_df[peoples_df.title == 'Professor']\n",
    "professor.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    None\n",
       "1    None\n",
       "2    None\n",
       "3    None\n",
       "4    None\n",
       "Name: name, dtype: object"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "name_compare = peoples_df['name'].str.contains('Rosella')\n",
    "name_compare.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Lấy giá trị của cột trả về numpy array"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Burks, Rosella ', 'Avila, Damien ', 'Olsen, Robin ',\n",
       "       'Moises, Edgar Estes', 'Brian, Heath Pruitt',\n",
       "       'Claude, Elvin Haney', 'Mosley, Edmund ', 'Derek, Antoine Mccoy',\n",
       "       'Hawkins, Callie ', 'Pate, Andrea ', 'Austin, Liz ',\n",
       "       'Kendrick, Reba Alford', 'Sims, Angelina ', 'Mullins, Kimberly ',\n",
       "       'Chuck, Lloyd Haney', 'Payne, Ladonna ',\n",
       "       'Baxter, Johnathan Browning', 'Weiss, Gilbert ',\n",
       "       'Deirdre, Florence Barrera', 'Fernando, Toby Calderon',\n",
       "       'Garrison, Patrica ', 'Effie, Leila Vinson', 'Buckley, Rose ',\n",
       "       'Stanton, Kathie ', 'Banks, Shannon ', 'Barnes, Cleo ',\n",
       "       'Brady, Nellie ', 'Katheryn, Ruben Holt', 'Michael, Dianne ',\n",
       "       'Grant, Adam ', 'Head, Kurtis ', 'Berger, Jami ',\n",
       "       'Earline, Jaime Fitzgerald', 'Evelyn, Summer Frost',\n",
       "       'Quentin, Sam Hyde', 'Dunlap, Ann ', 'Shields, Rich Pena',\n",
       "       'Page, Winnie ', 'Sparks, Ezra ', 'Kaufman, Elba '], dtype=object)"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "peoples_df['name'].values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "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>person_ID</th>\n",
       "      <th>name</th>\n",
       "      <th>first</th>\n",
       "      <th>last</th>\n",
       "      <th>middle</th>\n",
       "      <th>email</th>\n",
       "      <th>phone</th>\n",
       "      <th>fax</th>\n",
       "      <th>title</th>\n",
       "      <th>age</th>\n",
       "      <th>is_young</th>\n",
       "      <th>birthday</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>3903</td>\n",
       "      <td>None</td>\n",
       "      <td>Ann</td>\n",
       "      <td>Dunlap</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DunlapA@univ.edu</td>\n",
       "      <td>963.555.9067</td>\n",
       "      <td>963.777.4290</td>\n",
       "      <td>Assistant Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>False</td>\n",
       "      <td>1989</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>3095</td>\n",
       "      <td>None</td>\n",
       "      <td>Rich</td>\n",
       "      <td>Shields</td>\n",
       "      <td>Pena</td>\n",
       "      <td>ShieldsR@univ.edu</td>\n",
       "      <td>963.555.9197</td>\n",
       "      <td>963.777.7215</td>\n",
       "      <td>Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>False</td>\n",
       "      <td>1988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2383</td>\n",
       "      <td>None</td>\n",
       "      <td>Winnie</td>\n",
       "      <td>Page</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PageW@univ.edu</td>\n",
       "      <td>963.555.9366</td>\n",
       "      <td>963.777.3202</td>\n",
       "      <td>Curator</td>\n",
       "      <td>25</td>\n",
       "      <td>False</td>\n",
       "      <td>1999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2146</td>\n",
       "      <td>None</td>\n",
       "      <td>Ezra</td>\n",
       "      <td>Sparks</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SparksE@univ.edu</td>\n",
       "      <td>963.555.9390</td>\n",
       "      <td>963.777.9273</td>\n",
       "      <td>Assistant Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>False</td>\n",
       "      <td>1982</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>3958</td>\n",
       "      <td>None</td>\n",
       "      <td>Elba</td>\n",
       "      <td>Kaufman</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KaufmanE@univ.edu</td>\n",
       "      <td>963.555.9507</td>\n",
       "      <td>963.777.3298</td>\n",
       "      <td>Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>False</td>\n",
       "      <td>1989</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    person_ID  name   first     last middle              email         phone  \\\n",
       "35       3903  None     Ann   Dunlap    NaN   DunlapA@univ.edu  963.555.9067   \n",
       "36       3095  None    Rich  Shields   Pena  ShieldsR@univ.edu  963.555.9197   \n",
       "37       2383  None  Winnie     Page    NaN     PageW@univ.edu  963.555.9366   \n",
       "38       2146  None    Ezra   Sparks    NaN   SparksE@univ.edu  963.555.9390   \n",
       "39       3958  None    Elba  Kaufman    NaN  KaufmanE@univ.edu  963.555.9507   \n",
       "\n",
       "             fax                title  age  is_young  birthday  \n",
       "35  963.777.4290  Assistant Professor   25     False      1989  \n",
       "36  963.777.7215           Professor    25     False      1988  \n",
       "37  963.777.3202              Curator   25     False      1999  \n",
       "38  963.777.9273  Assistant Professor   25     False      1982  \n",
       "39  963.777.3298            Professor   25     False      1989  "
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_len = len(peoples_df)\n",
    "birthday = [random.randrange(1980, 2000, 1) for i in range(df_len)]\n",
    "peoples_df['birthday'] = birthday\n",
    "peoples_df.tail(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\ProgramData\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    },
    {
     "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>person_ID</th>\n",
       "      <th>name</th>\n",
       "      <th>first</th>\n",
       "      <th>last</th>\n",
       "      <th>middle</th>\n",
       "      <th>email</th>\n",
       "      <th>phone</th>\n",
       "      <th>fax</th>\n",
       "      <th>title</th>\n",
       "      <th>age</th>\n",
       "      <th>is_young</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3130</td>\n",
       "      <td>Hiếu</td>\n",
       "      <td>Rosella</td>\n",
       "      <td>Burks</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BurksR@univ.edu</td>\n",
       "      <td>963.555.1253</td>\n",
       "      <td>963.777.4065</td>\n",
       "      <td>Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3297</td>\n",
       "      <td>Avila, Damien</td>\n",
       "      <td>Damien</td>\n",
       "      <td>Avila</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AvilaD@univ.edu</td>\n",
       "      <td>963.555.1352</td>\n",
       "      <td>963.777.7914</td>\n",
       "      <td>Professor</td>\n",
       "      <td>23</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3547</td>\n",
       "      <td>Olsen, Robin</td>\n",
       "      <td>Robin</td>\n",
       "      <td>Olsen</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OlsenR@univ.edu</td>\n",
       "      <td>963.555.1378</td>\n",
       "      <td>963.777.9262</td>\n",
       "      <td>Assistant Professor</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1538</td>\n",
       "      <td>Moises, Edgar Estes</td>\n",
       "      <td>Edgar</td>\n",
       "      <td>Moises</td>\n",
       "      <td>Estes</td>\n",
       "      <td>MoisesE@univ.edu</td>\n",
       "      <td>963.555.2731x3565</td>\n",
       "      <td>963.777.8264</td>\n",
       "      <td>Professor</td>\n",
       "      <td>18</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   person_ID                 name    first    last middle             email  \\\n",
       "0       3130                 Hiếu  Rosella   Burks    NaN   BurksR@univ.edu   \n",
       "1       3297       Avila, Damien    Damien   Avila    NaN   AvilaD@univ.edu   \n",
       "2       3547        Olsen, Robin     Robin   Olsen    NaN   OlsenR@univ.edu   \n",
       "3       1538  Moises, Edgar Estes    Edgar  Moises  Estes  MoisesE@univ.edu   \n",
       "\n",
       "               phone           fax                title  age  is_young  \n",
       "0       963.555.1253  963.777.4065            Professor   25     False  \n",
       "1       963.555.1352  963.777.7914           Professor    23      True  \n",
       "2       963.555.1378  963.777.9262  Assistant Professor   21      True  \n",
       "3  963.555.2731x3565  963.777.8264            Professor   18      True  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "peoples_df['name'][0] = 'Hiếu'\n",
    "peoples_df.head(4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "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>person_ID</th>\n",
       "      <th>name</th>\n",
       "      <th>first</th>\n",
       "      <th>last</th>\n",
       "      <th>middle</th>\n",
       "      <th>email</th>\n",
       "      <th>phone</th>\n",
       "      <th>fax</th>\n",
       "      <th>title</th>\n",
       "      <th>age</th>\n",
       "      <th>new_column</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3130</td>\n",
       "      <td>Burks, Rosella</td>\n",
       "      <td>Rosella</td>\n",
       "      <td>Burks</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BurksR@univ.edu</td>\n",
       "      <td>963.555.1253</td>\n",
       "      <td>963.777.4065</td>\n",
       "      <td>Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3297</td>\n",
       "      <td>Avila, Damien</td>\n",
       "      <td>Damien</td>\n",
       "      <td>Avila</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AvilaD@univ.edu</td>\n",
       "      <td>963.555.1352</td>\n",
       "      <td>963.777.7914</td>\n",
       "      <td>Professor</td>\n",
       "      <td>23</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3547</td>\n",
       "      <td>Olsen, Robin</td>\n",
       "      <td>Robin</td>\n",
       "      <td>Olsen</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OlsenR@univ.edu</td>\n",
       "      <td>963.555.1378</td>\n",
       "      <td>963.777.9262</td>\n",
       "      <td>Assistant Professor</td>\n",
       "      <td>21</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1538</td>\n",
       "      <td>Moises, Edgar Estes</td>\n",
       "      <td>Edgar</td>\n",
       "      <td>Moises</td>\n",
       "      <td>Estes</td>\n",
       "      <td>MoisesE@univ.edu</td>\n",
       "      <td>963.555.2731x3565</td>\n",
       "      <td>963.777.8264</td>\n",
       "      <td>Professor</td>\n",
       "      <td>18</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2941</td>\n",
       "      <td>Brian, Heath Pruitt</td>\n",
       "      <td>Heath</td>\n",
       "      <td>Brian</td>\n",
       "      <td>Pruitt</td>\n",
       "      <td>BrianH@univ.edu</td>\n",
       "      <td>963.555.2800</td>\n",
       "      <td>963.777.7249</td>\n",
       "      <td>Associate Curator</td>\n",
       "      <td>30</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2401</td>\n",
       "      <td>Claude, Elvin Haney</td>\n",
       "      <td>Elvin</td>\n",
       "      <td>Claude</td>\n",
       "      <td>Haney</td>\n",
       "      <td>ClaudeE@univ.edu</td>\n",
       "      <td>963.555.2902</td>\n",
       "      <td>963.777.9730</td>\n",
       "      <td>Curator</td>\n",
       "      <td>35</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2070</td>\n",
       "      <td>Mosley, Edmund</td>\n",
       "      <td>Edmund</td>\n",
       "      <td>Mosley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MosleyE@univ.edu</td>\n",
       "      <td>963.555.2945</td>\n",
       "      <td>963.777.9285</td>\n",
       "      <td>Assistant Professor</td>\n",
       "      <td>35</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2561</td>\n",
       "      <td>Derek, Antoine Mccoy</td>\n",
       "      <td>Antoine</td>\n",
       "      <td>Derek</td>\n",
       "      <td>Mccoy</td>\n",
       "      <td>DerekA@univ.edu</td>\n",
       "      <td>963.555.2992</td>\n",
       "      <td>963.777.5454</td>\n",
       "      <td>Curator</td>\n",
       "      <td>35</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1625</td>\n",
       "      <td>Hawkins, Callie</td>\n",
       "      <td>Callie</td>\n",
       "      <td>Hawkins</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HawkinsC@univ.edu</td>\n",
       "      <td>963.555.3350x6480</td>\n",
       "      <td>963.777.4949</td>\n",
       "      <td>Professor</td>\n",
       "      <td>29</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1307</td>\n",
       "      <td>Pate, Andrea</td>\n",
       "      <td>Andrea</td>\n",
       "      <td>Pate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PateA@univ.edu</td>\n",
       "      <td>963.555.3723</td>\n",
       "      <td>963.777.5049</td>\n",
       "      <td>Professor</td>\n",
       "      <td>29</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2342</td>\n",
       "      <td>Austin, Liz</td>\n",
       "      <td>Liz</td>\n",
       "      <td>Austin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AustinL@univ.edu</td>\n",
       "      <td>963.555.4305</td>\n",
       "      <td>963.777.6143</td>\n",
       "      <td>Assistant Professor</td>\n",
       "      <td>28</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2755</td>\n",
       "      <td>Kendrick, Reba Alford</td>\n",
       "      <td>Reba</td>\n",
       "      <td>Kendrick</td>\n",
       "      <td>Alford</td>\n",
       "      <td>KendrickR@univ.edu</td>\n",
       "      <td>963.555.4618x7744</td>\n",
       "      <td>963.777.4371</td>\n",
       "      <td>Associate Curator</td>\n",
       "      <td>23</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>4150</td>\n",
       "      <td>Sims, Angelina</td>\n",
       "      <td>Angelina</td>\n",
       "      <td>Sims</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SimsA@univ.edu</td>\n",
       "      <td>963.555.5278</td>\n",
       "      <td>963.777.4400</td>\n",
       "      <td>Professor</td>\n",
       "      <td>22</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>3544</td>\n",
       "      <td>Mullins, Kimberly</td>\n",
       "      <td>Kimberly</td>\n",
       "      <td>Mullins</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MullinsK@univ.edu</td>\n",
       "      <td>963.555.5471x1017</td>\n",
       "      <td>963.777.9783</td>\n",
       "      <td>Assistant Professor</td>\n",
       "      <td>22</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2096</td>\n",
       "      <td>Chuck, Lloyd Haney</td>\n",
       "      <td>Lloyd</td>\n",
       "      <td>Chuck</td>\n",
       "      <td>Haney</td>\n",
       "      <td>ChuckL@univ.edu</td>\n",
       "      <td>963.555.5568x2652</td>\n",
       "      <td>963.777.9290</td>\n",
       "      <td>Assistant Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1089</td>\n",
       "      <td>Payne, Ladonna</td>\n",
       "      <td>Ladonna</td>\n",
       "      <td>Payne</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PayneL@univ.edu</td>\n",
       "      <td>963.555.5639</td>\n",
       "      <td>963.777.6469</td>\n",
       "      <td>Professor</td>\n",
       "      <td>24</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2948</td>\n",
       "      <td>Baxter, Johnathan Browning</td>\n",
       "      <td>Johnathan</td>\n",
       "      <td>Baxter</td>\n",
       "      <td>Browning</td>\n",
       "      <td>BaxterJ@univ.edu</td>\n",
       "      <td>963.555.5902</td>\n",
       "      <td>963.777.8336</td>\n",
       "      <td>Research Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>4539</td>\n",
       "      <td>Weiss, Gilbert</td>\n",
       "      <td>Gilbert</td>\n",
       "      <td>Weiss</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WeissG@univ.edu</td>\n",
       "      <td>963.555.5969</td>\n",
       "      <td>963.777.4975</td>\n",
       "      <td>Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2811</td>\n",
       "      <td>Deirdre, Florence Barrera</td>\n",
       "      <td>Florence</td>\n",
       "      <td>Deirdre</td>\n",
       "      <td>Barrera</td>\n",
       "      <td>DeirdreF@univ.edu</td>\n",
       "      <td>963.555.6319</td>\n",
       "      <td>963.777.9654</td>\n",
       "      <td>Associate Curator</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>4580</td>\n",
       "      <td>Fernando, Toby Calderon</td>\n",
       "      <td>Toby</td>\n",
       "      <td>Fernando</td>\n",
       "      <td>Calderon</td>\n",
       "      <td>FernandoT@univ.edu</td>\n",
       "      <td>963.555.6469</td>\n",
       "      <td>963.777.9864</td>\n",
       "      <td>Research Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2895</td>\n",
       "      <td>Garrison, Patrica</td>\n",
       "      <td>Patrica</td>\n",
       "      <td>Garrison</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GarrisonP@univ.edu</td>\n",
       "      <td>963.555.6760</td>\n",
       "      <td>963.777.4958</td>\n",
       "      <td>Associate Curator</td>\n",
       "      <td>28</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2254</td>\n",
       "      <td>Effie, Leila Vinson</td>\n",
       "      <td>Leila</td>\n",
       "      <td>Effie</td>\n",
       "      <td>Vinson</td>\n",
       "      <td>EffieL@univ.edu</td>\n",
       "      <td>963.555.6824</td>\n",
       "      <td>963.777.7299</td>\n",
       "      <td>Assistant Professor</td>\n",
       "      <td>28</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2389</td>\n",
       "      <td>Buckley, Rose</td>\n",
       "      <td>Rose</td>\n",
       "      <td>Buckley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BuckleyR@univ.edu</td>\n",
       "      <td>963.555.6855x5018</td>\n",
       "      <td>963.777.5233</td>\n",
       "      <td>Curator</td>\n",
       "      <td>28</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1699</td>\n",
       "      <td>Stanton, Kathie</td>\n",
       "      <td>Kathie</td>\n",
       "      <td>Stanton</td>\n",
       "      <td>NaN</td>\n",
       "      <td>StantonK@univ.edu</td>\n",
       "      <td>963.555.7095</td>\n",
       "      <td>963.777.1015</td>\n",
       "      <td>Professor</td>\n",
       "      <td>28</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1567</td>\n",
       "      <td>Banks, Shannon</td>\n",
       "      <td>Shannon</td>\n",
       "      <td>Banks</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BanksS@univ.edu</td>\n",
       "      <td>963.555.7198</td>\n",
       "      <td>963.777.6979</td>\n",
       "      <td>Professor</td>\n",
       "      <td>28</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>3066</td>\n",
       "      <td>Barnes, Cleo</td>\n",
       "      <td>Cleo</td>\n",
       "      <td>Barnes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BarnesC@univ.edu</td>\n",
       "      <td>963.555.7463x7335</td>\n",
       "      <td>963.777.1583</td>\n",
       "      <td>Research Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2426</td>\n",
       "      <td>Brady, Nellie</td>\n",
       "      <td>Nellie</td>\n",
       "      <td>Brady</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BradyN@univ.edu</td>\n",
       "      <td>963.555.7569</td>\n",
       "      <td>963.777.7218</td>\n",
       "      <td>Curator</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2217</td>\n",
       "      <td>Katheryn, Ruben Holt</td>\n",
       "      <td>Ruben</td>\n",
       "      <td>Katheryn</td>\n",
       "      <td>Holt</td>\n",
       "      <td>KatherynR@univ.edu</td>\n",
       "      <td>963.555.7578</td>\n",
       "      <td>963.777.3969</td>\n",
       "      <td>Assistant Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1968</td>\n",
       "      <td>Michael, Dianne</td>\n",
       "      <td>Dianne</td>\n",
       "      <td>Michael</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MichaelD@univ.edu</td>\n",
       "      <td>963.555.7592</td>\n",
       "      <td>963.777.9960</td>\n",
       "      <td>Assistant Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>3012</td>\n",
       "      <td>Grant, Adam</td>\n",
       "      <td>Adam</td>\n",
       "      <td>Grant</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GrantA@univ.edu</td>\n",
       "      <td>963.555.7775</td>\n",
       "      <td>963.777.8115</td>\n",
       "      <td>Research Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1824</td>\n",
       "      <td>Head, Kurtis</td>\n",
       "      <td>Kurtis</td>\n",
       "      <td>Head</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HeadK@univ.edu</td>\n",
       "      <td>963.555.7882</td>\n",
       "      <td>963.777.6348</td>\n",
       "      <td>Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>3929</td>\n",
       "      <td>Berger, Jami</td>\n",
       "      <td>Jami</td>\n",
       "      <td>Berger</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BergerJ@univ.edu</td>\n",
       "      <td>963.555.8158</td>\n",
       "      <td>963.777.5650</td>\n",
       "      <td>Research Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2682</td>\n",
       "      <td>Earline, Jaime Fitzgerald</td>\n",
       "      <td>Jaime</td>\n",
       "      <td>Earline</td>\n",
       "      <td>Fitzgerald</td>\n",
       "      <td>EarlineJ@univ.edu</td>\n",
       "      <td>963.555.8357</td>\n",
       "      <td>963.777.4114</td>\n",
       "      <td>Associate Curator</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>3112</td>\n",
       "      <td>Evelyn, Summer Frost</td>\n",
       "      <td>Summer</td>\n",
       "      <td>Evelyn</td>\n",
       "      <td>Frost</td>\n",
       "      <td>EvelynS@univ.edu</td>\n",
       "      <td>963.555.8895</td>\n",
       "      <td>963.777.5730</td>\n",
       "      <td>Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2303</td>\n",
       "      <td>Quentin, Sam Hyde</td>\n",
       "      <td>Sam</td>\n",
       "      <td>Quentin</td>\n",
       "      <td>Hyde</td>\n",
       "      <td>QuentinS@univ.edu</td>\n",
       "      <td>963.555.8921</td>\n",
       "      <td>963.777.2712</td>\n",
       "      <td>Assistant Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>3903</td>\n",
       "      <td>Dunlap, Ann</td>\n",
       "      <td>Ann</td>\n",
       "      <td>Dunlap</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DunlapA@univ.edu</td>\n",
       "      <td>963.555.9067</td>\n",
       "      <td>963.777.4290</td>\n",
       "      <td>Assistant Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>3095</td>\n",
       "      <td>Shields, Rich Pena</td>\n",
       "      <td>Rich</td>\n",
       "      <td>Shields</td>\n",
       "      <td>Pena</td>\n",
       "      <td>ShieldsR@univ.edu</td>\n",
       "      <td>963.555.9197</td>\n",
       "      <td>963.777.7215</td>\n",
       "      <td>Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2383</td>\n",
       "      <td>Page, Winnie</td>\n",
       "      <td>Winnie</td>\n",
       "      <td>Page</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PageW@univ.edu</td>\n",
       "      <td>963.555.9366</td>\n",
       "      <td>963.777.3202</td>\n",
       "      <td>Curator</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2146</td>\n",
       "      <td>Sparks, Ezra</td>\n",
       "      <td>Ezra</td>\n",
       "      <td>Sparks</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SparksE@univ.edu</td>\n",
       "      <td>963.555.9390</td>\n",
       "      <td>963.777.9273</td>\n",
       "      <td>Assistant Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>3958</td>\n",
       "      <td>Kaufman, Elba</td>\n",
       "      <td>Elba</td>\n",
       "      <td>Kaufman</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KaufmanE@univ.edu</td>\n",
       "      <td>963.555.9507</td>\n",
       "      <td>963.777.3298</td>\n",
       "      <td>Professor</td>\n",
       "      <td>25</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    person_ID                        name      first      last      middle  \\\n",
       "0        3130             Burks, Rosella     Rosella     Burks         NaN   \n",
       "1        3297              Avila, Damien      Damien     Avila         NaN   \n",
       "2        3547               Olsen, Robin       Robin     Olsen         NaN   \n",
       "3        1538         Moises, Edgar Estes      Edgar    Moises       Estes   \n",
       "4        2941         Brian, Heath Pruitt      Heath     Brian      Pruitt   \n",
       "5        2401         Claude, Elvin Haney      Elvin    Claude       Haney   \n",
       "6        2070             Mosley, Edmund      Edmund    Mosley         NaN   \n",
       "7        2561        Derek, Antoine Mccoy    Antoine     Derek       Mccoy   \n",
       "8        1625            Hawkins, Callie      Callie   Hawkins         NaN   \n",
       "9        1307               Pate, Andrea      Andrea      Pate         NaN   \n",
       "10       2342                Austin, Liz         Liz    Austin         NaN   \n",
       "11       2755       Kendrick, Reba Alford       Reba  Kendrick      Alford   \n",
       "12       4150             Sims, Angelina    Angelina      Sims         NaN   \n",
       "13       3544          Mullins, Kimberly    Kimberly   Mullins         NaN   \n",
       "14       2096          Chuck, Lloyd Haney      Lloyd     Chuck       Haney   \n",
       "15       1089             Payne, Ladonna     Ladonna     Payne         NaN   \n",
       "16       2948  Baxter, Johnathan Browning  Johnathan    Baxter    Browning   \n",
       "17       4539             Weiss, Gilbert     Gilbert     Weiss         NaN   \n",
       "18       2811   Deirdre, Florence Barrera   Florence   Deirdre     Barrera   \n",
       "19       4580     Fernando, Toby Calderon       Toby  Fernando    Calderon   \n",
       "20       2895          Garrison, Patrica     Patrica  Garrison         NaN   \n",
       "21       2254         Effie, Leila Vinson      Leila     Effie      Vinson   \n",
       "22       2389              Buckley, Rose        Rose   Buckley         NaN   \n",
       "23       1699            Stanton, Kathie      Kathie   Stanton         NaN   \n",
       "24       1567             Banks, Shannon     Shannon     Banks         NaN   \n",
       "25       3066               Barnes, Cleo        Cleo    Barnes         NaN   \n",
       "26       2426              Brady, Nellie      Nellie     Brady         NaN   \n",
       "27       2217        Katheryn, Ruben Holt      Ruben  Katheryn        Holt   \n",
       "28       1968            Michael, Dianne      Dianne   Michael         NaN   \n",
       "29       3012                Grant, Adam        Adam     Grant         NaN   \n",
       "30       1824               Head, Kurtis      Kurtis      Head         NaN   \n",
       "31       3929               Berger, Jami        Jami    Berger         NaN   \n",
       "32       2682   Earline, Jaime Fitzgerald      Jaime   Earline  Fitzgerald   \n",
       "33       3112        Evelyn, Summer Frost     Summer    Evelyn       Frost   \n",
       "34       2303           Quentin, Sam Hyde        Sam   Quentin        Hyde   \n",
       "35       3903                Dunlap, Ann         Ann    Dunlap         NaN   \n",
       "36       3095          Shields, Rich Pena       Rich   Shields        Pena   \n",
       "37       2383               Page, Winnie      Winnie      Page         NaN   \n",
       "38       2146               Sparks, Ezra        Ezra    Sparks         NaN   \n",
       "39       3958              Kaufman, Elba        Elba   Kaufman         NaN   \n",
       "\n",
       "                 email              phone           fax                title  \\\n",
       "0      BurksR@univ.edu       963.555.1253  963.777.4065            Professor   \n",
       "1      AvilaD@univ.edu       963.555.1352  963.777.7914           Professor    \n",
       "2      OlsenR@univ.edu       963.555.1378  963.777.9262  Assistant Professor   \n",
       "3     MoisesE@univ.edu  963.555.2731x3565  963.777.8264            Professor   \n",
       "4      BrianH@univ.edu       963.555.2800  963.777.7249   Associate Curator    \n",
       "5     ClaudeE@univ.edu       963.555.2902  963.777.9730              Curator   \n",
       "6     MosleyE@univ.edu       963.555.2945  963.777.9285  Assistant Professor   \n",
       "7      DerekA@univ.edu       963.555.2992  963.777.5454              Curator   \n",
       "8    HawkinsC@univ.edu  963.555.3350x6480  963.777.4949            Professor   \n",
       "9       PateA@univ.edu       963.555.3723  963.777.5049            Professor   \n",
       "10    AustinL@univ.edu       963.555.4305  963.777.6143  Assistant Professor   \n",
       "11  KendrickR@univ.edu  963.555.4618x7744  963.777.4371   Associate Curator    \n",
       "12      SimsA@univ.edu       963.555.5278  963.777.4400            Professor   \n",
       "13   MullinsK@univ.edu  963.555.5471x1017  963.777.9783  Assistant Professor   \n",
       "14     ChuckL@univ.edu  963.555.5568x2652  963.777.9290  Assistant Professor   \n",
       "15     PayneL@univ.edu       963.555.5639  963.777.6469            Professor   \n",
       "16    BaxterJ@univ.edu       963.555.5902  963.777.8336   Research Professor   \n",
       "17     WeissG@univ.edu       963.555.5969  963.777.4975            Professor   \n",
       "18   DeirdreF@univ.edu       963.555.6319  963.777.9654   Associate Curator    \n",
       "19  FernandoT@univ.edu       963.555.6469  963.777.9864   Research Professor   \n",
       "20  GarrisonP@univ.edu       963.555.6760  963.777.4958   Associate Curator    \n",
       "21     EffieL@univ.edu       963.555.6824  963.777.7299  Assistant Professor   \n",
       "22   BuckleyR@univ.edu  963.555.6855x5018  963.777.5233              Curator   \n",
       "23   StantonK@univ.edu       963.555.7095  963.777.1015            Professor   \n",
       "24     BanksS@univ.edu       963.555.7198  963.777.6979            Professor   \n",
       "25    BarnesC@univ.edu  963.555.7463x7335  963.777.1583   Research Professor   \n",
       "26     BradyN@univ.edu       963.555.7569  963.777.7218              Curator   \n",
       "27  KatherynR@univ.edu       963.555.7578  963.777.3969  Assistant Professor   \n",
       "28   MichaelD@univ.edu       963.555.7592  963.777.9960  Assistant Professor   \n",
       "29     GrantA@univ.edu       963.555.7775  963.777.8115   Research Professor   \n",
       "30      HeadK@univ.edu       963.555.7882  963.777.6348            Professor   \n",
       "31    BergerJ@univ.edu       963.555.8158  963.777.5650   Research Professor   \n",
       "32   EarlineJ@univ.edu       963.555.8357  963.777.4114   Associate Curator    \n",
       "33    EvelynS@univ.edu       963.555.8895  963.777.5730           Professor    \n",
       "34   QuentinS@univ.edu       963.555.8921  963.777.2712  Assistant Professor   \n",
       "35    DunlapA@univ.edu       963.555.9067  963.777.4290  Assistant Professor   \n",
       "36   ShieldsR@univ.edu       963.555.9197  963.777.7215           Professor    \n",
       "37      PageW@univ.edu       963.555.9366  963.777.3202              Curator   \n",
       "38    SparksE@univ.edu       963.555.9390  963.777.9273  Assistant Professor   \n",
       "39   KaufmanE@univ.edu       963.555.9507  963.777.3298            Professor   \n",
       "\n",
       "    age new_column  \n",
       "0    25       None  \n",
       "1    23       None  \n",
       "2    21       None  \n",
       "3    18       None  \n",
       "4    30       None  \n",
       "5    35       None  \n",
       "6    35       None  \n",
       "7    35       None  \n",
       "8    29       None  \n",
       "9    29       None  \n",
       "10   28       None  \n",
       "11   23       None  \n",
       "12   22       None  \n",
       "13   22       None  \n",
       "14   25       None  \n",
       "15   24       None  \n",
       "16   25       None  \n",
       "17   25       None  \n",
       "18   25       None  \n",
       "19   25       None  \n",
       "20   28       None  \n",
       "21   28       None  \n",
       "22   28       None  \n",
       "23   28       None  \n",
       "24   28       None  \n",
       "25   25       None  \n",
       "26   25       None  \n",
       "27   25       None  \n",
       "28   25       None  \n",
       "29   25       None  \n",
       "30   25       None  \n",
       "31   25       None  \n",
       "32   25       None  \n",
       "33   25       None  \n",
       "34   25       None  \n",
       "35   25       None  \n",
       "36   25       None  \n",
       "37   25       None  \n",
       "38   25       None  \n",
       "39   25       None  "
      ]
     },
     "execution_count": 105,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "peoples_df['new_column'] = None\n",
    "peoples_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Hiểu dữ liệu trong df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "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>person_ID</th>\n",
       "      <th>age</th>\n",
       "      <th>birthday</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>40.000000</td>\n",
       "      <td>40.000000</td>\n",
       "      <td>40.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2702.475000</td>\n",
       "      <td>25.975000</td>\n",
       "      <td>1989.825000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>863.183434</td>\n",
       "      <td>3.452888</td>\n",
       "      <td>6.254793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1089.000000</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>1980.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2133.500000</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>1985.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2621.500000</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>1989.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>3116.500000</td>\n",
       "      <td>28.000000</td>\n",
       "      <td>1995.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>4580.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>1999.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         person_ID        age     birthday\n",
       "count    40.000000  40.000000    40.000000\n",
       "mean   2702.475000  25.975000  1989.825000\n",
       "std     863.183434   3.452888     6.254793\n",
       "min    1089.000000  18.000000  1980.000000\n",
       "25%    2133.500000  25.000000  1985.500000\n",
       "50%    2621.500000  25.000000  1989.000000\n",
       "75%    3116.500000  28.000000  1995.500000\n",
       "max    4580.000000  35.000000  1999.000000"
      ]
     },
     "execution_count": 100,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "peoples_df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "25    21\n",
       "28     6\n",
       "35     3\n",
       "29     2\n",
       "23     2\n",
       "22     2\n",
       "30     1\n",
       "24     1\n",
       "21     1\n",
       "18     1\n",
       "Name: age, dtype: int64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Xem phân bố dữ liệu của thuộc tính 'age'\n",
    "peoples_df['age'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1c7974eaa90>"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX4AAAD/CAYAAAD2Qb01AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvhp/UCwAAFGRJREFUeJzt3X+wZGV95/H3R0BrIyi/Lj9kGCdrCIHEgO4t0GKzQQg4sCSwlkZwS0miO2Kpq1m3akm0hDK7G01irNrASo0yARNFdzUoGwGdRWqRrAgDGX4FkB+LYRyEURBkNTEj3/2jz6w3175zL3369u3xeb+quvqc5zznPN85t+dzzz3dfU6qCklSO5610gVIkibL4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTEGvyQ1xuCXpMbsvtIFDLP//vvXmjVrVroMSdpl3Hzzzd+qqpml9J3K4F+zZg2bNm1a6TIkaZeR5OtL7eupHklqjMEvSY0x+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjpvILXItZc+7ne2/jwff/yzFUIkm7Ho/4JakxBr8kNcbgl6TGGPyS1BiDX5Ias2jwJzk0ybVJ7kpyZ5J3dO37JtmY5N7ueZ8F1j+763NvkrPH/Q+QJD0zSzni3w68q6qOAF4GvDXJkcC5wDVVdRhwTTf/jyTZFzgPOBY4BjhvoV8QkqTJWDT4q+rhqrqlm/4ucBdwCHA6cGnX7VLgjCGrvxLYWFWPVdXjwEZg7TgKlySN5hmd40+yBngJ8FXgwKp6GAa/HIADhqxyCPDQnPktXZskaYUsOfiT7Al8BnhnVT251NWGtNUC21+XZFOSTdu2bVtqWZKkZ2hJwZ9kDwah//Gq+ouu+ZEkB3fLDwYeHbLqFuDQOfOrgK3Dxqiq9VU1W1WzMzNLul+wJGkES/lUT4CLgbuq6o/nLLoC2PEpnbOBzw1Z/QvAyUn26d7UPblrkyStkKUc8R8HvB44Icnm7nEq8H7gpCT3Aid18ySZTfJRgKp6DPg94Kbu8b6uTZK0Qha9OmdVXc/wc/UAJw7pvwl405z5DcCGUQuUJI2X39yVpMYY/JLUGINfkhpj8EtSYwx+SWqMwS9JjTH4JakxBr8kNcbgl6TGGPyS1BiDX5IaY/BLUmMMfklqjMEvSY0x+CWpMQa/JDVm0RuxJNkAnAY8WlW/0LV9Cji867I38J2qOnrIug8C3wV+CGyvqtkx1S1JGtGiwQ9cAlwAfGxHQ1W9dsd0kg8CT+xk/VdU1bdGLVCSNF5LufXidUnWDFvW3Yj914ETxluWJGm59D3H/0vAI1V17wLLC/hikpuTrNvZhpKsS7IpyaZt27b1LEuStJC+wX8WcNlOlh9XVS8FTgHemuRfLNSxqtZX1WxVzc7MzPQsS5K0kJGDP8nuwKuATy3Up6q2ds+PApcDx4w6niRpPPoc8f8KcHdVbRm2MMlzk+y1Yxo4Gbijx3iSpDFYNPiTXAZ8BTg8yZYkb+wWncm80zxJXpDkym72QOD6JLcCNwKfr6qrx1e6JGkUS/lUz1kLtP/GkLatwKnd9APAUT3rkySNmd/claTGGPyS1BiDX5IaY/BLUmMMfklqjMEvSY0x+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTFLuRHLhiSPJrljTtv5Sb6RZHP3OHWBddcmuSfJfUnOHWfhkqTRLOWI/xJg7ZD2D1XV0d3jyvkLk+wGXMjgRutHAmclObJPsZKk/hYN/qq6DnhshG0fA9xXVQ9U1Q+ATwKnj7AdSdIY9TnH/7Ykt3WngvYZsvwQ4KE581u6NknSCho1+D8MvAg4GngY+OCQPhnSVgttMMm6JJuSbNq2bduIZUmSFjNS8FfVI1X1w6p6GvgIg9M6820BDp0zvwrYupNtrq+q2aqanZmZGaUsSdISjBT8SQ6eM/uvgDuGdLsJOCzJTyd5NnAmcMUo40mSxmf3xTokuQw4Htg/yRbgPOD4JEczOHXzIPDmru8LgI9W1alVtT3J24AvALsBG6rqzmX5V0iSlmzR4K+qs4Y0X7xA363AqXPmrwR+7KOekqSV4zd3JakxBr8kNcbgl6TGGPyS1BiDX5IaY/BLUmMMfklqjMEvSY0x+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNWTT4k2xI8miSO+a0/WGSu5PcluTyJHsvsO6DSW5PsjnJpnEWLkkazVKO+C8B1s5r2wj8QlX9IvA14Hd2sv4rquroqpodrURJ0jgtGvxVdR3w2Ly2L1bV9m72BmDVMtQmSVoG4zjH/1vAVQssK+CLSW5Osm4MY0mSelr0Zus7k+TdwHbg4wt0Oa6qtiY5ANiY5O7uL4hh21oHrANYvXp1n7IkSTsx8hF/krOB04B/XVU1rE9Vbe2eHwUuB45ZaHtVtb6qZqtqdmZmZtSyJEmLGCn4k6wF/gPwa1X1vQX6PDfJXjumgZOBO4b1lSRNzlI+znkZ8BXg8CRbkrwRuADYi8Hpm81JLur6viDJld2qBwLXJ7kVuBH4fFVdvSz/CknSki16jr+qzhrSfPECfbcCp3bTDwBH9apOkjR2fnNXkhpj8EtSYwx+SWqMwS9JjTH4JakxBr8kNcbgl6TGGPyS1BiDX5IaY/BLUmMMfklqjMEvSY0x+CWpMQa/JDXG4Jekxhj8ktSYJQV/kg1JHk1yx5y2fZNsTHJv97zPAuue3fW5t7tPryRpBS31iP8SYO28tnOBa6rqMOCabv4fSbIvcB5wLIMbrZ+30C8ISdJkLCn4q+o64LF5zacDl3bTlwJnDFn1lcDGqnqsqh4HNvLjv0AkSRPU5xz/gVX1MED3fMCQPocAD82Z39K1/Zgk65JsSrJp27ZtPcqSJO3Mcr+5myFtNaxjVa2vqtmqmp2ZmVnmsiSpXX2C/5EkBwN0z48O6bMFOHTO/Cpga48xJUk99Qn+K4Adn9I5G/jckD5fAE5Osk/3pu7JXZskaYUs9eOclwFfAQ5PsiXJG4H3AycluRc4qZsnyWySjwJU1WPA7wE3dY/3dW2SpBWy+1I6VdVZCyw6cUjfTcCb5sxvADaMVJ0kaez85q4kNcbgl6TGGPyS1BiDX5IaY/BLUmMMfklqjMEvSY0x+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNGTn4kxyeZPOcx5NJ3jmvz/FJnpjT5739S5Yk9bGkG7EMU1X3AEcDJNkN+AZw+ZCuX66q00YdR5I0XuM61XMicH9VfX1M25MkLZNxBf+ZwGULLHt5kluTXJXk58c0niRpRL2DP8mzgV8D/vuQxbcAL6yqo4A/AT67k+2sS7IpyaZt27b1LUuStIBxHPGfAtxSVY/MX1BVT1bVU930lcAeSfYftpGqWl9Vs1U1OzMzM4ayJEnDjCP4z2KB0zxJDkqSbvqYbrxvj2FMSdKIRv5UD0CSnwJOAt48p+0cgKq6CHg18JYk24HvA2dWVfUZU5LUT6/gr6rvAfvNa7tozvQFwAV9xpAkjZff3JWkxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTEGvyQ1xuCXpMYY/JLUmF6XbGja+c8fwzae6L8NSXqGPOKXpMYY/JLUGINfkhpj8EtSYwx+SWrMOG62/mCS25NsTrJpyPIk+S9J7ktyW5KX9h1TkjS6cX2c8xVV9a0Flp0CHNY9jgU+3D1LklbAJE71nA58rAZuAPZOcvAExpUkDTGO4C/gi0luTrJuyPJDgIfmzG/p2iRJK2Acp3qOq6qtSQ4ANia5u6qum7M8Q9ap+Q3dL411AKtXrx5DWZKkYXof8VfV1u75UeBy4Jh5XbYAh86ZXwVsHbKd9VU1W1WzMzMzfcuSJC2gV/AneW6SvXZMAycDd8zrdgXwhu7TPS8Dnqiqh/uMK0kaXd9TPQcClyfZsa1PVNXVSc4BqKqLgCuBU4H7gO8Bv9lzTElSD72Cv6oeAI4a0n7RnOkC3tpnHEnS+PjNXUlqjMEvSY0x+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTEGvyQ1xuCXpMYY/JLUmHHcelEr6MWXvrj3Nm4/+/YxVCJpVzHyEX+SQ5Ncm+SuJHcmeceQPscneSLJ5u7x3n7lSpL66nPEvx14V1Xd0t1+8eYkG6vqb+b1+3JVndZjHEnSGI18xF9VD1fVLd30d4G7gEPGVZgkaXmM5c3dJGuAlwBfHbL45UluTXJVkp8fx3iSpNH1fnM3yZ7AZ4B3VtWT8xbfArywqp5KcirwWeCwBbazDlgHsHr16r5lSZIW0OuIP8keDEL/41X1F/OXV9WTVfVUN30lsEeS/Ydtq6rWV9VsVc3OzMz0KUuStBN9PtUT4GLgrqr64wX6HNT1I8kx3XjfHnVMSVJ/fU71HAe8Hrg9yeau7XeB1QBVdRHwauAtSbYD3wfOrKrqMaYkqaeRg7+qrgeySJ8LgAtGHUOSNH5+c1e93fVzR/TexhF339V7Gxee86Xe23jrRSf0Wv+Dr+3/lZV3feove29D2hmv1SNJjTH4JakxBr8kNcbgl6TGGPyS1BiDX5IaY/BLUmMMfklqjMEvSY3xm7vST6At53659zZWvf+Xeq1//vnn965hHNu45ksv6r2NE0+4v9f6B127efFOi/jmK47uvY0dPOKXpMYY/JLUGINfkhpj8EtSYwx+SWpM33vurk1yT5L7kpw7ZPlzknyqW/7VJGv6jCdJ6q/PPXd3Ay4ETgGOBM5KcuS8bm8EHq+qnwE+BHxg1PEkSePR54j/GOC+qnqgqn4AfBI4fV6f04FLu+lPAyfuuPm6JGll9An+Q4CH5sxv6dqG9qmq7cATwH49xpQk9ZSqGm3F5DXAK6vqTd3864Fjqurtc/rc2fXZ0s3f3/X59pDtrQPWdbOHA/eMVNjA/sC3eqw/LtNQxzTUANNRxzTUANNRxzTUANNRxzTUAP3reGFVzSylY59LNmwBDp0zvwrYukCfLUl2B54PPDZsY1W1Hljfo57/L8mmqpodx7Z29TqmoYZpqWMaapiWOqahhmmpYxpqmHQdfU713AQcluSnkzwbOBO4Yl6fK4Czu+lXA1+qUf/EkCSNxchH/FW1PcnbgC8AuwEbqurOJO8DNlXVFcDFwJ8luY/Bkf6Z4yhakjS6XlfnrKorgSvntb13zvTfAa/pM8aIxnLKaAymoY5pqAGmo45pqAGmo45pqAGmo45pqAEmWMfIb+5KknZNXrJBkhpj8EtSYwx+SWqMwS9pRSQ5YKVraNUuH/xJ1s6Zfn6Si5PcluQTSQ6cYB2zSa5N8udJDk2yMckTSW5K8pIJ1fCLc6b3SPKeJFck+c9JfmoSNXRj75nkfUnu7PbBtiQ3JPmNCdZwUJIPJ7kwyX5Jzk9ye5L/luTgCdXwvCS/n+TPkrxu3rL/OokaurF2T/LmJFd3/zduTXJVknOS7DGhGvad99gPuDHJPkn2nUQNi0ly1UrXMCm7/Kd6ktxSVS/tpj8KfBP4CPAq4Jer6owJ1XEjcB6wN/AHwG9X1aeTnAj8x6p6+QRqmLsvPsjgukh/CpwB7FdVb1juGrqxPwdcDvxP4NeB5zK4iN97gG9U1e9OoIargc93Y78O+DhwGYMLB/5KVc2/oOBy1PAZ4F7gBuC3gH8AXldVfz/3ZzWBOi4DvsPggolbuuZVDL5cuW9VvXYCNTwNfH1e86qunqqqf7rcNXR1LLTPA/xlVU3qoGAW+EPgG8DvABsYXPjya8C6qvrrZS2gqnbpB3DLnOnN85ZtnmAdfz1n+m8XWjbBGjYDe3TTAW6b4L64dd78Td3zs4C7p+DnMZHXxZDX47uBv2LwC/mWSdTQjXvPTpZ9bUI1/HvgauDFc9r+z6T2wZwxfwh8Cbh2yOP7E6zjRgaXtD+LwYUsX921nwh8ZbnH7/UFrilxQJJ/xyDcnpck1e1BJnsq6++SnMzgekSV5Iyq+mySX2bwYpuE5yd5FYN98Zyq+gcYHE4lmeSfdv83yT+vquuT/Crd9Zmq6ukJXpZ77s/+Y/OW7TahGp6T5FlV9TRAVf2nJFuA64A9J1QDwOPdRRU/s6OWJM9i8OXKxydRQFX9UZJPAh9K8hCDv45X4nTDXcCbq+re+Qu6uiZlj6q6qhv3A1X1aYCquibJHy334D8Jwf8RYK9u+lIGV7jbluQgBke9k3IOg1M8TwOvBN6S5BIGf8r9mwnV8L+AX+2mb0hyYFU90u2LSV598C3AR5L8LHAHgxvykGSGwc17JuFzSfasqqeq6j07GpP8DP2u/PpM/A/gBAanvACoqkuTPAL8yYRqgMGlUj4AXJjkO13b3gyOcid2GZUaXKX3Nd3BwEZgYu87zXE+Cx8Qvn2B9uWwogeKu/w5foAkP8fg2v9fraqn5rSvraqrJ1jHEcALVrKOJMcCT1fVTRncEW0tg9MrVy6y6rjrOILBz+SGFdwXK/662EkNp+w44ptQHccyOMK+HzgCeBnwN5N8XczdFwzC7UVVdccK/D+dhtfFUfzoQPG3GRwsnU13oFhV/3tZC5j0ObZlOFf2dgZHcJ8FHgROn7NskudR/y1w90rWweDP5xuATcDvA9cA72VwauHdje2LFX9dTEMN0/K66F4T07AvpqKORWr8zWUfY6X/kWPYSbcDe3bTa7oX9zu6+Ym8qTotdXQ17MbgT+gnged17f+Eyb65Oy37ovkapuV1MWX7YsXrWKTGv13uMX4SzvHvVt2fa1X1YJLjgU8neSGDNzlbqmN7Vf0Q+F6S+6vqya6e73cfp5uUadgX1vAj0/C6mJZ9MRV1JLltoUXAsn//aJf/AhfwzSRH75jpfqinMXiT98WN1fGDOV/U+mc7GpM8n8G5xEmZhn1hDT8yDa+LadkX01LHgcAbGHwYY/7jx25NO267/Ju7SVYxOKL55pBlx1XVX7VSR5LnVNXfD2nfHzi4qm5f7hq68aZhX1jDj8Za8dfFFO2LaanjYuBPq+r6Ics+UVWvG7La+Mbf1YNfkvTM/CSc6pEkPQMGvyQ1xuCXpMYY/JLUGINfkhrz/wAGEBsqxtwijgAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Biểu diễn phân bố dữ liệu của thuộc tính 'age' lên đồ thị\n",
    "peoples_df['age'].value_counts().plot(kind='bar') "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Tạo mới df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "              name  age                   website\n",
      "0  Nguyễn Văn Hiếu   28  https://nguyenvanhieu.vn\n",
      "1  Hiếu Nguyễn Văn   28                      None\n"
     ]
    }
   ],
   "source": [
    "peoples = {'name': ['Nguyễn Văn Hiếu', 'Hiếu Nguyễn Văn'], 'age': [28, 28], 'website': ['https://nguyenvanhieu.vn', None]}\n",
    "df = pd.DataFrame(peoples)\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                           txt  label\n",
      "0     chỗ này ăn cũng khá ngon      1\n",
      "1  ngon, nhất định sẽ quay lại      1\n",
      "2       thái độ phục vụ quá tệ      0\n"
     ]
    }
   ],
   "source": [
    "txts = ['chỗ này ăn cũng khá ngon', 'ngon, nhất định sẽ quay lại', 'thái độ phục vụ quá tệ']\n",
    "labels = [1, 1, 0]\n",
    "df = pd.DataFrame()\n",
    "df['txt'] = txts\n",
    "df['label'] = labels\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Một số thao tác khác"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Before sort\n",
      "    name  age\n",
      "0   Nam   18\n",
      "1  Hiếu   18\n",
      "2   Mai   17\n",
      "3   Hoa   19\n",
      "After sort\n",
      "    name  age\n",
      "2   Mai   17\n",
      "0   Nam   18\n",
      "1  Hiếu   18\n",
      "3   Hoa   19\n"
     ]
    }
   ],
   "source": [
    "# Sắp xếp df tăng dần theo cột nào đó\n",
    "df = pd.DataFrame({'name': ['Nam', 'Hiếu', 'Mai', 'Hoa'], 'age': [18,18,17,19]})\n",
    "print('Before sort\\n', df)\n",
    "df = df.sort_values('age', ascending=True)\n",
    "print('After sort\\n', df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "   age gender  name\n",
      "0   18   male  Hiếu\n",
      "0   15    NaN   Nam\n",
      "1   17    NaN   Mai\n",
      "2   19    NaN   Hoa\n"
     ]
    }
   ],
   "source": [
    "# Gộp 2 dataframe\n",
    "df1 = pd.DataFrame({'name': ['Hiếu'], 'age': [18], 'gender': ['male']})\n",
    "df2 = pd.DataFrame({'name': ['Nam', 'Mai', 'Hoa'], 'age': [15,17,19]})\n",
    "df = df1.append(df2, sort=True)\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Before shuffle\n",
      "    name  age\n",
      "0  Hiếu   18\n",
      "1   Nam   15\n",
      "2   Mai   17\n",
      "3   Hoa   19\n",
      "After shuffle\n",
      "    name  age\n",
      "0  Hiếu   18\n",
      "3   Hoa   19\n",
      "2   Mai   17\n",
      "1   Nam   15\n"
     ]
    }
   ],
   "source": [
    "# Xáo trộn các hàng trong df - shuffle dataframe rows\n",
    "df = pd.DataFrame({'name': ['Hiếu', 'Nam', 'Mai', 'Hoa'], 'age': [18,15,17,19]})\n",
    "print('Before shuffle\\n', df)\n",
    "df = df.sample(frac=1)\n",
    "print('After shuffle\\n', df)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Lưu dataframe xuống csv file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('comments.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}