Babynames: Popularity of City Names

Author

Grayson Kelley

Hypothesis

For this project, I will be analyzing the popularity of the top 10 city names and plotting them over time. I believe that there will be some city names that don’t necessarily correlate to the city itself, and will just be super popular, so I hope to be able to filter those out and find city names that have some correlation with the city itself. The top 10 city names I will be focusing on are: Allen, Austin, Charlotte, Elizabeth, Eugene, Jackson, Lynn, Madison, Norman, and Tyler.

First, I’ll install the necessary packages.

library(tidyverse)
── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
✔ dplyr     1.1.4     ✔ readr     2.1.5
✔ forcats   1.0.0     ✔ stringr   1.5.1
✔ ggplot2   3.4.4     ✔ tibble    3.2.1
✔ lubridate 1.9.3     ✔ tidyr     1.3.1
✔ purrr     1.0.2     
── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
✖ dplyr::filter() masks stats::filter()
✖ dplyr::lag()    masks stats::lag()
ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
library(babynames)
library(scales)

Attaching package: 'scales'

The following object is masked from 'package:purrr':

    discard

The following object is masked from 'package:readr':

    col_factor

The external data set was loaded here:

library(readxl)
#I got top 200 city names from a web scrape off of Wikipedia. 
library(readxl)
city_names <- read_excel("city_names.xlsx", 
    col_types = c("text", "text", "text", 
    "numeric", "numeric", "text", "text", 
    "numeric", "text", "text", "text"))
