5-address and remove duplicate data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "0521e4ed-d716-4fb4-8268-a6714e103d0d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "    country  order_value_EUR       cost                 date     category  \\\n",
      "0    Sweden         98320.37   77722.25            8/23/2020        Games   \n",
      "1    France         46296.26   40319.41            5/15/2020        Games   \n",
      "2  Portugal        140337.34  115708.14  2020-04-09 00:00:00   Appliances   \n",
      "3    France        203604.46  175344.16            6/26/2019  Electronics   \n",
      "4        UK         63979.04   56032.84           10/22/2019        Games   \n",
      "5     Italy        127075.41  110924.13            9/24/2019     Clothing   \n",
      "6    Sweden         69681.43   55529.13            1/25/2020     Clothing   \n",
      "7    Sweden         69681.43   55529.13            1/25/2020     Clothing   \n",
      "8    Sweden         69681.43   55529.13            1/25/2020     Clothing   \n",
      "9     Korea      99994324.23  324232.32  2035-07-10 00:00:00        Games   \n",
      "\n",
      "        customer_name    sales_manager            sales_rep device_type  \\\n",
      "0      Konopelski LLC     Maxie Marrow   Tarrah Castelletti      Tablet   \n",
      "1          Wisoky Inc    Othello Bowes  Amelina Piscopiello      Tablet   \n",
      "2       Hegmann Group  Celine Tumasian        Corene Shirer          PC   \n",
      "3     Kirlin and Sons    Othello Bowes         Crysta Halls      Mobile   \n",
      "4      Schoen-Keeling  Jessamine Apark   Genevra Charrisson          PC   \n",
      "5    Labadie and Sons   Piggy Roscrigg       Joshua Prevost          PC   \n",
      "6  Romaguera-Dietrich     Maxie Marrow         Alyosha Meah          PC   \n",
      "7  Romaguera-Dietrich     Maxie Marrow         Alyosha Meah          PC   \n",
      "8  Romaguera-Dietrich     Maxie Marrow         Alyosha Meah          PC   \n",
      "9     Kirlin and Sons  Celine Tumasian      Ayulisha Hughes         MAC   \n",
      "\n",
      "       order_id  \n",
      "0    70-0511466  \n",
      "1    77-3489084  \n",
      "2    65-8218141  \n",
      "3    29-5478106  \n",
      "4    27-3437546  \n",
      "5    57-6602854  \n",
      "6    78-3301264  \n",
      "7    78-3301264  \n",
      "8    78-3301264  \n",
      "9  323-32432342  \n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "# Specify the file path\n",
    "excel_file = 'sales data.xlsx'\n",
    "\n",
    "# Load the Excel file into a DataFrame\n",
    "df = pd.read_excel(excel_file)\n",
    "\n",
    "# Display the DataFrame\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "febd3998-2c08-40a0-8a1e-e9786c5fab2e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>country</th>\n",
       "      <th>order_value_EUR</th>\n",
       "      <th>cost</th>\n",
       "      <th>date</th>\n",
       "      <th>category</th>\n",
       "      <th>customer_name</th>\n",
       "      <th>sales_manager</th>\n",
       "      <th>sales_rep</th>\n",
       "      <th>device_type</th>\n",
       "      <th>order_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Sweden</td>\n",
       "      <td>98320.37</td>\n",
       "      <td>77722.25</td>\n",
       "      <td>8/23/2020</td>\n",
       "      <td>Games</td>\n",
       "      <td>Konopelski LLC</td>\n",
       "      <td>Maxie Marrow</td>\n",
       "      <td>Tarrah Castelletti</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>70-0511466</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>France</td>\n",
       "      <td>46296.26</td>\n",
       "      <td>40319.41</td>\n",
       "      <td>5/15/2020</td>\n",
       "      <td>Games</td>\n",
       "      <td>Wisoky Inc</td>\n",
       "      <td>Othello Bowes</td>\n",
       "      <td>Amelina Piscopiello</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>77-3489084</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Portugal</td>\n",
       "      <td>140337.34</td>\n",
       "      <td>115708.14</td>\n",
       "      <td>2020-04-09 00:00:00</td>\n",
       "      <td>Appliances</td>\n",
       "      <td>Hegmann Group</td>\n",
       "      <td>Celine Tumasian</td>\n",
       "      <td>Corene Shirer</td>\n",
       "      <td>PC</td>\n",
       "      <td>65-8218141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>France</td>\n",
       "      <td>203604.46</td>\n",
       "      <td>175344.16</td>\n",
       "      <td>6/26/2019</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Kirlin and Sons</td>\n",
       "      <td>Othello Bowes</td>\n",
       "      <td>Crysta Halls</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>29-5478106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>UK</td>\n",
       "      <td>63979.04</td>\n",
       "      <td>56032.84</td>\n",
       "      <td>10/22/2019</td>\n",
       "      <td>Games</td>\n",
       "      <td>Schoen-Keeling</td>\n",
       "      <td>Jessamine Apark</td>\n",
       "      <td>Genevra Charrisson</td>\n",
       "      <td>PC</td>\n",
       "      <td>27-3437546</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Italy</td>\n",
       "      <td>127075.41</td>\n",
       "      <td>110924.13</td>\n",
       "      <td>9/24/2019</td>\n",
       "      <td>Clothing</td>\n",
       "      <td>Labadie and Sons</td>\n",
       "      <td>Piggy Roscrigg</td>\n",
       "      <td>Joshua Prevost</td>\n",
       "      <td>PC</td>\n",
       "      <td>57-6602854</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Sweden</td>\n",
       "      <td>69681.43</td>\n",
       "      <td>55529.13</td>\n",
       "      <td>1/25/2020</td>\n",
       "      <td>Clothing</td>\n",
       "      <td>Romaguera-Dietrich</td>\n",
       "      <td>Maxie Marrow</td>\n",
       "      <td>Alyosha Meah</td>\n",
       "      <td>PC</td>\n",
       "      <td>78-3301264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Sweden</td>\n",
       "      <td>69681.43</td>\n",
       "      <td>55529.13</td>\n",
       "      <td>1/25/2020</td>\n",
       "      <td>Clothing</td>\n",
       "      <td>Romaguera-Dietrich</td>\n",
       "      <td>Maxie Marrow</td>\n",
       "      <td>Alyosha Meah</td>\n",
       "      <td>PC</td>\n",
       "      <td>78-3301264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Sweden</td>\n",
       "      <td>69681.43</td>\n",
       "      <td>55529.13</td>\n",
       "      <td>1/25/2020</td>\n",
       "      <td>Clothing</td>\n",
       "      <td>Romaguera-Dietrich</td>\n",
       "      <td>Maxie Marrow</td>\n",
       "      <td>Alyosha Meah</td>\n",
       "      <td>PC</td>\n",
       "      <td>78-3301264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Korea</td>\n",
       "      <td>99994324.23</td>\n",
       "      <td>324232.32</td>\n",
       "      <td>2035-07-10 00:00:00</td>\n",
       "      <td>Games</td>\n",
       "      <td>Kirlin and Sons</td>\n",
       "      <td>Celine Tumasian</td>\n",
       "      <td>Ayulisha Hughes</td>\n",
       "      <td>MAC</td>\n",
       "      <td>323-32432342</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    country  order_value_EUR       cost                 date     category  \\\n",
       "0    Sweden         98320.37   77722.25            8/23/2020        Games   \n",
       "1    France         46296.26   40319.41            5/15/2020        Games   \n",
       "2  Portugal        140337.34  115708.14  2020-04-09 00:00:00   Appliances   \n",
       "3    France        203604.46  175344.16            6/26/2019  Electronics   \n",
       "4        UK         63979.04   56032.84           10/22/2019        Games   \n",
       "5     Italy        127075.41  110924.13            9/24/2019     Clothing   \n",
       "6    Sweden         69681.43   55529.13            1/25/2020     Clothing   \n",
       "7    Sweden         69681.43   55529.13            1/25/2020     Clothing   \n",
       "8    Sweden         69681.43   55529.13            1/25/2020     Clothing   \n",
       "9     Korea      99994324.23  324232.32  2035-07-10 00:00:00        Games   \n",
       "\n",
       "        customer_name    sales_manager            sales_rep device_type  \\\n",
       "0      Konopelski LLC     Maxie Marrow   Tarrah Castelletti      Tablet   \n",
       "1          Wisoky Inc    Othello Bowes  Amelina Piscopiello      Tablet   \n",
       "2       Hegmann Group  Celine Tumasian        Corene Shirer          PC   \n",
       "3     Kirlin and Sons    Othello Bowes         Crysta Halls      Mobile   \n",
       "4      Schoen-Keeling  Jessamine Apark   Genevra Charrisson          PC   \n",
       "5    Labadie and Sons   Piggy Roscrigg       Joshua Prevost          PC   \n",
       "6  Romaguera-Dietrich     Maxie Marrow         Alyosha Meah          PC   \n",
       "7  Romaguera-Dietrich     Maxie Marrow         Alyosha Meah          PC   \n",
       "8  Romaguera-Dietrich     Maxie Marrow         Alyosha Meah          PC   \n",
       "9     Kirlin and Sons  Celine Tumasian      Ayulisha Hughes         MAC   \n",
       "\n",
       "       order_id  \n",
       "0    70-0511466  \n",
       "1    77-3489084  \n",
       "2    65-8218141  \n",
       "3    29-5478106  \n",
       "4    27-3437546  \n",
       "5    57-6602854  \n",
       "6    78-3301264  \n",
       "7    78-3301264  \n",
       "8    78-3301264  \n",
       "9  323-32432342  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Display a number of rows you want to show \n",
    "df.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "06056e43-980a-4f60-b727-60d3487197e8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Duplicated Rows: \n",
      "  country  order_value_EUR      cost       date  category       customer_name  \\\n",
      "7  Sweden         69681.43  55529.13  1/25/2020  Clothing  Romaguera-Dietrich   \n",
      "8  Sweden         69681.43  55529.13  1/25/2020  Clothing  Romaguera-Dietrich   \n",
      "\n",
      "  sales_manager     sales_rep device_type    order_id  \n",
      "7  Maxie Marrow  Alyosha Meah          PC  78-3301264  \n",
      "8  Maxie Marrow  Alyosha Meah          PC  78-3301264  \n"
     ]
    }
   ],
   "source": [
    "# Identify duplicate rows based on all columns\n",
    "duplicated_rows = df[df.duplicated()]\n",
    "\n",
    "# Display duplicated rows\n",
    "print (\"Duplicated Rows: \")\n",
    "print (duplicated_rows)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "a24ee120-7b22-4e8f-8e19-7b0ecdef7b94",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Dataframe without Duplicates: \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>country</th>\n",
       "      <th>order_value_EUR</th>\n",
       "      <th>cost</th>\n",
       "      <th>date</th>\n",
       "      <th>category</th>\n",
       "      <th>customer_name</th>\n",
       "      <th>sales_manager</th>\n",
       "      <th>sales_rep</th>\n",
       "      <th>device_type</th>\n",
       "      <th>order_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Sweden</td>\n",
       "      <td>98320.37</td>\n",
       "      <td>77722.25</td>\n",
       "      <td>8/23/2020</td>\n",
       "      <td>Games</td>\n",
       "      <td>Konopelski LLC</td>\n",
       "      <td>Maxie Marrow</td>\n",
       "      <td>Tarrah Castelletti</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>70-0511466</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>France</td>\n",
       "      <td>46296.26</td>\n",
       "      <td>40319.41</td>\n",
       "      <td>5/15/2020</td>\n",
       "      <td>Games</td>\n",
       "      <td>Wisoky Inc</td>\n",
       "      <td>Othello Bowes</td>\n",
       "      <td>Amelina Piscopiello</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>77-3489084</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Portugal</td>\n",
       "      <td>140337.34</td>\n",
       "      <td>115708.14</td>\n",
       "      <td>2020-04-09 00:00:00</td>\n",
       "      <td>Appliances</td>\n",
       "      <td>Hegmann Group</td>\n",
       "      <td>Celine Tumasian</td>\n",
       "      <td>Corene Shirer</td>\n",
       "      <td>PC</td>\n",
       "      <td>65-8218141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>France</td>\n",
       "      <td>203604.46</td>\n",
       "      <td>175344.16</td>\n",
       "      <td>6/26/2019</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Kirlin and Sons</td>\n",
       "      <td>Othello Bowes</td>\n",
       "      <td>Crysta Halls</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>29-5478106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>UK</td>\n",
       "      <td>63979.04</td>\n",
       "      <td>56032.84</td>\n",
       "      <td>10/22/2019</td>\n",
       "      <td>Games</td>\n",
       "      <td>Schoen-Keeling</td>\n",
       "      <td>Jessamine Apark</td>\n",
       "      <td>Genevra Charrisson</td>\n",
       "      <td>PC</td>\n",
       "      <td>27-3437546</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Italy</td>\n",
       "      <td>127075.41</td>\n",
       "      <td>110924.13</td>\n",
       "      <td>9/24/2019</td>\n",
       "      <td>Clothing</td>\n",
       "      <td>Labadie and Sons</td>\n",
       "      <td>Piggy Roscrigg</td>\n",
       "      <td>Joshua Prevost</td>\n",
       "      <td>PC</td>\n",
       "      <td>57-6602854</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Sweden</td>\n",
       "      <td>69681.43</td>\n",
       "      <td>55529.13</td>\n",
       "      <td>1/25/2020</td>\n",
       "      <td>Clothing</td>\n",
       "      <td>Romaguera-Dietrich</td>\n",
       "      <td>Maxie Marrow</td>\n",
       "      <td>Alyosha Meah</td>\n",
       "      <td>PC</td>\n",
       "      <td>78-3301264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Korea</td>\n",
       "      <td>99994324.23</td>\n",
       "      <td>324232.32</td>\n",
       "      <td>2035-07-10 00:00:00</td>\n",
       "      <td>Games</td>\n",
       "      <td>Kirlin and Sons</td>\n",
       "      <td>Celine Tumasian</td>\n",
       "      <td>Ayulisha Hughes</td>\n",
       "      <td>MAC</td>\n",
       "      <td>323-32432342</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    country  order_value_EUR       cost                 date     category  \\\n",
       "0    Sweden         98320.37   77722.25            8/23/2020        Games   \n",
       "1    France         46296.26   40319.41            5/15/2020        Games   \n",
       "2  Portugal        140337.34  115708.14  2020-04-09 00:00:00   Appliances   \n",
       "3    France        203604.46  175344.16            6/26/2019  Electronics   \n",
       "4        UK         63979.04   56032.84           10/22/2019        Games   \n",
       "5     Italy        127075.41  110924.13            9/24/2019     Clothing   \n",
       "6    Sweden         69681.43   55529.13            1/25/2020     Clothing   \n",
       "9     Korea      99994324.23  324232.32  2035-07-10 00:00:00        Games   \n",
       "\n",
       "        customer_name    sales_manager            sales_rep device_type  \\\n",
       "0      Konopelski LLC     Maxie Marrow   Tarrah Castelletti      Tablet   \n",
       "1          Wisoky Inc    Othello Bowes  Amelina Piscopiello      Tablet   \n",
       "2       Hegmann Group  Celine Tumasian        Corene Shirer          PC   \n",
       "3     Kirlin and Sons    Othello Bowes         Crysta Halls      Mobile   \n",
       "4      Schoen-Keeling  Jessamine Apark   Genevra Charrisson          PC   \n",
       "5    Labadie and Sons   Piggy Roscrigg       Joshua Prevost          PC   \n",
       "6  Romaguera-Dietrich     Maxie Marrow         Alyosha Meah          PC   \n",
       "9     Kirlin and Sons  Celine Tumasian      Ayulisha Hughes         MAC   \n",
       "\n",
       "       order_id  \n",
       "0    70-0511466  \n",
       "1    77-3489084  \n",
       "2    65-8218141  \n",
       "3    29-5478106  \n",
       "4    27-3437546  \n",
       "5    57-6602854  \n",
       "6    78-3301264  \n",
       "9  323-32432342  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Remove duplicated Rows keeping the first accurence \n",
    "df_no_duplicates = df.drop_duplicates()\n",
    "\n",
    "# Print the DataFrame without duplicates \n",
    "print (\"Dataframe without Duplicates: \")\n",
    "df_no_duplicates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "8740db93-6610-44c2-bfe2-6c87fe2ddcb5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>country</th>\n",
       "      <th>order_value_EUR</th>\n",
       "      <th>cost</th>\n",
       "      <th>date</th>\n",
       "      <th>category</th>\n",
       "      <th>customer_name</th>\n",
       "      <th>sales_manager</th>\n",
       "      <th>sales_rep</th>\n",
       "      <th>device_type</th>\n",
       "      <th>order_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Sweden</td>\n",
       "      <td>98320.37</td>\n",
       "      <td>77722.25</td>\n",
       "      <td>8/23/2020</td>\n",
       "      <td>Games</td>\n",
       "      <td>Konopelski LLC</td>\n",
       "      <td>Maxie Marrow</td>\n",
       "      <td>Tarrah Castelletti</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>70-0511466</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>France</td>\n",
       "      <td>46296.26</td>\n",
       "      <td>40319.41</td>\n",
       "      <td>5/15/2020</td>\n",
       "      <td>Games</td>\n",
       "      <td>Wisoky Inc</td>\n",
       "      <td>Othello Bowes</td>\n",
       "      <td>Amelina Piscopiello</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>77-3489084</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Portugal</td>\n",
       "      <td>140337.34</td>\n",
       "      <td>115708.14</td>\n",
       "      <td>2020-04-09 00:00:00</td>\n",
       "      <td>Appliances</td>\n",
       "      <td>Hegmann Group</td>\n",
       "      <td>Celine Tumasian</td>\n",
       "      <td>Corene Shirer</td>\n",
       "      <td>PC</td>\n",
       "      <td>65-8218141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>France</td>\n",
       "      <td>203604.46</td>\n",
       "      <td>175344.16</td>\n",
       "      <td>6/26/2019</td>\n",
       "      <td>Electronics</td>\n",
       "      <td>Kirlin and Sons</td>\n",
       "      <td>Othello Bowes</td>\n",
       "      <td>Crysta Halls</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>29-5478106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>UK</td>\n",
       "      <td>63979.04</td>\n",
       "      <td>56032.84</td>\n",
       "      <td>10/22/2019</td>\n",
       "      <td>Games</td>\n",
       "      <td>Schoen-Keeling</td>\n",
       "      <td>Jessamine Apark</td>\n",
       "      <td>Genevra Charrisson</td>\n",
       "      <td>PC</td>\n",
       "      <td>27-3437546</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Italy</td>\n",
       "      <td>127075.41</td>\n",
       "      <td>110924.13</td>\n",
       "      <td>9/24/2019</td>\n",
       "      <td>Clothing</td>\n",
       "      <td>Labadie and Sons</td>\n",
       "      <td>Piggy Roscrigg</td>\n",
       "      <td>Joshua Prevost</td>\n",
       "      <td>PC</td>\n",
       "      <td>57-6602854</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Sweden</td>\n",
       "      <td>69681.43</td>\n",
       "      <td>55529.13</td>\n",
       "      <td>1/25/2020</td>\n",
       "      <td>Clothing</td>\n",
       "      <td>Romaguera-Dietrich</td>\n",
       "      <td>Maxie Marrow</td>\n",
       "      <td>Alyosha Meah</td>\n",
       "      <td>PC</td>\n",
       "      <td>78-3301264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Korea</td>\n",
       "      <td>99994324.23</td>\n",
       "      <td>324232.32</td>\n",
       "      <td>2035-07-10 00:00:00</td>\n",
       "      <td>Games</td>\n",
       "      <td>Kirlin and Sons</td>\n",
       "      <td>Celine Tumasian</td>\n",
       "      <td>Ayulisha Hughes</td>\n",
       "      <td>MAC</td>\n",
       "      <td>323-32432342</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    country  order_value_EUR       cost                 date     category  \\\n",
       "0    Sweden         98320.37   77722.25            8/23/2020        Games   \n",
       "1    France         46296.26   40319.41            5/15/2020        Games   \n",
       "2  Portugal        140337.34  115708.14  2020-04-09 00:00:00   Appliances   \n",
       "3    France        203604.46  175344.16            6/26/2019  Electronics   \n",
       "4        UK         63979.04   56032.84           10/22/2019        Games   \n",
       "5     Italy        127075.41  110924.13            9/24/2019     Clothing   \n",
       "6    Sweden         69681.43   55529.13            1/25/2020     Clothing   \n",
       "9     Korea      99994324.23  324232.32  2035-07-10 00:00:00        Games   \n",
       "\n",
       "        customer_name    sales_manager            sales_rep device_type  \\\n",
       "0      Konopelski LLC     Maxie Marrow   Tarrah Castelletti      Tablet   \n",
       "1          Wisoky Inc    Othello Bowes  Amelina Piscopiello      Tablet   \n",
       "2       Hegmann Group  Celine Tumasian        Corene Shirer          PC   \n",
       "3     Kirlin and Sons    Othello Bowes         Crysta Halls      Mobile   \n",
       "4      Schoen-Keeling  Jessamine Apark   Genevra Charrisson          PC   \n",
       "5    Labadie and Sons   Piggy Roscrigg       Joshua Prevost          PC   \n",
       "6  Romaguera-Dietrich     Maxie Marrow         Alyosha Meah          PC   \n",
       "9     Kirlin and Sons  Celine Tumasian      Ayulisha Hughes         MAC   \n",
       "\n",
       "       order_id  \n",
       "0    70-0511466  \n",
       "1    77-3489084  \n",
       "2    65-8218141  \n",
       "3    29-5478106  \n",
       "4    27-3437546  \n",
       "5    57-6602854  \n",
       "6    78-3301264  \n",
       "9  323-32432342  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create a new variable to display a data without duplicates\n",
    "clean_data = df_no_duplicates\n",
    "\n",
    "# Print clean data\n",
    "clean_data.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "de99491e-8b74-4221-bdca-20273b63f18b",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.12.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}