diff options
Diffstat (limited to 'Data Cleaning/Customer Call/.ipynb_checkpoints')
| -rw-r--r-- | Data Cleaning/Customer Call/.ipynb_checkpoints/Customer Call List-checkpoint.ipynb | 3593 |
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 +} |