{ "cells": [ { "cell_type": "code", "execution_count": 13, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Job TitleInterestsInterests.1Education LevelCityFoodFood.1CarIncomeMovieMovie.1First NameLast NameEmail
0Chef ManagerMusicAccountingJunior collegeFremontMcDonald'sSun-PatAudi Q7801401AnimationAnimationGilAbbeyGil_Abbey1862@irrepsy.com
1Machine OperatorSociologyHealthTechnical collegeHonoluluHeinzMagnumCitroen Nemo29159AnimationRomanceNoahAbbeyNoah_Abbey3942@ubusive.com
2IT Support StaffnoneNaNPublic universitySan BernardinononeNaNNaN0NaNnoneVeraAbbeynone
3Executive DirectorModern LiteraturenoneHigh schoolBostonKFCnoneAudi Q1316511Adventure0JudithAdamsJudith_Adams7583@irrepsy.com
4AccountantLatinLanguage ArtsMiddle schoolFayettevilleDominoPapadopoulosBMW X6442632MusicalMusicalAlessiaAddisAlessia_Addis5500@cispeto.com
5Systems AdministratorSpeechnoneJunior collegeHoustonBetty CrockernoneBMW X3235058DramaNaNMelaniaAddisMelania_Addis8320@guentu.biz
6Healthcare SpecialistModern LiteratureNaNUniversity collegeOmahaBetty Crocker0Audi V8832094FamilyNaNOwenAdlerOwen_Adler8395@womeona.net
7Investment AdvisorMusicNaNUniversity collegeLong BeachSecret RecipeNaNCitroen Nemo645818Romance0NaNAinsworthKenzie_Ainsworth7824@nanoff.biz
8StockbrokerNaN0Corporate universityMoreno Valley0NaNFiat 500560429NaN0PeterAinsworthPeter_Ainsworth9788@nickia.com
9CashierAccountingResource ProgramGymnasiumNashvilleBel GroupKFCAudi Q3268487AnimationSci-FiChadAinsworthChad_Ainsworth2733@liret.org
10Production PainterNaN0University-preparatory schoolOrlando0NaNAudi A5369460NaN0BryonAinsworthBryon_Ainsworth1718@irrepsy.com
11HR CoordinatorArtSpeechUniversity collegeWienPizza HutNesquikHyundai Tucson43222ThrillerSci-FiValentinaAinsworthValentina_Ainsworth9363@liret.org
12WebmasterGrammarHistoryCorporate universityEl PasoHeinzAndy Capp's friesHyundai i35584686BiographyBiographyMattAlcroftMatt_Alcroft3345@muall.tech
13Call Center RepresentativeSpanishArtHigh schoolMadridKFCRed LobsterCitroen Nemo110167RomanceDramaMarkAlcroftMark_Alcroft5996@ovock.tech
14Software EngineerHistorySpanishJunior collegeHuntsvillePizza HutBel GroupFord Mondeo263391FamilyRomanceClintAldridgeClint_Aldridge8702@cispeto.com
15DoctorArtPhysical EducationPublic universitySan BernardinoStarbucksRed LobsterHonda CRV107064ComedyBiographyBorisAldridgeBoris_Aldridge8688@nimogy.biz
16Web DeveloperTrigonometryArtGraduate schoolBernaLEonidasSun-PatAudi TT252513BiographyMusicalRoccoAlexanderNaN
17Cash ManagerLatinnoneTechnical collegeTulsaNabiscononeFiat Freemont431684Thriller0KurtAlexanderKurt_Alexander8851@ovock.tech
18Insurance BrokerAmerican LiteratureDramaticsGraduate schoolZurichKnorrWendy'sMazda CX3403772Sci-FiComedyJavierAlexanderJavier_Alexander8393@gompie.com
19WebmasterResource ProgramMusicTechnical collegeLong BeachLEonidasVitta FoodsFiat Argo248789ActionMusicalFredAllenFred_Allen7346@cispeto.com
20Project ManagerLanguage ArtsScienceCorporate universityScottsdalePizza HutKinderDacia Sandero448237HistoryDramaBryonAllenBryon_Allen1891@twace.org
21Staffing ConsultantAncient CivilizationsGrammarUniversity collegeLincolnVitta FoodsSecret RecipeHyundai i2030032AdventureThrillerLeroyAllingtonLeroy_Allington6930@cispeto.com
22HR CoordinatorEarth ScienceNaNHigh schoolSan BernardinoPapadopoulosNaNOpel Insignia841216FamilyNaNAndieAllingtonAndie_Allington9567@vetan.org
23Associate ProfessorHandwritingMusicPublic universityBaltimoreApplebee'sDr. OetkerHonda Civic623661BiographyActionCalebAllwoodCaleb_Allwood7654@gmail.com
24Laboratory TechnicianInstrumental MusicAccountingHigh schoolBridgeportKnorrVitta FoodsCitroen C4101958ThrillerAdventureNoahAndrewsNoah_Andrews9063@joiniaa.com
25Staffing ConsultantMathematicsEnglish IVGraduate schoolSan AntonioBel GroupMagnumBMW X1598358ActionThrillerWinnieAndrewsWinnie_Andrews944@qater.org
26BiologistPhysical EducationGermanTechnical collegeSan JoseNesquikSubwayHyundai Santa Fe167739ThrillerHorrorCherishAndrewsCherish_Andrews263@mafthy.com
27Project ManagerDesign and technologyNaNMiddle schoolSanta AnaCarib BrewerynoneAudi Q5154580BiographyNaNMatthewAndrewsMatthew_Andrews9832@dionrab.com
28Laboratory TechnicianMusicnonePublic universityWienStarbucksNaNMazda CX5185831Musical0JohnnyAndrewsJohnny_Andrews8544@supunk.biz
29Design EngineerSpanishDesign and technologyPublic universityHendersonBurger KingNabiscoDacia Duster744523ThrillerThrillerLukeAntcliffLuke_Antcliff8245@sheye.org
.............................................
983Web DeveloperSpeechLatinMiddle schoolHollywoodSubwayPapadopoulosCitroen Jumper307866Sci-FiComedyHankWrightHank_Wright8414@tonsy.org
984Global Logistics SupervisorLeadershipEconomicsCorporate universityLisbonOlymelCobblestoneAudi A4648380HistoryCrimeLiamWrightLiam_Wright2660@womeona.net
985DentistFrenchHistoryHigh schoolOklahoma CityPapadopoulosVitta FoodsAudi A4110665RomanceCrimeChadWrightChad_Wright9492@corti.com
986Web DeveloperSpeechResource ProgramUniversity collegeOklahoma CityNesquikCobblestoneAudi Cabriolet881909CrimeDramaAlanWrightAlan_Wright1804@yahoo.com
987Insurance BrokerEcologySpanishTechnical collegeRenoDoritosAndy Capp's friesCitroen C3677283BiographySci-FiBartWrightBart_Wright9752@bungar.biz
988Business BrokerHistorySpanishJunior collegeTallahasseeCheetosVitta FoodsKia Sorento849632CrimeCrimeSarahWrightSarah_Wright6269@supunk.biz
989DentistEconomicsDramaticsGymnasiumLancasterDominoNutellaCitroen C4320368AnimationDramaJuliusYangJulius_Yang3284@hourpy.biz
990Healthcare SpecialistEcologyLanguage ArtsCorporate universityNorfolkBurger KingCarib BreweryBMW X5317678BiographyRomanceErickYangErick_Yang7391@gompie.com
991InspectorScienceLeadershipUniversity-preparatory schoolFremontDr. OetkerKinderHyundai i30502415DramaAdventureAleksandraYardAleksandra_Yard1020@womeona.net
992ElectricianMusicSpeechMiddle schoolAlbuquerqueApplebee'sOlymelOpel Astra396383HistoryBiographyMarlaYarlettMarla_Yarlett8267@nimogy.biz
993Software EngineerLOGICModern LiteratureGraduate schoolBerlinBel GroupPizza HutCitroen Nemo453841HorrorFamilyEduardoYarwoodEduardo_Yarwood8466@ovock.tech
994Executive DirectorNaNNaNGymnasiumCharlottenoneNaNFord Fiesta7593710noneCaraYatesCara_Yates8997@tonsy.org
995CooknoneNaNGymnasiumPraguenoneNaNCitroen C44506330noneErickYatesErick_Yates3648@irrepsy.com
996WebmasterTrigonometryResource ProgramJunior collegeMurfreesboroWendy'sCobblestoneHyundai Elantra368343FamilyComedyCedrickYorkCedrick_York7860@dionrab.com
997StockbrokerModern LiteratureEconomicsGymnasiumOntarioBaskin robbinsBaskin robbinsOpel Astra348532MusicalDramaMasonYorkMason_York2697@fuliss.net
998AuditorDesign and technologyGrammarGraduate schoolValettaTaco BellLEonidasFiat 50081510DramaMusicalElijahYorkElijah_York8639@yahoo.com
999CookAccountingScienceJunior collegeBernaLavazzaSubwayHyundai Tucson642577AnimationThrillerRyanYoungRyan_Young5697@vetan.org
1000Food TechnologistSpanishArtMiddle schoolDallasBewley'sBaskin robbinsHyundai i20467918FamilyHorrorPaigeYoungPaige_Young7597@bauros.biz
1001Insurance BrokerGermanInstrumental MusicGraduate schoolSan AntonioCarib BreweryAndy Capp's friesMazda 6182430CrimeThrillerBarryZaouiBarry_Zaoui5168@dionrab.com
1002Chef ManagerAmerican LiteratureEarth ScienceJunior collegeBakersfieldVitta FoodsSoproleCitroen Nemo20773Sci-FiMusicalNaNNaNJulian_Mullins5935@cispeto.com
1003AccountantModern LiteratureLatinHigh schoolBostonHeinzKitsKia Soul501421AnimationBiographyNaNNaNDavid_Ainsworth8114@joiniaa.com
1004Investment AdvisorMathematicsGrammarHigh schoolCincinnatiRed LobsterBaskin robbinsMazda CX3674796ComedyFamilyNaNNaNNaN
1005Ambulatory NurseLOGICLOGICTechnical collegeColorado SpringsBurger KingBetty CrockerMazda CX3733029FantasyMusicalNaNNaNNaN
1006LecturerMathematicsSpanishPublic universityEl PasoDr. OetkerKnorrFiat Freemont778289DramaFamilyNaNNaNNaN
1007PharmacistEconomicsSpanishUniversity-preparatory schoolFort LauderdaleMagnumDunkin' DonutsMazda CX5501469RomanceAnimationNaNNaNNaN
1008Health EducatorLanguage ArtsEcologyGymnasiumHollywoodNesquikHeinzAudi Q3859034ActionThrillerNaNNaNNaN
1009OperatorBasic MathFrenchGymnasiumInnsbruckDoritosDominoAudi Q7863596HistoryFamilyNaNNaNNaN
1010HR CoordinatorSpanishEconomicsGraduate schoolLincolnKinderHeinzBMW X3705612ThrillerHorrorNaNNaNNaN
1011Business BrokerScienceEconomicsHigh schoolLong BeachLEonidasWonder BreadHyundai i35500059ComedyRomanceJacobNaNJacob_Bolton6977@jiman.org
1012IT Support Staff0nonePublic universityLyonNaNnoneNaN0NaNNaNNaNNaNNaN
\n", "

1013 rows × 14 columns

\n", "
" ], "text/plain": [ " Job Title Interests \\\n", "0 Chef Manager Music \n", "1 Machine Operator Sociology \n", "2 IT Support Staff none \n", "3 Executive Director Modern Literature \n", "4 Accountant Latin \n", "5 Systems Administrator Speech \n", "6 Healthcare Specialist Modern Literature \n", "7 Investment Advisor Music \n", "8 Stockbroker NaN \n", "9 Cashier Accounting \n", "10 Production Painter NaN \n", "11 HR Coordinator Art \n", "12 Webmaster Grammar \n", "13 Call Center Representative Spanish \n", "14 Software Engineer History \n", "15 Doctor Art \n", "16 Web Developer Trigonometry \n", "17 Cash Manager Latin \n", "18 Insurance Broker American Literature \n", "19 Webmaster Resource Program \n", "20 Project Manager Language Arts \n", "21 Staffing Consultant Ancient Civilizations \n", "22 HR Coordinator Earth Science \n", "23 Associate Professor Handwriting \n", "24 Laboratory Technician Instrumental Music \n", "25 Staffing Consultant Mathematics \n", "26 Biologist Physical Education \n", "27 Project Manager Design and technology \n", "28 Laboratory Technician Music \n", "29 Design Engineer Spanish \n", "... ... ... \n", "983 Web Developer Speech \n", "984 Global Logistics Supervisor Leadership \n", "985 Dentist French \n", "986 Web Developer Speech \n", "987 Insurance Broker Ecology \n", "988 Business Broker History \n", "989 Dentist Economics \n", "990 Healthcare Specialist Ecology \n", "991 Inspector Science \n", "992 Electrician Music \n", "993 Software Engineer LOGIC \n", "994 Executive Director NaN \n", "995 Cook none \n", "996 Webmaster Trigonometry \n", "997 Stockbroker Modern Literature \n", "998 Auditor Design and technology \n", "999 Cook Accounting \n", "1000 Food Technologist Spanish \n", "1001 Insurance Broker German \n", "1002 Chef Manager American Literature \n", "1003 Accountant Modern Literature \n", "1004 Investment Advisor Mathematics \n", "1005 Ambulatory Nurse LOGIC \n", "1006 Lecturer Mathematics \n", "1007 Pharmacist Economics \n", "1008 Health Educator Language Arts \n", "1009 Operator Basic Math \n", "1010 HR Coordinator Spanish \n", "1011 Business Broker Science \n", "1012 IT Support Staff 0 \n", "\n", " Interests.1 Education Level City \\\n", "0 Accounting Junior college Fremont \n", "1 Health Technical college Honolulu \n", "2 NaN Public university San Bernardino \n", "3 none High school Boston \n", "4 Language Arts Middle school Fayetteville \n", "5 none Junior college Houston \n", "6 NaN University college Omaha \n", "7 NaN University college Long Beach \n", "8 0 Corporate university Moreno Valley \n", "9 Resource Program Gymnasium Nashville \n", "10 0 University-preparatory school Orlando \n", "11 Speech University college Wien \n", "12 History Corporate university El Paso \n", "13 Art High school Madrid \n", "14 Spanish Junior college Huntsville \n", "15 Physical Education Public university San Bernardino \n", "16 Art Graduate school Berna \n", "17 none Technical college Tulsa \n", "18 Dramatics Graduate school Zurich \n", "19 Music Technical college Long Beach \n", "20 Science Corporate university Scottsdale \n", "21 Grammar University college Lincoln \n", "22 NaN High school San Bernardino \n", "23 Music Public university Baltimore \n", "24 Accounting High school Bridgeport \n", "25 English IV Graduate school San Antonio \n", "26 German Technical college San Jose \n", "27 NaN Middle school Santa Ana \n", "28 none Public university Wien \n", "29 Design and technology Public university Henderson \n", "... ... ... ... \n", "983 Latin Middle school Hollywood \n", "984 Economics Corporate university Lisbon \n", "985 History High school Oklahoma City \n", "986 Resource Program University college Oklahoma City \n", "987 Spanish Technical college Reno \n", "988 Spanish Junior college Tallahassee \n", "989 Dramatics Gymnasium Lancaster \n", "990 Language Arts Corporate university Norfolk \n", "991 Leadership University-preparatory school Fremont \n", "992 Speech Middle school Albuquerque \n", "993 Modern Literature Graduate school Berlin \n", "994 NaN Gymnasium Charlotte \n", "995 NaN Gymnasium Prague \n", "996 Resource Program Junior college Murfreesboro \n", "997 Economics Gymnasium Ontario \n", "998 Grammar Graduate school Valetta \n", "999 Science Junior college Berna \n", "1000 Art Middle school Dallas \n", "1001 Instrumental Music Graduate school San Antonio \n", "1002 Earth Science Junior college Bakersfield \n", "1003 Latin High school Boston \n", "1004 Grammar High school Cincinnati \n", "1005 LOGIC Technical college Colorado Springs \n", "1006 Spanish Public university El Paso \n", "1007 Spanish University-preparatory school Fort Lauderdale \n", "1008 Ecology Gymnasium Hollywood \n", "1009 French Gymnasium Innsbruck \n", "1010 Economics Graduate school Lincoln \n", "1011 Economics High school Long Beach \n", "1012 none Public university Lyon \n", "\n", " Food Food.1 Car Income Movie \\\n", "0 McDonald's Sun-Pat Audi Q7 801401 Animation \n", "1 Heinz Magnum Citroen Nemo 29159 Animation \n", "2 none NaN NaN 0 NaN \n", "3 KFC none Audi Q1 316511 Adventure \n", "4 Domino Papadopoulos BMW X6 442632 Musical \n", "5 Betty Crocker none BMW X3 235058 Drama \n", "6 Betty Crocker 0 Audi V8 832094 Family \n", "7 Secret Recipe NaN Citroen Nemo 645818 Romance \n", "8 0 NaN Fiat 500 560429 NaN \n", "9 Bel Group KFC Audi Q3 268487 Animation \n", "10 0 NaN Audi A5 369460 NaN \n", "11 Pizza Hut Nesquik Hyundai Tucson 43222 Thriller \n", "12 Heinz Andy Capp's fries Hyundai i35 584686 Biography \n", "13 KFC Red Lobster Citroen Nemo 110167 Romance \n", "14 Pizza Hut Bel Group Ford Mondeo 263391 Family \n", "15 Starbucks Red Lobster Honda CRV 107064 Comedy \n", "16 LEonidas Sun-Pat Audi TT 252513 Biography \n", "17 Nabisco none Fiat Freemont 431684 Thriller \n", "18 Knorr Wendy's Mazda CX3 403772 Sci-Fi \n", "19 LEonidas Vitta Foods Fiat Argo 248789 Action \n", "20 Pizza Hut Kinder Dacia Sandero 448237 History \n", "21 Vitta Foods Secret Recipe Hyundai i20 30032 Adventure \n", "22 Papadopoulos NaN Opel Insignia 841216 Family \n", "23 Applebee's Dr. Oetker Honda Civic 623661 Biography \n", "24 Knorr Vitta Foods Citroen C4 101958 Thriller \n", "25 Bel Group Magnum BMW X1 598358 Action \n", "26 Nesquik Subway Hyundai Santa Fe 167739 Thriller \n", "27 Carib Brewery none Audi Q5 154580 Biography \n", "28 Starbucks NaN Mazda CX5 185831 Musical \n", "29 Burger King Nabisco Dacia Duster 744523 Thriller \n", "... ... ... ... ... ... \n", "983 Subway Papadopoulos Citroen Jumper 307866 Sci-Fi \n", "984 Olymel Cobblestone Audi A4 648380 History \n", "985 Papadopoulos Vitta Foods Audi A4 110665 Romance \n", "986 Nesquik Cobblestone Audi Cabriolet 881909 Crime \n", "987 Doritos Andy Capp's fries Citroen C3 677283 Biography \n", "988 Cheetos Vitta Foods Kia Sorento 849632 Crime \n", "989 Domino Nutella Citroen C4 320368 Animation \n", "990 Burger King Carib Brewery BMW X5 317678 Biography \n", "991 Dr. Oetker Kinder Hyundai i30 502415 Drama \n", "992 Applebee's Olymel Opel Astra 396383 History \n", "993 Bel Group Pizza Hut Citroen Nemo 453841 Horror \n", "994 none NaN Ford Fiesta 759371 0 \n", "995 none NaN Citroen C4 450633 0 \n", "996 Wendy's Cobblestone Hyundai Elantra 368343 Family \n", "997 Baskin robbins Baskin robbins Opel Astra 348532 Musical \n", "998 Taco Bell LEonidas Fiat 500 81510 Drama \n", "999 Lavazza Subway Hyundai Tucson 642577 Animation \n", "1000 Bewley's Baskin robbins Hyundai i20 467918 Family \n", "1001 Carib Brewery Andy Capp's fries Mazda 6 182430 Crime \n", "1002 Vitta Foods Soprole Citroen Nemo 20773 Sci-Fi \n", "1003 Heinz Kits Kia Soul 501421 Animation \n", "1004 Red Lobster Baskin robbins Mazda CX3 674796 Comedy \n", "1005 Burger King Betty Crocker Mazda CX3 733029 Fantasy \n", "1006 Dr. Oetker Knorr Fiat Freemont 778289 Drama \n", "1007 Magnum Dunkin' Donuts Mazda CX5 501469 Romance \n", "1008 Nesquik Heinz Audi Q3 859034 Action \n", "1009 Doritos Domino Audi Q7 863596 History \n", "1010 Kinder Heinz BMW X3 705612 Thriller \n", "1011 LEonidas Wonder Bread Hyundai i35 500059 Comedy \n", "1012 NaN none NaN 0 NaN \n", "\n", " Movie.1 First Name Last Name Email \n", "0 Animation Gil Abbey Gil_Abbey1862@irrepsy.com \n", "1 Romance Noah Abbey Noah_Abbey3942@ubusive.com \n", "2 none Vera Abbey none \n", "3 0 Judith Adams Judith_Adams7583@irrepsy.com \n", "4 Musical Alessia Addis Alessia_Addis5500@cispeto.com \n", "5 NaN Melania Addis Melania_Addis8320@guentu.biz \n", "6 NaN Owen Adler Owen_Adler8395@womeona.net \n", "7 0 NaN Ainsworth Kenzie_Ainsworth7824@nanoff.biz \n", "8 0 Peter Ainsworth Peter_Ainsworth9788@nickia.com \n", "9 Sci-Fi Chad Ainsworth Chad_Ainsworth2733@liret.org \n", "10 0 Bryon Ainsworth Bryon_Ainsworth1718@irrepsy.com \n", "11 Sci-Fi Valentina Ainsworth Valentina_Ainsworth9363@liret.org \n", "12 Biography Matt Alcroft Matt_Alcroft3345@muall.tech \n", "13 Drama Mark Alcroft Mark_Alcroft5996@ovock.tech \n", "14 Romance Clint Aldridge Clint_Aldridge8702@cispeto.com \n", "15 Biography Boris Aldridge Boris_Aldridge8688@nimogy.biz \n", "16 Musical Rocco Alexander NaN \n", "17 0 Kurt Alexander Kurt_Alexander8851@ovock.tech \n", "18 Comedy Javier Alexander Javier_Alexander8393@gompie.com \n", "19 Musical Fred Allen Fred_Allen7346@cispeto.com \n", "20 Drama Bryon Allen Bryon_Allen1891@twace.org \n", "21 Thriller Leroy Allington Leroy_Allington6930@cispeto.com \n", "22 NaN Andie Allington Andie_Allington9567@vetan.org \n", "23 Action Caleb Allwood Caleb_Allwood7654@gmail.com \n", "24 Adventure Noah Andrews Noah_Andrews9063@joiniaa.com \n", "25 Thriller Winnie Andrews Winnie_Andrews944@qater.org \n", "26 Horror Cherish Andrews Cherish_Andrews263@mafthy.com \n", "27 NaN Matthew Andrews Matthew_Andrews9832@dionrab.com \n", "28 0 Johnny Andrews Johnny_Andrews8544@supunk.biz \n", "29 Thriller Luke Antcliff Luke_Antcliff8245@sheye.org \n", "... ... ... ... ... \n", "983 Comedy Hank Wright Hank_Wright8414@tonsy.org \n", "984 Crime Liam Wright Liam_Wright2660@womeona.net \n", "985 Crime Chad Wright Chad_Wright9492@corti.com \n", "986 Drama Alan Wright Alan_Wright1804@yahoo.com \n", "987 Sci-Fi Bart Wright Bart_Wright9752@bungar.biz \n", "988 Crime Sarah Wright Sarah_Wright6269@supunk.biz \n", "989 Drama Julius Yang Julius_Yang3284@hourpy.biz \n", "990 Romance Erick Yang Erick_Yang7391@gompie.com \n", "991 Adventure Aleksandra Yard Aleksandra_Yard1020@womeona.net \n", "992 Biography Marla Yarlett Marla_Yarlett8267@nimogy.biz \n", "993 Family Eduardo Yarwood Eduardo_Yarwood8466@ovock.tech \n", "994 none Cara Yates Cara_Yates8997@tonsy.org \n", "995 none Erick Yates Erick_Yates3648@irrepsy.com \n", "996 Comedy Cedrick York Cedrick_York7860@dionrab.com \n", "997 Drama Mason York Mason_York2697@fuliss.net \n", "998 Musical Elijah York Elijah_York8639@yahoo.com \n", "999 Thriller Ryan Young Ryan_Young5697@vetan.org \n", "1000 Horror Paige Young Paige_Young7597@bauros.biz \n", "1001 Thriller Barry Zaoui Barry_Zaoui5168@dionrab.com \n", "1002 Musical NaN NaN Julian_Mullins5935@cispeto.com \n", "1003 Biography NaN NaN David_Ainsworth8114@joiniaa.com \n", "1004 Family NaN NaN NaN \n", "1005 Musical NaN NaN NaN \n", "1006 Family NaN NaN NaN \n", "1007 Animation NaN NaN NaN \n", "1008 Thriller NaN NaN NaN \n", "1009 Family NaN NaN NaN \n", "1010 Horror NaN NaN NaN \n", "1011 Romance Jacob NaN Jacob_Bolton6977@jiman.org \n", "1012 NaN NaN NaN NaN \n", "\n", "[1013 rows x 14 columns]" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#********************WEEK4_ACT3_EX1***********************************\n", "import numpy as np\n", "import pandas as pd\n", "#opening the file\n", "df=pd.read_csv(\"PeoplesFavourites.csv\")\n", "df" ] }, { "cell_type": "code", "execution_count": 14, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Job TitleInterestsInterests.1Education LevelCityFoodFood.1CarIncomeMovieMovie.1First NameLast NameEmail
0Chef ManagerMusicAccountingJunior collegeFremontMcDonald'sSun-PatAudi Q7801401AnimationAnimation55259289122886518614206759612282018337Gil_Abbey1862@irrepsy.com
1Machine OperatorSociologyHealthTechnical collegeHonoluluHeinzMagnumCitroen Nemo29159AnimationRomance70427625574728861104206759612282018337Noah_Abbey3942@ubusive.com
2IT Support StaffnoneNaNPublic universitySan BernardinononeNaNNaN0NaNnone8448497954700773214206759612282018337none
3Executive DirectorModern LiteraturenoneHigh schoolBostonKFCnoneAudi Q1316511Adventure08649512297698996172638013971769049753Judith_Adams7583@irrepsy.com
4AccountantLatinLanguage ArtsMiddle schoolFayettevilleDominoPapadopoulosBMW X6442632MusicalMusical6458623837331504417268967984277984449Alessia_Addis5500@cispeto.com
5Systems AdministratorSpeechnoneJunior collegeHoustonBetty CrockernoneBMW X3235058DramaNaN64954308833339193327268967984277984449Melania_Addis8320@guentu.biz
6Healthcare SpecialistModern LiteratureNaNUniversity collegeOmahaBetty Crocker0Audi V8832094FamilyNaN60429744068224301851245511952883952896Owen_Adler8395@womeona.net
7Investment AdvisorMusicNaNUniversity collegeLong BeachSecret RecipeNaNCitroen Nemo645818Romance001513945620991270455Kenzie_Ainsworth7824@nanoff.biz
8StockbrokerNaN0Corporate universityMoreno Valley0NaNFiat 500560429NaN067039639086570544381513945620991270455Peter_Ainsworth9788@nickia.com
9CashierAccountingResource ProgramGymnasiumNashvilleBel GroupKFCAudi Q3268487AnimationSci-Fi66692951997430464711513945620991270455Chad_Ainsworth2733@liret.org
10Production PainterNaN0University-preparatory schoolOrlando0NaNAudi A5369460NaN041857739955466617451513945620991270455Bryon_Ainsworth1718@irrepsy.com
11HR CoordinatorArtSpeechUniversity collegeWienPizza HutNesquikHyundai Tucson43222ThrillerSci-Fi37835980823462565131513945620991270455Valentina_Ainsworth9363@liret.org
12WebmasterGrammarHistoryCorporate universityEl PasoHeinzAndy Capp's friesHyundai i35584686BiographyBiography91549918900297542055972706850620146064Matt_Alcroft3345@muall.tech
13Call Center RepresentativeSpanishArtHigh schoolMadridKFCRed LobsterCitroen Nemo110167RomanceDrama23934928997846971855972706850620146064Mark_Alcroft5996@ovock.tech
14Software EngineerHistorySpanishJunior collegeHuntsvillePizza HutBel GroupFord Mondeo263391FamilyRomance75753462528996894196884548124242581831Clint_Aldridge8702@cispeto.com
15DoctorArtPhysical EducationPublic universitySan BernardinoStarbucksRed LobsterHonda CRV107064ComedyBiography32355772783838024686884548124242581831Boris_Aldridge8688@nimogy.biz
16Web DeveloperTrigonometryArtGraduate schoolBernaLEonidasSun-PatAudi TT252513BiographyMusical22474596301449975025452220799772127725NaN
17Cash ManagerLatinnoneTechnical collegeTulsaNabiscononeFiat Freemont431684Thriller08756960135700471785452220799772127725Kurt_Alexander8851@ovock.tech
18Insurance BrokerAmerican LiteratureDramaticsGraduate schoolZurichKnorrWendy'sMazda CX3403772Sci-FiComedy59528382788400194005452220799772127725Javier_Alexander8393@gompie.com
19WebmasterResource ProgramMusicTechnical collegeLong BeachLEonidasVitta FoodsFiat Argo248789ActionMusical1956328899077870346467263162285791682Fred_Allen7346@cispeto.com
20Project ManagerLanguage ArtsScienceCorporate universityScottsdalePizza HutKinderDacia Sandero448237HistoryDrama4185773995546661745467263162285791682Bryon_Allen1891@twace.org
21Staffing ConsultantAncient CivilizationsGrammarUniversity collegeLincolnVitta FoodsSecret RecipeHyundai i2030032AdventureThriller52113848799934087473915227604749149746Leroy_Allington6930@cispeto.com
22HR CoordinatorEarth ScienceNaNHigh schoolSan BernardinoPapadopoulosNaNOpel Insignia841216FamilyNaN18180828328054185023915227604749149746Andie_Allington9567@vetan.org
23Associate ProfessorHandwritingMusicPublic universityBaltimoreApplebee'sDr. OetkerHonda Civic623661BiographyAction31393396579478888418906133069031974196Caleb_Allwood7654@gmail.com
24Laboratory TechnicianInstrumental MusicAccountingHigh schoolBridgeportKnorrVitta FoodsCitroen C4101958ThrillerAdventure70427625574728861107771254255227750831Noah_Andrews9063@joiniaa.com
25Staffing ConsultantMathematicsEnglish IVGraduate schoolSan AntonioBel GroupMagnumBMW X1598358ActionThriller41776028997474432927771254255227750831Winnie_Andrews944@qater.org
26BiologistPhysical EducationGermanTechnical collegeSan JoseNesquikSubwayHyundai Santa Fe167739ThrillerHorror26678375516213974927771254255227750831Cherish_Andrews263@mafthy.com
27Project ManagerDesign and technologyNaNMiddle schoolSanta AnaCarib BrewerynoneAudi Q5154580BiographyNaN87558309534076946077771254255227750831Matthew_Andrews9832@dionrab.com
28Laboratory TechnicianMusicnonePublic universityWienStarbucksNaNMazda CX5185831Musical045061010766894551707771254255227750831Johnny_Andrews8544@supunk.biz
29Design EngineerSpanishDesign and technologyPublic universityHendersonBurger KingNabiscoDacia Duster744523ThrillerThriller8909809787508259508484141246053636730Luke_Antcliff8245@sheye.org
.............................................
983Web DeveloperSpeechLatinMiddle schoolHollywoodSubwayPapadopoulosCitroen Jumper307866Sci-FiComedy21119619902936480867453927719886423563Hank_Wright8414@tonsy.org
984Global Logistics SupervisorLeadershipEconomicsCorporate universityLisbonOlymelCobblestoneAudi A4648380HistoryCrime64055906435288270507453927719886423563Liam_Wright2660@womeona.net
985DentistFrenchHistoryHigh schoolOklahoma CityPapadopoulosVitta FoodsAudi A4110665RomanceCrime66692951997430464717453927719886423563Chad_Wright9492@corti.com
986Web DeveloperSpeechResource ProgramUniversity collegeOklahoma CityNesquikCobblestoneAudi Cabriolet881909CrimeDrama50295835094670825187453927719886423563Alan_Wright1804@yahoo.com
987Insurance BrokerEcologySpanishTechnical collegeRenoDoritosAndy Capp's friesCitroen C3677283BiographySci-Fi66398528200313074557453927719886423563Bart_Wright9752@bungar.biz
988Business BrokerHistorySpanishJunior collegeTallahasseeCheetosVitta FoodsKia Sorento849632CrimeCrime77220777352367494657453927719886423563Sarah_Wright6269@supunk.biz
989DentistEconomicsDramaticsGymnasiumLancasterDominoNutellaCitroen C4320368AnimationDrama81909337782247330611624051484013556665Julius_Yang3284@hourpy.biz
990Healthcare SpecialistEcologyLanguage ArtsCorporate universityNorfolkBurger KingCarib BreweryBMW X5317678BiographyRomance56947085608010210851624051484013556665Erick_Yang7391@gompie.com
991InspectorScienceLeadershipUniversity-preparatory schoolFremontDr. OetkerKinderHyundai i30502415DramaAdventure82056634571891886696490845777576213122Aleksandra_Yard1020@womeona.net
992ElectricianMusicSpeechMiddle schoolAlbuquerqueApplebee'sOlymelOpel Astra396383HistoryBiography7813807661243340285601129917837199634Marla_Yarlett8267@nimogy.biz
993Software EngineerLOGICModern LiteratureGraduate schoolBerlinBel GroupPizza HutCitroen Nemo453841HorrorFamily82395710544585582672139171345624969609Eduardo_Yarwood8466@ovock.tech
994Executive DirectorNaNNaNGymnasiumCharlottenoneNaNFord Fiesta7593710none31889877638159113647199010166483654596Cara_Yates8997@tonsy.org
995CooknoneNaNGymnasiumPraguenoneNaNCitroen C44506330none56947085608010210857199010166483654596Erick_Yates3648@irrepsy.com
996WebmasterTrigonometryResource ProgramJunior collegeMurfreesboroWendy'sCobblestoneHyundai Elantra368343FamilyComedy23856258906199070878861084602755028556Cedrick_York7860@dionrab.com
997StockbrokerModern LiteratureEconomicsGymnasiumOntarioBaskin robbinsBaskin robbinsOpel Astra348532MusicalDrama11331386012000578278861084602755028556Mason_York2697@fuliss.net
998AuditorDesign and technologyGrammarGraduate schoolValettaTaco BellLEonidasFiat 50081510DramaMusical36403901763980592878861084602755028556Elijah_York8639@yahoo.com
999CookAccountingScienceJunior collegeBernaLavazzaSubwayHyundai Tucson642577AnimationThriller18780019021834276467451240902177457467Ryan_Young5697@vetan.org
1000Food TechnologistSpanishArtMiddle schoolDallasBewley'sBaskin robbinsHyundai i20467918FamilyHorror7527368424782504227451240902177457467Paige_Young7597@bauros.biz
1001Insurance BrokerGermanInstrumental MusicGraduate schoolSan AntonioCarib BreweryAndy Capp's friesMazda 6182430CrimeThriller62714046237204804433084286614218966688Barry_Zaoui5168@dionrab.com
1002Chef ManagerAmerican LiteratureEarth ScienceJunior collegeBakersfieldVitta FoodsSoproleCitroen Nemo20773Sci-FiMusical00Julian_Mullins5935@cispeto.com
1003AccountantModern LiteratureLatinHigh schoolBostonHeinzKitsKia Soul501421AnimationBiography00David_Ainsworth8114@joiniaa.com
1004Investment AdvisorMathematicsGrammarHigh schoolCincinnatiRed LobsterBaskin robbinsMazda CX3674796ComedyFamily00NaN
1005Ambulatory NurseLOGICLOGICTechnical collegeColorado SpringsBurger KingBetty CrockerMazda CX3733029FantasyMusical00NaN
1006LecturerMathematicsSpanishPublic universityEl PasoDr. OetkerKnorrFiat Freemont778289DramaFamily00NaN
1007PharmacistEconomicsSpanishUniversity-preparatory schoolFort LauderdaleMagnumDunkin' DonutsMazda CX5501469RomanceAnimation00NaN
1008Health EducatorLanguage ArtsEcologyGymnasiumHollywoodNesquikHeinzAudi Q3859034ActionThriller00NaN
1009OperatorBasic MathFrenchGymnasiumInnsbruckDoritosDominoAudi Q7863596HistoryFamily00NaN
1010HR CoordinatorSpanishEconomicsGraduate schoolLincolnKinderHeinzBMW X3705612ThrillerHorror00NaN
1011Business BrokerScienceEconomicsHigh schoolLong BeachLEonidasWonder BreadHyundai i35500059ComedyRomance20945248430416689500Jacob_Bolton6977@jiman.org
1012IT Support Staff0nonePublic universityLyonNaNnoneNaN0NaNNaN00NaN
\n", "

1013 rows × 14 columns

\n", "
" ], "text/plain": [ " Job Title Interests \\\n", "0 Chef Manager Music \n", "1 Machine Operator Sociology \n", "2 IT Support Staff none \n", "3 Executive Director Modern Literature \n", "4 Accountant Latin \n", "5 Systems Administrator Speech \n", "6 Healthcare Specialist Modern Literature \n", "7 Investment Advisor Music \n", "8 Stockbroker NaN \n", "9 Cashier Accounting \n", "10 Production Painter NaN \n", "11 HR Coordinator Art \n", "12 Webmaster Grammar \n", "13 Call Center Representative Spanish \n", "14 Software Engineer History \n", "15 Doctor Art \n", "16 Web Developer Trigonometry \n", "17 Cash Manager Latin \n", "18 Insurance Broker American Literature \n", "19 Webmaster Resource Program \n", "20 Project Manager Language Arts \n", "21 Staffing Consultant Ancient Civilizations \n", "22 HR Coordinator Earth Science \n", "23 Associate Professor Handwriting \n", "24 Laboratory Technician Instrumental Music \n", "25 Staffing Consultant Mathematics \n", "26 Biologist Physical Education \n", "27 Project Manager Design and technology \n", "28 Laboratory Technician Music \n", "29 Design Engineer Spanish \n", "... ... ... \n", "983 Web Developer Speech \n", "984 Global Logistics Supervisor Leadership \n", "985 Dentist French \n", "986 Web Developer Speech \n", "987 Insurance Broker Ecology \n", "988 Business Broker History \n", "989 Dentist Economics \n", "990 Healthcare Specialist Ecology \n", "991 Inspector Science \n", "992 Electrician Music \n", "993 Software Engineer LOGIC \n", "994 Executive Director NaN \n", "995 Cook none \n", "996 Webmaster Trigonometry \n", "997 Stockbroker Modern Literature \n", "998 Auditor Design and technology \n", "999 Cook Accounting \n", "1000 Food Technologist Spanish \n", "1001 Insurance Broker German \n", "1002 Chef Manager American Literature \n", "1003 Accountant Modern Literature \n", "1004 Investment Advisor Mathematics \n", "1005 Ambulatory Nurse LOGIC \n", "1006 Lecturer Mathematics \n", "1007 Pharmacist Economics \n", "1008 Health Educator Language Arts \n", "1009 Operator Basic Math \n", "1010 HR Coordinator Spanish \n", "1011 Business Broker Science \n", "1012 IT Support Staff 0 \n", "\n", " Interests.1 Education Level City \\\n", "0 Accounting Junior college Fremont \n", "1 Health Technical college Honolulu \n", "2 NaN Public university San Bernardino \n", "3 none High school Boston \n", "4 Language Arts Middle school Fayetteville \n", "5 none Junior college Houston \n", "6 NaN University college Omaha \n", "7 NaN University college Long Beach \n", "8 0 Corporate university Moreno Valley \n", "9 Resource Program Gymnasium Nashville \n", "10 0 University-preparatory school Orlando \n", "11 Speech University college Wien \n", "12 History Corporate university El Paso \n", "13 Art High school Madrid \n", "14 Spanish Junior college Huntsville \n", "15 Physical Education Public university San Bernardino \n", "16 Art Graduate school Berna \n", "17 none Technical college Tulsa \n", "18 Dramatics Graduate school Zurich \n", "19 Music Technical college Long Beach \n", "20 Science Corporate university Scottsdale \n", "21 Grammar University college Lincoln \n", "22 NaN High school San Bernardino \n", "23 Music Public university Baltimore \n", "24 Accounting High school Bridgeport \n", "25 English IV Graduate school San Antonio \n", "26 German Technical college San Jose \n", "27 NaN Middle school Santa Ana \n", "28 none Public university Wien \n", "29 Design and technology Public university Henderson \n", "... ... ... ... \n", "983 Latin Middle school Hollywood \n", "984 Economics Corporate university Lisbon \n", "985 History High school Oklahoma City \n", "986 Resource Program University college Oklahoma City \n", "987 Spanish Technical college Reno \n", "988 Spanish Junior college Tallahassee \n", "989 Dramatics Gymnasium Lancaster \n", "990 Language Arts Corporate university Norfolk \n", "991 Leadership University-preparatory school Fremont \n", "992 Speech Middle school Albuquerque \n", "993 Modern Literature Graduate school Berlin \n", "994 NaN Gymnasium Charlotte \n", "995 NaN Gymnasium Prague \n", "996 Resource Program Junior college Murfreesboro \n", "997 Economics Gymnasium Ontario \n", "998 Grammar Graduate school Valetta \n", "999 Science Junior college Berna \n", "1000 Art Middle school Dallas \n", "1001 Instrumental Music Graduate school San Antonio \n", "1002 Earth Science Junior college Bakersfield \n", "1003 Latin High school Boston \n", "1004 Grammar High school Cincinnati \n", "1005 LOGIC Technical college Colorado Springs \n", "1006 Spanish Public university El Paso \n", "1007 Spanish University-preparatory school Fort Lauderdale \n", "1008 Ecology Gymnasium Hollywood \n", "1009 French Gymnasium Innsbruck \n", "1010 Economics Graduate school Lincoln \n", "1011 Economics High school Long Beach \n", "1012 none Public university Lyon \n", "\n", " Food Food.1 Car Income Movie \\\n", "0 McDonald's Sun-Pat Audi Q7 801401 Animation \n", "1 Heinz Magnum Citroen Nemo 29159 Animation \n", "2 none NaN NaN 0 NaN \n", "3 KFC none Audi Q1 316511 Adventure \n", "4 Domino Papadopoulos BMW X6 442632 Musical \n", "5 Betty Crocker none BMW X3 235058 Drama \n", "6 Betty Crocker 0 Audi V8 832094 Family \n", "7 Secret Recipe NaN Citroen Nemo 645818 Romance \n", "8 0 NaN Fiat 500 560429 NaN \n", "9 Bel Group KFC Audi Q3 268487 Animation \n", "10 0 NaN Audi A5 369460 NaN \n", "11 Pizza Hut Nesquik Hyundai Tucson 43222 Thriller \n", "12 Heinz Andy Capp's fries Hyundai i35 584686 Biography \n", "13 KFC Red Lobster Citroen Nemo 110167 Romance \n", "14 Pizza Hut Bel Group Ford Mondeo 263391 Family \n", "15 Starbucks Red Lobster Honda CRV 107064 Comedy \n", "16 LEonidas Sun-Pat Audi TT 252513 Biography \n", "17 Nabisco none Fiat Freemont 431684 Thriller \n", "18 Knorr Wendy's Mazda CX3 403772 Sci-Fi \n", "19 LEonidas Vitta Foods Fiat Argo 248789 Action \n", "20 Pizza Hut Kinder Dacia Sandero 448237 History \n", "21 Vitta Foods Secret Recipe Hyundai i20 30032 Adventure \n", "22 Papadopoulos NaN Opel Insignia 841216 Family \n", "23 Applebee's Dr. Oetker Honda Civic 623661 Biography \n", "24 Knorr Vitta Foods Citroen C4 101958 Thriller \n", "25 Bel Group Magnum BMW X1 598358 Action \n", "26 Nesquik Subway Hyundai Santa Fe 167739 Thriller \n", "27 Carib Brewery none Audi Q5 154580 Biography \n", "28 Starbucks NaN Mazda CX5 185831 Musical \n", "29 Burger King Nabisco Dacia Duster 744523 Thriller \n", "... ... ... ... ... ... \n", "983 Subway Papadopoulos Citroen Jumper 307866 Sci-Fi \n", "984 Olymel Cobblestone Audi A4 648380 History \n", "985 Papadopoulos Vitta Foods Audi A4 110665 Romance \n", "986 Nesquik Cobblestone Audi Cabriolet 881909 Crime \n", "987 Doritos Andy Capp's fries Citroen C3 677283 Biography \n", "988 Cheetos Vitta Foods Kia Sorento 849632 Crime \n", "989 Domino Nutella Citroen C4 320368 Animation \n", "990 Burger King Carib Brewery BMW X5 317678 Biography \n", "991 Dr. Oetker Kinder Hyundai i30 502415 Drama \n", "992 Applebee's Olymel Opel Astra 396383 History \n", "993 Bel Group Pizza Hut Citroen Nemo 453841 Horror \n", "994 none NaN Ford Fiesta 759371 0 \n", "995 none NaN Citroen C4 450633 0 \n", "996 Wendy's Cobblestone Hyundai Elantra 368343 Family \n", "997 Baskin robbins Baskin robbins Opel Astra 348532 Musical \n", "998 Taco Bell LEonidas Fiat 500 81510 Drama \n", "999 Lavazza Subway Hyundai Tucson 642577 Animation \n", "1000 Bewley's Baskin robbins Hyundai i20 467918 Family \n", "1001 Carib Brewery Andy Capp's fries Mazda 6 182430 Crime \n", "1002 Vitta Foods Soprole Citroen Nemo 20773 Sci-Fi \n", "1003 Heinz Kits Kia Soul 501421 Animation \n", "1004 Red Lobster Baskin robbins Mazda CX3 674796 Comedy \n", "1005 Burger King Betty Crocker Mazda CX3 733029 Fantasy \n", "1006 Dr. Oetker Knorr Fiat Freemont 778289 Drama \n", "1007 Magnum Dunkin' Donuts Mazda CX5 501469 Romance \n", "1008 Nesquik Heinz Audi Q3 859034 Action \n", "1009 Doritos Domino Audi Q7 863596 History \n", "1010 Kinder Heinz BMW X3 705612 Thriller \n", "1011 LEonidas Wonder Bread Hyundai i35 500059 Comedy \n", "1012 NaN none NaN 0 NaN \n", "\n", " Movie.1 First Name Last Name \\\n", "0 Animation 5525928912288651861 4206759612282018337 \n", "1 Romance 7042762557472886110 4206759612282018337 \n", "2 none 844849795470077321 4206759612282018337 \n", "3 0 8649512297698996172 638013971769049753 \n", "4 Musical 645862383733150441 7268967984277984449 \n", "5 NaN 6495430883333919332 7268967984277984449 \n", "6 NaN 6042974406822430185 1245511952883952896 \n", "7 0 0 1513945620991270455 \n", "8 0 6703963908657054438 1513945620991270455 \n", "9 Sci-Fi 6669295199743046471 1513945620991270455 \n", "10 0 4185773995546661745 1513945620991270455 \n", "11 Sci-Fi 3783598082346256513 1513945620991270455 \n", "12 Biography 9154991890029754205 5972706850620146064 \n", "13 Drama 2393492899784697185 5972706850620146064 \n", "14 Romance 7575346252899689419 6884548124242581831 \n", "15 Biography 3235577278383802468 6884548124242581831 \n", "16 Musical 2247459630144997502 5452220799772127725 \n", "17 0 875696013570047178 5452220799772127725 \n", "18 Comedy 5952838278840019400 5452220799772127725 \n", "19 Musical 1956328899077870346 467263162285791682 \n", "20 Drama 4185773995546661745 467263162285791682 \n", "21 Thriller 5211384879993408747 3915227604749149746 \n", "22 NaN 1818082832805418502 3915227604749149746 \n", "23 Action 3139339657947888841 8906133069031974196 \n", "24 Adventure 7042762557472886110 7771254255227750831 \n", "25 Thriller 4177602899747443292 7771254255227750831 \n", "26 Horror 2667837551621397492 7771254255227750831 \n", "27 NaN 8755830953407694607 7771254255227750831 \n", "28 0 4506101076689455170 7771254255227750831 \n", "29 Thriller 890980978750825950 8484141246053636730 \n", "... ... ... ... \n", "983 Comedy 2111961990293648086 7453927719886423563 \n", "984 Crime 6405590643528827050 7453927719886423563 \n", "985 Crime 6669295199743046471 7453927719886423563 \n", "986 Drama 5029583509467082518 7453927719886423563 \n", "987 Sci-Fi 6639852820031307455 7453927719886423563 \n", "988 Crime 7722077735236749465 7453927719886423563 \n", "989 Drama 8190933778224733061 1624051484013556665 \n", "990 Romance 5694708560801021085 1624051484013556665 \n", "991 Adventure 8205663457189188669 6490845777576213122 \n", "992 Biography 781380766124334028 5601129917837199634 \n", "993 Family 8239571054458558267 2139171345624969609 \n", "994 none 3188987763815911364 7199010166483654596 \n", "995 none 5694708560801021085 7199010166483654596 \n", "996 Comedy 2385625890619907087 8861084602755028556 \n", "997 Drama 1133138601200057827 8861084602755028556 \n", "998 Musical 3640390176398059287 8861084602755028556 \n", "999 Thriller 1878001902183427646 7451240902177457467 \n", "1000 Horror 752736842478250422 7451240902177457467 \n", "1001 Thriller 6271404623720480443 3084286614218966688 \n", "1002 Musical 0 0 \n", "1003 Biography 0 0 \n", "1004 Family 0 0 \n", "1005 Musical 0 0 \n", "1006 Family 0 0 \n", "1007 Animation 0 0 \n", "1008 Thriller 0 0 \n", "1009 Family 0 0 \n", "1010 Horror 0 0 \n", "1011 Romance 2094524843041668950 0 \n", "1012 NaN 0 0 \n", "\n", " Email \n", "0 Gil_Abbey1862@irrepsy.com \n", "1 Noah_Abbey3942@ubusive.com \n", "2 none \n", "3 Judith_Adams7583@irrepsy.com \n", "4 Alessia_Addis5500@cispeto.com \n", "5 Melania_Addis8320@guentu.biz \n", "6 Owen_Adler8395@womeona.net \n", "7 Kenzie_Ainsworth7824@nanoff.biz \n", "8 Peter_Ainsworth9788@nickia.com \n", "9 Chad_Ainsworth2733@liret.org \n", "10 Bryon_Ainsworth1718@irrepsy.com \n", "11 Valentina_Ainsworth9363@liret.org \n", "12 Matt_Alcroft3345@muall.tech \n", "13 Mark_Alcroft5996@ovock.tech \n", "14 Clint_Aldridge8702@cispeto.com \n", "15 Boris_Aldridge8688@nimogy.biz \n", "16 NaN \n", "17 Kurt_Alexander8851@ovock.tech \n", "18 Javier_Alexander8393@gompie.com \n", "19 Fred_Allen7346@cispeto.com \n", "20 Bryon_Allen1891@twace.org \n", "21 Leroy_Allington6930@cispeto.com \n", "22 Andie_Allington9567@vetan.org \n", "23 Caleb_Allwood7654@gmail.com \n", "24 Noah_Andrews9063@joiniaa.com \n", "25 Winnie_Andrews944@qater.org \n", "26 Cherish_Andrews263@mafthy.com \n", "27 Matthew_Andrews9832@dionrab.com \n", "28 Johnny_Andrews8544@supunk.biz \n", "29 Luke_Antcliff8245@sheye.org \n", "... ... \n", "983 Hank_Wright8414@tonsy.org \n", "984 Liam_Wright2660@womeona.net \n", "985 Chad_Wright9492@corti.com \n", "986 Alan_Wright1804@yahoo.com \n", "987 Bart_Wright9752@bungar.biz \n", "988 Sarah_Wright6269@supunk.biz \n", "989 Julius_Yang3284@hourpy.biz \n", "990 Erick_Yang7391@gompie.com \n", "991 Aleksandra_Yard1020@womeona.net \n", "992 Marla_Yarlett8267@nimogy.biz \n", "993 Eduardo_Yarwood8466@ovock.tech \n", "994 Cara_Yates8997@tonsy.org \n", "995 Erick_Yates3648@irrepsy.com \n", "996 Cedrick_York7860@dionrab.com \n", "997 Mason_York2697@fuliss.net \n", "998 Elijah_York8639@yahoo.com \n", "999 Ryan_Young5697@vetan.org \n", "1000 Paige_Young7597@bauros.biz \n", "1001 Barry_Zaoui5168@dionrab.com \n", "1002 Julian_Mullins5935@cispeto.com \n", "1003 David_Ainsworth8114@joiniaa.com \n", "1004 NaN \n", "1005 NaN \n", "1006 NaN \n", "1007 NaN \n", "1008 NaN \n", "1009 NaN \n", "1010 NaN \n", "1011 Jacob_Bolton6977@jiman.org \n", "1012 NaN \n", "\n", "[1013 rows x 14 columns]" ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#QUESTION 1\n", "#remove customer names (first and last), replacing with a unique identifier. \n", "#We will be using lambda to generate unique keys\n", "\n", "df[\"First Name\"]=df[\"First Name\"].apply(lambda a:abs(hash(a)))\n", "df[\"Last Name\"]=df[\"Last Name\"].apply(lambda a:abs(hash(a)))\n", "df" ] }, { "cell_type": "code", "execution_count": 19, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Job TitleInterestsInterests.1Education LevelCityFoodFood.1CarIncomeMovieMovie.1First NameLast NameEmail
0Chef ManagerMusicAccountingJunior collegeFremontMcDonald'sSun-PatAudi Q7801401AnimationAnimation55259289122886518614206759612282018337Gil_Abbey1862@irrepsy.com
1Machine OperatorSociologyHealthTechnical collegeHonoluluHeinzMagnumCitroen Nemo29159AnimationRomance70427625574728861104206759612282018337Noah_Abbey3942@ubusive.com
2IT Support StaffnullNaNPublic universitySan BernardinonullNaNNaNnullNaNnull8448497954700773214206759612282018337null
3Executive DirectorModern LiteraturenullHigh schoolBostonKFCnullAudi Q1316511Adventurenull8649512297698996172638013971769049753Judith_Adams7583@irrepsy.com
4AccountantLatinLanguage ArtsMiddle schoolFayettevilleDominoPapadopoulosBMW X6442632MusicalMusical6458623837331504417268967984277984449Alessia_Addis5500@cispeto.com
5Systems AdministratorSpeechnullJunior collegeHoustonBetty CrockernullBMW X3235058DramaNaN64954308833339193327268967984277984449Melania_Addis8320@guentu.biz
6Healthcare SpecialistModern LiteratureNaNUniversity collegeOmahaBetty CrockernullAudi V8832094FamilyNaN60429744068224301851245511952883952896Owen_Adler8395@womeona.net
7Investment AdvisorMusicNaNUniversity collegeLong BeachSecret RecipeNaNCitroen Nemo645818Romancenullnull1513945620991270455Kenzie_Ainsworth7824@nanoff.biz
8StockbrokerNaNnullCorporate universityMoreno ValleynullNaNFiat 500560429NaNnull67039639086570544381513945620991270455Peter_Ainsworth9788@nickia.com
9CashierAccountingResource ProgramGymnasiumNashvilleBel GroupKFCAudi Q3268487AnimationSci-Fi66692951997430464711513945620991270455Chad_Ainsworth2733@liret.org
10Production PainterNaNnullUniversity-preparatory schoolOrlandonullNaNAudi A5369460NaNnull41857739955466617451513945620991270455Bryon_Ainsworth1718@irrepsy.com
11HR CoordinatorArtSpeechUniversity collegeWienPizza HutNesquikHyundai Tucson43222ThrillerSci-Fi37835980823462565131513945620991270455Valentina_Ainsworth9363@liret.org
12WebmasterGrammarHistoryCorporate universityEl PasoHeinzAndy Capp's friesHyundai i35584686BiographyBiography91549918900297542055972706850620146064Matt_Alcroft3345@muall.tech
13Call Center RepresentativeSpanishArtHigh schoolMadridKFCRed LobsterCitroen Nemo110167RomanceDrama23934928997846971855972706850620146064Mark_Alcroft5996@ovock.tech
14Software EngineerHistorySpanishJunior collegeHuntsvillePizza HutBel GroupFord Mondeo263391FamilyRomance75753462528996894196884548124242581831Clint_Aldridge8702@cispeto.com
15DoctorArtPhysical EducationPublic universitySan BernardinoStarbucksRed LobsterHonda CRV107064ComedyBiography32355772783838024686884548124242581831Boris_Aldridge8688@nimogy.biz
16Web DeveloperTrigonometryArtGraduate schoolBernaLEonidasSun-PatAudi TT252513BiographyMusical22474596301449975025452220799772127725NaN
17Cash ManagerLatinnullTechnical collegeTulsaNabisconullFiat Freemont431684Thrillernull8756960135700471785452220799772127725Kurt_Alexander8851@ovock.tech
18Insurance BrokerAmerican LiteratureDramaticsGraduate schoolZurichKnorrWendy'sMazda CX3403772Sci-FiComedy59528382788400194005452220799772127725Javier_Alexander8393@gompie.com
19WebmasterResource ProgramMusicTechnical collegeLong BeachLEonidasVitta FoodsFiat Argo248789ActionMusical1956328899077870346467263162285791682Fred_Allen7346@cispeto.com
20Project ManagerLanguage ArtsScienceCorporate universityScottsdalePizza HutKinderDacia Sandero448237HistoryDrama4185773995546661745467263162285791682Bryon_Allen1891@twace.org
21Staffing ConsultantAncient CivilizationsGrammarUniversity collegeLincolnVitta FoodsSecret RecipeHyundai i2030032AdventureThriller52113848799934087473915227604749149746Leroy_Allington6930@cispeto.com
22HR CoordinatorEarth ScienceNaNHigh schoolSan BernardinoPapadopoulosNaNOpel Insignia841216FamilyNaN18180828328054185023915227604749149746Andie_Allington9567@vetan.org
23Associate ProfessorHandwritingMusicPublic universityBaltimoreApplebee'sDr. OetkerHonda Civic623661BiographyAction31393396579478888418906133069031974196Caleb_Allwood7654@gmail.com
24Laboratory TechnicianInstrumental MusicAccountingHigh schoolBridgeportKnorrVitta FoodsCitroen C4101958ThrillerAdventure70427625574728861107771254255227750831Noah_Andrews9063@joiniaa.com
25Staffing ConsultantMathematicsEnglish IVGraduate schoolSan AntonioBel GroupMagnumBMW X1598358ActionThriller41776028997474432927771254255227750831Winnie_Andrews944@qater.org
26BiologistPhysical EducationGermanTechnical collegeSan JoseNesquikSubwayHyundai Santa Fe167739ThrillerHorror26678375516213974927771254255227750831Cherish_Andrews263@mafthy.com
27Project ManagerDesign and technologyNaNMiddle schoolSanta AnaCarib BrewerynullAudi Q5154580BiographyNaN87558309534076946077771254255227750831Matthew_Andrews9832@dionrab.com
28Laboratory TechnicianMusicnullPublic universityWienStarbucksNaNMazda CX5185831Musicalnull45061010766894551707771254255227750831Johnny_Andrews8544@supunk.biz
29Design EngineerSpanishDesign and technologyPublic universityHendersonBurger KingNabiscoDacia Duster744523ThrillerThriller8909809787508259508484141246053636730Luke_Antcliff8245@sheye.org
.............................................
983Web DeveloperSpeechLatinMiddle schoolHollywoodSubwayPapadopoulosCitroen Jumper307866Sci-FiComedy21119619902936480867453927719886423563Hank_Wright8414@tonsy.org
984Global Logistics SupervisorLeadershipEconomicsCorporate universityLisbonOlymelCobblestoneAudi A4648380HistoryCrime64055906435288270507453927719886423563Liam_Wright2660@womeona.net
985DentistFrenchHistoryHigh schoolOklahoma CityPapadopoulosVitta FoodsAudi A4110665RomanceCrime66692951997430464717453927719886423563Chad_Wright9492@corti.com
986Web DeveloperSpeechResource ProgramUniversity collegeOklahoma CityNesquikCobblestoneAudi Cabriolet881909CrimeDrama50295835094670825187453927719886423563Alan_Wright1804@yahoo.com
987Insurance BrokerEcologySpanishTechnical collegeRenoDoritosAndy Capp's friesCitroen C3677283BiographySci-Fi66398528200313074557453927719886423563Bart_Wright9752@bungar.biz
988Business BrokerHistorySpanishJunior collegeTallahasseeCheetosVitta FoodsKia Sorento849632CrimeCrime77220777352367494657453927719886423563Sarah_Wright6269@supunk.biz
989DentistEconomicsDramaticsGymnasiumLancasterDominoNutellaCitroen C4320368AnimationDrama81909337782247330611624051484013556665Julius_Yang3284@hourpy.biz
990Healthcare SpecialistEcologyLanguage ArtsCorporate universityNorfolkBurger KingCarib BreweryBMW X5317678BiographyRomance56947085608010210851624051484013556665Erick_Yang7391@gompie.com
991InspectorScienceLeadershipUniversity-preparatory schoolFremontDr. OetkerKinderHyundai i30502415DramaAdventure82056634571891886696490845777576213122Aleksandra_Yard1020@womeona.net
992ElectricianMusicSpeechMiddle schoolAlbuquerqueApplebee'sOlymelOpel Astra396383HistoryBiography7813807661243340285601129917837199634Marla_Yarlett8267@nimogy.biz
993Software EngineerLOGICModern LiteratureGraduate schoolBerlinBel GroupPizza HutCitroen Nemo453841HorrorFamily82395710544585582672139171345624969609Eduardo_Yarwood8466@ovock.tech
994Executive DirectorNaNNaNGymnasiumCharlottenullNaNFord Fiesta759371nullnull31889877638159113647199010166483654596Cara_Yates8997@tonsy.org
995CooknullNaNGymnasiumPraguenullNaNCitroen C4450633nullnull56947085608010210857199010166483654596Erick_Yates3648@irrepsy.com
996WebmasterTrigonometryResource ProgramJunior collegeMurfreesboroWendy'sCobblestoneHyundai Elantra368343FamilyComedy23856258906199070878861084602755028556Cedrick_York7860@dionrab.com
997StockbrokerModern LiteratureEconomicsGymnasiumOntarioBaskin robbinsBaskin robbinsOpel Astra348532MusicalDrama11331386012000578278861084602755028556Mason_York2697@fuliss.net
998AuditorDesign and technologyGrammarGraduate schoolValettaTaco BellLEonidasFiat 50081510DramaMusical36403901763980592878861084602755028556Elijah_York8639@yahoo.com
999CookAccountingScienceJunior collegeBernaLavazzaSubwayHyundai Tucson642577AnimationThriller18780019021834276467451240902177457467Ryan_Young5697@vetan.org
1000Food TechnologistSpanishArtMiddle schoolDallasBewley'sBaskin robbinsHyundai i20467918FamilyHorror7527368424782504227451240902177457467Paige_Young7597@bauros.biz
1001Insurance BrokerGermanInstrumental MusicGraduate schoolSan AntonioCarib BreweryAndy Capp's friesMazda 6182430CrimeThriller62714046237204804433084286614218966688Barry_Zaoui5168@dionrab.com
1002Chef ManagerAmerican LiteratureEarth ScienceJunior collegeBakersfieldVitta FoodsSoproleCitroen Nemo20773Sci-FiMusicalnullnullJulian_Mullins5935@cispeto.com
1003AccountantModern LiteratureLatinHigh schoolBostonHeinzKitsKia Soul501421AnimationBiographynullnullDavid_Ainsworth8114@joiniaa.com
1004Investment AdvisorMathematicsGrammarHigh schoolCincinnatiRed LobsterBaskin robbinsMazda CX3674796ComedyFamilynullnullNaN
1005Ambulatory NurseLOGICLOGICTechnical collegeColorado SpringsBurger KingBetty CrockerMazda CX3733029FantasyMusicalnullnullNaN
1006LecturerMathematicsSpanishPublic universityEl PasoDr. OetkerKnorrFiat Freemont778289DramaFamilynullnullNaN
1007PharmacistEconomicsSpanishUniversity-preparatory schoolFort LauderdaleMagnumDunkin' DonutsMazda CX5501469RomanceAnimationnullnullNaN
1008Health EducatorLanguage ArtsEcologyGymnasiumHollywoodNesquikHeinzAudi Q3859034ActionThrillernullnullNaN
1009OperatorBasic MathFrenchGymnasiumInnsbruckDoritosDominoAudi Q7863596HistoryFamilynullnullNaN
1010HR CoordinatorSpanishEconomicsGraduate schoolLincolnKinderHeinzBMW X3705612ThrillerHorrornullnullNaN
1011Business BrokerScienceEconomicsHigh schoolLong BeachLEonidasWonder BreadHyundai i35500059ComedyRomance2094524843041668950nullJacob_Bolton6977@jiman.org
1012IT Support StaffnullnullPublic universityLyonNaNnullNaNnullNaNNaNnullnullNaN
\n", "

1013 rows × 14 columns

\n", "
" ], "text/plain": [ " Job Title Interests \\\n", "0 Chef Manager Music \n", "1 Machine Operator Sociology \n", "2 IT Support Staff null \n", "3 Executive Director Modern Literature \n", "4 Accountant Latin \n", "5 Systems Administrator Speech \n", "6 Healthcare Specialist Modern Literature \n", "7 Investment Advisor Music \n", "8 Stockbroker NaN \n", "9 Cashier Accounting \n", "10 Production Painter NaN \n", "11 HR Coordinator Art \n", "12 Webmaster Grammar \n", "13 Call Center Representative Spanish \n", "14 Software Engineer History \n", "15 Doctor Art \n", "16 Web Developer Trigonometry \n", "17 Cash Manager Latin \n", "18 Insurance Broker American Literature \n", "19 Webmaster Resource Program \n", "20 Project Manager Language Arts \n", "21 Staffing Consultant Ancient Civilizations \n", "22 HR Coordinator Earth Science \n", "23 Associate Professor Handwriting \n", "24 Laboratory Technician Instrumental Music \n", "25 Staffing Consultant Mathematics \n", "26 Biologist Physical Education \n", "27 Project Manager Design and technology \n", "28 Laboratory Technician Music \n", "29 Design Engineer Spanish \n", "... ... ... \n", "983 Web Developer Speech \n", "984 Global Logistics Supervisor Leadership \n", "985 Dentist French \n", "986 Web Developer Speech \n", "987 Insurance Broker Ecology \n", "988 Business Broker History \n", "989 Dentist Economics \n", "990 Healthcare Specialist Ecology \n", "991 Inspector Science \n", "992 Electrician Music \n", "993 Software Engineer LOGIC \n", "994 Executive Director NaN \n", "995 Cook null \n", "996 Webmaster Trigonometry \n", "997 Stockbroker Modern Literature \n", "998 Auditor Design and technology \n", "999 Cook Accounting \n", "1000 Food Technologist Spanish \n", "1001 Insurance Broker German \n", "1002 Chef Manager American Literature \n", "1003 Accountant Modern Literature \n", "1004 Investment Advisor Mathematics \n", "1005 Ambulatory Nurse LOGIC \n", "1006 Lecturer Mathematics \n", "1007 Pharmacist Economics \n", "1008 Health Educator Language Arts \n", "1009 Operator Basic Math \n", "1010 HR Coordinator Spanish \n", "1011 Business Broker Science \n", "1012 IT Support Staff null \n", "\n", " Interests.1 Education Level City \\\n", "0 Accounting Junior college Fremont \n", "1 Health Technical college Honolulu \n", "2 NaN Public university San Bernardino \n", "3 null High school Boston \n", "4 Language Arts Middle school Fayetteville \n", "5 null Junior college Houston \n", "6 NaN University college Omaha \n", "7 NaN University college Long Beach \n", "8 null Corporate university Moreno Valley \n", "9 Resource Program Gymnasium Nashville \n", "10 null University-preparatory school Orlando \n", "11 Speech University college Wien \n", "12 History Corporate university El Paso \n", "13 Art High school Madrid \n", "14 Spanish Junior college Huntsville \n", "15 Physical Education Public university San Bernardino \n", "16 Art Graduate school Berna \n", "17 null Technical college Tulsa \n", "18 Dramatics Graduate school Zurich \n", "19 Music Technical college Long Beach \n", "20 Science Corporate university Scottsdale \n", "21 Grammar University college Lincoln \n", "22 NaN High school San Bernardino \n", "23 Music Public university Baltimore \n", "24 Accounting High school Bridgeport \n", "25 English IV Graduate school San Antonio \n", "26 German Technical college San Jose \n", "27 NaN Middle school Santa Ana \n", "28 null Public university Wien \n", "29 Design and technology Public university Henderson \n", "... ... ... ... \n", "983 Latin Middle school Hollywood \n", "984 Economics Corporate university Lisbon \n", "985 History High school Oklahoma City \n", "986 Resource Program University college Oklahoma City \n", "987 Spanish Technical college Reno \n", "988 Spanish Junior college Tallahassee \n", "989 Dramatics Gymnasium Lancaster \n", "990 Language Arts Corporate university Norfolk \n", "991 Leadership University-preparatory school Fremont \n", "992 Speech Middle school Albuquerque \n", "993 Modern Literature Graduate school Berlin \n", "994 NaN Gymnasium Charlotte \n", "995 NaN Gymnasium Prague \n", "996 Resource Program Junior college Murfreesboro \n", "997 Economics Gymnasium Ontario \n", "998 Grammar Graduate school Valetta \n", "999 Science Junior college Berna \n", "1000 Art Middle school Dallas \n", "1001 Instrumental Music Graduate school San Antonio \n", "1002 Earth Science Junior college Bakersfield \n", "1003 Latin High school Boston \n", "1004 Grammar High school Cincinnati \n", "1005 LOGIC Technical college Colorado Springs \n", "1006 Spanish Public university El Paso \n", "1007 Spanish University-preparatory school Fort Lauderdale \n", "1008 Ecology Gymnasium Hollywood \n", "1009 French Gymnasium Innsbruck \n", "1010 Economics Graduate school Lincoln \n", "1011 Economics High school Long Beach \n", "1012 null Public university Lyon \n", "\n", " Food Food.1 Car Income Movie \\\n", "0 McDonald's Sun-Pat Audi Q7 801401 Animation \n", "1 Heinz Magnum Citroen Nemo 29159 Animation \n", "2 null NaN NaN null NaN \n", "3 KFC null Audi Q1 316511 Adventure \n", "4 Domino Papadopoulos BMW X6 442632 Musical \n", "5 Betty Crocker null BMW X3 235058 Drama \n", "6 Betty Crocker null Audi V8 832094 Family \n", "7 Secret Recipe NaN Citroen Nemo 645818 Romance \n", "8 null NaN Fiat 500 560429 NaN \n", "9 Bel Group KFC Audi Q3 268487 Animation \n", "10 null NaN Audi A5 369460 NaN \n", "11 Pizza Hut Nesquik Hyundai Tucson 43222 Thriller \n", "12 Heinz Andy Capp's fries Hyundai i35 584686 Biography \n", "13 KFC Red Lobster Citroen Nemo 110167 Romance \n", "14 Pizza Hut Bel Group Ford Mondeo 263391 Family \n", "15 Starbucks Red Lobster Honda CRV 107064 Comedy \n", "16 LEonidas Sun-Pat Audi TT 252513 Biography \n", "17 Nabisco null Fiat Freemont 431684 Thriller \n", "18 Knorr Wendy's Mazda CX3 403772 Sci-Fi \n", "19 LEonidas Vitta Foods Fiat Argo 248789 Action \n", "20 Pizza Hut Kinder Dacia Sandero 448237 History \n", "21 Vitta Foods Secret Recipe Hyundai i20 30032 Adventure \n", "22 Papadopoulos NaN Opel Insignia 841216 Family \n", "23 Applebee's Dr. Oetker Honda Civic 623661 Biography \n", "24 Knorr Vitta Foods Citroen C4 101958 Thriller \n", "25 Bel Group Magnum BMW X1 598358 Action \n", "26 Nesquik Subway Hyundai Santa Fe 167739 Thriller \n", "27 Carib Brewery null Audi Q5 154580 Biography \n", "28 Starbucks NaN Mazda CX5 185831 Musical \n", "29 Burger King Nabisco Dacia Duster 744523 Thriller \n", "... ... ... ... ... ... \n", "983 Subway Papadopoulos Citroen Jumper 307866 Sci-Fi \n", "984 Olymel Cobblestone Audi A4 648380 History \n", "985 Papadopoulos Vitta Foods Audi A4 110665 Romance \n", "986 Nesquik Cobblestone Audi Cabriolet 881909 Crime \n", "987 Doritos Andy Capp's fries Citroen C3 677283 Biography \n", "988 Cheetos Vitta Foods Kia Sorento 849632 Crime \n", "989 Domino Nutella Citroen C4 320368 Animation \n", "990 Burger King Carib Brewery BMW X5 317678 Biography \n", "991 Dr. Oetker Kinder Hyundai i30 502415 Drama \n", "992 Applebee's Olymel Opel Astra 396383 History \n", "993 Bel Group Pizza Hut Citroen Nemo 453841 Horror \n", "994 null NaN Ford Fiesta 759371 null \n", "995 null NaN Citroen C4 450633 null \n", "996 Wendy's Cobblestone Hyundai Elantra 368343 Family \n", "997 Baskin robbins Baskin robbins Opel Astra 348532 Musical \n", "998 Taco Bell LEonidas Fiat 500 81510 Drama \n", "999 Lavazza Subway Hyundai Tucson 642577 Animation \n", "1000 Bewley's Baskin robbins Hyundai i20 467918 Family \n", "1001 Carib Brewery Andy Capp's fries Mazda 6 182430 Crime \n", "1002 Vitta Foods Soprole Citroen Nemo 20773 Sci-Fi \n", "1003 Heinz Kits Kia Soul 501421 Animation \n", "1004 Red Lobster Baskin robbins Mazda CX3 674796 Comedy \n", "1005 Burger King Betty Crocker Mazda CX3 733029 Fantasy \n", "1006 Dr. Oetker Knorr Fiat Freemont 778289 Drama \n", "1007 Magnum Dunkin' Donuts Mazda CX5 501469 Romance \n", "1008 Nesquik Heinz Audi Q3 859034 Action \n", "1009 Doritos Domino Audi Q7 863596 History \n", "1010 Kinder Heinz BMW X3 705612 Thriller \n", "1011 LEonidas Wonder Bread Hyundai i35 500059 Comedy \n", "1012 NaN null NaN null NaN \n", "\n", " Movie.1 First Name Last Name \\\n", "0 Animation 5525928912288651861 4206759612282018337 \n", "1 Romance 7042762557472886110 4206759612282018337 \n", "2 null 844849795470077321 4206759612282018337 \n", "3 null 8649512297698996172 638013971769049753 \n", "4 Musical 645862383733150441 7268967984277984449 \n", "5 NaN 6495430883333919332 7268967984277984449 \n", "6 NaN 6042974406822430185 1245511952883952896 \n", "7 null null 1513945620991270455 \n", "8 null 6703963908657054438 1513945620991270455 \n", "9 Sci-Fi 6669295199743046471 1513945620991270455 \n", "10 null 4185773995546661745 1513945620991270455 \n", "11 Sci-Fi 3783598082346256513 1513945620991270455 \n", "12 Biography 9154991890029754205 5972706850620146064 \n", "13 Drama 2393492899784697185 5972706850620146064 \n", "14 Romance 7575346252899689419 6884548124242581831 \n", "15 Biography 3235577278383802468 6884548124242581831 \n", "16 Musical 2247459630144997502 5452220799772127725 \n", "17 null 875696013570047178 5452220799772127725 \n", "18 Comedy 5952838278840019400 5452220799772127725 \n", "19 Musical 1956328899077870346 467263162285791682 \n", "20 Drama 4185773995546661745 467263162285791682 \n", "21 Thriller 5211384879993408747 3915227604749149746 \n", "22 NaN 1818082832805418502 3915227604749149746 \n", "23 Action 3139339657947888841 8906133069031974196 \n", "24 Adventure 7042762557472886110 7771254255227750831 \n", "25 Thriller 4177602899747443292 7771254255227750831 \n", "26 Horror 2667837551621397492 7771254255227750831 \n", "27 NaN 8755830953407694607 7771254255227750831 \n", "28 null 4506101076689455170 7771254255227750831 \n", "29 Thriller 890980978750825950 8484141246053636730 \n", "... ... ... ... \n", "983 Comedy 2111961990293648086 7453927719886423563 \n", "984 Crime 6405590643528827050 7453927719886423563 \n", "985 Crime 6669295199743046471 7453927719886423563 \n", "986 Drama 5029583509467082518 7453927719886423563 \n", "987 Sci-Fi 6639852820031307455 7453927719886423563 \n", "988 Crime 7722077735236749465 7453927719886423563 \n", "989 Drama 8190933778224733061 1624051484013556665 \n", "990 Romance 5694708560801021085 1624051484013556665 \n", "991 Adventure 8205663457189188669 6490845777576213122 \n", "992 Biography 781380766124334028 5601129917837199634 \n", "993 Family 8239571054458558267 2139171345624969609 \n", "994 null 3188987763815911364 7199010166483654596 \n", "995 null 5694708560801021085 7199010166483654596 \n", "996 Comedy 2385625890619907087 8861084602755028556 \n", "997 Drama 1133138601200057827 8861084602755028556 \n", "998 Musical 3640390176398059287 8861084602755028556 \n", "999 Thriller 1878001902183427646 7451240902177457467 \n", "1000 Horror 752736842478250422 7451240902177457467 \n", "1001 Thriller 6271404623720480443 3084286614218966688 \n", "1002 Musical null null \n", "1003 Biography null null \n", "1004 Family null null \n", "1005 Musical null null \n", "1006 Family null null \n", "1007 Animation null null \n", "1008 Thriller null null \n", "1009 Family null null \n", "1010 Horror null null \n", "1011 Romance 2094524843041668950 null \n", "1012 NaN null null \n", "\n", " Email \n", "0 Gil_Abbey1862@irrepsy.com \n", "1 Noah_Abbey3942@ubusive.com \n", "2 null \n", "3 Judith_Adams7583@irrepsy.com \n", "4 Alessia_Addis5500@cispeto.com \n", "5 Melania_Addis8320@guentu.biz \n", "6 Owen_Adler8395@womeona.net \n", "7 Kenzie_Ainsworth7824@nanoff.biz \n", "8 Peter_Ainsworth9788@nickia.com \n", "9 Chad_Ainsworth2733@liret.org \n", "10 Bryon_Ainsworth1718@irrepsy.com \n", "11 Valentina_Ainsworth9363@liret.org \n", "12 Matt_Alcroft3345@muall.tech \n", "13 Mark_Alcroft5996@ovock.tech \n", "14 Clint_Aldridge8702@cispeto.com \n", "15 Boris_Aldridge8688@nimogy.biz \n", "16 NaN \n", "17 Kurt_Alexander8851@ovock.tech \n", "18 Javier_Alexander8393@gompie.com \n", "19 Fred_Allen7346@cispeto.com \n", "20 Bryon_Allen1891@twace.org \n", "21 Leroy_Allington6930@cispeto.com \n", "22 Andie_Allington9567@vetan.org \n", "23 Caleb_Allwood7654@gmail.com \n", "24 Noah_Andrews9063@joiniaa.com \n", "25 Winnie_Andrews944@qater.org \n", "26 Cherish_Andrews263@mafthy.com \n", "27 Matthew_Andrews9832@dionrab.com \n", "28 Johnny_Andrews8544@supunk.biz \n", "29 Luke_Antcliff8245@sheye.org \n", "... ... \n", "983 Hank_Wright8414@tonsy.org \n", "984 Liam_Wright2660@womeona.net \n", "985 Chad_Wright9492@corti.com \n", "986 Alan_Wright1804@yahoo.com \n", "987 Bart_Wright9752@bungar.biz \n", "988 Sarah_Wright6269@supunk.biz \n", "989 Julius_Yang3284@hourpy.biz \n", "990 Erick_Yang7391@gompie.com \n", "991 Aleksandra_Yard1020@womeona.net \n", "992 Marla_Yarlett8267@nimogy.biz \n", "993 Eduardo_Yarwood8466@ovock.tech \n", "994 Cara_Yates8997@tonsy.org \n", "995 Erick_Yates3648@irrepsy.com \n", "996 Cedrick_York7860@dionrab.com \n", "997 Mason_York2697@fuliss.net \n", "998 Elijah_York8639@yahoo.com \n", "999 Ryan_Young5697@vetan.org \n", "1000 Paige_Young7597@bauros.biz \n", "1001 Barry_Zaoui5168@dionrab.com \n", "1002 Julian_Mullins5935@cispeto.com \n", "1003 David_Ainsworth8114@joiniaa.com \n", "1004 NaN \n", "1005 NaN \n", "1006 NaN \n", "1007 NaN \n", "1008 NaN \n", "1009 NaN \n", "1010 NaN \n", "1011 Jacob_Bolton6977@jiman.org \n", "1012 NaN \n", "\n", "[1013 rows x 14 columns]" ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#QUESTION 2 - null values and consistency\n", "#I will treat 0 (string), none, 0, '' as null values\n", "\n", "df=df.replace(0,\"null\")\n", "df=df.replace(\"none\",\"null\")\n", "df=df.replace('',\"null\")\n", "df=df.replace(\"0\",\"null\")\n", "df" ] }, { "cell_type": "code", "execution_count": 16, "metadata": {}, "outputs": [], "source": [ "#QUESTION 3\n", "#Removing any customer data that has missing data in any of the following:\n", "#first, last and email\n", "\n", "\n" ] }, { "cell_type": "code", "execution_count": 20, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Job TitleInterestsInterests.1Education LevelCityFoodFood.1CarIncomeMovieMovie.1First NameLast NameEmail
0Chef ManagerMusicAccountingJunior collegeFremontMcDonald'sSun-PatAudi Q7801401AnimationAnimation55259289122886518614206759612282018337Gil_Abbey1862@irrepsy.com
1Machine OperatorSociologyHealthTechnical collegeHonoluluHeinzMagnumCitroen Nemo29159AnimationRomance70427625574728861104206759612282018337Noah_Abbey3942@ubusive.com
2IT Support StaffnullNaNPublic universitySan BernardinonullNaNNaNnullNaNnull8448497954700773214206759612282018337null
3Executive DirectorModern LiteraturenullHigh schoolBostonKFCnullAudi Q1316511Adventurenull8649512297698996172638013971769049753Judith_Adams7583@irrepsy.com
4AccountantLatinLanguage ArtsMiddle schoolFayettevilleDominoPapadopoulosBMW X6442632MusicalMusical6458623837331504417268967984277984449Alessia_Addis5500@cispeto.com
5Systems AdministratorSpeechnullJunior collegeHoustonBetty CrockernullBMW X3235058DramaNaN64954308833339193327268967984277984449Melania_Addis8320@guentu.biz
6Healthcare SpecialistModern LiteratureNaNUniversity collegeOmahaBetty CrockernullAudi V8832094FamilyNaN60429744068224301851245511952883952896Owen_Adler8395@womeona.net
7Investment AdvisorMusicNaNUniversity collegeLong BeachSecret RecipeNaNCitroen Nemo645818Romancenullnull1513945620991270455Kenzie_Ainsworth7824@nanoff.biz
8StockbrokerNaNnullCorporate universityMoreno ValleynullNaNFiat 500560429NaNnull67039639086570544381513945620991270455Peter_Ainsworth9788@nickia.com
9CashierAccountingResource ProgramGymnasiumNashvilleBel GroupKFCAudi Q3268487AnimationSci-Fi66692951997430464711513945620991270455Chad_Ainsworth2733@liret.org
10Production PainterNaNnullUniversity-preparatory schoolOrlandonullNaNAudi A5369460NaNnull41857739955466617451513945620991270455Bryon_Ainsworth1718@irrepsy.com
11HR CoordinatorArtSpeechUniversity collegeWienPizza HutNesquikHyundai Tucson43222ThrillerSci-Fi37835980823462565131513945620991270455Valentina_Ainsworth9363@liret.org
12WebmasterGrammarHistoryCorporate universityEl PasoHeinzAndy Capp's friesHyundai i35584686BiographyBiography91549918900297542055972706850620146064Matt_Alcroft3345@muall.tech
13Call Center RepresentativeSpanishArtHigh schoolMadridKFCRed LobsterCitroen Nemo110167RomanceDrama23934928997846971855972706850620146064Mark_Alcroft5996@ovock.tech
14Software EngineerHistorySpanishJunior collegeHuntsvillePizza HutBel GroupFord Mondeo263391FamilyRomance75753462528996894196884548124242581831Clint_Aldridge8702@cispeto.com
15DoctorArtPhysical EducationPublic universitySan BernardinoStarbucksRed LobsterHonda CRV107064ComedyBiography32355772783838024686884548124242581831Boris_Aldridge8688@nimogy.biz
17Cash ManagerLatinnullTechnical collegeTulsaNabisconullFiat Freemont431684Thrillernull8756960135700471785452220799772127725Kurt_Alexander8851@ovock.tech
18Insurance BrokerAmerican LiteratureDramaticsGraduate schoolZurichKnorrWendy'sMazda CX3403772Sci-FiComedy59528382788400194005452220799772127725Javier_Alexander8393@gompie.com
19WebmasterResource ProgramMusicTechnical collegeLong BeachLEonidasVitta FoodsFiat Argo248789ActionMusical1956328899077870346467263162285791682Fred_Allen7346@cispeto.com
20Project ManagerLanguage ArtsScienceCorporate universityScottsdalePizza HutKinderDacia Sandero448237HistoryDrama4185773995546661745467263162285791682Bryon_Allen1891@twace.org
21Staffing ConsultantAncient CivilizationsGrammarUniversity collegeLincolnVitta FoodsSecret RecipeHyundai i2030032AdventureThriller52113848799934087473915227604749149746Leroy_Allington6930@cispeto.com
22HR CoordinatorEarth ScienceNaNHigh schoolSan BernardinoPapadopoulosNaNOpel Insignia841216FamilyNaN18180828328054185023915227604749149746Andie_Allington9567@vetan.org
23Associate ProfessorHandwritingMusicPublic universityBaltimoreApplebee'sDr. OetkerHonda Civic623661BiographyAction31393396579478888418906133069031974196Caleb_Allwood7654@gmail.com
24Laboratory TechnicianInstrumental MusicAccountingHigh schoolBridgeportKnorrVitta FoodsCitroen C4101958ThrillerAdventure70427625574728861107771254255227750831Noah_Andrews9063@joiniaa.com
25Staffing ConsultantMathematicsEnglish IVGraduate schoolSan AntonioBel GroupMagnumBMW X1598358ActionThriller41776028997474432927771254255227750831Winnie_Andrews944@qater.org
26BiologistPhysical EducationGermanTechnical collegeSan JoseNesquikSubwayHyundai Santa Fe167739ThrillerHorror26678375516213974927771254255227750831Cherish_Andrews263@mafthy.com
27Project ManagerDesign and technologyNaNMiddle schoolSanta AnaCarib BrewerynullAudi Q5154580BiographyNaN87558309534076946077771254255227750831Matthew_Andrews9832@dionrab.com
28Laboratory TechnicianMusicnullPublic universityWienStarbucksNaNMazda CX5185831Musicalnull45061010766894551707771254255227750831Johnny_Andrews8544@supunk.biz
29Design EngineerSpanishDesign and technologyPublic universityHendersonBurger KingNabiscoDacia Duster744523ThrillerThriller8909809787508259508484141246053636730Luke_Antcliff8245@sheye.org
30DentistEcologynullJunior collegeMiamiCarib BrewerynullCitroen C4157286Comedynull48522283799048297988484141246053636730Cadence_Antcliff1058@ovock.tech
.............................................
975Healthcare SpecialistGermanDesign and technologyMiddle schoolDetroitCarib BreweryKnorrFiat Panda99405ActionSci-Fi57802378766505362334781517554128201224Henry_Woods8709@hourpy.biz
976Production PainterDesign and technologyDramaticsCorporate universityInnsbruckVitta FoodsMcDonald'sOpel Astra478967RomanceComedy43011469483287472864410089280501602376Brad_Wooldridge4318@acrit.org
977HR CoordinatorBasic MathnullJunior collegeHoustonApplebee'sNaNMitsubishi Outlander135724Musicalnull45719876848933458983567034275951807655David_Wren7982@bauros.biz
978FabricatorDesign and technologyLeadershipPublic universityLouisvilleCheetosSoproleBMW X1813699RomanceThriller82395710544585582673567034275951807655Eduardo_Wren548@nanoff.biz
979ParamedicMathematicsModern LiteratureUniversity collegeNorfolkStarbucksHeinzKia Sorento479487HorrorMusical56533160482607422563567034275951807655Kamila_Wren7179@jiman.org
980StewardnullNaNTechnical collegeDenvernullNaNNaNnullNaNnull5072386268710952837453927719886423563null
981CNC OperatorGeographyLatinPublic universityEscondidoMcDonald'sBurger KingAudi R8290622MusicalCrime13675086491216135277453927719886423563Callie_Wright9976@qater.org
982ElectricianScienceBasic MathUniversity collegeFayettevilleKitsVitta FoodsFord Fiesta525270AdventureHorror70427625574728861107453927719886423563Noah_Wright1442@gmail.com
983Web DeveloperSpeechLatinMiddle schoolHollywoodSubwayPapadopoulosCitroen Jumper307866Sci-FiComedy21119619902936480867453927719886423563Hank_Wright8414@tonsy.org
984Global Logistics SupervisorLeadershipEconomicsCorporate universityLisbonOlymelCobblestoneAudi A4648380HistoryCrime64055906435288270507453927719886423563Liam_Wright2660@womeona.net
985DentistFrenchHistoryHigh schoolOklahoma CityPapadopoulosVitta FoodsAudi A4110665RomanceCrime66692951997430464717453927719886423563Chad_Wright9492@corti.com
986Web DeveloperSpeechResource ProgramUniversity collegeOklahoma CityNesquikCobblestoneAudi Cabriolet881909CrimeDrama50295835094670825187453927719886423563Alan_Wright1804@yahoo.com
987Insurance BrokerEcologySpanishTechnical collegeRenoDoritosAndy Capp's friesCitroen C3677283BiographySci-Fi66398528200313074557453927719886423563Bart_Wright9752@bungar.biz
988Business BrokerHistorySpanishJunior collegeTallahasseeCheetosVitta FoodsKia Sorento849632CrimeCrime77220777352367494657453927719886423563Sarah_Wright6269@supunk.biz
989DentistEconomicsDramaticsGymnasiumLancasterDominoNutellaCitroen C4320368AnimationDrama81909337782247330611624051484013556665Julius_Yang3284@hourpy.biz
990Healthcare SpecialistEcologyLanguage ArtsCorporate universityNorfolkBurger KingCarib BreweryBMW X5317678BiographyRomance56947085608010210851624051484013556665Erick_Yang7391@gompie.com
991InspectorScienceLeadershipUniversity-preparatory schoolFremontDr. OetkerKinderHyundai i30502415DramaAdventure82056634571891886696490845777576213122Aleksandra_Yard1020@womeona.net
992ElectricianMusicSpeechMiddle schoolAlbuquerqueApplebee'sOlymelOpel Astra396383HistoryBiography7813807661243340285601129917837199634Marla_Yarlett8267@nimogy.biz
993Software EngineerLOGICModern LiteratureGraduate schoolBerlinBel GroupPizza HutCitroen Nemo453841HorrorFamily82395710544585582672139171345624969609Eduardo_Yarwood8466@ovock.tech
994Executive DirectorNaNNaNGymnasiumCharlottenullNaNFord Fiesta759371nullnull31889877638159113647199010166483654596Cara_Yates8997@tonsy.org
995CooknullNaNGymnasiumPraguenullNaNCitroen C4450633nullnull56947085608010210857199010166483654596Erick_Yates3648@irrepsy.com
996WebmasterTrigonometryResource ProgramJunior collegeMurfreesboroWendy'sCobblestoneHyundai Elantra368343FamilyComedy23856258906199070878861084602755028556Cedrick_York7860@dionrab.com
997StockbrokerModern LiteratureEconomicsGymnasiumOntarioBaskin robbinsBaskin robbinsOpel Astra348532MusicalDrama11331386012000578278861084602755028556Mason_York2697@fuliss.net
998AuditorDesign and technologyGrammarGraduate schoolValettaTaco BellLEonidasFiat 50081510DramaMusical36403901763980592878861084602755028556Elijah_York8639@yahoo.com
999CookAccountingScienceJunior collegeBernaLavazzaSubwayHyundai Tucson642577AnimationThriller18780019021834276467451240902177457467Ryan_Young5697@vetan.org
1000Food TechnologistSpanishArtMiddle schoolDallasBewley'sBaskin robbinsHyundai i20467918FamilyHorror7527368424782504227451240902177457467Paige_Young7597@bauros.biz
1001Insurance BrokerGermanInstrumental MusicGraduate schoolSan AntonioCarib BreweryAndy Capp's friesMazda 6182430CrimeThriller62714046237204804433084286614218966688Barry_Zaoui5168@dionrab.com
1002Chef ManagerAmerican LiteratureEarth ScienceJunior collegeBakersfieldVitta FoodsSoproleCitroen Nemo20773Sci-FiMusicalnullnullJulian_Mullins5935@cispeto.com
1003AccountantModern LiteratureLatinHigh schoolBostonHeinzKitsKia Soul501421AnimationBiographynullnullDavid_Ainsworth8114@joiniaa.com
1011Business BrokerScienceEconomicsHigh schoolLong BeachLEonidasWonder BreadHyundai i35500059ComedyRomance2094524843041668950nullJacob_Bolton6977@jiman.org
\n", "

995 rows × 14 columns

\n", "
" ], "text/plain": [ " Job Title Interests \\\n", "0 Chef Manager Music \n", "1 Machine Operator Sociology \n", "2 IT Support Staff null \n", "3 Executive Director Modern Literature \n", "4 Accountant Latin \n", "5 Systems Administrator Speech \n", "6 Healthcare Specialist Modern Literature \n", "7 Investment Advisor Music \n", "8 Stockbroker NaN \n", "9 Cashier Accounting \n", "10 Production Painter NaN \n", "11 HR Coordinator Art \n", "12 Webmaster Grammar \n", "13 Call Center Representative Spanish \n", "14 Software Engineer History \n", "15 Doctor Art \n", "17 Cash Manager Latin \n", "18 Insurance Broker American Literature \n", "19 Webmaster Resource Program \n", "20 Project Manager Language Arts \n", "21 Staffing Consultant Ancient Civilizations \n", "22 HR Coordinator Earth Science \n", "23 Associate Professor Handwriting \n", "24 Laboratory Technician Instrumental Music \n", "25 Staffing Consultant Mathematics \n", "26 Biologist Physical Education \n", "27 Project Manager Design and technology \n", "28 Laboratory Technician Music \n", "29 Design Engineer Spanish \n", "30 Dentist Ecology \n", "... ... ... \n", "975 Healthcare Specialist German \n", "976 Production Painter Design and technology \n", "977 HR Coordinator Basic Math \n", "978 Fabricator Design and technology \n", "979 Paramedic Mathematics \n", "980 Steward null \n", "981 CNC Operator Geography \n", "982 Electrician Science \n", "983 Web Developer Speech \n", "984 Global Logistics Supervisor Leadership \n", "985 Dentist French \n", "986 Web Developer Speech \n", "987 Insurance Broker Ecology \n", "988 Business Broker History \n", "989 Dentist Economics \n", "990 Healthcare Specialist Ecology \n", "991 Inspector Science \n", "992 Electrician Music \n", "993 Software Engineer LOGIC \n", "994 Executive Director NaN \n", "995 Cook null \n", "996 Webmaster Trigonometry \n", "997 Stockbroker Modern Literature \n", "998 Auditor Design and technology \n", "999 Cook Accounting \n", "1000 Food Technologist Spanish \n", "1001 Insurance Broker German \n", "1002 Chef Manager American Literature \n", "1003 Accountant Modern Literature \n", "1011 Business Broker Science \n", "\n", " Interests.1 Education Level City \\\n", "0 Accounting Junior college Fremont \n", "1 Health Technical college Honolulu \n", "2 NaN Public university San Bernardino \n", "3 null High school Boston \n", "4 Language Arts Middle school Fayetteville \n", "5 null Junior college Houston \n", "6 NaN University college Omaha \n", "7 NaN University college Long Beach \n", "8 null Corporate university Moreno Valley \n", "9 Resource Program Gymnasium Nashville \n", "10 null University-preparatory school Orlando \n", "11 Speech University college Wien \n", "12 History Corporate university El Paso \n", "13 Art High school Madrid \n", "14 Spanish Junior college Huntsville \n", "15 Physical Education Public university San Bernardino \n", "17 null Technical college Tulsa \n", "18 Dramatics Graduate school Zurich \n", "19 Music Technical college Long Beach \n", "20 Science Corporate university Scottsdale \n", "21 Grammar University college Lincoln \n", "22 NaN High school San Bernardino \n", "23 Music Public university Baltimore \n", "24 Accounting High school Bridgeport \n", "25 English IV Graduate school San Antonio \n", "26 German Technical college San Jose \n", "27 NaN Middle school Santa Ana \n", "28 null Public university Wien \n", "29 Design and technology Public university Henderson \n", "30 null Junior college Miami \n", "... ... ... ... \n", "975 Design and technology Middle school Detroit \n", "976 Dramatics Corporate university Innsbruck \n", "977 null Junior college Houston \n", "978 Leadership Public university Louisville \n", "979 Modern Literature University college Norfolk \n", "980 NaN Technical college Denver \n", "981 Latin Public university Escondido \n", "982 Basic Math University college Fayetteville \n", "983 Latin Middle school Hollywood \n", "984 Economics Corporate university Lisbon \n", "985 History High school Oklahoma City \n", "986 Resource Program University college Oklahoma City \n", "987 Spanish Technical college Reno \n", "988 Spanish Junior college Tallahassee \n", "989 Dramatics Gymnasium Lancaster \n", "990 Language Arts Corporate university Norfolk \n", "991 Leadership University-preparatory school Fremont \n", "992 Speech Middle school Albuquerque \n", "993 Modern Literature Graduate school Berlin \n", "994 NaN Gymnasium Charlotte \n", "995 NaN Gymnasium Prague \n", "996 Resource Program Junior college Murfreesboro \n", "997 Economics Gymnasium Ontario \n", "998 Grammar Graduate school Valetta \n", "999 Science Junior college Berna \n", "1000 Art Middle school Dallas \n", "1001 Instrumental Music Graduate school San Antonio \n", "1002 Earth Science Junior college Bakersfield \n", "1003 Latin High school Boston \n", "1011 Economics High school Long Beach \n", "\n", " Food Food.1 Car Income \\\n", "0 McDonald's Sun-Pat Audi Q7 801401 \n", "1 Heinz Magnum Citroen Nemo 29159 \n", "2 null NaN NaN null \n", "3 KFC null Audi Q1 316511 \n", "4 Domino Papadopoulos BMW X6 442632 \n", "5 Betty Crocker null BMW X3 235058 \n", "6 Betty Crocker null Audi V8 832094 \n", "7 Secret Recipe NaN Citroen Nemo 645818 \n", "8 null NaN Fiat 500 560429 \n", "9 Bel Group KFC Audi Q3 268487 \n", "10 null NaN Audi A5 369460 \n", "11 Pizza Hut Nesquik Hyundai Tucson 43222 \n", "12 Heinz Andy Capp's fries Hyundai i35 584686 \n", "13 KFC Red Lobster Citroen Nemo 110167 \n", "14 Pizza Hut Bel Group Ford Mondeo 263391 \n", "15 Starbucks Red Lobster Honda CRV 107064 \n", "17 Nabisco null Fiat Freemont 431684 \n", "18 Knorr Wendy's Mazda CX3 403772 \n", "19 LEonidas Vitta Foods Fiat Argo 248789 \n", "20 Pizza Hut Kinder Dacia Sandero 448237 \n", "21 Vitta Foods Secret Recipe Hyundai i20 30032 \n", "22 Papadopoulos NaN Opel Insignia 841216 \n", "23 Applebee's Dr. Oetker Honda Civic 623661 \n", "24 Knorr Vitta Foods Citroen C4 101958 \n", "25 Bel Group Magnum BMW X1 598358 \n", "26 Nesquik Subway Hyundai Santa Fe 167739 \n", "27 Carib Brewery null Audi Q5 154580 \n", "28 Starbucks NaN Mazda CX5 185831 \n", "29 Burger King Nabisco Dacia Duster 744523 \n", "30 Carib Brewery null Citroen C4 157286 \n", "... ... ... ... ... \n", "975 Carib Brewery Knorr Fiat Panda 99405 \n", "976 Vitta Foods McDonald's Opel Astra 478967 \n", "977 Applebee's NaN Mitsubishi Outlander 135724 \n", "978 Cheetos Soprole BMW X1 813699 \n", "979 Starbucks Heinz Kia Sorento 479487 \n", "980 null NaN NaN null \n", "981 McDonald's Burger King Audi R8 290622 \n", "982 Kits Vitta Foods Ford Fiesta 525270 \n", "983 Subway Papadopoulos Citroen Jumper 307866 \n", "984 Olymel Cobblestone Audi A4 648380 \n", "985 Papadopoulos Vitta Foods Audi A4 110665 \n", "986 Nesquik Cobblestone Audi Cabriolet 881909 \n", "987 Doritos Andy Capp's fries Citroen C3 677283 \n", "988 Cheetos Vitta Foods Kia Sorento 849632 \n", "989 Domino Nutella Citroen C4 320368 \n", "990 Burger King Carib Brewery BMW X5 317678 \n", "991 Dr. Oetker Kinder Hyundai i30 502415 \n", "992 Applebee's Olymel Opel Astra 396383 \n", "993 Bel Group Pizza Hut Citroen Nemo 453841 \n", "994 null NaN Ford Fiesta 759371 \n", "995 null NaN Citroen C4 450633 \n", "996 Wendy's Cobblestone Hyundai Elantra 368343 \n", "997 Baskin robbins Baskin robbins Opel Astra 348532 \n", "998 Taco Bell LEonidas Fiat 500 81510 \n", "999 Lavazza Subway Hyundai Tucson 642577 \n", "1000 Bewley's Baskin robbins Hyundai i20 467918 \n", "1001 Carib Brewery Andy Capp's fries Mazda 6 182430 \n", "1002 Vitta Foods Soprole Citroen Nemo 20773 \n", "1003 Heinz Kits Kia Soul 501421 \n", "1011 LEonidas Wonder Bread Hyundai i35 500059 \n", "\n", " Movie Movie.1 First Name Last Name \\\n", "0 Animation Animation 5525928912288651861 4206759612282018337 \n", "1 Animation Romance 7042762557472886110 4206759612282018337 \n", "2 NaN null 844849795470077321 4206759612282018337 \n", "3 Adventure null 8649512297698996172 638013971769049753 \n", "4 Musical Musical 645862383733150441 7268967984277984449 \n", "5 Drama NaN 6495430883333919332 7268967984277984449 \n", "6 Family NaN 6042974406822430185 1245511952883952896 \n", "7 Romance null null 1513945620991270455 \n", "8 NaN null 6703963908657054438 1513945620991270455 \n", "9 Animation Sci-Fi 6669295199743046471 1513945620991270455 \n", "10 NaN null 4185773995546661745 1513945620991270455 \n", "11 Thriller Sci-Fi 3783598082346256513 1513945620991270455 \n", "12 Biography Biography 9154991890029754205 5972706850620146064 \n", "13 Romance Drama 2393492899784697185 5972706850620146064 \n", "14 Family Romance 7575346252899689419 6884548124242581831 \n", "15 Comedy Biography 3235577278383802468 6884548124242581831 \n", "17 Thriller null 875696013570047178 5452220799772127725 \n", "18 Sci-Fi Comedy 5952838278840019400 5452220799772127725 \n", "19 Action Musical 1956328899077870346 467263162285791682 \n", "20 History Drama 4185773995546661745 467263162285791682 \n", "21 Adventure Thriller 5211384879993408747 3915227604749149746 \n", "22 Family NaN 1818082832805418502 3915227604749149746 \n", "23 Biography Action 3139339657947888841 8906133069031974196 \n", "24 Thriller Adventure 7042762557472886110 7771254255227750831 \n", "25 Action Thriller 4177602899747443292 7771254255227750831 \n", "26 Thriller Horror 2667837551621397492 7771254255227750831 \n", "27 Biography NaN 8755830953407694607 7771254255227750831 \n", "28 Musical null 4506101076689455170 7771254255227750831 \n", "29 Thriller Thriller 890980978750825950 8484141246053636730 \n", "30 Comedy null 4852228379904829798 8484141246053636730 \n", "... ... ... ... ... \n", "975 Action Sci-Fi 5780237876650536233 4781517554128201224 \n", "976 Romance Comedy 4301146948328747286 4410089280501602376 \n", "977 Musical null 4571987684893345898 3567034275951807655 \n", "978 Romance Thriller 8239571054458558267 3567034275951807655 \n", "979 Horror Musical 5653316048260742256 3567034275951807655 \n", "980 NaN null 507238626871095283 7453927719886423563 \n", "981 Musical Crime 1367508649121613527 7453927719886423563 \n", "982 Adventure Horror 7042762557472886110 7453927719886423563 \n", "983 Sci-Fi Comedy 2111961990293648086 7453927719886423563 \n", "984 History Crime 6405590643528827050 7453927719886423563 \n", "985 Romance Crime 6669295199743046471 7453927719886423563 \n", "986 Crime Drama 5029583509467082518 7453927719886423563 \n", "987 Biography Sci-Fi 6639852820031307455 7453927719886423563 \n", "988 Crime Crime 7722077735236749465 7453927719886423563 \n", "989 Animation Drama 8190933778224733061 1624051484013556665 \n", "990 Biography Romance 5694708560801021085 1624051484013556665 \n", "991 Drama Adventure 8205663457189188669 6490845777576213122 \n", "992 History Biography 781380766124334028 5601129917837199634 \n", "993 Horror Family 8239571054458558267 2139171345624969609 \n", "994 null null 3188987763815911364 7199010166483654596 \n", "995 null null 5694708560801021085 7199010166483654596 \n", "996 Family Comedy 2385625890619907087 8861084602755028556 \n", "997 Musical Drama 1133138601200057827 8861084602755028556 \n", "998 Drama Musical 3640390176398059287 8861084602755028556 \n", "999 Animation Thriller 1878001902183427646 7451240902177457467 \n", "1000 Family Horror 752736842478250422 7451240902177457467 \n", "1001 Crime Thriller 6271404623720480443 3084286614218966688 \n", "1002 Sci-Fi Musical null null \n", "1003 Animation Biography null null \n", "1011 Comedy Romance 2094524843041668950 null \n", "\n", " Email \n", "0 Gil_Abbey1862@irrepsy.com \n", "1 Noah_Abbey3942@ubusive.com \n", "2 null \n", "3 Judith_Adams7583@irrepsy.com \n", "4 Alessia_Addis5500@cispeto.com \n", "5 Melania_Addis8320@guentu.biz \n", "6 Owen_Adler8395@womeona.net \n", "7 Kenzie_Ainsworth7824@nanoff.biz \n", "8 Peter_Ainsworth9788@nickia.com \n", "9 Chad_Ainsworth2733@liret.org \n", "10 Bryon_Ainsworth1718@irrepsy.com \n", "11 Valentina_Ainsworth9363@liret.org \n", "12 Matt_Alcroft3345@muall.tech \n", "13 Mark_Alcroft5996@ovock.tech \n", "14 Clint_Aldridge8702@cispeto.com \n", "15 Boris_Aldridge8688@nimogy.biz \n", "17 Kurt_Alexander8851@ovock.tech \n", "18 Javier_Alexander8393@gompie.com \n", "19 Fred_Allen7346@cispeto.com \n", "20 Bryon_Allen1891@twace.org \n", "21 Leroy_Allington6930@cispeto.com \n", "22 Andie_Allington9567@vetan.org \n", "23 Caleb_Allwood7654@gmail.com \n", "24 Noah_Andrews9063@joiniaa.com \n", "25 Winnie_Andrews944@qater.org \n", "26 Cherish_Andrews263@mafthy.com \n", "27 Matthew_Andrews9832@dionrab.com \n", "28 Johnny_Andrews8544@supunk.biz \n", "29 Luke_Antcliff8245@sheye.org \n", "30 Cadence_Antcliff1058@ovock.tech \n", "... ... \n", "975 Henry_Woods8709@hourpy.biz \n", "976 Brad_Wooldridge4318@acrit.org \n", "977 David_Wren7982@bauros.biz \n", "978 Eduardo_Wren548@nanoff.biz \n", "979 Kamila_Wren7179@jiman.org \n", "980 null \n", "981 Callie_Wright9976@qater.org \n", "982 Noah_Wright1442@gmail.com \n", "983 Hank_Wright8414@tonsy.org \n", "984 Liam_Wright2660@womeona.net \n", "985 Chad_Wright9492@corti.com \n", "986 Alan_Wright1804@yahoo.com \n", "987 Bart_Wright9752@bungar.biz \n", "988 Sarah_Wright6269@supunk.biz \n", "989 Julius_Yang3284@hourpy.biz \n", "990 Erick_Yang7391@gompie.com \n", "991 Aleksandra_Yard1020@womeona.net \n", "992 Marla_Yarlett8267@nimogy.biz \n", "993 Eduardo_Yarwood8466@ovock.tech \n", "994 Cara_Yates8997@tonsy.org \n", "995 Erick_Yates3648@irrepsy.com \n", "996 Cedrick_York7860@dionrab.com \n", "997 Mason_York2697@fuliss.net \n", "998 Elijah_York8639@yahoo.com \n", "999 Ryan_Young5697@vetan.org \n", "1000 Paige_Young7597@bauros.biz \n", "1001 Barry_Zaoui5168@dionrab.com \n", "1002 Julian_Mullins5935@cispeto.com \n", "1003 David_Ainsworth8114@joiniaa.com \n", "1011 Jacob_Bolton6977@jiman.org \n", "\n", "[995 rows x 14 columns]" ] }, "execution_count": 20, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df=df.dropna(subset=[\"First Name\",\"Last Name\",\"Email\"])\n", "df" ] }, { "cell_type": "code", "execution_count": 22, "metadata": {}, "outputs": [], "source": [ "#Question 4 - exporting the data\n", "df=df.to_csv('newdata.csv')" ] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "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.7.3" } }, "nbformat": 4, "nbformat_minor": 2 }