summaryrefslogtreecommitdiff
path: root/Data Cleaning/Customer Call/.ipynb_checkpoints/Customer Call List-checkpoint.ipynb
diff options
context:
space:
mode:
Diffstat (limited to 'Data Cleaning/Customer Call/.ipynb_checkpoints/Customer Call List-checkpoint.ipynb')
-rw-r--r--Data Cleaning/Customer Call/.ipynb_checkpoints/Customer Call List-checkpoint.ipynb3593
1 files changed, 3593 insertions, 0 deletions
diff --git a/Data Cleaning/Customer Call/.ipynb_checkpoints/Customer Call List-checkpoint.ipynb b/Data Cleaning/Customer Call/.ipynb_checkpoints/Customer Call List-checkpoint.ipynb
new file mode 100644
index 0000000..bce03ed
--- /dev/null
+++ b/Data Cleaning/Customer Call/.ipynb_checkpoints/Customer Call List-checkpoint.ipynb
@@ -0,0 +1,3593 @@
+{
+ "cells": [
+ {
+ "cell_type": "markdown",
+ "id": "c6038cd0",
+ "metadata": {},
+ "source": [
+ "# Data Cleaning in Pandas"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 26,
+ "id": "9d8c99e2",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "import pandas as pd"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 27,
+ "id": "1996c91f",
+ "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>CustomerID</th>\n",
+ " <th>First_Name</th>\n",
+ " <th>Last_Name</th>\n",
+ " <th>Phone_Number</th>\n",
+ " <th>Address</th>\n",
+ " <th>Paying Customer</th>\n",
+ " <th>Do_Not_Contact</th>\n",
+ " <th>Not_Useful_Column</th>\n",
+ " </tr>\n",
+ " </thead>\n",
+ " <tbody>\n",
+ " <tr>\n",
+ " <th>0</th>\n",
+ " <td>1001</td>\n",
+ " <td>Frodo</td>\n",
+ " <td>Baggins</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>123 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " <td>True</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>1</th>\n",
+ " <td>1002</td>\n",
+ " <td>Abed</td>\n",
+ " <td>Nadir</td>\n",
+ " <td>123/643/9775</td>\n",
+ " <td>93 West Main Street</td>\n",
+ " <td>No</td>\n",
+ " <td>Yes</td>\n",
+ " <td>False</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2</th>\n",
+ " <td>1003</td>\n",
+ " <td>Walter</td>\n",
+ " <td>/White</td>\n",
+ " <td>7066950392</td>\n",
+ " <td>298 Drugs Driveway</td>\n",
+ " <td>N</td>\n",
+ " <td>NaN</td>\n",
+ " <td>True</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>3</th>\n",
+ " <td>1004</td>\n",
+ " <td>Dwight</td>\n",
+ " <td>Schrute</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>980 Paper Avenue, Pennsylvania, 18503</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Y</td>\n",
+ " <td>True</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>4</th>\n",
+ " <td>1005</td>\n",
+ " <td>Jon</td>\n",
+ " <td>Snow</td>\n",
+ " <td>876|678|3469</td>\n",
+ " <td>123 Dragons Road</td>\n",
+ " <td>Y</td>\n",
+ " <td>No</td>\n",
+ " <td>True</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>5</th>\n",
+ " <td>1006</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Swanson</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>768 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Yes</td>\n",
+ " <td>True</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>6</th>\n",
+ " <td>1007</td>\n",
+ " <td>Jeff</td>\n",
+ " <td>Winger</td>\n",
+ " <td>NaN</td>\n",
+ " <td>1209 South Street</td>\n",
+ " <td>No</td>\n",
+ " <td>No</td>\n",
+ " <td>False</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>7</th>\n",
+ " <td>1008</td>\n",
+ " <td>Sherlock</td>\n",
+ " <td>Holmes</td>\n",
+ " <td>876|678|3469</td>\n",
+ " <td>98 Clue Drive</td>\n",
+ " <td>N</td>\n",
+ " <td>No</td>\n",
+ " <td>False</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>8</th>\n",
+ " <td>1009</td>\n",
+ " <td>Gandalf</td>\n",
+ " <td>NaN</td>\n",
+ " <td>N/a</td>\n",
+ " <td>123 Middle Earth</td>\n",
+ " <td>Yes</td>\n",
+ " <td>NaN</td>\n",
+ " <td>False</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>9</th>\n",
+ " <td>1010</td>\n",
+ " <td>Peter</td>\n",
+ " <td>Parker</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>25th Main Street, New York</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " <td>True</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>10</th>\n",
+ " <td>1011</td>\n",
+ " <td>Samwise</td>\n",
+ " <td>Gamgee</td>\n",
+ " <td>NaN</td>\n",
+ " <td>612 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " <td>True</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>11</th>\n",
+ " <td>1012</td>\n",
+ " <td>Harry</td>\n",
+ " <td>...Potter</td>\n",
+ " <td>7066950392</td>\n",
+ " <td>2394 Hogwarts Avenue</td>\n",
+ " <td>Y</td>\n",
+ " <td>NaN</td>\n",
+ " <td>True</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>12</th>\n",
+ " <td>1013</td>\n",
+ " <td>Don</td>\n",
+ " <td>Draper</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>2039 Main Street</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>False</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>13</th>\n",
+ " <td>1014</td>\n",
+ " <td>Leslie</td>\n",
+ " <td>Knope</td>\n",
+ " <td>876|678|3469</td>\n",
+ " <td>343 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " <td>False</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>14</th>\n",
+ " <td>1015</td>\n",
+ " <td>Toby</td>\n",
+ " <td>Flenderson_</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>214 HR Avenue</td>\n",
+ " <td>N</td>\n",
+ " <td>No</td>\n",
+ " <td>False</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>15</th>\n",
+ " <td>1016</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Weasley</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>2395 Hogwarts Avenue</td>\n",
+ " <td>No</td>\n",
+ " <td>N</td>\n",
+ " <td>False</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>16</th>\n",
+ " <td>1017</td>\n",
+ " <td>Michael</td>\n",
+ " <td>Scott</td>\n",
+ " <td>123/643/9775</td>\n",
+ " <td>121 Paper Avenue, Pennsylvania</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " <td>False</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>17</th>\n",
+ " <td>1018</td>\n",
+ " <td>Clark</td>\n",
+ " <td>Kent</td>\n",
+ " <td>7066950392</td>\n",
+ " <td>3498 Super Lane</td>\n",
+ " <td>Y</td>\n",
+ " <td>NaN</td>\n",
+ " <td>True</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>18</th>\n",
+ " <td>1019</td>\n",
+ " <td>Creed</td>\n",
+ " <td>Braton</td>\n",
+ " <td>N/a</td>\n",
+ " <td>N/a</td>\n",
+ " <td>N/a</td>\n",
+ " <td>Yes</td>\n",
+ " <td>True</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>19</th>\n",
+ " <td>1020</td>\n",
+ " <td>Anakin</td>\n",
+ " <td>Skywalker</td>\n",
+ " <td>876|678|3469</td>\n",
+ " <td>910 Tatooine Road, Tatooine</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>True</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>20</th>\n",
+ " <td>1020</td>\n",
+ " <td>Anakin</td>\n",
+ " <td>Skywalker</td>\n",
+ " <td>876|678|3469</td>\n",
+ " <td>910 Tatooine Road, Tatooine</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>True</td>\n",
+ " </tr>\n",
+ " </tbody>\n",
+ "</table>\n",
+ "</div>"
+ ],
+ "text/plain": [
+ " CustomerID First_Name Last_Name Phone_Number \\\n",
+ "0 1001 Frodo Baggins 123-545-5421 \n",
+ "1 1002 Abed Nadir 123/643/9775 \n",
+ "2 1003 Walter /White 7066950392 \n",
+ "3 1004 Dwight Schrute 123-543-2345 \n",
+ "4 1005 Jon Snow 876|678|3469 \n",
+ "5 1006 Ron Swanson 304-762-2467 \n",
+ "6 1007 Jeff Winger NaN \n",
+ "7 1008 Sherlock Holmes 876|678|3469 \n",
+ "8 1009 Gandalf NaN N/a \n",
+ "9 1010 Peter Parker 123-545-5421 \n",
+ "10 1011 Samwise Gamgee NaN \n",
+ "11 1012 Harry ...Potter 7066950392 \n",
+ "12 1013 Don Draper 123-543-2345 \n",
+ "13 1014 Leslie Knope 876|678|3469 \n",
+ "14 1015 Toby Flenderson_ 304-762-2467 \n",
+ "15 1016 Ron Weasley 123-545-5421 \n",
+ "16 1017 Michael Scott 123/643/9775 \n",
+ "17 1018 Clark Kent 7066950392 \n",
+ "18 1019 Creed Braton N/a \n",
+ "19 1020 Anakin Skywalker 876|678|3469 \n",
+ "20 1020 Anakin Skywalker 876|678|3469 \n",
+ "\n",
+ " Address Paying Customer Do_Not_Contact \\\n",
+ "0 123 Shire Lane, Shire Yes No \n",
+ "1 93 West Main Street No Yes \n",
+ "2 298 Drugs Driveway N NaN \n",
+ "3 980 Paper Avenue, Pennsylvania, 18503 Yes Y \n",
+ "4 123 Dragons Road Y No \n",
+ "5 768 City Parkway Yes Yes \n",
+ "6 1209 South Street No No \n",
+ "7 98 Clue Drive N No \n",
+ "8 123 Middle Earth Yes NaN \n",
+ "9 25th Main Street, New York Yes No \n",
+ "10 612 Shire Lane, Shire Yes No \n",
+ "11 2394 Hogwarts Avenue Y NaN \n",
+ "12 2039 Main Street Yes N \n",
+ "13 343 City Parkway Yes No \n",
+ "14 214 HR Avenue N No \n",
+ "15 2395 Hogwarts Avenue No N \n",
+ "16 121 Paper Avenue, Pennsylvania Yes No \n",
+ "17 3498 Super Lane Y NaN \n",
+ "18 N/a N/a Yes \n",
+ "19 910 Tatooine Road, Tatooine Yes N \n",
+ "20 910 Tatooine Road, Tatooine Yes N \n",
+ "\n",
+ " Not_Useful_Column \n",
+ "0 True \n",
+ "1 False \n",
+ "2 True \n",
+ "3 True \n",
+ "4 True \n",
+ "5 True \n",
+ "6 False \n",
+ "7 False \n",
+ "8 False \n",
+ "9 True \n",
+ "10 True \n",
+ "11 True \n",
+ "12 False \n",
+ "13 False \n",
+ "14 False \n",
+ "15 False \n",
+ "16 False \n",
+ "17 True \n",
+ "18 True \n",
+ "19 True \n",
+ "20 True "
+ ]
+ },
+ "execution_count": 27,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "df = pd.read_excel(r\"~/Projects/Data Cleaning/Customer Call/Customer Call List.xlsx\")\n",
+ "df"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 28,
+ "id": "8624a784",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "df = df.drop_duplicates()"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 29,
+ "id": "66259ab9",
+ "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>CustomerID</th>\n",
+ " <th>First_Name</th>\n",
+ " <th>Last_Name</th>\n",
+ " <th>Phone_Number</th>\n",
+ " <th>Address</th>\n",
+ " <th>Paying Customer</th>\n",
+ " <th>Do_Not_Contact</th>\n",
+ " </tr>\n",
+ " </thead>\n",
+ " <tbody>\n",
+ " <tr>\n",
+ " <th>0</th>\n",
+ " <td>1001</td>\n",
+ " <td>Frodo</td>\n",
+ " <td>Baggins</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>123 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>1</th>\n",
+ " <td>1002</td>\n",
+ " <td>Abed</td>\n",
+ " <td>Nadir</td>\n",
+ " <td>123/643/9775</td>\n",
+ " <td>93 West Main Street</td>\n",
+ " <td>No</td>\n",
+ " <td>Yes</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2</th>\n",
+ " <td>1003</td>\n",
+ " <td>Walter</td>\n",
+ " <td>/White</td>\n",
+ " <td>7066950392</td>\n",
+ " <td>298 Drugs Driveway</td>\n",
+ " <td>N</td>\n",
+ " <td>NaN</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>3</th>\n",
+ " <td>1004</td>\n",
+ " <td>Dwight</td>\n",
+ " <td>Schrute</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>980 Paper Avenue, Pennsylvania, 18503</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Y</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>4</th>\n",
+ " <td>1005</td>\n",
+ " <td>Jon</td>\n",
+ " <td>Snow</td>\n",
+ " <td>876|678|3469</td>\n",
+ " <td>123 Dragons Road</td>\n",
+ " <td>Y</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>5</th>\n",
+ " <td>1006</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Swanson</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>768 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Yes</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>6</th>\n",
+ " <td>1007</td>\n",
+ " <td>Jeff</td>\n",
+ " <td>Winger</td>\n",
+ " <td>NaN</td>\n",
+ " <td>1209 South Street</td>\n",
+ " <td>No</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>7</th>\n",
+ " <td>1008</td>\n",
+ " <td>Sherlock</td>\n",
+ " <td>Holmes</td>\n",
+ " <td>876|678|3469</td>\n",
+ " <td>98 Clue Drive</td>\n",
+ " <td>N</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>8</th>\n",
+ " <td>1009</td>\n",
+ " <td>Gandalf</td>\n",
+ " <td>NaN</td>\n",
+ " <td>N/a</td>\n",
+ " <td>123 Middle Earth</td>\n",
+ " <td>Yes</td>\n",
+ " <td>NaN</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>9</th>\n",
+ " <td>1010</td>\n",
+ " <td>Peter</td>\n",
+ " <td>Parker</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>25th Main Street, New York</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>10</th>\n",
+ " <td>1011</td>\n",
+ " <td>Samwise</td>\n",
+ " <td>Gamgee</td>\n",
+ " <td>NaN</td>\n",
+ " <td>612 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>11</th>\n",
+ " <td>1012</td>\n",
+ " <td>Harry</td>\n",
+ " <td>...Potter</td>\n",
+ " <td>7066950392</td>\n",
+ " <td>2394 Hogwarts Avenue</td>\n",
+ " <td>Y</td>\n",
+ " <td>NaN</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>12</th>\n",
+ " <td>1013</td>\n",
+ " <td>Don</td>\n",
+ " <td>Draper</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>2039 Main Street</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>13</th>\n",
+ " <td>1014</td>\n",
+ " <td>Leslie</td>\n",
+ " <td>Knope</td>\n",
+ " <td>876|678|3469</td>\n",
+ " <td>343 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>14</th>\n",
+ " <td>1015</td>\n",
+ " <td>Toby</td>\n",
+ " <td>Flenderson_</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>214 HR Avenue</td>\n",
+ " <td>N</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>15</th>\n",
+ " <td>1016</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Weasley</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>2395 Hogwarts Avenue</td>\n",
+ " <td>No</td>\n",
+ " <td>N</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>16</th>\n",
+ " <td>1017</td>\n",
+ " <td>Michael</td>\n",
+ " <td>Scott</td>\n",
+ " <td>123/643/9775</td>\n",
+ " <td>121 Paper Avenue, Pennsylvania</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>17</th>\n",
+ " <td>1018</td>\n",
+ " <td>Clark</td>\n",
+ " <td>Kent</td>\n",
+ " <td>7066950392</td>\n",
+ " <td>3498 Super Lane</td>\n",
+ " <td>Y</td>\n",
+ " <td>NaN</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>18</th>\n",
+ " <td>1019</td>\n",
+ " <td>Creed</td>\n",
+ " <td>Braton</td>\n",
+ " <td>N/a</td>\n",
+ " <td>N/a</td>\n",
+ " <td>N/a</td>\n",
+ " <td>Yes</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>19</th>\n",
+ " <td>1020</td>\n",
+ " <td>Anakin</td>\n",
+ " <td>Skywalker</td>\n",
+ " <td>876|678|3469</td>\n",
+ " <td>910 Tatooine Road, Tatooine</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " </tr>\n",
+ " </tbody>\n",
+ "</table>\n",
+ "</div>"
+ ],
+ "text/plain": [
+ " CustomerID First_Name Last_Name Phone_Number \\\n",
+ "0 1001 Frodo Baggins 123-545-5421 \n",
+ "1 1002 Abed Nadir 123/643/9775 \n",
+ "2 1003 Walter /White 7066950392 \n",
+ "3 1004 Dwight Schrute 123-543-2345 \n",
+ "4 1005 Jon Snow 876|678|3469 \n",
+ "5 1006 Ron Swanson 304-762-2467 \n",
+ "6 1007 Jeff Winger NaN \n",
+ "7 1008 Sherlock Holmes 876|678|3469 \n",
+ "8 1009 Gandalf NaN N/a \n",
+ "9 1010 Peter Parker 123-545-5421 \n",
+ "10 1011 Samwise Gamgee NaN \n",
+ "11 1012 Harry ...Potter 7066950392 \n",
+ "12 1013 Don Draper 123-543-2345 \n",
+ "13 1014 Leslie Knope 876|678|3469 \n",
+ "14 1015 Toby Flenderson_ 304-762-2467 \n",
+ "15 1016 Ron Weasley 123-545-5421 \n",
+ "16 1017 Michael Scott 123/643/9775 \n",
+ "17 1018 Clark Kent 7066950392 \n",
+ "18 1019 Creed Braton N/a \n",
+ "19 1020 Anakin Skywalker 876|678|3469 \n",
+ "\n",
+ " Address Paying Customer Do_Not_Contact \n",
+ "0 123 Shire Lane, Shire Yes No \n",
+ "1 93 West Main Street No Yes \n",
+ "2 298 Drugs Driveway N NaN \n",
+ "3 980 Paper Avenue, Pennsylvania, 18503 Yes Y \n",
+ "4 123 Dragons Road Y No \n",
+ "5 768 City Parkway Yes Yes \n",
+ "6 1209 South Street No No \n",
+ "7 98 Clue Drive N No \n",
+ "8 123 Middle Earth Yes NaN \n",
+ "9 25th Main Street, New York Yes No \n",
+ "10 612 Shire Lane, Shire Yes No \n",
+ "11 2394 Hogwarts Avenue Y NaN \n",
+ "12 2039 Main Street Yes N \n",
+ "13 343 City Parkway Yes No \n",
+ "14 214 HR Avenue N No \n",
+ "15 2395 Hogwarts Avenue No N \n",
+ "16 121 Paper Avenue, Pennsylvania Yes No \n",
+ "17 3498 Super Lane Y NaN \n",
+ "18 N/a N/a Yes \n",
+ "19 910 Tatooine Road, Tatooine Yes N "
+ ]
+ },
+ "execution_count": 29,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "df = df.drop(columns = \"Not_Useful_Column\")\n",
+ "df"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 30,
+ "id": "e89a398d",
+ "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>CustomerID</th>\n",
+ " <th>First_Name</th>\n",
+ " <th>Last_Name</th>\n",
+ " <th>Phone_Number</th>\n",
+ " <th>Address</th>\n",
+ " <th>Paying Customer</th>\n",
+ " <th>Do_Not_Contact</th>\n",
+ " </tr>\n",
+ " </thead>\n",
+ " <tbody>\n",
+ " <tr>\n",
+ " <th>0</th>\n",
+ " <td>1001</td>\n",
+ " <td>Frodo</td>\n",
+ " <td>Baggins</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>123 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>1</th>\n",
+ " <td>1002</td>\n",
+ " <td>Abed</td>\n",
+ " <td>Nadir</td>\n",
+ " <td>123/643/9775</td>\n",
+ " <td>93 West Main Street</td>\n",
+ " <td>No</td>\n",
+ " <td>Yes</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2</th>\n",
+ " <td>1003</td>\n",
+ " <td>Walter</td>\n",
+ " <td>White</td>\n",
+ " <td>7066950392</td>\n",
+ " <td>298 Drugs Driveway</td>\n",
+ " <td>N</td>\n",
+ " <td>NaN</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>3</th>\n",
+ " <td>1004</td>\n",
+ " <td>Dwight</td>\n",
+ " <td>Schrute</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>980 Paper Avenue, Pennsylvania, 18503</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Y</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>4</th>\n",
+ " <td>1005</td>\n",
+ " <td>Jon</td>\n",
+ " <td>Snow</td>\n",
+ " <td>876|678|3469</td>\n",
+ " <td>123 Dragons Road</td>\n",
+ " <td>Y</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>5</th>\n",
+ " <td>1006</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Swanson</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>768 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Yes</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>6</th>\n",
+ " <td>1007</td>\n",
+ " <td>Jeff</td>\n",
+ " <td>Winger</td>\n",
+ " <td>NaN</td>\n",
+ " <td>1209 South Street</td>\n",
+ " <td>No</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>7</th>\n",
+ " <td>1008</td>\n",
+ " <td>Sherlock</td>\n",
+ " <td>Holmes</td>\n",
+ " <td>876|678|3469</td>\n",
+ " <td>98 Clue Drive</td>\n",
+ " <td>N</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>8</th>\n",
+ " <td>1009</td>\n",
+ " <td>Gandalf</td>\n",
+ " <td>NaN</td>\n",
+ " <td>N/a</td>\n",
+ " <td>123 Middle Earth</td>\n",
+ " <td>Yes</td>\n",
+ " <td>NaN</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>9</th>\n",
+ " <td>1010</td>\n",
+ " <td>Peter</td>\n",
+ " <td>Parker</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>25th Main Street, New York</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>10</th>\n",
+ " <td>1011</td>\n",
+ " <td>Samwise</td>\n",
+ " <td>Gamgee</td>\n",
+ " <td>NaN</td>\n",
+ " <td>612 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>11</th>\n",
+ " <td>1012</td>\n",
+ " <td>Harry</td>\n",
+ " <td>Potter</td>\n",
+ " <td>7066950392</td>\n",
+ " <td>2394 Hogwarts Avenue</td>\n",
+ " <td>Y</td>\n",
+ " <td>NaN</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>12</th>\n",
+ " <td>1013</td>\n",
+ " <td>Don</td>\n",
+ " <td>Draper</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>2039 Main Street</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>13</th>\n",
+ " <td>1014</td>\n",
+ " <td>Leslie</td>\n",
+ " <td>Knope</td>\n",
+ " <td>876|678|3469</td>\n",
+ " <td>343 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>14</th>\n",
+ " <td>1015</td>\n",
+ " <td>Toby</td>\n",
+ " <td>Flenderson</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>214 HR Avenue</td>\n",
+ " <td>N</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>15</th>\n",
+ " <td>1016</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Weasley</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>2395 Hogwarts Avenue</td>\n",
+ " <td>No</td>\n",
+ " <td>N</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>16</th>\n",
+ " <td>1017</td>\n",
+ " <td>Michael</td>\n",
+ " <td>Scott</td>\n",
+ " <td>123/643/9775</td>\n",
+ " <td>121 Paper Avenue, Pennsylvania</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>17</th>\n",
+ " <td>1018</td>\n",
+ " <td>Clark</td>\n",
+ " <td>Kent</td>\n",
+ " <td>7066950392</td>\n",
+ " <td>3498 Super Lane</td>\n",
+ " <td>Y</td>\n",
+ " <td>NaN</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>18</th>\n",
+ " <td>1019</td>\n",
+ " <td>Creed</td>\n",
+ " <td>Braton</td>\n",
+ " <td>N/a</td>\n",
+ " <td>N/a</td>\n",
+ " <td>N/a</td>\n",
+ " <td>Yes</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>19</th>\n",
+ " <td>1020</td>\n",
+ " <td>Anakin</td>\n",
+ " <td>Skywalker</td>\n",
+ " <td>876|678|3469</td>\n",
+ " <td>910 Tatooine Road, Tatooine</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " </tr>\n",
+ " </tbody>\n",
+ "</table>\n",
+ "</div>"
+ ],
+ "text/plain": [
+ " CustomerID First_Name Last_Name Phone_Number \\\n",
+ "0 1001 Frodo Baggins 123-545-5421 \n",
+ "1 1002 Abed Nadir 123/643/9775 \n",
+ "2 1003 Walter White 7066950392 \n",
+ "3 1004 Dwight Schrute 123-543-2345 \n",
+ "4 1005 Jon Snow 876|678|3469 \n",
+ "5 1006 Ron Swanson 304-762-2467 \n",
+ "6 1007 Jeff Winger NaN \n",
+ "7 1008 Sherlock Holmes 876|678|3469 \n",
+ "8 1009 Gandalf NaN N/a \n",
+ "9 1010 Peter Parker 123-545-5421 \n",
+ "10 1011 Samwise Gamgee NaN \n",
+ "11 1012 Harry Potter 7066950392 \n",
+ "12 1013 Don Draper 123-543-2345 \n",
+ "13 1014 Leslie Knope 876|678|3469 \n",
+ "14 1015 Toby Flenderson 304-762-2467 \n",
+ "15 1016 Ron Weasley 123-545-5421 \n",
+ "16 1017 Michael Scott 123/643/9775 \n",
+ "17 1018 Clark Kent 7066950392 \n",
+ "18 1019 Creed Braton N/a \n",
+ "19 1020 Anakin Skywalker 876|678|3469 \n",
+ "\n",
+ " Address Paying Customer Do_Not_Contact \n",
+ "0 123 Shire Lane, Shire Yes No \n",
+ "1 93 West Main Street No Yes \n",
+ "2 298 Drugs Driveway N NaN \n",
+ "3 980 Paper Avenue, Pennsylvania, 18503 Yes Y \n",
+ "4 123 Dragons Road Y No \n",
+ "5 768 City Parkway Yes Yes \n",
+ "6 1209 South Street No No \n",
+ "7 98 Clue Drive N No \n",
+ "8 123 Middle Earth Yes NaN \n",
+ "9 25th Main Street, New York Yes No \n",
+ "10 612 Shire Lane, Shire Yes No \n",
+ "11 2394 Hogwarts Avenue Y NaN \n",
+ "12 2039 Main Street Yes N \n",
+ "13 343 City Parkway Yes No \n",
+ "14 214 HR Avenue N No \n",
+ "15 2395 Hogwarts Avenue No N \n",
+ "16 121 Paper Avenue, Pennsylvania Yes No \n",
+ "17 3498 Super Lane Y NaN \n",
+ "18 N/a N/a Yes \n",
+ "19 910 Tatooine Road, Tatooine Yes N "
+ ]
+ },
+ "execution_count": 30,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "df[\"Last_Name\"] = df[\"Last_Name\"].str.strip(\"123._/\")\n",
+ "df"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 31,
+ "id": "e65fe734",
+ "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>CustomerID</th>\n",
+ " <th>First_Name</th>\n",
+ " <th>Last_Name</th>\n",
+ " <th>Phone_Number</th>\n",
+ " <th>Address</th>\n",
+ " <th>Paying Customer</th>\n",
+ " <th>Do_Not_Contact</th>\n",
+ " </tr>\n",
+ " </thead>\n",
+ " <tbody>\n",
+ " <tr>\n",
+ " <th>0</th>\n",
+ " <td>1001</td>\n",
+ " <td>Frodo</td>\n",
+ " <td>Baggins</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>123 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>1</th>\n",
+ " <td>1002</td>\n",
+ " <td>Abed</td>\n",
+ " <td>Nadir</td>\n",
+ " <td>123-643-9775</td>\n",
+ " <td>93 West Main Street</td>\n",
+ " <td>No</td>\n",
+ " <td>Yes</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2</th>\n",
+ " <td>1003</td>\n",
+ " <td>Walter</td>\n",
+ " <td>White</td>\n",
+ " <td></td>\n",
+ " <td>298 Drugs Driveway</td>\n",
+ " <td>N</td>\n",
+ " <td>NaN</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>3</th>\n",
+ " <td>1004</td>\n",
+ " <td>Dwight</td>\n",
+ " <td>Schrute</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>980 Paper Avenue, Pennsylvania, 18503</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Y</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>4</th>\n",
+ " <td>1005</td>\n",
+ " <td>Jon</td>\n",
+ " <td>Snow</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>123 Dragons Road</td>\n",
+ " <td>Y</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>5</th>\n",
+ " <td>1006</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Swanson</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>768 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Yes</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>6</th>\n",
+ " <td>1007</td>\n",
+ " <td>Jeff</td>\n",
+ " <td>Winger</td>\n",
+ " <td></td>\n",
+ " <td>1209 South Street</td>\n",
+ " <td>No</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>7</th>\n",
+ " <td>1008</td>\n",
+ " <td>Sherlock</td>\n",
+ " <td>Holmes</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>98 Clue Drive</td>\n",
+ " <td>N</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>8</th>\n",
+ " <td>1009</td>\n",
+ " <td>Gandalf</td>\n",
+ " <td>NaN</td>\n",
+ " <td></td>\n",
+ " <td>123 Middle Earth</td>\n",
+ " <td>Yes</td>\n",
+ " <td>NaN</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>9</th>\n",
+ " <td>1010</td>\n",
+ " <td>Peter</td>\n",
+ " <td>Parker</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>25th Main Street, New York</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>10</th>\n",
+ " <td>1011</td>\n",
+ " <td>Samwise</td>\n",
+ " <td>Gamgee</td>\n",
+ " <td></td>\n",
+ " <td>612 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>11</th>\n",
+ " <td>1012</td>\n",
+ " <td>Harry</td>\n",
+ " <td>Potter</td>\n",
+ " <td></td>\n",
+ " <td>2394 Hogwarts Avenue</td>\n",
+ " <td>Y</td>\n",
+ " <td>NaN</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>12</th>\n",
+ " <td>1013</td>\n",
+ " <td>Don</td>\n",
+ " <td>Draper</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>2039 Main Street</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>13</th>\n",
+ " <td>1014</td>\n",
+ " <td>Leslie</td>\n",
+ " <td>Knope</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>343 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>14</th>\n",
+ " <td>1015</td>\n",
+ " <td>Toby</td>\n",
+ " <td>Flenderson</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>214 HR Avenue</td>\n",
+ " <td>N</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>15</th>\n",
+ " <td>1016</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Weasley</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>2395 Hogwarts Avenue</td>\n",
+ " <td>No</td>\n",
+ " <td>N</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>16</th>\n",
+ " <td>1017</td>\n",
+ " <td>Michael</td>\n",
+ " <td>Scott</td>\n",
+ " <td>123-643-9775</td>\n",
+ " <td>121 Paper Avenue, Pennsylvania</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>17</th>\n",
+ " <td>1018</td>\n",
+ " <td>Clark</td>\n",
+ " <td>Kent</td>\n",
+ " <td></td>\n",
+ " <td>3498 Super Lane</td>\n",
+ " <td>Y</td>\n",
+ " <td>NaN</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>18</th>\n",
+ " <td>1019</td>\n",
+ " <td>Creed</td>\n",
+ " <td>Braton</td>\n",
+ " <td></td>\n",
+ " <td>N/a</td>\n",
+ " <td>N/a</td>\n",
+ " <td>Yes</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>19</th>\n",
+ " <td>1020</td>\n",
+ " <td>Anakin</td>\n",
+ " <td>Skywalker</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>910 Tatooine Road, Tatooine</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " </tr>\n",
+ " </tbody>\n",
+ "</table>\n",
+ "</div>"
+ ],
+ "text/plain": [
+ " CustomerID First_Name Last_Name Phone_Number \\\n",
+ "0 1001 Frodo Baggins 123-545-5421 \n",
+ "1 1002 Abed Nadir 123-643-9775 \n",
+ "2 1003 Walter White \n",
+ "3 1004 Dwight Schrute 123-543-2345 \n",
+ "4 1005 Jon Snow 876-678-3469 \n",
+ "5 1006 Ron Swanson 304-762-2467 \n",
+ "6 1007 Jeff Winger \n",
+ "7 1008 Sherlock Holmes 876-678-3469 \n",
+ "8 1009 Gandalf NaN \n",
+ "9 1010 Peter Parker 123-545-5421 \n",
+ "10 1011 Samwise Gamgee \n",
+ "11 1012 Harry Potter \n",
+ "12 1013 Don Draper 123-543-2345 \n",
+ "13 1014 Leslie Knope 876-678-3469 \n",
+ "14 1015 Toby Flenderson 304-762-2467 \n",
+ "15 1016 Ron Weasley 123-545-5421 \n",
+ "16 1017 Michael Scott 123-643-9775 \n",
+ "17 1018 Clark Kent \n",
+ "18 1019 Creed Braton \n",
+ "19 1020 Anakin Skywalker 876-678-3469 \n",
+ "\n",
+ " Address Paying Customer Do_Not_Contact \n",
+ "0 123 Shire Lane, Shire Yes No \n",
+ "1 93 West Main Street No Yes \n",
+ "2 298 Drugs Driveway N NaN \n",
+ "3 980 Paper Avenue, Pennsylvania, 18503 Yes Y \n",
+ "4 123 Dragons Road Y No \n",
+ "5 768 City Parkway Yes Yes \n",
+ "6 1209 South Street No No \n",
+ "7 98 Clue Drive N No \n",
+ "8 123 Middle Earth Yes NaN \n",
+ "9 25th Main Street, New York Yes No \n",
+ "10 612 Shire Lane, Shire Yes No \n",
+ "11 2394 Hogwarts Avenue Y NaN \n",
+ "12 2039 Main Street Yes N \n",
+ "13 343 City Parkway Yes No \n",
+ "14 214 HR Avenue N No \n",
+ "15 2395 Hogwarts Avenue No N \n",
+ "16 121 Paper Avenue, Pennsylvania Yes No \n",
+ "17 3498 Super Lane Y NaN \n",
+ "18 N/a N/a Yes \n",
+ "19 910 Tatooine Road, Tatooine Yes N "
+ ]
+ },
+ "execution_count": 31,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "df[\"Phone_Number\"] = df[\"Phone_Number\"].str.replace('[^a-zA-Z0-9]','')\n",
+ "df[\"Phone_Number\"] = df[\"Phone_Number\"].str.replace('(\\d{3})[^-](\\d{3})[^-](\\d{4})', r'\\1-\\2-\\3', regex=True)\n",
+ "df[\"Phone_Number\"] = df[\"Phone_Number\"].where(df[\"Phone_Number\"].str.match(r'\\d{3}-\\d{3}-\\d{4}'), '')\n",
+ "df"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 32,
+ "id": "c9cdb66a",
+ "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>CustomerID</th>\n",
+ " <th>First_Name</th>\n",
+ " <th>Last_Name</th>\n",
+ " <th>Phone_Number</th>\n",
+ " <th>Address</th>\n",
+ " <th>Paying Customer</th>\n",
+ " <th>Do_Not_Contact</th>\n",
+ " <th>Street_Address</th>\n",
+ " <th>State</th>\n",
+ " <th>Zip_Code</th>\n",
+ " </tr>\n",
+ " </thead>\n",
+ " <tbody>\n",
+ " <tr>\n",
+ " <th>0</th>\n",
+ " <td>1001</td>\n",
+ " <td>Frodo</td>\n",
+ " <td>Baggins</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>123 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " <td>123 Shire Lane</td>\n",
+ " <td>Shire</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>1</th>\n",
+ " <td>1002</td>\n",
+ " <td>Abed</td>\n",
+ " <td>Nadir</td>\n",
+ " <td>123-643-9775</td>\n",
+ " <td>93 West Main Street</td>\n",
+ " <td>No</td>\n",
+ " <td>Yes</td>\n",
+ " <td>93 West Main Street</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2</th>\n",
+ " <td>1003</td>\n",
+ " <td>Walter</td>\n",
+ " <td>White</td>\n",
+ " <td></td>\n",
+ " <td>298 Drugs Driveway</td>\n",
+ " <td>N</td>\n",
+ " <td>NaN</td>\n",
+ " <td>298 Drugs Driveway</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>3</th>\n",
+ " <td>1004</td>\n",
+ " <td>Dwight</td>\n",
+ " <td>Schrute</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>980 Paper Avenue, Pennsylvania, 18503</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Y</td>\n",
+ " <td>980 Paper Avenue</td>\n",
+ " <td>Pennsylvania</td>\n",
+ " <td>18503</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>4</th>\n",
+ " <td>1005</td>\n",
+ " <td>Jon</td>\n",
+ " <td>Snow</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>123 Dragons Road</td>\n",
+ " <td>Y</td>\n",
+ " <td>No</td>\n",
+ " <td>123 Dragons Road</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>5</th>\n",
+ " <td>1006</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Swanson</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>768 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Yes</td>\n",
+ " <td>768 City Parkway</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>6</th>\n",
+ " <td>1007</td>\n",
+ " <td>Jeff</td>\n",
+ " <td>Winger</td>\n",
+ " <td></td>\n",
+ " <td>1209 South Street</td>\n",
+ " <td>No</td>\n",
+ " <td>No</td>\n",
+ " <td>1209 South Street</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>7</th>\n",
+ " <td>1008</td>\n",
+ " <td>Sherlock</td>\n",
+ " <td>Holmes</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>98 Clue Drive</td>\n",
+ " <td>N</td>\n",
+ " <td>No</td>\n",
+ " <td>98 Clue Drive</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>8</th>\n",
+ " <td>1009</td>\n",
+ " <td>Gandalf</td>\n",
+ " <td>NaN</td>\n",
+ " <td></td>\n",
+ " <td>123 Middle Earth</td>\n",
+ " <td>Yes</td>\n",
+ " <td>NaN</td>\n",
+ " <td>123 Middle Earth</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>9</th>\n",
+ " <td>1010</td>\n",
+ " <td>Peter</td>\n",
+ " <td>Parker</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>25th Main Street, New York</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " <td>25th Main Street</td>\n",
+ " <td>New York</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>10</th>\n",
+ " <td>1011</td>\n",
+ " <td>Samwise</td>\n",
+ " <td>Gamgee</td>\n",
+ " <td></td>\n",
+ " <td>612 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " <td>612 Shire Lane</td>\n",
+ " <td>Shire</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>11</th>\n",
+ " <td>1012</td>\n",
+ " <td>Harry</td>\n",
+ " <td>Potter</td>\n",
+ " <td></td>\n",
+ " <td>2394 Hogwarts Avenue</td>\n",
+ " <td>Y</td>\n",
+ " <td>NaN</td>\n",
+ " <td>2394 Hogwarts Avenue</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>12</th>\n",
+ " <td>1013</td>\n",
+ " <td>Don</td>\n",
+ " <td>Draper</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>2039 Main Street</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>2039 Main Street</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>13</th>\n",
+ " <td>1014</td>\n",
+ " <td>Leslie</td>\n",
+ " <td>Knope</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>343 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " <td>343 City Parkway</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>14</th>\n",
+ " <td>1015</td>\n",
+ " <td>Toby</td>\n",
+ " <td>Flenderson</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>214 HR Avenue</td>\n",
+ " <td>N</td>\n",
+ " <td>No</td>\n",
+ " <td>214 HR Avenue</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>15</th>\n",
+ " <td>1016</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Weasley</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>2395 Hogwarts Avenue</td>\n",
+ " <td>No</td>\n",
+ " <td>N</td>\n",
+ " <td>2395 Hogwarts Avenue</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>16</th>\n",
+ " <td>1017</td>\n",
+ " <td>Michael</td>\n",
+ " <td>Scott</td>\n",
+ " <td>123-643-9775</td>\n",
+ " <td>121 Paper Avenue, Pennsylvania</td>\n",
+ " <td>Yes</td>\n",
+ " <td>No</td>\n",
+ " <td>121 Paper Avenue</td>\n",
+ " <td>Pennsylvania</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>17</th>\n",
+ " <td>1018</td>\n",
+ " <td>Clark</td>\n",
+ " <td>Kent</td>\n",
+ " <td></td>\n",
+ " <td>3498 Super Lane</td>\n",
+ " <td>Y</td>\n",
+ " <td>NaN</td>\n",
+ " <td>3498 Super Lane</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>18</th>\n",
+ " <td>1019</td>\n",
+ " <td>Creed</td>\n",
+ " <td>Braton</td>\n",
+ " <td></td>\n",
+ " <td>N/a</td>\n",
+ " <td>N/a</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N/a</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>19</th>\n",
+ " <td>1020</td>\n",
+ " <td>Anakin</td>\n",
+ " <td>Skywalker</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>910 Tatooine Road, Tatooine</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>910 Tatooine Road</td>\n",
+ " <td>Tatooine</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " </tbody>\n",
+ "</table>\n",
+ "</div>"
+ ],
+ "text/plain": [
+ " CustomerID First_Name Last_Name Phone_Number \\\n",
+ "0 1001 Frodo Baggins 123-545-5421 \n",
+ "1 1002 Abed Nadir 123-643-9775 \n",
+ "2 1003 Walter White \n",
+ "3 1004 Dwight Schrute 123-543-2345 \n",
+ "4 1005 Jon Snow 876-678-3469 \n",
+ "5 1006 Ron Swanson 304-762-2467 \n",
+ "6 1007 Jeff Winger \n",
+ "7 1008 Sherlock Holmes 876-678-3469 \n",
+ "8 1009 Gandalf NaN \n",
+ "9 1010 Peter Parker 123-545-5421 \n",
+ "10 1011 Samwise Gamgee \n",
+ "11 1012 Harry Potter \n",
+ "12 1013 Don Draper 123-543-2345 \n",
+ "13 1014 Leslie Knope 876-678-3469 \n",
+ "14 1015 Toby Flenderson 304-762-2467 \n",
+ "15 1016 Ron Weasley 123-545-5421 \n",
+ "16 1017 Michael Scott 123-643-9775 \n",
+ "17 1018 Clark Kent \n",
+ "18 1019 Creed Braton \n",
+ "19 1020 Anakin Skywalker 876-678-3469 \n",
+ "\n",
+ " Address Paying Customer Do_Not_Contact \\\n",
+ "0 123 Shire Lane, Shire Yes No \n",
+ "1 93 West Main Street No Yes \n",
+ "2 298 Drugs Driveway N NaN \n",
+ "3 980 Paper Avenue, Pennsylvania, 18503 Yes Y \n",
+ "4 123 Dragons Road Y No \n",
+ "5 768 City Parkway Yes Yes \n",
+ "6 1209 South Street No No \n",
+ "7 98 Clue Drive N No \n",
+ "8 123 Middle Earth Yes NaN \n",
+ "9 25th Main Street, New York Yes No \n",
+ "10 612 Shire Lane, Shire Yes No \n",
+ "11 2394 Hogwarts Avenue Y NaN \n",
+ "12 2039 Main Street Yes N \n",
+ "13 343 City Parkway Yes No \n",
+ "14 214 HR Avenue N No \n",
+ "15 2395 Hogwarts Avenue No N \n",
+ "16 121 Paper Avenue, Pennsylvania Yes No \n",
+ "17 3498 Super Lane Y NaN \n",
+ "18 N/a N/a Yes \n",
+ "19 910 Tatooine Road, Tatooine Yes N \n",
+ "\n",
+ " Street_Address State Zip_Code \n",
+ "0 123 Shire Lane Shire None \n",
+ "1 93 West Main Street None None \n",
+ "2 298 Drugs Driveway None None \n",
+ "3 980 Paper Avenue Pennsylvania 18503 \n",
+ "4 123 Dragons Road None None \n",
+ "5 768 City Parkway None None \n",
+ "6 1209 South Street None None \n",
+ "7 98 Clue Drive None None \n",
+ "8 123 Middle Earth None None \n",
+ "9 25th Main Street New York None \n",
+ "10 612 Shire Lane Shire None \n",
+ "11 2394 Hogwarts Avenue None None \n",
+ "12 2039 Main Street None None \n",
+ "13 343 City Parkway None None \n",
+ "14 214 HR Avenue None None \n",
+ "15 2395 Hogwarts Avenue None None \n",
+ "16 121 Paper Avenue Pennsylvania None \n",
+ "17 3498 Super Lane None None \n",
+ "18 N/a None None \n",
+ "19 910 Tatooine Road Tatooine None "
+ ]
+ },
+ "execution_count": 32,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "df[[\"Street_Address\", \"State\", \"Zip_Code\"]] = df[\"Address\"].str.split(',',n=2,expand=True)\n",
+ "df"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 33,
+ "id": "8c55b8ab",
+ "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>CustomerID</th>\n",
+ " <th>First_Name</th>\n",
+ " <th>Last_Name</th>\n",
+ " <th>Phone_Number</th>\n",
+ " <th>Address</th>\n",
+ " <th>Paying Customer</th>\n",
+ " <th>Do_Not_Contact</th>\n",
+ " <th>Street_Address</th>\n",
+ " <th>State</th>\n",
+ " <th>Zip_Code</th>\n",
+ " </tr>\n",
+ " </thead>\n",
+ " <tbody>\n",
+ " <tr>\n",
+ " <th>0</th>\n",
+ " <td>1001</td>\n",
+ " <td>Frodo</td>\n",
+ " <td>Baggins</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>123 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>123 Shire Lane</td>\n",
+ " <td>Shire</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>1</th>\n",
+ " <td>1002</td>\n",
+ " <td>Abed</td>\n",
+ " <td>Nadir</td>\n",
+ " <td>123-643-9775</td>\n",
+ " <td>93 West Main Street</td>\n",
+ " <td>No</td>\n",
+ " <td>Y</td>\n",
+ " <td>93 West Main Street</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2</th>\n",
+ " <td>1003</td>\n",
+ " <td>Walter</td>\n",
+ " <td>White</td>\n",
+ " <td></td>\n",
+ " <td>298 Drugs Driveway</td>\n",
+ " <td>N</td>\n",
+ " <td>NaN</td>\n",
+ " <td>298 Drugs Driveway</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>3</th>\n",
+ " <td>1004</td>\n",
+ " <td>Dwight</td>\n",
+ " <td>Schrute</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>980 Paper Avenue, Pennsylvania, 18503</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Y</td>\n",
+ " <td>980 Paper Avenue</td>\n",
+ " <td>Pennsylvania</td>\n",
+ " <td>18503</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>4</th>\n",
+ " <td>1005</td>\n",
+ " <td>Jon</td>\n",
+ " <td>Snow</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>123 Dragons Road</td>\n",
+ " <td>Y</td>\n",
+ " <td>N</td>\n",
+ " <td>123 Dragons Road</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>5</th>\n",
+ " <td>1006</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Swanson</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>768 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Y</td>\n",
+ " <td>768 City Parkway</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>6</th>\n",
+ " <td>1007</td>\n",
+ " <td>Jeff</td>\n",
+ " <td>Winger</td>\n",
+ " <td></td>\n",
+ " <td>1209 South Street</td>\n",
+ " <td>No</td>\n",
+ " <td>N</td>\n",
+ " <td>1209 South Street</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>7</th>\n",
+ " <td>1008</td>\n",
+ " <td>Sherlock</td>\n",
+ " <td>Holmes</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>98 Clue Drive</td>\n",
+ " <td>N</td>\n",
+ " <td>N</td>\n",
+ " <td>98 Clue Drive</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>8</th>\n",
+ " <td>1009</td>\n",
+ " <td>Gandalf</td>\n",
+ " <td>NaN</td>\n",
+ " <td></td>\n",
+ " <td>123 Middle Earth</td>\n",
+ " <td>Yes</td>\n",
+ " <td>NaN</td>\n",
+ " <td>123 Middle Earth</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>9</th>\n",
+ " <td>1010</td>\n",
+ " <td>Peter</td>\n",
+ " <td>Parker</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>25th Main Street, New York</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>25th Main Street</td>\n",
+ " <td>New York</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>10</th>\n",
+ " <td>1011</td>\n",
+ " <td>Samwise</td>\n",
+ " <td>Gamgee</td>\n",
+ " <td></td>\n",
+ " <td>612 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>612 Shire Lane</td>\n",
+ " <td>Shire</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>11</th>\n",
+ " <td>1012</td>\n",
+ " <td>Harry</td>\n",
+ " <td>Potter</td>\n",
+ " <td></td>\n",
+ " <td>2394 Hogwarts Avenue</td>\n",
+ " <td>Y</td>\n",
+ " <td>NaN</td>\n",
+ " <td>2394 Hogwarts Avenue</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>12</th>\n",
+ " <td>1013</td>\n",
+ " <td>Don</td>\n",
+ " <td>Draper</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>2039 Main Street</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>2039 Main Street</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>13</th>\n",
+ " <td>1014</td>\n",
+ " <td>Leslie</td>\n",
+ " <td>Knope</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>343 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>343 City Parkway</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>14</th>\n",
+ " <td>1015</td>\n",
+ " <td>Toby</td>\n",
+ " <td>Flenderson</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>214 HR Avenue</td>\n",
+ " <td>N</td>\n",
+ " <td>N</td>\n",
+ " <td>214 HR Avenue</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>15</th>\n",
+ " <td>1016</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Weasley</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>2395 Hogwarts Avenue</td>\n",
+ " <td>No</td>\n",
+ " <td>N</td>\n",
+ " <td>2395 Hogwarts Avenue</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>16</th>\n",
+ " <td>1017</td>\n",
+ " <td>Michael</td>\n",
+ " <td>Scott</td>\n",
+ " <td>123-643-9775</td>\n",
+ " <td>121 Paper Avenue, Pennsylvania</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>121 Paper Avenue</td>\n",
+ " <td>Pennsylvania</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>17</th>\n",
+ " <td>1018</td>\n",
+ " <td>Clark</td>\n",
+ " <td>Kent</td>\n",
+ " <td></td>\n",
+ " <td>3498 Super Lane</td>\n",
+ " <td>Y</td>\n",
+ " <td>NaN</td>\n",
+ " <td>3498 Super Lane</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>18</th>\n",
+ " <td>1019</td>\n",
+ " <td>Creed</td>\n",
+ " <td>Braton</td>\n",
+ " <td></td>\n",
+ " <td>N/a</td>\n",
+ " <td>N/a</td>\n",
+ " <td>Y</td>\n",
+ " <td>N/a</td>\n",
+ " <td>None</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>19</th>\n",
+ " <td>1020</td>\n",
+ " <td>Anakin</td>\n",
+ " <td>Skywalker</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>910 Tatooine Road, Tatooine</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>910 Tatooine Road</td>\n",
+ " <td>Tatooine</td>\n",
+ " <td>None</td>\n",
+ " </tr>\n",
+ " </tbody>\n",
+ "</table>\n",
+ "</div>"
+ ],
+ "text/plain": [
+ " CustomerID First_Name Last_Name Phone_Number \\\n",
+ "0 1001 Frodo Baggins 123-545-5421 \n",
+ "1 1002 Abed Nadir 123-643-9775 \n",
+ "2 1003 Walter White \n",
+ "3 1004 Dwight Schrute 123-543-2345 \n",
+ "4 1005 Jon Snow 876-678-3469 \n",
+ "5 1006 Ron Swanson 304-762-2467 \n",
+ "6 1007 Jeff Winger \n",
+ "7 1008 Sherlock Holmes 876-678-3469 \n",
+ "8 1009 Gandalf NaN \n",
+ "9 1010 Peter Parker 123-545-5421 \n",
+ "10 1011 Samwise Gamgee \n",
+ "11 1012 Harry Potter \n",
+ "12 1013 Don Draper 123-543-2345 \n",
+ "13 1014 Leslie Knope 876-678-3469 \n",
+ "14 1015 Toby Flenderson 304-762-2467 \n",
+ "15 1016 Ron Weasley 123-545-5421 \n",
+ "16 1017 Michael Scott 123-643-9775 \n",
+ "17 1018 Clark Kent \n",
+ "18 1019 Creed Braton \n",
+ "19 1020 Anakin Skywalker 876-678-3469 \n",
+ "\n",
+ " Address Paying Customer Do_Not_Contact \\\n",
+ "0 123 Shire Lane, Shire Yes N \n",
+ "1 93 West Main Street No Y \n",
+ "2 298 Drugs Driveway N NaN \n",
+ "3 980 Paper Avenue, Pennsylvania, 18503 Yes Y \n",
+ "4 123 Dragons Road Y N \n",
+ "5 768 City Parkway Yes Y \n",
+ "6 1209 South Street No N \n",
+ "7 98 Clue Drive N N \n",
+ "8 123 Middle Earth Yes NaN \n",
+ "9 25th Main Street, New York Yes N \n",
+ "10 612 Shire Lane, Shire Yes N \n",
+ "11 2394 Hogwarts Avenue Y NaN \n",
+ "12 2039 Main Street Yes N \n",
+ "13 343 City Parkway Yes N \n",
+ "14 214 HR Avenue N N \n",
+ "15 2395 Hogwarts Avenue No N \n",
+ "16 121 Paper Avenue, Pennsylvania Yes N \n",
+ "17 3498 Super Lane Y NaN \n",
+ "18 N/a N/a Y \n",
+ "19 910 Tatooine Road, Tatooine Yes N \n",
+ "\n",
+ " Street_Address State Zip_Code \n",
+ "0 123 Shire Lane Shire None \n",
+ "1 93 West Main Street None None \n",
+ "2 298 Drugs Driveway None None \n",
+ "3 980 Paper Avenue Pennsylvania 18503 \n",
+ "4 123 Dragons Road None None \n",
+ "5 768 City Parkway None None \n",
+ "6 1209 South Street None None \n",
+ "7 98 Clue Drive None None \n",
+ "8 123 Middle Earth None None \n",
+ "9 25th Main Street New York None \n",
+ "10 612 Shire Lane Shire None \n",
+ "11 2394 Hogwarts Avenue None None \n",
+ "12 2039 Main Street None None \n",
+ "13 343 City Parkway None None \n",
+ "14 214 HR Avenue None None \n",
+ "15 2395 Hogwarts Avenue None None \n",
+ "16 121 Paper Avenue Pennsylvania None \n",
+ "17 3498 Super Lane None None \n",
+ "18 N/a None None \n",
+ "19 910 Tatooine Road Tatooine None "
+ ]
+ },
+ "execution_count": 33,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "df[\"Do_Not_Contact\"] = df[\"Do_Not_Contact\"].str.replace('Yes','Y')\n",
+ "df[\"Do_Not_Contact\"] = df[\"Do_Not_Contact\"].str.replace('No','N')\n",
+ "df"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 34,
+ "id": "5f1f693c",
+ "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>CustomerID</th>\n",
+ " <th>First_Name</th>\n",
+ " <th>Last_Name</th>\n",
+ " <th>Phone_Number</th>\n",
+ " <th>Address</th>\n",
+ " <th>Paying Customer</th>\n",
+ " <th>Do_Not_Contact</th>\n",
+ " <th>Street_Address</th>\n",
+ " <th>State</th>\n",
+ " <th>Zip_Code</th>\n",
+ " </tr>\n",
+ " </thead>\n",
+ " <tbody>\n",
+ " <tr>\n",
+ " <th>0</th>\n",
+ " <td>1001</td>\n",
+ " <td>Frodo</td>\n",
+ " <td>Baggins</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>123 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>123 Shire Lane</td>\n",
+ " <td>Shire</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>1</th>\n",
+ " <td>1002</td>\n",
+ " <td>Abed</td>\n",
+ " <td>Nadir</td>\n",
+ " <td>123-643-9775</td>\n",
+ " <td>93 West Main Street</td>\n",
+ " <td>No</td>\n",
+ " <td>Y</td>\n",
+ " <td>93 West Main Street</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2</th>\n",
+ " <td>1003</td>\n",
+ " <td>Walter</td>\n",
+ " <td>White</td>\n",
+ " <td></td>\n",
+ " <td>298 Drugs Driveway</td>\n",
+ " <td>N</td>\n",
+ " <td></td>\n",
+ " <td>298 Drugs Driveway</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>3</th>\n",
+ " <td>1004</td>\n",
+ " <td>Dwight</td>\n",
+ " <td>Schrute</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>980 Paper Avenue, Pennsylvania, 18503</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Y</td>\n",
+ " <td>980 Paper Avenue</td>\n",
+ " <td>Pennsylvania</td>\n",
+ " <td>18503</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>4</th>\n",
+ " <td>1005</td>\n",
+ " <td>Jon</td>\n",
+ " <td>Snow</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>123 Dragons Road</td>\n",
+ " <td>Y</td>\n",
+ " <td>N</td>\n",
+ " <td>123 Dragons Road</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>5</th>\n",
+ " <td>1006</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Swanson</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>768 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Y</td>\n",
+ " <td>768 City Parkway</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>6</th>\n",
+ " <td>1007</td>\n",
+ " <td>Jeff</td>\n",
+ " <td>Winger</td>\n",
+ " <td></td>\n",
+ " <td>1209 South Street</td>\n",
+ " <td>No</td>\n",
+ " <td>N</td>\n",
+ " <td>1209 South Street</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>7</th>\n",
+ " <td>1008</td>\n",
+ " <td>Sherlock</td>\n",
+ " <td>Holmes</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>98 Clue Drive</td>\n",
+ " <td>N</td>\n",
+ " <td>N</td>\n",
+ " <td>98 Clue Drive</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>8</th>\n",
+ " <td>1009</td>\n",
+ " <td>Gandalf</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " <td>123 Middle Earth</td>\n",
+ " <td>Yes</td>\n",
+ " <td></td>\n",
+ " <td>123 Middle Earth</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>9</th>\n",
+ " <td>1010</td>\n",
+ " <td>Peter</td>\n",
+ " <td>Parker</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>25th Main Street, New York</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>25th Main Street</td>\n",
+ " <td>New York</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>10</th>\n",
+ " <td>1011</td>\n",
+ " <td>Samwise</td>\n",
+ " <td>Gamgee</td>\n",
+ " <td></td>\n",
+ " <td>612 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>612 Shire Lane</td>\n",
+ " <td>Shire</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>11</th>\n",
+ " <td>1012</td>\n",
+ " <td>Harry</td>\n",
+ " <td>Potter</td>\n",
+ " <td></td>\n",
+ " <td>2394 Hogwarts Avenue</td>\n",
+ " <td>Y</td>\n",
+ " <td></td>\n",
+ " <td>2394 Hogwarts Avenue</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>12</th>\n",
+ " <td>1013</td>\n",
+ " <td>Don</td>\n",
+ " <td>Draper</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>2039 Main Street</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>2039 Main Street</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>13</th>\n",
+ " <td>1014</td>\n",
+ " <td>Leslie</td>\n",
+ " <td>Knope</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>343 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>343 City Parkway</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>14</th>\n",
+ " <td>1015</td>\n",
+ " <td>Toby</td>\n",
+ " <td>Flenderson</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>214 HR Avenue</td>\n",
+ " <td>N</td>\n",
+ " <td>N</td>\n",
+ " <td>214 HR Avenue</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>15</th>\n",
+ " <td>1016</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Weasley</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>2395 Hogwarts Avenue</td>\n",
+ " <td>No</td>\n",
+ " <td>N</td>\n",
+ " <td>2395 Hogwarts Avenue</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>16</th>\n",
+ " <td>1017</td>\n",
+ " <td>Michael</td>\n",
+ " <td>Scott</td>\n",
+ " <td>123-643-9775</td>\n",
+ " <td>121 Paper Avenue, Pennsylvania</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>121 Paper Avenue</td>\n",
+ " <td>Pennsylvania</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>17</th>\n",
+ " <td>1018</td>\n",
+ " <td>Clark</td>\n",
+ " <td>Kent</td>\n",
+ " <td></td>\n",
+ " <td>3498 Super Lane</td>\n",
+ " <td>Y</td>\n",
+ " <td></td>\n",
+ " <td>3498 Super Lane</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>18</th>\n",
+ " <td>1019</td>\n",
+ " <td>Creed</td>\n",
+ " <td>Braton</td>\n",
+ " <td></td>\n",
+ " <td>N/a</td>\n",
+ " <td>N/a</td>\n",
+ " <td>Y</td>\n",
+ " <td>N/a</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>19</th>\n",
+ " <td>1020</td>\n",
+ " <td>Anakin</td>\n",
+ " <td>Skywalker</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>910 Tatooine Road, Tatooine</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>910 Tatooine Road</td>\n",
+ " <td>Tatooine</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " </tbody>\n",
+ "</table>\n",
+ "</div>"
+ ],
+ "text/plain": [
+ " CustomerID First_Name Last_Name Phone_Number \\\n",
+ "0 1001 Frodo Baggins 123-545-5421 \n",
+ "1 1002 Abed Nadir 123-643-9775 \n",
+ "2 1003 Walter White \n",
+ "3 1004 Dwight Schrute 123-543-2345 \n",
+ "4 1005 Jon Snow 876-678-3469 \n",
+ "5 1006 Ron Swanson 304-762-2467 \n",
+ "6 1007 Jeff Winger \n",
+ "7 1008 Sherlock Holmes 876-678-3469 \n",
+ "8 1009 Gandalf \n",
+ "9 1010 Peter Parker 123-545-5421 \n",
+ "10 1011 Samwise Gamgee \n",
+ "11 1012 Harry Potter \n",
+ "12 1013 Don Draper 123-543-2345 \n",
+ "13 1014 Leslie Knope 876-678-3469 \n",
+ "14 1015 Toby Flenderson 304-762-2467 \n",
+ "15 1016 Ron Weasley 123-545-5421 \n",
+ "16 1017 Michael Scott 123-643-9775 \n",
+ "17 1018 Clark Kent \n",
+ "18 1019 Creed Braton \n",
+ "19 1020 Anakin Skywalker 876-678-3469 \n",
+ "\n",
+ " Address Paying Customer Do_Not_Contact \\\n",
+ "0 123 Shire Lane, Shire Yes N \n",
+ "1 93 West Main Street No Y \n",
+ "2 298 Drugs Driveway N \n",
+ "3 980 Paper Avenue, Pennsylvania, 18503 Yes Y \n",
+ "4 123 Dragons Road Y N \n",
+ "5 768 City Parkway Yes Y \n",
+ "6 1209 South Street No N \n",
+ "7 98 Clue Drive N N \n",
+ "8 123 Middle Earth Yes \n",
+ "9 25th Main Street, New York Yes N \n",
+ "10 612 Shire Lane, Shire Yes N \n",
+ "11 2394 Hogwarts Avenue Y \n",
+ "12 2039 Main Street Yes N \n",
+ "13 343 City Parkway Yes N \n",
+ "14 214 HR Avenue N N \n",
+ "15 2395 Hogwarts Avenue No N \n",
+ "16 121 Paper Avenue, Pennsylvania Yes N \n",
+ "17 3498 Super Lane Y \n",
+ "18 N/a N/a Y \n",
+ "19 910 Tatooine Road, Tatooine Yes N \n",
+ "\n",
+ " Street_Address State Zip_Code \n",
+ "0 123 Shire Lane Shire \n",
+ "1 93 West Main Street \n",
+ "2 298 Drugs Driveway \n",
+ "3 980 Paper Avenue Pennsylvania 18503 \n",
+ "4 123 Dragons Road \n",
+ "5 768 City Parkway \n",
+ "6 1209 South Street \n",
+ "7 98 Clue Drive \n",
+ "8 123 Middle Earth \n",
+ "9 25th Main Street New York \n",
+ "10 612 Shire Lane Shire \n",
+ "11 2394 Hogwarts Avenue \n",
+ "12 2039 Main Street \n",
+ "13 343 City Parkway \n",
+ "14 214 HR Avenue \n",
+ "15 2395 Hogwarts Avenue \n",
+ "16 121 Paper Avenue Pennsylvania \n",
+ "17 3498 Super Lane \n",
+ "18 N/a \n",
+ "19 910 Tatooine Road Tatooine "
+ ]
+ },
+ "execution_count": 34,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "df=df.fillna('')\n",
+ "df"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 35,
+ "id": "2785de92",
+ "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>CustomerID</th>\n",
+ " <th>First_Name</th>\n",
+ " <th>Last_Name</th>\n",
+ " <th>Phone_Number</th>\n",
+ " <th>Address</th>\n",
+ " <th>Paying Customer</th>\n",
+ " <th>Do_Not_Contact</th>\n",
+ " <th>Street_Address</th>\n",
+ " <th>State</th>\n",
+ " <th>Zip_Code</th>\n",
+ " </tr>\n",
+ " </thead>\n",
+ " <tbody>\n",
+ " <tr>\n",
+ " <th>0</th>\n",
+ " <td>1001</td>\n",
+ " <td>Frodo</td>\n",
+ " <td>Baggins</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>123 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>123 Shire Lane</td>\n",
+ " <td>Shire</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>1</th>\n",
+ " <td>1002</td>\n",
+ " <td>Abed</td>\n",
+ " <td>Nadir</td>\n",
+ " <td>123-643-9775</td>\n",
+ " <td>93 West Main Street</td>\n",
+ " <td>No</td>\n",
+ " <td>Y</td>\n",
+ " <td>93 West Main Street</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2</th>\n",
+ " <td>1003</td>\n",
+ " <td>Walter</td>\n",
+ " <td>White</td>\n",
+ " <td></td>\n",
+ " <td>298 Drugs Driveway</td>\n",
+ " <td>N</td>\n",
+ " <td></td>\n",
+ " <td>298 Drugs Driveway</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>3</th>\n",
+ " <td>1004</td>\n",
+ " <td>Dwight</td>\n",
+ " <td>Schrute</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>980 Paper Avenue, Pennsylvania, 18503</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Y</td>\n",
+ " <td>980 Paper Avenue</td>\n",
+ " <td>Pennsylvania</td>\n",
+ " <td>18503</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>4</th>\n",
+ " <td>1005</td>\n",
+ " <td>Jon</td>\n",
+ " <td>Snow</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>123 Dragons Road</td>\n",
+ " <td>Y</td>\n",
+ " <td>N</td>\n",
+ " <td>123 Dragons Road</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>5</th>\n",
+ " <td>1006</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Swanson</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>768 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Y</td>\n",
+ " <td>768 City Parkway</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>6</th>\n",
+ " <td>1007</td>\n",
+ " <td>Jeff</td>\n",
+ " <td>Winger</td>\n",
+ " <td></td>\n",
+ " <td>1209 South Street</td>\n",
+ " <td>No</td>\n",
+ " <td>N</td>\n",
+ " <td>1209 South Street</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>7</th>\n",
+ " <td>1008</td>\n",
+ " <td>Sherlock</td>\n",
+ " <td>Holmes</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>98 Clue Drive</td>\n",
+ " <td>N</td>\n",
+ " <td>N</td>\n",
+ " <td>98 Clue Drive</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>8</th>\n",
+ " <td>1009</td>\n",
+ " <td>Gandalf</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " <td>123 Middle Earth</td>\n",
+ " <td>Yes</td>\n",
+ " <td></td>\n",
+ " <td>123 Middle Earth</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>9</th>\n",
+ " <td>1010</td>\n",
+ " <td>Peter</td>\n",
+ " <td>Parker</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>25th Main Street, New York</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>25th Main Street</td>\n",
+ " <td>New York</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>10</th>\n",
+ " <td>1011</td>\n",
+ " <td>Samwise</td>\n",
+ " <td>Gamgee</td>\n",
+ " <td></td>\n",
+ " <td>612 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>612 Shire Lane</td>\n",
+ " <td>Shire</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>11</th>\n",
+ " <td>1012</td>\n",
+ " <td>Harry</td>\n",
+ " <td>Potter</td>\n",
+ " <td></td>\n",
+ " <td>2394 Hogwarts Avenue</td>\n",
+ " <td>Y</td>\n",
+ " <td></td>\n",
+ " <td>2394 Hogwarts Avenue</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>12</th>\n",
+ " <td>1013</td>\n",
+ " <td>Don</td>\n",
+ " <td>Draper</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>2039 Main Street</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>2039 Main Street</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>13</th>\n",
+ " <td>1014</td>\n",
+ " <td>Leslie</td>\n",
+ " <td>Knope</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>343 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>343 City Parkway</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>14</th>\n",
+ " <td>1015</td>\n",
+ " <td>Toby</td>\n",
+ " <td>Flenderson</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>214 HR Avenue</td>\n",
+ " <td>N</td>\n",
+ " <td>N</td>\n",
+ " <td>214 HR Avenue</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>15</th>\n",
+ " <td>1016</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Weasley</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>2395 Hogwarts Avenue</td>\n",
+ " <td>No</td>\n",
+ " <td>N</td>\n",
+ " <td>2395 Hogwarts Avenue</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>16</th>\n",
+ " <td>1017</td>\n",
+ " <td>Michael</td>\n",
+ " <td>Scott</td>\n",
+ " <td>123-643-9775</td>\n",
+ " <td>121 Paper Avenue, Pennsylvania</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>121 Paper Avenue</td>\n",
+ " <td>Pennsylvania</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>17</th>\n",
+ " <td>1018</td>\n",
+ " <td>Clark</td>\n",
+ " <td>Kent</td>\n",
+ " <td></td>\n",
+ " <td>3498 Super Lane</td>\n",
+ " <td>Y</td>\n",
+ " <td></td>\n",
+ " <td>3498 Super Lane</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>18</th>\n",
+ " <td>1019</td>\n",
+ " <td>Creed</td>\n",
+ " <td>Braton</td>\n",
+ " <td></td>\n",
+ " <td>N/a</td>\n",
+ " <td>N/a</td>\n",
+ " <td>Y</td>\n",
+ " <td>N/a</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>19</th>\n",
+ " <td>1020</td>\n",
+ " <td>Anakin</td>\n",
+ " <td>Skywalker</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>910 Tatooine Road, Tatooine</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>910 Tatooine Road</td>\n",
+ " <td>Tatooine</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " </tbody>\n",
+ "</table>\n",
+ "</div>"
+ ],
+ "text/plain": [
+ " CustomerID First_Name Last_Name Phone_Number \\\n",
+ "0 1001 Frodo Baggins 123-545-5421 \n",
+ "1 1002 Abed Nadir 123-643-9775 \n",
+ "2 1003 Walter White \n",
+ "3 1004 Dwight Schrute 123-543-2345 \n",
+ "4 1005 Jon Snow 876-678-3469 \n",
+ "5 1006 Ron Swanson 304-762-2467 \n",
+ "6 1007 Jeff Winger \n",
+ "7 1008 Sherlock Holmes 876-678-3469 \n",
+ "8 1009 Gandalf \n",
+ "9 1010 Peter Parker 123-545-5421 \n",
+ "10 1011 Samwise Gamgee \n",
+ "11 1012 Harry Potter \n",
+ "12 1013 Don Draper 123-543-2345 \n",
+ "13 1014 Leslie Knope 876-678-3469 \n",
+ "14 1015 Toby Flenderson 304-762-2467 \n",
+ "15 1016 Ron Weasley 123-545-5421 \n",
+ "16 1017 Michael Scott 123-643-9775 \n",
+ "17 1018 Clark Kent \n",
+ "18 1019 Creed Braton \n",
+ "19 1020 Anakin Skywalker 876-678-3469 \n",
+ "\n",
+ " Address Paying Customer Do_Not_Contact \\\n",
+ "0 123 Shire Lane, Shire Yes N \n",
+ "1 93 West Main Street No Y \n",
+ "2 298 Drugs Driveway N \n",
+ "3 980 Paper Avenue, Pennsylvania, 18503 Yes Y \n",
+ "4 123 Dragons Road Y N \n",
+ "5 768 City Parkway Yes Y \n",
+ "6 1209 South Street No N \n",
+ "7 98 Clue Drive N N \n",
+ "8 123 Middle Earth Yes \n",
+ "9 25th Main Street, New York Yes N \n",
+ "10 612 Shire Lane, Shire Yes N \n",
+ "11 2394 Hogwarts Avenue Y \n",
+ "12 2039 Main Street Yes N \n",
+ "13 343 City Parkway Yes N \n",
+ "14 214 HR Avenue N N \n",
+ "15 2395 Hogwarts Avenue No N \n",
+ "16 121 Paper Avenue, Pennsylvania Yes N \n",
+ "17 3498 Super Lane Y \n",
+ "18 N/a N/a Y \n",
+ "19 910 Tatooine Road, Tatooine Yes N \n",
+ "\n",
+ " Street_Address State Zip_Code \n",
+ "0 123 Shire Lane Shire \n",
+ "1 93 West Main Street \n",
+ "2 298 Drugs Driveway \n",
+ "3 980 Paper Avenue Pennsylvania 18503 \n",
+ "4 123 Dragons Road \n",
+ "5 768 City Parkway \n",
+ "6 1209 South Street \n",
+ "7 98 Clue Drive \n",
+ "8 123 Middle Earth \n",
+ "9 25th Main Street New York \n",
+ "10 612 Shire Lane Shire \n",
+ "11 2394 Hogwarts Avenue \n",
+ "12 2039 Main Street \n",
+ "13 343 City Parkway \n",
+ "14 214 HR Avenue \n",
+ "15 2395 Hogwarts Avenue \n",
+ "16 121 Paper Avenue Pennsylvania \n",
+ "17 3498 Super Lane \n",
+ "18 N/a \n",
+ "19 910 Tatooine Road Tatooine "
+ ]
+ },
+ "execution_count": 35,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "df.dropna(subset=\"Do_Not_Contact\", inplace=True)\n",
+ "df"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 36,
+ "id": "e6abe261",
+ "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>CustomerID</th>\n",
+ " <th>First_Name</th>\n",
+ " <th>Last_Name</th>\n",
+ " <th>Phone_Number</th>\n",
+ " <th>Address</th>\n",
+ " <th>Paying Customer</th>\n",
+ " <th>Do_Not_Contact</th>\n",
+ " <th>Street_Address</th>\n",
+ " <th>State</th>\n",
+ " <th>Zip_Code</th>\n",
+ " </tr>\n",
+ " </thead>\n",
+ " <tbody>\n",
+ " <tr>\n",
+ " <th>0</th>\n",
+ " <td>1001</td>\n",
+ " <td>Frodo</td>\n",
+ " <td>Baggins</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>123 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>123 Shire Lane</td>\n",
+ " <td>Shire</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>1</th>\n",
+ " <td>1002</td>\n",
+ " <td>Abed</td>\n",
+ " <td>Nadir</td>\n",
+ " <td>123-643-9775</td>\n",
+ " <td>93 West Main Street</td>\n",
+ " <td>No</td>\n",
+ " <td>Y</td>\n",
+ " <td>93 West Main Street</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2</th>\n",
+ " <td>1003</td>\n",
+ " <td>Walter</td>\n",
+ " <td>White</td>\n",
+ " <td></td>\n",
+ " <td>298 Drugs Driveway</td>\n",
+ " <td>N</td>\n",
+ " <td></td>\n",
+ " <td>298 Drugs Driveway</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>3</th>\n",
+ " <td>1004</td>\n",
+ " <td>Dwight</td>\n",
+ " <td>Schrute</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>980 Paper Avenue, Pennsylvania, 18503</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Y</td>\n",
+ " <td>980 Paper Avenue</td>\n",
+ " <td>Pennsylvania</td>\n",
+ " <td>18503</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>4</th>\n",
+ " <td>1005</td>\n",
+ " <td>Jon</td>\n",
+ " <td>Snow</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>123 Dragons Road</td>\n",
+ " <td>Y</td>\n",
+ " <td>N</td>\n",
+ " <td>123 Dragons Road</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>5</th>\n",
+ " <td>1006</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Swanson</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>768 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Y</td>\n",
+ " <td>768 City Parkway</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>6</th>\n",
+ " <td>1007</td>\n",
+ " <td>Jeff</td>\n",
+ " <td>Winger</td>\n",
+ " <td></td>\n",
+ " <td>1209 South Street</td>\n",
+ " <td>No</td>\n",
+ " <td>N</td>\n",
+ " <td>1209 South Street</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>7</th>\n",
+ " <td>1008</td>\n",
+ " <td>Sherlock</td>\n",
+ " <td>Holmes</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>98 Clue Drive</td>\n",
+ " <td>N</td>\n",
+ " <td>N</td>\n",
+ " <td>98 Clue Drive</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>8</th>\n",
+ " <td>1009</td>\n",
+ " <td>Gandalf</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " <td>123 Middle Earth</td>\n",
+ " <td>Yes</td>\n",
+ " <td></td>\n",
+ " <td>123 Middle Earth</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>9</th>\n",
+ " <td>1010</td>\n",
+ " <td>Peter</td>\n",
+ " <td>Parker</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>25th Main Street, New York</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>25th Main Street</td>\n",
+ " <td>New York</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>10</th>\n",
+ " <td>1011</td>\n",
+ " <td>Samwise</td>\n",
+ " <td>Gamgee</td>\n",
+ " <td></td>\n",
+ " <td>612 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>612 Shire Lane</td>\n",
+ " <td>Shire</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>11</th>\n",
+ " <td>1012</td>\n",
+ " <td>Harry</td>\n",
+ " <td>Potter</td>\n",
+ " <td></td>\n",
+ " <td>2394 Hogwarts Avenue</td>\n",
+ " <td>Y</td>\n",
+ " <td></td>\n",
+ " <td>2394 Hogwarts Avenue</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>12</th>\n",
+ " <td>1013</td>\n",
+ " <td>Don</td>\n",
+ " <td>Draper</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>2039 Main Street</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>2039 Main Street</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>13</th>\n",
+ " <td>1014</td>\n",
+ " <td>Leslie</td>\n",
+ " <td>Knope</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>343 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>343 City Parkway</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>14</th>\n",
+ " <td>1015</td>\n",
+ " <td>Toby</td>\n",
+ " <td>Flenderson</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>214 HR Avenue</td>\n",
+ " <td>N</td>\n",
+ " <td>N</td>\n",
+ " <td>214 HR Avenue</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>15</th>\n",
+ " <td>1016</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Weasley</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>2395 Hogwarts Avenue</td>\n",
+ " <td>No</td>\n",
+ " <td>N</td>\n",
+ " <td>2395 Hogwarts Avenue</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>16</th>\n",
+ " <td>1017</td>\n",
+ " <td>Michael</td>\n",
+ " <td>Scott</td>\n",
+ " <td>123-643-9775</td>\n",
+ " <td>121 Paper Avenue, Pennsylvania</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>121 Paper Avenue</td>\n",
+ " <td>Pennsylvania</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>17</th>\n",
+ " <td>1018</td>\n",
+ " <td>Clark</td>\n",
+ " <td>Kent</td>\n",
+ " <td></td>\n",
+ " <td>3498 Super Lane</td>\n",
+ " <td>Y</td>\n",
+ " <td></td>\n",
+ " <td>3498 Super Lane</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>18</th>\n",
+ " <td>1019</td>\n",
+ " <td>Creed</td>\n",
+ " <td>Braton</td>\n",
+ " <td></td>\n",
+ " <td>N/a</td>\n",
+ " <td>N/a</td>\n",
+ " <td>Y</td>\n",
+ " <td>N/a</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>19</th>\n",
+ " <td>1020</td>\n",
+ " <td>Anakin</td>\n",
+ " <td>Skywalker</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>910 Tatooine Road, Tatooine</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>910 Tatooine Road</td>\n",
+ " <td>Tatooine</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " </tbody>\n",
+ "</table>\n",
+ "</div>"
+ ],
+ "text/plain": [
+ " CustomerID First_Name Last_Name Phone_Number \\\n",
+ "0 1001 Frodo Baggins 123-545-5421 \n",
+ "1 1002 Abed Nadir 123-643-9775 \n",
+ "2 1003 Walter White \n",
+ "3 1004 Dwight Schrute 123-543-2345 \n",
+ "4 1005 Jon Snow 876-678-3469 \n",
+ "5 1006 Ron Swanson 304-762-2467 \n",
+ "6 1007 Jeff Winger \n",
+ "7 1008 Sherlock Holmes 876-678-3469 \n",
+ "8 1009 Gandalf \n",
+ "9 1010 Peter Parker 123-545-5421 \n",
+ "10 1011 Samwise Gamgee \n",
+ "11 1012 Harry Potter \n",
+ "12 1013 Don Draper 123-543-2345 \n",
+ "13 1014 Leslie Knope 876-678-3469 \n",
+ "14 1015 Toby Flenderson 304-762-2467 \n",
+ "15 1016 Ron Weasley 123-545-5421 \n",
+ "16 1017 Michael Scott 123-643-9775 \n",
+ "17 1018 Clark Kent \n",
+ "18 1019 Creed Braton \n",
+ "19 1020 Anakin Skywalker 876-678-3469 \n",
+ "\n",
+ " Address Paying Customer Do_Not_Contact \\\n",
+ "0 123 Shire Lane, Shire Yes N \n",
+ "1 93 West Main Street No Y \n",
+ "2 298 Drugs Driveway N \n",
+ "3 980 Paper Avenue, Pennsylvania, 18503 Yes Y \n",
+ "4 123 Dragons Road Y N \n",
+ "5 768 City Parkway Yes Y \n",
+ "6 1209 South Street No N \n",
+ "7 98 Clue Drive N N \n",
+ "8 123 Middle Earth Yes \n",
+ "9 25th Main Street, New York Yes N \n",
+ "10 612 Shire Lane, Shire Yes N \n",
+ "11 2394 Hogwarts Avenue Y \n",
+ "12 2039 Main Street Yes N \n",
+ "13 343 City Parkway Yes N \n",
+ "14 214 HR Avenue N N \n",
+ "15 2395 Hogwarts Avenue No N \n",
+ "16 121 Paper Avenue, Pennsylvania Yes N \n",
+ "17 3498 Super Lane Y \n",
+ "18 N/a N/a Y \n",
+ "19 910 Tatooine Road, Tatooine Yes N \n",
+ "\n",
+ " Street_Address State Zip_Code \n",
+ "0 123 Shire Lane Shire \n",
+ "1 93 West Main Street \n",
+ "2 298 Drugs Driveway \n",
+ "3 980 Paper Avenue Pennsylvania 18503 \n",
+ "4 123 Dragons Road \n",
+ "5 768 City Parkway \n",
+ "6 1209 South Street \n",
+ "7 98 Clue Drive \n",
+ "8 123 Middle Earth \n",
+ "9 25th Main Street New York \n",
+ "10 612 Shire Lane Shire \n",
+ "11 2394 Hogwarts Avenue \n",
+ "12 2039 Main Street \n",
+ "13 343 City Parkway \n",
+ "14 214 HR Avenue \n",
+ "15 2395 Hogwarts Avenue \n",
+ "16 121 Paper Avenue Pennsylvania \n",
+ "17 3498 Super Lane \n",
+ "18 N/a \n",
+ "19 910 Tatooine Road Tatooine "
+ ]
+ },
+ "execution_count": 36,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "df.dropna(subset=\"Phone_Number\", inplace=True)\n",
+ "df"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 37,
+ "id": "552ef68e",
+ "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>CustomerID</th>\n",
+ " <th>First_Name</th>\n",
+ " <th>Last_Name</th>\n",
+ " <th>Phone_Number</th>\n",
+ " <th>Address</th>\n",
+ " <th>Paying Customer</th>\n",
+ " <th>Do_Not_Contact</th>\n",
+ " <th>Street_Address</th>\n",
+ " <th>State</th>\n",
+ " <th>Zip_Code</th>\n",
+ " </tr>\n",
+ " </thead>\n",
+ " <tbody>\n",
+ " <tr>\n",
+ " <th>0</th>\n",
+ " <td>1001</td>\n",
+ " <td>Frodo</td>\n",
+ " <td>Baggins</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>123 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>123 Shire Lane</td>\n",
+ " <td>Shire</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>1</th>\n",
+ " <td>1002</td>\n",
+ " <td>Abed</td>\n",
+ " <td>Nadir</td>\n",
+ " <td>123-643-9775</td>\n",
+ " <td>93 West Main Street</td>\n",
+ " <td>No</td>\n",
+ " <td>Y</td>\n",
+ " <td>93 West Main Street</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>2</th>\n",
+ " <td>1003</td>\n",
+ " <td>Walter</td>\n",
+ " <td>White</td>\n",
+ " <td></td>\n",
+ " <td>298 Drugs Driveway</td>\n",
+ " <td>N</td>\n",
+ " <td></td>\n",
+ " <td>298 Drugs Driveway</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>3</th>\n",
+ " <td>1004</td>\n",
+ " <td>Dwight</td>\n",
+ " <td>Schrute</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>980 Paper Avenue, Pennsylvania, 18503</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Y</td>\n",
+ " <td>980 Paper Avenue</td>\n",
+ " <td>Pennsylvania</td>\n",
+ " <td>18503</td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>4</th>\n",
+ " <td>1005</td>\n",
+ " <td>Jon</td>\n",
+ " <td>Snow</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>123 Dragons Road</td>\n",
+ " <td>Y</td>\n",
+ " <td>N</td>\n",
+ " <td>123 Dragons Road</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>5</th>\n",
+ " <td>1006</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Swanson</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>768 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>Y</td>\n",
+ " <td>768 City Parkway</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>6</th>\n",
+ " <td>1007</td>\n",
+ " <td>Jeff</td>\n",
+ " <td>Winger</td>\n",
+ " <td></td>\n",
+ " <td>1209 South Street</td>\n",
+ " <td>No</td>\n",
+ " <td>N</td>\n",
+ " <td>1209 South Street</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>7</th>\n",
+ " <td>1008</td>\n",
+ " <td>Sherlock</td>\n",
+ " <td>Holmes</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>98 Clue Drive</td>\n",
+ " <td>N</td>\n",
+ " <td>N</td>\n",
+ " <td>98 Clue Drive</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>8</th>\n",
+ " <td>1009</td>\n",
+ " <td>Gandalf</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " <td>123 Middle Earth</td>\n",
+ " <td>Yes</td>\n",
+ " <td></td>\n",
+ " <td>123 Middle Earth</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>9</th>\n",
+ " <td>1010</td>\n",
+ " <td>Peter</td>\n",
+ " <td>Parker</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>25th Main Street, New York</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>25th Main Street</td>\n",
+ " <td>New York</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>10</th>\n",
+ " <td>1011</td>\n",
+ " <td>Samwise</td>\n",
+ " <td>Gamgee</td>\n",
+ " <td></td>\n",
+ " <td>612 Shire Lane, Shire</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>612 Shire Lane</td>\n",
+ " <td>Shire</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>11</th>\n",
+ " <td>1012</td>\n",
+ " <td>Harry</td>\n",
+ " <td>Potter</td>\n",
+ " <td></td>\n",
+ " <td>2394 Hogwarts Avenue</td>\n",
+ " <td>Y</td>\n",
+ " <td></td>\n",
+ " <td>2394 Hogwarts Avenue</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>12</th>\n",
+ " <td>1013</td>\n",
+ " <td>Don</td>\n",
+ " <td>Draper</td>\n",
+ " <td>123-543-2345</td>\n",
+ " <td>2039 Main Street</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>2039 Main Street</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>13</th>\n",
+ " <td>1014</td>\n",
+ " <td>Leslie</td>\n",
+ " <td>Knope</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>343 City Parkway</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>343 City Parkway</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>14</th>\n",
+ " <td>1015</td>\n",
+ " <td>Toby</td>\n",
+ " <td>Flenderson</td>\n",
+ " <td>304-762-2467</td>\n",
+ " <td>214 HR Avenue</td>\n",
+ " <td>N</td>\n",
+ " <td>N</td>\n",
+ " <td>214 HR Avenue</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>15</th>\n",
+ " <td>1016</td>\n",
+ " <td>Ron</td>\n",
+ " <td>Weasley</td>\n",
+ " <td>123-545-5421</td>\n",
+ " <td>2395 Hogwarts Avenue</td>\n",
+ " <td>No</td>\n",
+ " <td>N</td>\n",
+ " <td>2395 Hogwarts Avenue</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>16</th>\n",
+ " <td>1017</td>\n",
+ " <td>Michael</td>\n",
+ " <td>Scott</td>\n",
+ " <td>123-643-9775</td>\n",
+ " <td>121 Paper Avenue, Pennsylvania</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>121 Paper Avenue</td>\n",
+ " <td>Pennsylvania</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>17</th>\n",
+ " <td>1018</td>\n",
+ " <td>Clark</td>\n",
+ " <td>Kent</td>\n",
+ " <td></td>\n",
+ " <td>3498 Super Lane</td>\n",
+ " <td>Y</td>\n",
+ " <td></td>\n",
+ " <td>3498 Super Lane</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>18</th>\n",
+ " <td>1019</td>\n",
+ " <td>Creed</td>\n",
+ " <td>Braton</td>\n",
+ " <td></td>\n",
+ " <td>N/a</td>\n",
+ " <td>N/a</td>\n",
+ " <td>Y</td>\n",
+ " <td>N/a</td>\n",
+ " <td></td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " <tr>\n",
+ " <th>19</th>\n",
+ " <td>1020</td>\n",
+ " <td>Anakin</td>\n",
+ " <td>Skywalker</td>\n",
+ " <td>876-678-3469</td>\n",
+ " <td>910 Tatooine Road, Tatooine</td>\n",
+ " <td>Yes</td>\n",
+ " <td>N</td>\n",
+ " <td>910 Tatooine Road</td>\n",
+ " <td>Tatooine</td>\n",
+ " <td></td>\n",
+ " </tr>\n",
+ " </tbody>\n",
+ "</table>\n",
+ "</div>"
+ ],
+ "text/plain": [
+ " CustomerID First_Name Last_Name Phone_Number \\\n",
+ "0 1001 Frodo Baggins 123-545-5421 \n",
+ "1 1002 Abed Nadir 123-643-9775 \n",
+ "2 1003 Walter White \n",
+ "3 1004 Dwight Schrute 123-543-2345 \n",
+ "4 1005 Jon Snow 876-678-3469 \n",
+ "5 1006 Ron Swanson 304-762-2467 \n",
+ "6 1007 Jeff Winger \n",
+ "7 1008 Sherlock Holmes 876-678-3469 \n",
+ "8 1009 Gandalf \n",
+ "9 1010 Peter Parker 123-545-5421 \n",
+ "10 1011 Samwise Gamgee \n",
+ "11 1012 Harry Potter \n",
+ "12 1013 Don Draper 123-543-2345 \n",
+ "13 1014 Leslie Knope 876-678-3469 \n",
+ "14 1015 Toby Flenderson 304-762-2467 \n",
+ "15 1016 Ron Weasley 123-545-5421 \n",
+ "16 1017 Michael Scott 123-643-9775 \n",
+ "17 1018 Clark Kent \n",
+ "18 1019 Creed Braton \n",
+ "19 1020 Anakin Skywalker 876-678-3469 \n",
+ "\n",
+ " Address Paying Customer Do_Not_Contact \\\n",
+ "0 123 Shire Lane, Shire Yes N \n",
+ "1 93 West Main Street No Y \n",
+ "2 298 Drugs Driveway N \n",
+ "3 980 Paper Avenue, Pennsylvania, 18503 Yes Y \n",
+ "4 123 Dragons Road Y N \n",
+ "5 768 City Parkway Yes Y \n",
+ "6 1209 South Street No N \n",
+ "7 98 Clue Drive N N \n",
+ "8 123 Middle Earth Yes \n",
+ "9 25th Main Street, New York Yes N \n",
+ "10 612 Shire Lane, Shire Yes N \n",
+ "11 2394 Hogwarts Avenue Y \n",
+ "12 2039 Main Street Yes N \n",
+ "13 343 City Parkway Yes N \n",
+ "14 214 HR Avenue N N \n",
+ "15 2395 Hogwarts Avenue No N \n",
+ "16 121 Paper Avenue, Pennsylvania Yes N \n",
+ "17 3498 Super Lane Y \n",
+ "18 N/a N/a Y \n",
+ "19 910 Tatooine Road, Tatooine Yes N \n",
+ "\n",
+ " Street_Address State Zip_Code \n",
+ "0 123 Shire Lane Shire \n",
+ "1 93 West Main Street \n",
+ "2 298 Drugs Driveway \n",
+ "3 980 Paper Avenue Pennsylvania 18503 \n",
+ "4 123 Dragons Road \n",
+ "5 768 City Parkway \n",
+ "6 1209 South Street \n",
+ "7 98 Clue Drive \n",
+ "8 123 Middle Earth \n",
+ "9 25th Main Street New York \n",
+ "10 612 Shire Lane Shire \n",
+ "11 2394 Hogwarts Avenue \n",
+ "12 2039 Main Street \n",
+ "13 343 City Parkway \n",
+ "14 214 HR Avenue \n",
+ "15 2395 Hogwarts Avenue \n",
+ "16 121 Paper Avenue Pennsylvania \n",
+ "17 3498 Super Lane \n",
+ "18 N/a \n",
+ "19 910 Tatooine Road Tatooine "
+ ]
+ },
+ "execution_count": 37,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "df = df.reset_index(drop=True)\n",
+ "df"
+ ]
+ }
+ ],
+ "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.11.5"
+ }
+ },
+ "nbformat": 4,
+ "nbformat_minor": 5
+}
generated by cgit v1.2.3 (git 2.39.1) at 2025-12-06 22:48:56 +0000