{ "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 }