Warning: Expecting numeric in D2 / R2C4: got 'estimate'
Warning: Expecting numeric in E2 / R2C5: got 'census'
Warning: Expecting numeric in H3 / R3C8: got '778.3 km2'
Warning: Expecting numeric in H4 / R4C8: got '1,216.0 km2'
Warning: Expecting numeric in H5 / R5C8: got '589.7 km2'
Warning: Expecting numeric in H6 / R6C8: got '1,658.6 km2'
Warning: Expecting numeric in H7 / R7C8: got '1,341.6 km2'
Warning: Expecting numeric in H8 / R8C8: got '348.1 km2'
Warning: Expecting numeric in H9 / R9C8: got '1,291.9 km2'
Warning: Expecting numeric in H10 / R10C8: got '844.1 km2'
Warning: Expecting numeric in H11 / R11C8: got '879.6 km2'
Warning: Expecting numeric in H12 / R12C8: got '828.5 km2'
Warning: Expecting numeric in H13 / R13C8: got '1,935.5 km2'
Warning: Expecting numeric in H14 / R14C8: got '461.8 km2'
Warning: Expecting numeric in H15 / R15C8: got '899.5 km2'
Warning: Expecting numeric in H16 / R16C8: got '569.8 km2'
Warning: Expecting numeric in H17 / R17C8: got '798.5 km2'
Warning: Expecting numeric in H18 / R18C8: got '936.5 km2'
Warning: Expecting numeric in H19 / R19C8: got '121.5 km2'
Warning: Expecting numeric in H20 / R20C8: got '217.0 km2'
Warning: Expecting numeric in H21 / R21C8: got '396.5 km2'
Warning: Expecting numeric in H22 / R22C8: got '1,570.1 km2'
Warning: Expecting numeric in H23 / R23C8: got '1,232.3 km2'
Warning: Expecting numeric in H24 / R24C8: got '669.3 km2'
Warning: Expecting numeric in H25 / R25C8: got '158.2 km2'
Warning: Expecting numeric in H26 / R26C8: got '367.3 km2'
Warning: Expecting numeric in H27 / R27C8: got '125.1 km2'
Warning: Expecting numeric in H28 / R28C8: got '345.8 km2'
Warning: Expecting numeric in H29 / R29C8: got '841.5 km2'
Warning: Expecting numeric in H30 / R30C8: got '769.2 km2'
Warning: Expecting numeric in H31 / R31C8: got '359.2 km2'
Warning: Expecting numeric in H32 / R32C8: got '209.5 km2'
Warning: Expecting numeric in H33 / R33C8: got '249.2 km2'
Warning: Expecting numeric in H34 / R34C8: got '485.1 km2'
Warning: Expecting numeric in H35 / R35C8: got '624.2 km2'
Warning: Expecting numeric in H36 / R36C8: got '298.4 km2'
Warning: Expecting numeric in H37 / R37C8: got '255.4 km2'
Warning: Expecting numeric in H38 / R38C8: got '359.2 km2'
Warning: Expecting numeric in H39 / R39C8: got '815.1 km2'
Warning: Expecting numeric in H40 / R40C8: got '350.4 km2'
Warning: Expecting numeric in H41 / R41C8: got '506.1 km2'
Warning: Expecting numeric in H42 / R42C8: got '366.7 km2'
Warning: Expecting numeric in H43 / R43C8: got '381.0 km2'
Warning: Expecting numeric in H44 / R44C8: got '633.8 km2'
Warning: Expecting numeric in H45 / R45C8: got '131.3 km2'
Warning: Expecting numeric in H46 / R46C8: got '93.2 km2'
Warning: Expecting numeric in H47 / R47C8: got '144.8 km2'
Warning: Expecting numeric in H48 / R48C8: got '139.9 km2'
Warning: Expecting numeric in H49 / R49C8: got '511.5 km2'
Warning: Expecting numeric in H50 / R50C8: got '388.0 km2'
Warning: Expecting numeric in H51 / R51C8: got '295.3 km2'
Warning: Expecting numeric in H52 / R52C8: got '419.6 km2'
Warning: Expecting numeric in H53 / R53C8: got '248.4 km2'
Warning: Expecting numeric in H54 / R54C8: got '414.7 km2'
Warning: Expecting numeric in H55 / R55C8: got '439.0 km2'
Warning: Expecting numeric in H56 / R56C8: got '201.2 km2'
Warning: Expecting numeric in H57 / R57C8: got '130.3 km2'
Warning: Expecting numeric in H58 / R58C8: got '156.7 km2'
Warning: Expecting numeric in H59 / R59C8: got '275.1 km2'
Warning: Expecting numeric in H60 / R60C8: got '161.1 km2'
Warning: Expecting numeric in H61 / R61C8: got '210.3 km2'
Warning: Expecting numeric in H62 / R62C8: got '734.5 km2'
Warning: Expecting numeric in H63 / R63C8: got '420.1 km2'
Warning: Expecting numeric in H64 / R64C8: got '286.5 km2'
Warning: Expecting numeric in H65 / R65C8: got '169.9 km2'
Warning: Expecting numeric in H66 / R66C8: got '201.5 km2'
Warning: Expecting numeric in H67 / R67C8: got '70.7 km2'
Warning: Expecting numeric in H68 / R68C8: got '62.4 km2'
Warning: Expecting numeric in H69 / R69C8: got '134.7 km2'
Warning: Expecting numeric in H70 / R70C8: got '143.5 km2'
Warning: Expecting numeric in H71 / R71C8: got '335.7 km2'
Warning: Expecting numeric in H72 / R72C8: got '253.0 km2'
Warning: Expecting numeric in H73 / R73C8: got '292.2 km2'
Warning: Expecting numeric in H74 / R74C8: got '185.7 km2'
Warning: Expecting numeric in H75 / R75C8: got '4,420.6 km2'
Warning: Expecting numeric in H76 / R76C8: got '38.1 km2'
Warning: Expecting numeric in H77 / R77C8: got '159.8 km2'
Warning: Expecting numeric in H78 / R78C8: got '169.1 km2'
Warning: Expecting numeric in H79 / R79C8: got '262.4 km2'
Warning: Expecting numeric in H80 / R80C8: got '128.5 km2'
Warning: Expecting numeric in H81 / R81C8: got '104.6 km2'
Warning: Expecting numeric in H82 / R82C8: got '177.7 km2'
Warning: Expecting numeric in H83 / R83C8: got '281.8 km2'
Warning: Expecting numeric in H84 / R84C8: got '206.2 km2'
Warning: Expecting numeric in H85 / R85C8: got '286.7 km2'
Warning: Expecting numeric in H86 / R86C8: got '208.5 km2'
Warning: Expecting numeric in H87 / R87C8: got '348.6 km2'
Warning: Expecting numeric in H88 / R88C8: got '160.1 km2'
Warning: Expecting numeric in H89 / R89C8: got '275.8 km2'
Warning: Expecting numeric in H90 / R90C8: got '173.5 km2'
Warning: Expecting numeric in H91 / R91C8: got '876.7 km2'
Warning: Expecting numeric in H92 / R92C8: got '159.5 km2'
Warning: Expecting numeric in H93 / R93C8: got '343.7 km2'
Warning: Expecting numeric in H94 / R94C8: got '476.6 km2'
Warning: Expecting numeric in H95 / R95C8: got '147.9 km2'
Warning: Expecting numeric in H96 / R96C8: got '217.6 km2'
Warning: Expecting numeric in H97 / R97C8: got '138.0 km2'
Warning: Expecting numeric in H98 / R98C8: got '308.7 km2'
Warning: Expecting numeric in H99 / R99C8: got '178.2 km2'
Warning: Expecting numeric in H100 / R100C8: got '155.1 km2'
Warning: Expecting numeric in H101 / R101C8: got '202.8 km2'
Warning: Expecting numeric in H102 / R102C8: got '564.9 km2'
Warning: Expecting numeric in H103 / R103C8: got '128.7 km2'
Warning: Expecting numeric in H104 / R104C8: got '223.5 km2'
Warning: Expecting numeric in H105 / R105C8: got '183.4 km2'
Warning: Expecting numeric in H106 / R106C8: got '160.8 km2'
Warning: Expecting numeric in H107 / R107C8: got '55.9 km2'
Warning: Expecting numeric in H108 / R108C8: got '177.7 km2'
Warning: Expecting numeric in H109 / R109C8: got '111.4 km2'
Warning: Expecting numeric in H110 / R110C8: got '274.5 km2'
Warning: Expecting numeric in H111 / R111C8: got '111.6 km2'
Warning: Expecting numeric in H112 / R112C8: got '132.9 km2'
Warning: Expecting numeric in H113 / R113C8: got '228.4 km2'
Warning: Expecting numeric in H114 / R114C8: got '92.7 km2'
Warning: Expecting numeric in H115 / R115C8: got '384.1 km2'
Warning: Expecting numeric in H116 / R116C8: got '46.6 km2'
Warning: Expecting numeric in H117 / R117C8: got '173.5 km2'
Warning: Expecting numeric in H118 / R118C8: got '96.9 km2'
Warning: Expecting numeric in H119 / R119C8: got '285.7 km2'
Warning: Expecting numeric in H120 / R120C8: got '310.8 km2'
Warning: Expecting numeric in H121 / R121C8: got '560.7 km2'
Warning: Expecting numeric in H122 / R122C8: got '783.0 km2'
Warning: Expecting numeric in H123 / R123C8: got '204.9 km2'
Warning: Expecting numeric in H124 / R124C8: got '188.0 km2'
Warning: Expecting numeric in H125 / R125C8: got '261.3 km2'
Warning: Expecting numeric in H126 / R126C8: got '265.0 km2'
Warning: Expecting numeric in H127 / R127C8: got '68.6 km2'
Warning: Expecting numeric in H128 / R128C8: got '456.1 km2'
Warning: Expecting numeric in H129 / R129C8: got '194.8 km2'
Warning: Expecting numeric in H130 / R130C8: got '414.1 km2'
Warning: Expecting numeric in H131 / R131C8: got '380.7 km2'
Warning: Expecting numeric in H132 / R132C8: got '116.0 km2'
Warning: Expecting numeric in H133 / R133C8: got '255.6 km2'
Warning: Expecting numeric in H134 / R134C8: got '126.1 km2'
Warning: Expecting numeric in H135 / R135C8: got '69.9 km2'
Warning: Expecting numeric in H136 / R136C8: got '47.7 km2'
Warning: Expecting numeric in H137 / R137C8: got '340.6 km2'
Warning: Expecting numeric in H138 / R138C8: got '79.0 km2'
Warning: Expecting numeric in H139 / R139C8: got '160.3 km2'
Warning: Expecting numeric in H140 / R140C8: got '103.3 km2'
Warning: Expecting numeric in H141 / R141C8: got '178.7 km2'
Warning: Expecting numeric in H142 / R142C8: got '368.8 km2'
Warning: Expecting numeric in H143 / R143C8: got '361.3 km2'
Warning: Expecting numeric in H144 / R144C8: got '89.6 km2'
Warning: Expecting numeric in H145 / R145C8: got '153.3 km2'
Warning: Expecting numeric in H146 / R146C8: got '279.2 km2'
Warning: Expecting numeric in H147 / R147C8: got '129.5 km2'
Warning: Expecting numeric in H148 / R148C8: got '114.5 km2'
Warning: Expecting numeric in H149 / R149C8: got '116.5 km2'
Warning: Expecting numeric in H150 / R150C8: got '108.8 km2'
Warning: Expecting numeric in H151 / R151C8: got '126.4 km2'
Warning: Expecting numeric in H152 / R152C8: got '110.1 km2'
Warning: Expecting numeric in H153 / R153C8: got '257.4 km2'
Warning: Expecting numeric in H154 / R154C8: got '103.9 km2'
Warning: Expecting numeric in H155 / R155C8: got '107.0 km2'
Warning: Expecting numeric in H156 / R156C8: got '213.4 km2'
Warning: Expecting numeric in H157 / R157C8: got '84.7 km2'
Warning: Expecting numeric in H158 / R158C8: got '46.6 km2'
Warning: Expecting numeric in H159 / R159C8: got '148.1 km2'
Warning: Expecting numeric in H160 / R160C8: got '244.2 km2'
Warning: Expecting numeric in H161 / R161C8: got '274.8 km2'
Warning: Expecting numeric in H162 / R162C8: got '162.9 km2'
Warning: Expecting numeric in H163 / R163C8: got '60.9 km2'
Warning: Expecting numeric in H164 / R164C8: got '103.3 km2'
Warning: Expecting numeric in H165 / R165C8: got '141.9 km2'
Warning: Expecting numeric in H166 / R166C8: got '118.6 km2'
Warning: Expecting numeric in H167 / R167C8: got '21.8 km2'
Warning: Expecting numeric in H168 / R168C8: got '645.9 km2'
Warning: Expecting numeric in H169 / R169C8: got '112.7 km2'
Warning: Expecting numeric in H170 / R170C8: got '38.6 km2'
Warning: Expecting numeric in H171 / R171C8: got '114.2 km2'
Warning: Expecting numeric in H172 / R172C8: got '285.7 km2'
Warning: Expecting numeric in H173 / R173C8: got '82.6 km2'
Warning: Expecting numeric in H174 / R174C8: got '297.3 km2'
Warning: Expecting numeric in H175 / R175C8: got '323.0 km2'
Warning: Expecting numeric in H176 / R176C8: got '57.2 km2'
Warning: Expecting numeric in H177 / R177C8: got '86.8 km2'
Warning: Expecting numeric in H178 / R178C8: got '70.7 km2'
Warning: Expecting numeric in H179 / R179C8: got '249.7 km2'
Warning: Expecting numeric in H180 / R180C8: got '96.6 km2'
Warning: Expecting numeric in H181 / R181C8: got '167.1 km2'
Warning: Expecting numeric in H182 / R182C8: got '101.3 km2'
Warning: Expecting numeric in H183 / R183C8: got '41.7 km2'
Warning: Expecting numeric in H184 / R184C8: got '276.6 km2'
Warning: Expecting numeric in H185 / R185C8: got '125.6 km2'
Warning: Expecting numeric in H186 / R186C8: got '113.2 km2'
Warning: Expecting numeric in H187 / R187C8: got '167.1 km2'
Warning: Expecting numeric in H188 / R188C8: got '59.6 km2'
Warning: Expecting numeric in H189 / R189C8: got '289.3 km2'
Warning: Expecting numeric in H190 / R190C8: got '160.3 km2'
Warning: Expecting numeric in H191 / R191C8: got '163.7 km2'
Warning: Expecting numeric in H192 / R192C8: got '161.4 km2'
Warning: Expecting numeric in H193 / R193C8: got '65.0 km2'
Warning: Expecting numeric in H194 / R194C8: got '229.7 km2'
Warning: Expecting numeric in H195 / R195C8: got '98.2 km2'
Warning: Expecting numeric in H196 / R196C8: got '93.0 km2'
Warning: Expecting numeric in H197 / R197C8: got '53.1 km2'
Warning: Expecting numeric in H198 / R198C8: got '58.0 km2'
Warning: Expecting numeric in H199 / R199C8: got '354.3 km2'
Warning: Expecting numeric in H200 / R200C8: got '64.0 km2'
Warning: Expecting numeric in H201 / R201C8: got '48.4 km2'
Warning: Expecting numeric in H202 / R202C8: got '133.4 km2'
Warning: Expecting numeric in H203 / R203C8: got '74.9 km2'
Warning: Expecting numeric in H204 / R204C8: got '190.9 km2'
Warning: Expecting numeric in H205 / R205C8: got '89.1 km2'
Warning: Expecting numeric in H206 / R206C8: got '92.7 km2'
Warning: Expecting numeric in H207 / R207C8: got '186.7 km2'
Warning: Expecting numeric in H208 / R208C8: got '97.4 km2'
Warning: Expecting numeric in H209 / R209C8: got '66.6 km2'
Warning: Expecting numeric in H210 / R210C8: got '144.5 km2'
Warning: Expecting numeric in H211 / R211C8: got '195.5 km2'
Warning: Expecting numeric in H212 / R212C8: got '87.5 km2'
Warning: Expecting numeric in H213 / R213C8: got '31.9 km2'
Warning: Expecting numeric in H214 / R214C8: got '59.6 km2'
Warning: Expecting numeric in H215 / R215C8: got '95.1 km2'
Warning: Expecting numeric in H216 / R216C8: got '59.3 km2'
Warning: Expecting numeric in H217 / R217C8: got '94.3 km2'
Warning: Expecting numeric in H218 / R218C8: got '129.0 km2'
Warning: Expecting numeric in H219 / R219C8: got '95.8 km2'
Warning: Expecting numeric in H220 / R220C8: got '90.9 km2'
Warning: Expecting numeric in H221 / R221C8: got '463.1 km2'
Warning: Expecting numeric in H222 / R222C8: got '223.8 km2'
Warning: Expecting numeric in H223 / R223C8: got '301.2 km2'
Warning: Expecting numeric in H224 / R224C8: got '172.2 km2'
Warning: Expecting numeric in H225 / R225C8: got '276.4 km2'
Warning: Expecting numeric in H226 / R226C8: got '126.1 km2'
Warning: Expecting numeric in H227 / R227C8: got '47.4 km2'
Warning: Expecting numeric in H228 / R228C8: got '97.4 km2'
Warning: Expecting numeric in H229 / R229C8: got '159.0 km2'
Warning: Expecting numeric in H230 / R230C8: got '45.6 km2'
Warning: Expecting numeric in H231 / R231C8: got '65.8 km2'
Warning: Expecting numeric in H232 / R232C8: got '107.5 km2'
Warning: Expecting numeric in H233 / R233C8: got '132.6 km2'
Warning: Expecting numeric in H234 / R234C8: got '143.2 km2'
Warning: Expecting numeric in H235 / R235C8: got '78.7 km2'
Warning: Expecting numeric in H236 / R236C8: got '79.3 km2'
Warning: Expecting numeric in H237 / R237C8: got '143.7 km2'
Warning: Expecting numeric in H238 / R238C8: got '100.8 km2'
Warning: Expecting numeric in H239 / R239C8: got '144.5 km2'
Warning: Expecting numeric in H240 / R240C8: got '202.0 km2'
Warning: Expecting numeric in H241 / R241C8: got '139.3 km2'
Warning: Expecting numeric in H242 / R242C8: got '45.1 km2'
Warning: Expecting numeric in H243 / R243C8: got '133.1 km2'
Warning: Expecting numeric in H244 / R244C8: got '171.5 km2'
Warning: Expecting numeric in H245 / R245C8: got '116.0 km2'
Warning: Expecting numeric in H246 / R246C8: got '73.0 km2'
Warning: Expecting numeric in H247 / R247C8: got '107.7 km2'
Warning: Expecting numeric in H248 / R248C8: got '26.9 km2'
Warning: Expecting numeric in H249 / R249C8: got '74.1 km2'
Warning: Expecting numeric in H250 / R250C8: got '201.0 km2'
Warning: Expecting numeric in H251 / R251C8: got '16.6 km2'
Warning: Expecting numeric in H252 / R252C8: got '163.2 km2'
Warning: Expecting numeric in H253 / R253C8: got '67.6 km2'
Warning: Expecting numeric in H254 / R254C8: got '83.7 km2'
Warning: Expecting numeric in H255 / R255C8: got '122.8 km2'
Warning: Expecting numeric in H256 / R256C8: got '132.9 km2'
Warning: Expecting numeric in H257 / R257C8: got '75.6 km2'
Warning: Expecting numeric in H258 / R258C8: got '85.7 km2'
Warning: Expecting numeric in H259 / R259C8: got '146.1 km2'
Warning: Expecting numeric in H260 / R260C8: got '73.8 km2'
Warning: Expecting numeric in H261 / R261C8: got '81.8 km2'
Warning: Expecting numeric in H262 / R262C8: got '78.0 km2'
Warning: Expecting numeric in H263 / R263C8: got '97.9 km2'
Warning: Expecting numeric in H264 / R264C8: got '199.2 km2'
Warning: Expecting numeric in H265 / R265C8: got '87.0 km2'
Warning: Expecting numeric in H266 / R266C8: got '35.2 km2'
Warning: Expecting numeric in H267 / R267C8: got '108.0 km2'
Warning: Expecting numeric in H268 / R268C8: got '158.2 km2'
Warning: Expecting numeric in H269 / R269C8: got '98.4 km2'
Warning: Expecting numeric in H270 / R270C8: got '132.3 km2'
Warning: Expecting numeric in H271 / R271C8: got '101.3 km2'
Warning: Expecting numeric in H272 / R272C8: got '62.2 km2'
Warning: Expecting numeric in H273 / R273C8: got '213.7 km2'
Warning: Expecting numeric in H274 / R274C8: got '96.6 km2'
Warning: Expecting numeric in H275 / R275C8: got '60.9 km2'
Warning: Expecting numeric in H276 / R276C8: got '68.4 km2'
Warning: Expecting numeric in H277 / R277C8: got '143.5 km2'
Warning: Expecting numeric in H278 / R278C8: got '86.0 km2'
Warning: Expecting numeric in H279 / R279C8: got '220.7 km2'
Warning: Expecting numeric in H280 / R280C8: got '124.3 km2'
Warning: Expecting numeric in H281 / R281C8: got '86.8 km2'
Warning: Expecting numeric in H282 / R282C8: got '160.3 km2'
Warning: Expecting numeric in H283 / R283C8: got '47.1 km2'
Warning: Expecting numeric in H284 / R284C8: got '59.1 km2'
Warning: Expecting numeric in H285 / R285C8: got '32.1 km2'
Warning: Expecting numeric in H286 / R286C8: got '164.5 km2'
Warning: Expecting numeric in H287 / R287C8: got '56.7 km2'
Warning: Expecting numeric in H288 / R288C8: got '40.9 km2'
Warning: Expecting numeric in H289 / R289C8: got '104.9 km2'
Warning: Expecting numeric in H290 / R290C8: got '120.4 km2'
Warning: Expecting numeric in H291 / R291C8: got '148.9 km2'
Warning: Expecting numeric in H292 / R292C8: got '94.3 km2'
Warning: Expecting numeric in H293 / R293C8: got '126.7 km2'
Warning: Expecting numeric in H294 / R294C8: got '267.8 km2'
Warning: Expecting numeric in H295 / R295C8: got '97.6 km2'
Warning: Expecting numeric in H296 / R296C8: got '62.7 km2'
Warning: Expecting numeric in H297 / R297C8: got '111.1 km2'
Warning: Expecting numeric in H298 / R298C8: got '78.0 km2'
Warning: Expecting numeric in H299 / R299C8: got '97.6 km2'
Warning: Expecting numeric in H300 / R300C8: got '66.6 km2'
Warning: Expecting numeric in H301 / R301C8: got '90.4 km2'
Warning: Expecting numeric in H302 / R302C8: got '117.8 km2'
Warning: Expecting numeric in H303 / R303C8: got '76.9 km2'
Warning: Expecting numeric in H304 / R304C8: got '1,017.9 km2'
Warning: Expecting numeric in H305 / R305C8: got '68.1 km2'
Warning: Expecting numeric in H306 / R306C8: got '495.5 km2'
Warning: Expecting numeric in H307 / R307C8: got '24.9 km2'
Warning: Expecting numeric in H308 / R308C8: got '41.4 km2'
Warning: Expecting numeric in H309 / R309C8: got '55.2 km2'
Warning: Expecting numeric in H310 / R310C8: got '117.1 km2'
Warning: Expecting numeric in H311 / R311C8: got '37.6 km2'
Warning: Expecting numeric in H312 / R312C8: got '115.8 km2'
Warning: Expecting numeric in H313 / R313C8: got '60.9 km2'
Warning: Expecting numeric in H314 / R314C8: got '44.8 km2'
Warning: Expecting numeric in H315 / R315C8: got '23.6 km2'
Warning: Expecting numeric in H316 / R316C8: got '62.4 km2'
Warning: Expecting numeric in H317 / R317C8: got '165.5 km2'
Warning: Expecting numeric in H318 / R318C8: got '87.0 km2'
Warning: Expecting numeric in H319 / R319C8: got '60.3 km2'
Warning: Expecting numeric in H320 / R320C8: got '108.8 km2'
Warning: Expecting numeric in H321 / R321C8: got '186.5 km2'
Warning: Expecting numeric in H322 / R322C8: got '203.3 km2'
Warning: Expecting numeric in H323 / R323C8: got '92.2 km2'
Warning: Expecting numeric in H324 / R324C8: got '127.2 km2'
Warning: Expecting numeric in H325 / R325C8: got '77.4 km2'
Warning: Expecting numeric in H326 / R326C8: got '43.0 km2'
Warning: Expecting numeric in H327 / R327C8: got '186.5 km2'
Warning: Expecting numeric in H328 / R328C8: got '88.3 km2'
Warning: Expecting numeric in H329 / R329C8: got '31.3 km2'
Warning: Expecting numeric in H330 / R330C8: got '27.7 km2'
Warning: Expecting numeric in H331 / R331C8: got '55.4 km2'
Warning: Expecting numeric in H332 / R332C8: got '188.3 km2'
Warning: Expecting numeric in H333 / R333C8: got '51.8 km2'
Warning: Expecting numeric in H334 / R334C8: got '165.2 km2'
Warning: Expecting numeric in H335 / R335C8: got '19.7 km2'
New names:
• `2022` -> `2022...1`
• `2022` -> `2022...4`
• `` -> `...10`
• `` -> `...11`
colnames(city_names)[2] <- "name"
babynames |>
  
  inner_join(city_names, relationship = "many-to-many") -> merged
