A solution to last week's Challenge can be found here!
A big thanks to those of you that joined us last week at Inspire for the Weekly Challenge session! It was so much fun solving with you all!
This week, we're identifying the most popular baby names that were registered between the years of 1880 and 2017. Given the provided dataset, determine the most popular names for Males and Females for each available year. The column "Field_1" contains three concatenated values: the name, the associated gender (Male or Female) and the number of occurrences that the name appeared in birth records. The column "FileName" contains the name of the file in which the record is found; the data was read in from a zip file that contained text files for each year (1880-2017) of records.
