From 12130bda7851770f815b1857edd1b900755bc3d6 Mon Sep 17 00:00:00 2001 From: TheSiahxyz <164138827+TheSiahxyz@users.noreply.github.com> Date: Thu, 10 Oct 2024 15:51:46 +0900 Subject: created ", created README.md --- .../Customer Call List-checkpoint.ipynb | 3593 ++++++++++++++++++++ .../Customer Call/Customer Call List.ipynb | 3593 ++++++++++++++++++++ .../Customer Call/Customer Call List.xlsx | Bin 0 -> 12692 bytes 3 files changed, 7186 insertions(+) create mode 100644 Data Cleaning/Customer Call/.ipynb_checkpoints/Customer Call List-checkpoint.ipynb create mode 100644 Data Cleaning/Customer Call/Customer Call List.ipynb create mode 100644 Data Cleaning/Customer Call/Customer Call List.xlsx (limited to 'Data Cleaning/Customer Call') 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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_ContactNot_Useful_Column
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesNoTrue
11002AbedNadir123/643/977593 West Main StreetNoYesFalse
21003Walter/White7066950392298 Drugs DrivewayNNaNTrue
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesYTrue
41005JonSnow876|678|3469123 Dragons RoadYNoTrue
51006RonSwanson304-762-2467768 City ParkwayYesYesTrue
61007JeffWingerNaN1209 South StreetNoNoFalse
71008SherlockHolmes876|678|346998 Clue DriveNNoFalse
81009GandalfNaNN/a123 Middle EarthYesNaNFalse
91010PeterParker123-545-542125th Main Street, New YorkYesNoTrue
101011SamwiseGamgeeNaN612 Shire Lane, ShireYesNoTrue
111012Harry...Potter70669503922394 Hogwarts AvenueYNaNTrue
121013DonDraper123-543-23452039 Main StreetYesNFalse
131014LeslieKnope876|678|3469343 City ParkwayYesNoFalse
141015TobyFlenderson_304-762-2467214 HR AvenueNNoFalse
151016RonWeasley123-545-54212395 Hogwarts AvenueNoNFalse
161017MichaelScott123/643/9775121 Paper Avenue, PennsylvaniaYesNoFalse
171018ClarkKent70669503923498 Super LaneYNaNTrue
181019CreedBratonN/aN/aN/aYesTrue
191020AnakinSkywalker876|678|3469910 Tatooine Road, TatooineYesNTrue
201020AnakinSkywalker876|678|3469910 Tatooine Road, TatooineYesNTrue
\n", + "
" + ], + "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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_Contact
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesNo
11002AbedNadir123/643/977593 West Main StreetNoYes
21003Walter/White7066950392298 Drugs DrivewayNNaN
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesY
41005JonSnow876|678|3469123 Dragons RoadYNo
51006RonSwanson304-762-2467768 City ParkwayYesYes
61007JeffWingerNaN1209 South StreetNoNo
71008SherlockHolmes876|678|346998 Clue DriveNNo
81009GandalfNaNN/a123 Middle EarthYesNaN
91010PeterParker123-545-542125th Main Street, New YorkYesNo
101011SamwiseGamgeeNaN612 Shire Lane, ShireYesNo
111012Harry...Potter70669503922394 Hogwarts AvenueYNaN
121013DonDraper123-543-23452039 Main StreetYesN
131014LeslieKnope876|678|3469343 City ParkwayYesNo
141015TobyFlenderson_304-762-2467214 HR AvenueNNo
151016RonWeasley123-545-54212395 Hogwarts AvenueNoN
161017MichaelScott123/643/9775121 Paper Avenue, PennsylvaniaYesNo
171018ClarkKent70669503923498 Super LaneYNaN
181019CreedBratonN/aN/aN/aYes
191020AnakinSkywalker876|678|3469910 Tatooine Road, TatooineYesN
\n", + "
" + ], + "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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_Contact
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesNo
11002AbedNadir123/643/977593 West Main StreetNoYes
21003WalterWhite7066950392298 Drugs DrivewayNNaN
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesY
41005JonSnow876|678|3469123 Dragons RoadYNo
51006RonSwanson304-762-2467768 City ParkwayYesYes
61007JeffWingerNaN1209 South StreetNoNo
71008SherlockHolmes876|678|346998 Clue DriveNNo
81009GandalfNaNN/a123 Middle EarthYesNaN
91010PeterParker123-545-542125th Main Street, New YorkYesNo
101011SamwiseGamgeeNaN612 Shire Lane, ShireYesNo
111012HarryPotter70669503922394 Hogwarts AvenueYNaN
121013DonDraper123-543-23452039 Main StreetYesN
131014LeslieKnope876|678|3469343 City ParkwayYesNo
141015TobyFlenderson304-762-2467214 HR AvenueNNo
151016RonWeasley123-545-54212395 Hogwarts AvenueNoN
161017MichaelScott123/643/9775121 Paper Avenue, PennsylvaniaYesNo
171018ClarkKent70669503923498 Super LaneYNaN
181019CreedBratonN/aN/aN/aYes
191020AnakinSkywalker876|678|3469910 Tatooine Road, TatooineYesN
\n", + "
" + ], + "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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_Contact
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesNo
11002AbedNadir123-643-977593 West Main StreetNoYes
21003WalterWhite298 Drugs DrivewayNNaN
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesY
41005JonSnow876-678-3469123 Dragons RoadYNo
51006RonSwanson304-762-2467768 City ParkwayYesYes
61007JeffWinger1209 South StreetNoNo
71008SherlockHolmes876-678-346998 Clue DriveNNo
81009GandalfNaN123 Middle EarthYesNaN
91010PeterParker123-545-542125th Main Street, New YorkYesNo
101011SamwiseGamgee612 Shire Lane, ShireYesNo
111012HarryPotter2394 Hogwarts AvenueYNaN
121013DonDraper123-543-23452039 Main StreetYesN
131014LeslieKnope876-678-3469343 City ParkwayYesNo
141015TobyFlenderson304-762-2467214 HR AvenueNNo
151016RonWeasley123-545-54212395 Hogwarts AvenueNoN
161017MichaelScott123-643-9775121 Paper Avenue, PennsylvaniaYesNo
171018ClarkKent3498 Super LaneYNaN
181019CreedBratonN/aN/aYes
191020AnakinSkywalker876-678-3469910 Tatooine Road, TatooineYesN
\n", + "
" + ], + "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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_ContactStreet_AddressStateZip_Code
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesNo123 Shire LaneShireNone
11002AbedNadir123-643-977593 West Main StreetNoYes93 West Main StreetNoneNone
21003WalterWhite298 Drugs DrivewayNNaN298 Drugs DrivewayNoneNone
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesY980 Paper AvenuePennsylvania18503
41005JonSnow876-678-3469123 Dragons RoadYNo123 Dragons RoadNoneNone
51006RonSwanson304-762-2467768 City ParkwayYesYes768 City ParkwayNoneNone
61007JeffWinger1209 South StreetNoNo1209 South StreetNoneNone
71008SherlockHolmes876-678-346998 Clue DriveNNo98 Clue DriveNoneNone
81009GandalfNaN123 Middle EarthYesNaN123 Middle EarthNoneNone
91010PeterParker123-545-542125th Main Street, New YorkYesNo25th Main StreetNew YorkNone
101011SamwiseGamgee612 Shire Lane, ShireYesNo612 Shire LaneShireNone
111012HarryPotter2394 Hogwarts AvenueYNaN2394 Hogwarts AvenueNoneNone
121013DonDraper123-543-23452039 Main StreetYesN2039 Main StreetNoneNone
131014LeslieKnope876-678-3469343 City ParkwayYesNo343 City ParkwayNoneNone
141015TobyFlenderson304-762-2467214 HR AvenueNNo214 HR AvenueNoneNone
151016RonWeasley123-545-54212395 Hogwarts AvenueNoN2395 Hogwarts AvenueNoneNone
161017MichaelScott123-643-9775121 Paper Avenue, PennsylvaniaYesNo121 Paper AvenuePennsylvaniaNone
171018ClarkKent3498 Super LaneYNaN3498 Super LaneNoneNone
181019CreedBratonN/aN/aYesN/aNoneNone
191020AnakinSkywalker876-678-3469910 Tatooine Road, TatooineYesN910 Tatooine RoadTatooineNone
\n", + "
" + ], + "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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_ContactStreet_AddressStateZip_Code
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesN123 Shire LaneShireNone
11002AbedNadir123-643-977593 West Main StreetNoY93 West Main StreetNoneNone
21003WalterWhite298 Drugs DrivewayNNaN298 Drugs DrivewayNoneNone
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesY980 Paper AvenuePennsylvania18503
41005JonSnow876-678-3469123 Dragons RoadYN123 Dragons RoadNoneNone
51006RonSwanson304-762-2467768 City ParkwayYesY768 City ParkwayNoneNone
61007JeffWinger1209 South StreetNoN1209 South StreetNoneNone
71008SherlockHolmes876-678-346998 Clue DriveNN98 Clue DriveNoneNone
81009GandalfNaN123 Middle EarthYesNaN123 Middle EarthNoneNone
91010PeterParker123-545-542125th Main Street, New YorkYesN25th Main StreetNew YorkNone
101011SamwiseGamgee612 Shire Lane, ShireYesN612 Shire LaneShireNone
111012HarryPotter2394 Hogwarts AvenueYNaN2394 Hogwarts AvenueNoneNone
121013DonDraper123-543-23452039 Main StreetYesN2039 Main StreetNoneNone
131014LeslieKnope876-678-3469343 City ParkwayYesN343 City ParkwayNoneNone
141015TobyFlenderson304-762-2467214 HR AvenueNN214 HR AvenueNoneNone
151016RonWeasley123-545-54212395 Hogwarts AvenueNoN2395 Hogwarts AvenueNoneNone
161017MichaelScott123-643-9775121 Paper Avenue, PennsylvaniaYesN121 Paper AvenuePennsylvaniaNone
171018ClarkKent3498 Super LaneYNaN3498 Super LaneNoneNone
181019CreedBratonN/aN/aYN/aNoneNone
191020AnakinSkywalker876-678-3469910 Tatooine Road, TatooineYesN910 Tatooine RoadTatooineNone
\n", + "
" + ], + "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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_ContactStreet_AddressStateZip_Code
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesN123 Shire LaneShire
11002AbedNadir123-643-977593 West Main StreetNoY93 West Main Street
21003WalterWhite298 Drugs DrivewayN298 Drugs Driveway
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesY980 Paper AvenuePennsylvania18503
41005JonSnow876-678-3469123 Dragons RoadYN123 Dragons Road
51006RonSwanson304-762-2467768 City ParkwayYesY768 City Parkway
61007JeffWinger1209 South StreetNoN1209 South Street
71008SherlockHolmes876-678-346998 Clue DriveNN98 Clue Drive
81009Gandalf123 Middle EarthYes123 Middle Earth
91010PeterParker123-545-542125th Main Street, New YorkYesN25th Main StreetNew York
101011SamwiseGamgee612 Shire Lane, ShireYesN612 Shire LaneShire
111012HarryPotter2394 Hogwarts AvenueY2394 Hogwarts Avenue
121013DonDraper123-543-23452039 Main StreetYesN2039 Main Street
131014LeslieKnope876-678-3469343 City ParkwayYesN343 City Parkway
141015TobyFlenderson304-762-2467214 HR AvenueNN214 HR Avenue
151016RonWeasley123-545-54212395 Hogwarts AvenueNoN2395 Hogwarts Avenue
161017MichaelScott123-643-9775121 Paper Avenue, PennsylvaniaYesN121 Paper AvenuePennsylvania
171018ClarkKent3498 Super LaneY3498 Super Lane
181019CreedBratonN/aN/aYN/a
191020AnakinSkywalker876-678-3469910 Tatooine Road, TatooineYesN910 Tatooine RoadTatooine
\n", + "
" + ], + "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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_ContactStreet_AddressStateZip_Code
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesN123 Shire LaneShire
11002AbedNadir123-643-977593 West Main StreetNoY93 West Main Street
21003WalterWhite298 Drugs DrivewayN298 Drugs Driveway
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesY980 Paper AvenuePennsylvania18503
41005JonSnow876-678-3469123 Dragons RoadYN123 Dragons Road
51006RonSwanson304-762-2467768 City ParkwayYesY768 City Parkway
61007JeffWinger1209 South StreetNoN1209 South Street
71008SherlockHolmes876-678-346998 Clue DriveNN98 Clue Drive
81009Gandalf123 Middle EarthYes123 Middle Earth
91010PeterParker123-545-542125th Main Street, New YorkYesN25th Main StreetNew York
101011SamwiseGamgee612 Shire Lane, ShireYesN612 Shire LaneShire
111012HarryPotter2394 Hogwarts AvenueY2394 Hogwarts Avenue
121013DonDraper123-543-23452039 Main StreetYesN2039 Main Street
131014LeslieKnope876-678-3469343 City ParkwayYesN343 City Parkway
141015TobyFlenderson304-762-2467214 HR AvenueNN214 HR Avenue
151016RonWeasley123-545-54212395 Hogwarts AvenueNoN2395 Hogwarts Avenue
161017MichaelScott123-643-9775121 Paper Avenue, PennsylvaniaYesN121 Paper AvenuePennsylvania
171018ClarkKent3498 Super LaneY3498 Super Lane
181019CreedBratonN/aN/aYN/a
191020AnakinSkywalker876-678-3469910 Tatooine Road, TatooineYesN910 Tatooine RoadTatooine
\n", + "
" + ], + "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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_ContactStreet_AddressStateZip_Code
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesN123 Shire LaneShire
11002AbedNadir123-643-977593 West Main StreetNoY93 West Main Street
21003WalterWhite298 Drugs DrivewayN298 Drugs Driveway
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesY980 Paper AvenuePennsylvania18503
41005JonSnow876-678-3469123 Dragons RoadYN123 Dragons Road
51006RonSwanson304-762-2467768 City ParkwayYesY768 City Parkway
61007JeffWinger1209 South StreetNoN1209 South Street
71008SherlockHolmes876-678-346998 Clue DriveNN98 Clue Drive
81009Gandalf123 Middle EarthYes123 Middle Earth
91010PeterParker123-545-542125th Main Street, New YorkYesN25th Main StreetNew York
101011SamwiseGamgee612 Shire Lane, ShireYesN612 Shire LaneShire
111012HarryPotter2394 Hogwarts AvenueY2394 Hogwarts Avenue
121013DonDraper123-543-23452039 Main StreetYesN2039 Main Street
131014LeslieKnope876-678-3469343 City ParkwayYesN343 City Parkway
141015TobyFlenderson304-762-2467214 HR AvenueNN214 HR Avenue
151016RonWeasley123-545-54212395 Hogwarts AvenueNoN2395 Hogwarts Avenue
161017MichaelScott123-643-9775121 Paper Avenue, PennsylvaniaYesN121 Paper AvenuePennsylvania
171018ClarkKent3498 Super LaneY3498 Super Lane
181019CreedBratonN/aN/aYN/a
191020AnakinSkywalker876-678-3469910 Tatooine Road, TatooineYesN910 Tatooine RoadTatooine
\n", + "
" + ], + "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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_ContactStreet_AddressStateZip_Code
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesN123 Shire LaneShire
11002AbedNadir123-643-977593 West Main StreetNoY93 West Main Street
21003WalterWhite298 Drugs DrivewayN298 Drugs Driveway
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesY980 Paper AvenuePennsylvania18503
41005JonSnow876-678-3469123 Dragons RoadYN123 Dragons Road
51006RonSwanson304-762-2467768 City ParkwayYesY768 City Parkway
61007JeffWinger1209 South StreetNoN1209 South Street
71008SherlockHolmes876-678-346998 Clue DriveNN98 Clue Drive
81009Gandalf123 Middle EarthYes123 Middle Earth
91010PeterParker123-545-542125th Main Street, New YorkYesN25th Main StreetNew York
101011SamwiseGamgee612 Shire Lane, ShireYesN612 Shire LaneShire
111012HarryPotter2394 Hogwarts AvenueY2394 Hogwarts Avenue
121013DonDraper123-543-23452039 Main StreetYesN2039 Main Street
131014LeslieKnope876-678-3469343 City ParkwayYesN343 City Parkway
141015TobyFlenderson304-762-2467214 HR AvenueNN214 HR Avenue
151016RonWeasley123-545-54212395 Hogwarts AvenueNoN2395 Hogwarts Avenue
161017MichaelScott123-643-9775121 Paper Avenue, PennsylvaniaYesN121 Paper AvenuePennsylvania
171018ClarkKent3498 Super LaneY3498 Super Lane
181019CreedBratonN/aN/aYN/a
191020AnakinSkywalker876-678-3469910 Tatooine Road, TatooineYesN910 Tatooine RoadTatooine
\n", + "
" + ], + "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 +} diff --git a/Data Cleaning/Customer Call/Customer Call List.ipynb b/Data Cleaning/Customer Call/Customer Call List.ipynb new file mode 100644 index 0000000..bce03ed --- /dev/null +++ b/Data Cleaning/Customer Call/Customer Call List.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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_ContactNot_Useful_Column
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesNoTrue
11002AbedNadir123/643/977593 West Main StreetNoYesFalse
21003Walter/White7066950392298 Drugs DrivewayNNaNTrue
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesYTrue
41005JonSnow876|678|3469123 Dragons RoadYNoTrue
51006RonSwanson304-762-2467768 City ParkwayYesYesTrue
61007JeffWingerNaN1209 South StreetNoNoFalse
71008SherlockHolmes876|678|346998 Clue DriveNNoFalse
81009GandalfNaNN/a123 Middle EarthYesNaNFalse
91010PeterParker123-545-542125th Main Street, New YorkYesNoTrue
101011SamwiseGamgeeNaN612 Shire Lane, ShireYesNoTrue
111012Harry...Potter70669503922394 Hogwarts AvenueYNaNTrue
121013DonDraper123-543-23452039 Main StreetYesNFalse
131014LeslieKnope876|678|3469343 City ParkwayYesNoFalse
141015TobyFlenderson_304-762-2467214 HR AvenueNNoFalse
151016RonWeasley123-545-54212395 Hogwarts AvenueNoNFalse
161017MichaelScott123/643/9775121 Paper Avenue, PennsylvaniaYesNoFalse
171018ClarkKent70669503923498 Super LaneYNaNTrue
181019CreedBratonN/aN/aN/aYesTrue
191020AnakinSkywalker876|678|3469910 Tatooine Road, TatooineYesNTrue
201020AnakinSkywalker876|678|3469910 Tatooine Road, TatooineYesNTrue
\n", + "
" + ], + "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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_Contact
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesNo
11002AbedNadir123/643/977593 West Main StreetNoYes
21003Walter/White7066950392298 Drugs DrivewayNNaN
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesY
41005JonSnow876|678|3469123 Dragons RoadYNo
51006RonSwanson304-762-2467768 City ParkwayYesYes
61007JeffWingerNaN1209 South StreetNoNo
71008SherlockHolmes876|678|346998 Clue DriveNNo
81009GandalfNaNN/a123 Middle EarthYesNaN
91010PeterParker123-545-542125th Main Street, New YorkYesNo
101011SamwiseGamgeeNaN612 Shire Lane, ShireYesNo
111012Harry...Potter70669503922394 Hogwarts AvenueYNaN
121013DonDraper123-543-23452039 Main StreetYesN
131014LeslieKnope876|678|3469343 City ParkwayYesNo
141015TobyFlenderson_304-762-2467214 HR AvenueNNo
151016RonWeasley123-545-54212395 Hogwarts AvenueNoN
161017MichaelScott123/643/9775121 Paper Avenue, PennsylvaniaYesNo
171018ClarkKent70669503923498 Super LaneYNaN
181019CreedBratonN/aN/aN/aYes
191020AnakinSkywalker876|678|3469910 Tatooine Road, TatooineYesN
\n", + "
" + ], + "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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_Contact
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesNo
11002AbedNadir123/643/977593 West Main StreetNoYes
21003WalterWhite7066950392298 Drugs DrivewayNNaN
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesY
41005JonSnow876|678|3469123 Dragons RoadYNo
51006RonSwanson304-762-2467768 City ParkwayYesYes
61007JeffWingerNaN1209 South StreetNoNo
71008SherlockHolmes876|678|346998 Clue DriveNNo
81009GandalfNaNN/a123 Middle EarthYesNaN
91010PeterParker123-545-542125th Main Street, New YorkYesNo
101011SamwiseGamgeeNaN612 Shire Lane, ShireYesNo
111012HarryPotter70669503922394 Hogwarts AvenueYNaN
121013DonDraper123-543-23452039 Main StreetYesN
131014LeslieKnope876|678|3469343 City ParkwayYesNo
141015TobyFlenderson304-762-2467214 HR AvenueNNo
151016RonWeasley123-545-54212395 Hogwarts AvenueNoN
161017MichaelScott123/643/9775121 Paper Avenue, PennsylvaniaYesNo
171018ClarkKent70669503923498 Super LaneYNaN
181019CreedBratonN/aN/aN/aYes
191020AnakinSkywalker876|678|3469910 Tatooine Road, TatooineYesN
\n", + "
" + ], + "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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_Contact
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesNo
11002AbedNadir123-643-977593 West Main StreetNoYes
21003WalterWhite298 Drugs DrivewayNNaN
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesY
41005JonSnow876-678-3469123 Dragons RoadYNo
51006RonSwanson304-762-2467768 City ParkwayYesYes
61007JeffWinger1209 South StreetNoNo
71008SherlockHolmes876-678-346998 Clue DriveNNo
81009GandalfNaN123 Middle EarthYesNaN
91010PeterParker123-545-542125th Main Street, New YorkYesNo
101011SamwiseGamgee612 Shire Lane, ShireYesNo
111012HarryPotter2394 Hogwarts AvenueYNaN
121013DonDraper123-543-23452039 Main StreetYesN
131014LeslieKnope876-678-3469343 City ParkwayYesNo
141015TobyFlenderson304-762-2467214 HR AvenueNNo
151016RonWeasley123-545-54212395 Hogwarts AvenueNoN
161017MichaelScott123-643-9775121 Paper Avenue, PennsylvaniaYesNo
171018ClarkKent3498 Super LaneYNaN
181019CreedBratonN/aN/aYes
191020AnakinSkywalker876-678-3469910 Tatooine Road, TatooineYesN
\n", + "
" + ], + "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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_ContactStreet_AddressStateZip_Code
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesNo123 Shire LaneShireNone
11002AbedNadir123-643-977593 West Main StreetNoYes93 West Main StreetNoneNone
21003WalterWhite298 Drugs DrivewayNNaN298 Drugs DrivewayNoneNone
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesY980 Paper AvenuePennsylvania18503
41005JonSnow876-678-3469123 Dragons RoadYNo123 Dragons RoadNoneNone
51006RonSwanson304-762-2467768 City ParkwayYesYes768 City ParkwayNoneNone
61007JeffWinger1209 South StreetNoNo1209 South StreetNoneNone
71008SherlockHolmes876-678-346998 Clue DriveNNo98 Clue DriveNoneNone
81009GandalfNaN123 Middle EarthYesNaN123 Middle EarthNoneNone
91010PeterParker123-545-542125th Main Street, New YorkYesNo25th Main StreetNew YorkNone
101011SamwiseGamgee612 Shire Lane, ShireYesNo612 Shire LaneShireNone
111012HarryPotter2394 Hogwarts AvenueYNaN2394 Hogwarts AvenueNoneNone
121013DonDraper123-543-23452039 Main StreetYesN2039 Main StreetNoneNone
131014LeslieKnope876-678-3469343 City ParkwayYesNo343 City ParkwayNoneNone
141015TobyFlenderson304-762-2467214 HR AvenueNNo214 HR AvenueNoneNone
151016RonWeasley123-545-54212395 Hogwarts AvenueNoN2395 Hogwarts AvenueNoneNone
161017MichaelScott123-643-9775121 Paper Avenue, PennsylvaniaYesNo121 Paper AvenuePennsylvaniaNone
171018ClarkKent3498 Super LaneYNaN3498 Super LaneNoneNone
181019CreedBratonN/aN/aYesN/aNoneNone
191020AnakinSkywalker876-678-3469910 Tatooine Road, TatooineYesN910 Tatooine RoadTatooineNone
\n", + "
" + ], + "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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_ContactStreet_AddressStateZip_Code
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesN123 Shire LaneShireNone
11002AbedNadir123-643-977593 West Main StreetNoY93 West Main StreetNoneNone
21003WalterWhite298 Drugs DrivewayNNaN298 Drugs DrivewayNoneNone
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesY980 Paper AvenuePennsylvania18503
41005JonSnow876-678-3469123 Dragons RoadYN123 Dragons RoadNoneNone
51006RonSwanson304-762-2467768 City ParkwayYesY768 City ParkwayNoneNone
61007JeffWinger1209 South StreetNoN1209 South StreetNoneNone
71008SherlockHolmes876-678-346998 Clue DriveNN98 Clue DriveNoneNone
81009GandalfNaN123 Middle EarthYesNaN123 Middle EarthNoneNone
91010PeterParker123-545-542125th Main Street, New YorkYesN25th Main StreetNew YorkNone
101011SamwiseGamgee612 Shire Lane, ShireYesN612 Shire LaneShireNone
111012HarryPotter2394 Hogwarts AvenueYNaN2394 Hogwarts AvenueNoneNone
121013DonDraper123-543-23452039 Main StreetYesN2039 Main StreetNoneNone
131014LeslieKnope876-678-3469343 City ParkwayYesN343 City ParkwayNoneNone
141015TobyFlenderson304-762-2467214 HR AvenueNN214 HR AvenueNoneNone
151016RonWeasley123-545-54212395 Hogwarts AvenueNoN2395 Hogwarts AvenueNoneNone
161017MichaelScott123-643-9775121 Paper Avenue, PennsylvaniaYesN121 Paper AvenuePennsylvaniaNone
171018ClarkKent3498 Super LaneYNaN3498 Super LaneNoneNone
181019CreedBratonN/aN/aYN/aNoneNone
191020AnakinSkywalker876-678-3469910 Tatooine Road, TatooineYesN910 Tatooine RoadTatooineNone
\n", + "
" + ], + "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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_ContactStreet_AddressStateZip_Code
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesN123 Shire LaneShire
11002AbedNadir123-643-977593 West Main StreetNoY93 West Main Street
21003WalterWhite298 Drugs DrivewayN298 Drugs Driveway
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesY980 Paper AvenuePennsylvania18503
41005JonSnow876-678-3469123 Dragons RoadYN123 Dragons Road
51006RonSwanson304-762-2467768 City ParkwayYesY768 City Parkway
61007JeffWinger1209 South StreetNoN1209 South Street
71008SherlockHolmes876-678-346998 Clue DriveNN98 Clue Drive
81009Gandalf123 Middle EarthYes123 Middle Earth
91010PeterParker123-545-542125th Main Street, New YorkYesN25th Main StreetNew York
101011SamwiseGamgee612 Shire Lane, ShireYesN612 Shire LaneShire
111012HarryPotter2394 Hogwarts AvenueY2394 Hogwarts Avenue
121013DonDraper123-543-23452039 Main StreetYesN2039 Main Street
131014LeslieKnope876-678-3469343 City ParkwayYesN343 City Parkway
141015TobyFlenderson304-762-2467214 HR AvenueNN214 HR Avenue
151016RonWeasley123-545-54212395 Hogwarts AvenueNoN2395 Hogwarts Avenue
161017MichaelScott123-643-9775121 Paper Avenue, PennsylvaniaYesN121 Paper AvenuePennsylvania
171018ClarkKent3498 Super LaneY3498 Super Lane
181019CreedBratonN/aN/aYN/a
191020AnakinSkywalker876-678-3469910 Tatooine Road, TatooineYesN910 Tatooine RoadTatooine
\n", + "
" + ], + "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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_ContactStreet_AddressStateZip_Code
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesN123 Shire LaneShire
11002AbedNadir123-643-977593 West Main StreetNoY93 West Main Street
21003WalterWhite298 Drugs DrivewayN298 Drugs Driveway
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesY980 Paper AvenuePennsylvania18503
41005JonSnow876-678-3469123 Dragons RoadYN123 Dragons Road
51006RonSwanson304-762-2467768 City ParkwayYesY768 City Parkway
61007JeffWinger1209 South StreetNoN1209 South Street
71008SherlockHolmes876-678-346998 Clue DriveNN98 Clue Drive
81009Gandalf123 Middle EarthYes123 Middle Earth
91010PeterParker123-545-542125th Main Street, New YorkYesN25th Main StreetNew York
101011SamwiseGamgee612 Shire Lane, ShireYesN612 Shire LaneShire
111012HarryPotter2394 Hogwarts AvenueY2394 Hogwarts Avenue
121013DonDraper123-543-23452039 Main StreetYesN2039 Main Street
131014LeslieKnope876-678-3469343 City ParkwayYesN343 City Parkway
141015TobyFlenderson304-762-2467214 HR AvenueNN214 HR Avenue
151016RonWeasley123-545-54212395 Hogwarts AvenueNoN2395 Hogwarts Avenue
161017MichaelScott123-643-9775121 Paper Avenue, PennsylvaniaYesN121 Paper AvenuePennsylvania
171018ClarkKent3498 Super LaneY3498 Super Lane
181019CreedBratonN/aN/aYN/a
191020AnakinSkywalker876-678-3469910 Tatooine Road, TatooineYesN910 Tatooine RoadTatooine
\n", + "
" + ], + "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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_ContactStreet_AddressStateZip_Code
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesN123 Shire LaneShire
11002AbedNadir123-643-977593 West Main StreetNoY93 West Main Street
21003WalterWhite298 Drugs DrivewayN298 Drugs Driveway
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesY980 Paper AvenuePennsylvania18503
41005JonSnow876-678-3469123 Dragons RoadYN123 Dragons Road
51006RonSwanson304-762-2467768 City ParkwayYesY768 City Parkway
61007JeffWinger1209 South StreetNoN1209 South Street
71008SherlockHolmes876-678-346998 Clue DriveNN98 Clue Drive
81009Gandalf123 Middle EarthYes123 Middle Earth
91010PeterParker123-545-542125th Main Street, New YorkYesN25th Main StreetNew York
101011SamwiseGamgee612 Shire Lane, ShireYesN612 Shire LaneShire
111012HarryPotter2394 Hogwarts AvenueY2394 Hogwarts Avenue
121013DonDraper123-543-23452039 Main StreetYesN2039 Main Street
131014LeslieKnope876-678-3469343 City ParkwayYesN343 City Parkway
141015TobyFlenderson304-762-2467214 HR AvenueNN214 HR Avenue
151016RonWeasley123-545-54212395 Hogwarts AvenueNoN2395 Hogwarts Avenue
161017MichaelScott123-643-9775121 Paper Avenue, PennsylvaniaYesN121 Paper AvenuePennsylvania
171018ClarkKent3498 Super LaneY3498 Super Lane
181019CreedBratonN/aN/aYN/a
191020AnakinSkywalker876-678-3469910 Tatooine Road, TatooineYesN910 Tatooine RoadTatooine
\n", + "
" + ], + "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": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
CustomerIDFirst_NameLast_NamePhone_NumberAddressPaying CustomerDo_Not_ContactStreet_AddressStateZip_Code
01001FrodoBaggins123-545-5421123 Shire Lane, ShireYesN123 Shire LaneShire
11002AbedNadir123-643-977593 West Main StreetNoY93 West Main Street
21003WalterWhite298 Drugs DrivewayN298 Drugs Driveway
31004DwightSchrute123-543-2345980 Paper Avenue, Pennsylvania, 18503YesY980 Paper AvenuePennsylvania18503
41005JonSnow876-678-3469123 Dragons RoadYN123 Dragons Road
51006RonSwanson304-762-2467768 City ParkwayYesY768 City Parkway
61007JeffWinger1209 South StreetNoN1209 South Street
71008SherlockHolmes876-678-346998 Clue DriveNN98 Clue Drive
81009Gandalf123 Middle EarthYes123 Middle Earth
91010PeterParker123-545-542125th Main Street, New YorkYesN25th Main StreetNew York
101011SamwiseGamgee612 Shire Lane, ShireYesN612 Shire LaneShire
111012HarryPotter2394 Hogwarts AvenueY2394 Hogwarts Avenue
121013DonDraper123-543-23452039 Main StreetYesN2039 Main Street
131014LeslieKnope876-678-3469343 City ParkwayYesN343 City Parkway
141015TobyFlenderson304-762-2467214 HR AvenueNN214 HR Avenue
151016RonWeasley123-545-54212395 Hogwarts AvenueNoN2395 Hogwarts Avenue
161017MichaelScott123-643-9775121 Paper Avenue, PennsylvaniaYesN121 Paper AvenuePennsylvania
171018ClarkKent3498 Super LaneY3498 Super Lane
181019CreedBratonN/aN/aYN/a
191020AnakinSkywalker876-678-3469910 Tatooine Road, TatooineYesN910 Tatooine RoadTatooine
\n", + "
" + ], + "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 +} diff --git a/Data Cleaning/Customer Call/Customer Call List.xlsx b/Data Cleaning/Customer Call/Customer Call List.xlsx new file mode 100644 index 0000000..7ae0443 Binary files /dev/null and b/Data Cleaning/Customer Call/Customer Call List.xlsx differ -- cgit v1.2.3