Joining with `by = join_by(name)`
babynames |> 
  filter(name %in% city_names$name) -> cnames

Observation 1:

I renamed my data to be called cnames. I will then create a chart arranging in descending order to show the most popular name and the percentage of people who were named in that year. I also focused on the top 10 most popular city names.

cnames |> 
  group_by(name) |> 
  summarize(total = sum(n)) |> 
  arrange(desc(total)) |> 
  head(10) -> ten_most_popular

Next I will split my graph into two, to represent both the male names and the female names.

library(tidyverse)
babynames |>
  filter(name %in% ten_most_popular$name) |>
  ggplot(aes(year, prop, color = name)) + geom_line() +
  facet_wrap(~sex)

Observation 2:

Looking at this graph over time, you can see that Elizabeth has a huge peak in around 1880, decreased, and then peaked again in 1980. For the men’s names, Tyler had a massive peak in 1990. Now I am going to figure out the total number of each name over time:

babynames |> 
  filter(name %in% cnames $name) |> 
  group_by(name) |> 
  summarize(total = sum(n)) |> 
  arrange(desc(total))
# A tibble: 107 × 2
   name        total
   <chr>       <int>
 1 Elizabeth 1634860
 2 Tyler      600620
 3 Austin     412179
 4 Madison    381276
 5 Eugene     381165
 6 Charlotte  349559
 7 Allen      268817
 8 Norman     253409
 9 Lynn       234084
