Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

****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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David M. Kroenke, David J. Auer

7th edition

133544621, 133544626, 0-13-354462-1, 978-0133544626

More Books

Students also viewed these Databases questions

Question

Identify ways to increase your selfesteem.

Answered: 1 week ago

Question

=+With whom does the firm have to negotiate?

Answered: 1 week ago

Question

=+Are there shop stewards?

Answered: 1 week ago