Question
****Python*** #----------------------------------------------------------- #The United States Social Security Administration publishes #a list of all documented baby names each year, along with #how often each name was
****Python***
#----------------------------------------------------------- #The United States Social Security Administration publishes #a list of all documented baby names each year, along with #how often each name was used for boys and for girls. The #list is used to see what names are most common in a given #year. # #We've grabbed that data for any name used more than 25 #times, and provided it to you in a file called #babynames.csv. The line below will open the file:
names_file = open('../resource/lib/public/babynames.csv', 'r')
#We've also provided a sample subset of the data in #sample.csv. # #Each line of the file has three values, separated by #commas. The first value is the name; the second value is #the number of times the name was given in the 2010s (so #far); and the third value is whether that count #corresponds to girls or boys. Note that if a name is #given to both girls and boys, it is listed twice: for #example, so far in the 2010s, the name Jamie has been #given to 611 boys and 1545 girls. # #Use this dataset to answer the questions below.
#Here, add any code you want to allow you to answer the #questions asked below over on edX. This is just a sandbox #for you to explore the dataset: nothing is required for #submission here.
How many total names are listed in the database? unanswered
How many total births are covered by the names in the database? unanswered
How many different boys' names are there that begin with the letter Z? (Count the names, not the people.) unanswered
What is the most common girl's name that begins with the letter Q? unanswered
How many total babies were given names that both start and end with vowels (A, E, I, O, or U)? unanswered
What letter is the least common first letter of a baby's name (in terms of number of babies with names starting with that letter, not number of names)? unanswered
How many babies were born with names starting with that least-common letter? unanswered
What letter is the most common first letter of a baby's name (in terms of number of babies with names starting with that letter, not number of names)? unanswered
How many babies were born with names starting with that most-common letter? unanswered
By default, the Social Security Administration's data separates out names by gender. For example, Jamie is listed separately for girls and for boys. If you were to remove this separation, what would be the most common name in the 2010s regardless of gender? unanswered
How many people would have that name? unanswered
What name that is used for both genders has the smallest difference in which gender holds the name most frequently? In case of a tie, enter any one of the correct answers.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started