10 Jackson    229533
# ℹ 97 more rows

You can see that Elizabeth and Tyler are over 500000 total names, so we can exclude them from the data set.

babynames |> 
  filter(name %in% ten_most_popular $name) |> 
  arrange(desc(prop)) |> 
  filter(!name %in% c("Elizabeth", "Tyler")) |> 
  ggplot(aes(year, prop, color = name)) + geom_line() + facet_wrap(~sex)

Observation 3:

After looking at the data, I now want to find a way to mathematically exclude Elizabeth and Tyler. It is clear that they are not names that are being named after a New Jersey or Wisconsin city. You can also see an increase after 1980 so now I am going to filter the year 1979 so we get a closer look of when the peak is as well as the correlation.

babynames |> 
  filter(name %in% ten_most_popular $name) |> 
  arrange(desc(prop)) |> 
  filter(!name %in% c("Elizabeth", "Tyler")) |> 
  filter(year > 1979) |> 
  ggplot(aes(year, prop, color = name)) + geom_line() + facet_wrap(~sex)

Conclusion:

You can see that there is correlation regarding an increase in city names over time. Austin and Madison are bigger cities and better known cities, compared to Elizabeth and Tyler, which are much smaller cities, most likely not being used to name children after the city itself. You can see that just after the year 20000, both Madison and Austin spiked. In 2015, there was also a spike in the names Charlotte and Jackson. There doesn’t seem to be a trend relating to time. I have concluded that there is no correlation with the name and the actual city. If anything, the city might have been named after the popular name.