06_ajouter_des_donnees.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "e50d5af5-477e-4178-8e14-03f464fc7cb3",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "62c58b56-7988-4336-aee2-810a3d73d830",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"data.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "52dc8d9e-3783-44af-9bf4-55ff4fc919e2",
   "metadata": {},
   "source": [
    "# Ajouter des colonnes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "f4a89a16-6f6b-403c-948a-9523c05c055f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.dropna(subset=[\"tax\"], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "20ae8a2e-3ab9-4a5b-9cb5-53bbcf3ee6f1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>first_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>email</th>\n",
       "      <th>gender</th>\n",
       "      <th>ip_address</th>\n",
       "      <th>country</th>\n",
       "      <th>price_paid</th>\n",
       "      <th>tax</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>03/17/2021</td>\n",
       "      <td>Erl</td>\n",
       "      <td>Kilminster</td>\n",
       "      <td>ekilminster2@etsy.com</td>\n",
       "      <td>Male</td>\n",
       "      <td>213.8.101.145</td>\n",
       "      <td>United States</td>\n",
       "      <td>$3.73</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>03/19/2021</td>\n",
       "      <td>Grata</td>\n",
       "      <td>Brantl</td>\n",
       "      <td>gbrantl3@umn.edu</td>\n",
       "      <td>Female</td>\n",
       "      <td>5.140.237.101</td>\n",
       "      <td>United States</td>\n",
       "      <td>$3.70</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>03/24/2021</td>\n",
       "      <td>Kanya</td>\n",
       "      <td>Beasant</td>\n",
       "      <td>kbeasant4@jigsy.com</td>\n",
       "      <td>Male</td>\n",
       "      <td>106.252.162.233</td>\n",
       "      <td>Morocco</td>\n",
       "      <td>$9.24</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>03/08/2021</td>\n",
       "      <td>Codi</td>\n",
       "      <td>Feasley</td>\n",
       "      <td>cfeasley7@ed.gov</td>\n",
       "      <td>Male</td>\n",
       "      <td>26.190.191.249</td>\n",
       "      <td>France</td>\n",
       "      <td>$3.01</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>03/09/2021</td>\n",
       "      <td>Waylon</td>\n",
       "      <td>Heersema</td>\n",
       "      <td>wheersema8@tumblr.com</td>\n",
       "      <td>Male</td>\n",
       "      <td>63.242.174.112</td>\n",
       "      <td>Canada</td>\n",
       "      <td>$3.70</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>991</th>\n",
       "      <td>992</td>\n",
       "      <td>03/07/2021</td>\n",
       "      <td>Elihu</td>\n",
       "      <td>Crush</td>\n",
       "      <td>ecrushrj@berkeley.edu</td>\n",
       "      <td>Male</td>\n",
       "      <td>174.38.173.53</td>\n",
       "      <td>Morocco</td>\n",
       "      <td>$5.05</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>994</th>\n",
       "      <td>995</td>\n",
       "      <td>03/17/2021</td>\n",
       "      <td>Carolyne</td>\n",
       "      <td>Bruntjen</td>\n",
       "      <td>cbruntjenrm@reference.com</td>\n",
       "      <td>Female</td>\n",
       "      <td>7.29.168.78</td>\n",
       "      <td>France</td>\n",
       "      <td>$5.68</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>997</td>\n",
       "      <td>03/17/2021</td>\n",
       "      <td>Ame</td>\n",
       "      <td>Rastall</td>\n",
       "      <td>arastallro@toplist.cz</td>\n",
       "      <td>Female</td>\n",
       "      <td>188.219.12.109</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$4.59</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>998</td>\n",
       "      <td>03/13/2021</td>\n",
       "      <td>Betty</td>\n",
       "      <td>Stickels</td>\n",
       "      <td>bstickelsrp@cloudflare.com</td>\n",
       "      <td>Male</td>\n",
       "      <td>199.80.60.87</td>\n",
       "      <td>United States</td>\n",
       "      <td>$7.54</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>1000</td>\n",
       "      <td>03/23/2021</td>\n",
       "      <td>Rochelle</td>\n",
       "      <td>Pringuer</td>\n",
       "      <td>rpringuerrr@house.gov</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170.193.249.83</td>\n",
       "      <td>Canada</td>\n",
       "      <td>$8.01</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>654 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       id        date first_name   last_name                       email  \\\n",
       "2       3  03/17/2021        Erl  Kilminster       ekilminster2@etsy.com   \n",
       "3       4  03/19/2021      Grata      Brantl            gbrantl3@umn.edu   \n",
       "4       5  03/24/2021      Kanya     Beasant         kbeasant4@jigsy.com   \n",
       "7       8  03/08/2021       Codi     Feasley            cfeasley7@ed.gov   \n",
       "8       9  03/09/2021     Waylon    Heersema       wheersema8@tumblr.com   \n",
       "..    ...         ...        ...         ...                         ...   \n",
       "991   992  03/07/2021      Elihu       Crush       ecrushrj@berkeley.edu   \n",
       "994   995  03/17/2021   Carolyne    Bruntjen   cbruntjenrm@reference.com   \n",
       "996   997  03/17/2021        Ame     Rastall       arastallro@toplist.cz   \n",
       "997   998  03/13/2021      Betty    Stickels  bstickelsrp@cloudflare.com   \n",
       "999  1000  03/23/2021   Rochelle    Pringuer       rpringuerrr@house.gov   \n",
       "\n",
       "     gender       ip_address        country price_paid   tax  \n",
       "2      Male    213.8.101.145  United States      $3.73  20.0  \n",
       "3    Female    5.140.237.101  United States      $3.70  20.0  \n",
       "4      Male  106.252.162.233        Morocco      $9.24  20.0  \n",
       "7      Male   26.190.191.249         France      $3.01  20.0  \n",
       "8      Male   63.242.174.112         Canada      $3.70  20.0  \n",
       "..      ...              ...            ...        ...   ...  \n",
       "991    Male    174.38.173.53        Morocco      $5.05  20.0  \n",
       "994  Female      7.29.168.78         France      $5.68  20.0  \n",
       "996  Female   188.219.12.109            NaN      $4.59  20.0  \n",
       "997    Male     199.80.60.87  United States      $7.54  20.0  \n",
       "999     NaN   170.193.249.83         Canada      $8.01  20.0  \n",
       "\n",
       "[654 rows x 10 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "ffc09c83-4884-4f26-b524-438eeba68744",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "id              int64\n",
       "date           object\n",
       "first_name     object\n",
       "last_name      object\n",
       "email          object\n",
       "gender         object\n",
       "ip_address     object\n",
       "country        object\n",
       "price_paid    float64\n",
       "tax           float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.price_paid = df.price_paid.apply(lambda x: x.replace(\"$\", \"\"))\n",
    "df.price_paid = df.price_paid.astype(float)\n",
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "45dcbced-3dc8-4c09-ba1f-f8cea34c7418",
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"price_total\"] = df[\"price_paid\"] * (1 - df[\"tax\"] / 100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "6af470d6-f294-49d0-a4fc-3fde15e74f23",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>first_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>email</th>\n",
       "      <th>gender</th>\n",
       "      <th>ip_address</th>\n",
       "      <th>country</th>\n",
       "      <th>price_paid</th>\n",
       "      <th>tax</th>\n",
       "      <th>price_total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>03/17/2021</td>\n",
       "      <td>Erl</td>\n",
       "      <td>Kilminster</td>\n",
       "      <td>ekilminster2@etsy.com</td>\n",
       "      <td>Male</td>\n",
       "      <td>213.8.101.145</td>\n",
       "      <td>United States</td>\n",
       "      <td>3.73</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2.984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>03/19/2021</td>\n",
       "      <td>Grata</td>\n",
       "      <td>Brantl</td>\n",
       "      <td>gbrantl3@umn.edu</td>\n",
       "      <td>Female</td>\n",
       "      <td>5.140.237.101</td>\n",
       "      <td>United States</td>\n",
       "      <td>3.70</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2.960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>03/24/2021</td>\n",
       "      <td>Kanya</td>\n",
       "      <td>Beasant</td>\n",
       "      <td>kbeasant4@jigsy.com</td>\n",
       "      <td>Male</td>\n",
       "      <td>106.252.162.233</td>\n",
       "      <td>Morocco</td>\n",
       "      <td>9.24</td>\n",
       "      <td>20.0</td>\n",
       "      <td>7.392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>03/08/2021</td>\n",
       "      <td>Codi</td>\n",
       "      <td>Feasley</td>\n",
       "      <td>cfeasley7@ed.gov</td>\n",
       "      <td>Male</td>\n",
       "      <td>26.190.191.249</td>\n",
       "      <td>France</td>\n",
       "      <td>3.01</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2.408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>03/09/2021</td>\n",
       "      <td>Waylon</td>\n",
       "      <td>Heersema</td>\n",
       "      <td>wheersema8@tumblr.com</td>\n",
       "      <td>Male</td>\n",
       "      <td>63.242.174.112</td>\n",
       "      <td>Canada</td>\n",
       "      <td>3.70</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2.960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>991</th>\n",
       "      <td>992</td>\n",
       "      <td>03/07/2021</td>\n",
       "      <td>Elihu</td>\n",
       "      <td>Crush</td>\n",
       "      <td>ecrushrj@berkeley.edu</td>\n",
       "      <td>Male</td>\n",
       "      <td>174.38.173.53</td>\n",
       "      <td>Morocco</td>\n",
       "      <td>5.05</td>\n",
       "      <td>20.0</td>\n",
       "      <td>4.040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>994</th>\n",
       "      <td>995</td>\n",
       "      <td>03/17/2021</td>\n",
       "      <td>Carolyne</td>\n",
       "      <td>Bruntjen</td>\n",
       "      <td>cbruntjenrm@reference.com</td>\n",
       "      <td>Female</td>\n",
       "      <td>7.29.168.78</td>\n",
       "      <td>France</td>\n",
       "      <td>5.68</td>\n",
       "      <td>20.0</td>\n",
       "      <td>4.544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>997</td>\n",
       "      <td>03/17/2021</td>\n",
       "      <td>Ame</td>\n",
       "      <td>Rastall</td>\n",
       "      <td>arastallro@toplist.cz</td>\n",
       "      <td>Female</td>\n",
       "      <td>188.219.12.109</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.59</td>\n",
       "      <td>20.0</td>\n",
       "      <td>3.672</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>998</td>\n",
       "      <td>03/13/2021</td>\n",
       "      <td>Betty</td>\n",
       "      <td>Stickels</td>\n",
       "      <td>bstickelsrp@cloudflare.com</td>\n",
       "      <td>Male</td>\n",
       "      <td>199.80.60.87</td>\n",
       "      <td>United States</td>\n",
       "      <td>7.54</td>\n",
       "      <td>20.0</td>\n",
       "      <td>6.032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>1000</td>\n",
       "      <td>03/23/2021</td>\n",
       "      <td>Rochelle</td>\n",
       "      <td>Pringuer</td>\n",
       "      <td>rpringuerrr@house.gov</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170.193.249.83</td>\n",
       "      <td>Canada</td>\n",
       "      <td>8.01</td>\n",
       "      <td>20.0</td>\n",
       "      <td>6.408</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>654 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       id        date first_name   last_name                       email  \\\n",
       "2       3  03/17/2021        Erl  Kilminster       ekilminster2@etsy.com   \n",
       "3       4  03/19/2021      Grata      Brantl            gbrantl3@umn.edu   \n",
       "4       5  03/24/2021      Kanya     Beasant         kbeasant4@jigsy.com   \n",
       "7       8  03/08/2021       Codi     Feasley            cfeasley7@ed.gov   \n",
       "8       9  03/09/2021     Waylon    Heersema       wheersema8@tumblr.com   \n",
       "..    ...         ...        ...         ...                         ...   \n",
       "991   992  03/07/2021      Elihu       Crush       ecrushrj@berkeley.edu   \n",
       "994   995  03/17/2021   Carolyne    Bruntjen   cbruntjenrm@reference.com   \n",
       "996   997  03/17/2021        Ame     Rastall       arastallro@toplist.cz   \n",
       "997   998  03/13/2021      Betty    Stickels  bstickelsrp@cloudflare.com   \n",
       "999  1000  03/23/2021   Rochelle    Pringuer       rpringuerrr@house.gov   \n",
       "\n",
       "     gender       ip_address        country  price_paid   tax  price_total  \n",
       "2      Male    213.8.101.145  United States        3.73  20.0        2.984  \n",
       "3    Female    5.140.237.101  United States        3.70  20.0        2.960  \n",
       "4      Male  106.252.162.233        Morocco        9.24  20.0        7.392  \n",
       "7      Male   26.190.191.249         France        3.01  20.0        2.408  \n",
       "8      Male   63.242.174.112         Canada        3.70  20.0        2.960  \n",
       "..      ...              ...            ...         ...   ...          ...  \n",
       "991    Male    174.38.173.53        Morocco        5.05  20.0        4.040  \n",
       "994  Female      7.29.168.78         France        5.68  20.0        4.544  \n",
       "996  Female   188.219.12.109            NaN        4.59  20.0        3.672  \n",
       "997    Male     199.80.60.87  United States        7.54  20.0        6.032  \n",
       "999     NaN   170.193.249.83         Canada        8.01  20.0        6.408  \n",
       "\n",
       "[654 rows x 11 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "1c8db2cb-80b3-4818-92d2-4cbf22e0f43b",
   "metadata": {},
   "outputs": [],
   "source": [
    "countries = {\"United States\": \"UN\", \"France\": \"FR\", \"Canada\": \"CA\", \"Morocco\": \"MA\"}\n",
    "df[\"country_code\"] = df[\"country\"].map(countries)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "d6f76a3e-1f50-449e-b818-ba89ef5b3535",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>first_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>email</th>\n",
       "      <th>gender</th>\n",
       "      <th>ip_address</th>\n",
       "      <th>country</th>\n",
       "      <th>price_paid</th>\n",
       "      <th>tax</th>\n",
       "      <th>price_total</th>\n",
       "      <th>country_code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>03/17/2021</td>\n",
       "      <td>Erl</td>\n",
       "      <td>Kilminster</td>\n",
       "      <td>ekilminster2@etsy.com</td>\n",
       "      <td>Male</td>\n",
       "      <td>213.8.101.145</td>\n",
       "      <td>United States</td>\n",
       "      <td>3.73</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2.984</td>\n",
       "      <td>UN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>03/19/2021</td>\n",
       "      <td>Grata</td>\n",
       "      <td>Brantl</td>\n",
       "      <td>gbrantl3@umn.edu</td>\n",
       "      <td>Female</td>\n",
       "      <td>5.140.237.101</td>\n",
       "      <td>United States</td>\n",
       "      <td>3.70</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2.960</td>\n",
       "      <td>UN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>03/24/2021</td>\n",
       "      <td>Kanya</td>\n",
       "      <td>Beasant</td>\n",
       "      <td>kbeasant4@jigsy.com</td>\n",
       "      <td>Male</td>\n",
       "      <td>106.252.162.233</td>\n",
       "      <td>Morocco</td>\n",
       "      <td>9.24</td>\n",
       "      <td>20.0</td>\n",
       "      <td>7.392</td>\n",
       "      <td>MA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>03/08/2021</td>\n",
       "      <td>Codi</td>\n",
       "      <td>Feasley</td>\n",
       "      <td>cfeasley7@ed.gov</td>\n",
       "      <td>Male</td>\n",
       "      <td>26.190.191.249</td>\n",
       "      <td>France</td>\n",
       "      <td>3.01</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2.408</td>\n",
       "      <td>FR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>03/09/2021</td>\n",
       "      <td>Waylon</td>\n",
       "      <td>Heersema</td>\n",
       "      <td>wheersema8@tumblr.com</td>\n",
       "      <td>Male</td>\n",
       "      <td>63.242.174.112</td>\n",
       "      <td>Canada</td>\n",
       "      <td>3.70</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2.960</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>991</th>\n",
       "      <td>992</td>\n",
       "      <td>03/07/2021</td>\n",
       "      <td>Elihu</td>\n",
       "      <td>Crush</td>\n",
       "      <td>ecrushrj@berkeley.edu</td>\n",
       "      <td>Male</td>\n",
       "      <td>174.38.173.53</td>\n",
       "      <td>Morocco</td>\n",
       "      <td>5.05</td>\n",
       "      <td>20.0</td>\n",
       "      <td>4.040</td>\n",
       "      <td>MA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>994</th>\n",
       "      <td>995</td>\n",
       "      <td>03/17/2021</td>\n",
       "      <td>Carolyne</td>\n",
       "      <td>Bruntjen</td>\n",
       "      <td>cbruntjenrm@reference.com</td>\n",
       "      <td>Female</td>\n",
       "      <td>7.29.168.78</td>\n",
       "      <td>France</td>\n",
       "      <td>5.68</td>\n",
       "      <td>20.0</td>\n",
       "      <td>4.544</td>\n",
       "      <td>FR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>997</td>\n",
       "      <td>03/17/2021</td>\n",
       "      <td>Ame</td>\n",
       "      <td>Rastall</td>\n",
       "      <td>arastallro@toplist.cz</td>\n",
       "      <td>Female</td>\n",
       "      <td>188.219.12.109</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.59</td>\n",
       "      <td>20.0</td>\n",
       "      <td>3.672</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>998</td>\n",
       "      <td>03/13/2021</td>\n",
       "      <td>Betty</td>\n",
       "      <td>Stickels</td>\n",
       "      <td>bstickelsrp@cloudflare.com</td>\n",
       "      <td>Male</td>\n",
       "      <td>199.80.60.87</td>\n",
       "      <td>United States</td>\n",
       "      <td>7.54</td>\n",
       "      <td>20.0</td>\n",
       "      <td>6.032</td>\n",
       "      <td>UN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>1000</td>\n",
       "      <td>03/23/2021</td>\n",
       "      <td>Rochelle</td>\n",
       "      <td>Pringuer</td>\n",
       "      <td>rpringuerrr@house.gov</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170.193.249.83</td>\n",
       "      <td>Canada</td>\n",
       "      <td>8.01</td>\n",
       "      <td>20.0</td>\n",
       "      <td>6.408</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>654 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       id        date first_name   last_name                       email  \\\n",
       "2       3  03/17/2021        Erl  Kilminster       ekilminster2@etsy.com   \n",
       "3       4  03/19/2021      Grata      Brantl            gbrantl3@umn.edu   \n",
       "4       5  03/24/2021      Kanya     Beasant         kbeasant4@jigsy.com   \n",
       "7       8  03/08/2021       Codi     Feasley            cfeasley7@ed.gov   \n",
       "8       9  03/09/2021     Waylon    Heersema       wheersema8@tumblr.com   \n",
       "..    ...         ...        ...         ...                         ...   \n",
       "991   992  03/07/2021      Elihu       Crush       ecrushrj@berkeley.edu   \n",
       "994   995  03/17/2021   Carolyne    Bruntjen   cbruntjenrm@reference.com   \n",
       "996   997  03/17/2021        Ame     Rastall       arastallro@toplist.cz   \n",
       "997   998  03/13/2021      Betty    Stickels  bstickelsrp@cloudflare.com   \n",
       "999  1000  03/23/2021   Rochelle    Pringuer       rpringuerrr@house.gov   \n",
       "\n",
       "     gender       ip_address        country  price_paid   tax  price_total  \\\n",
       "2      Male    213.8.101.145  United States        3.73  20.0        2.984   \n",
       "3    Female    5.140.237.101  United States        3.70  20.0        2.960   \n",
       "4      Male  106.252.162.233        Morocco        9.24  20.0        7.392   \n",
       "7      Male   26.190.191.249         France        3.01  20.0        2.408   \n",
       "8      Male   63.242.174.112         Canada        3.70  20.0        2.960   \n",
       "..      ...              ...            ...         ...   ...          ...   \n",
       "991    Male    174.38.173.53        Morocco        5.05  20.0        4.040   \n",
       "994  Female      7.29.168.78         France        5.68  20.0        4.544   \n",
       "996  Female   188.219.12.109            NaN        4.59  20.0        3.672   \n",
       "997    Male     199.80.60.87  United States        7.54  20.0        6.032   \n",
       "999     NaN   170.193.249.83         Canada        8.01  20.0        6.408   \n",
       "\n",
       "    country_code  \n",
       "2             UN  \n",
       "3             UN  \n",
       "4             MA  \n",
       "7             FR  \n",
       "8             CA  \n",
       "..           ...  \n",
       "991           MA  \n",
       "994           FR  \n",
       "996          NaN  \n",
       "997           UN  \n",
       "999           CA  \n",
       "\n",
       "[654 rows x 12 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f6e28ef0-ac4c-4beb-8e8f-cee90abbb19c",
   "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.9.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}