Not logged in
Talk
Contributions
Create account
Log in
Navigation
Main page
About
People
Publications
Teaching
Resources
Research Blog
Wiki Functions
Recent changes
Help
Licensing
Page
Discussion
Edit
View history
Editing
Community Data Science Course (Spring 2023)/Week 3 coding challenges
(section)
From CommunityData
Jump to:
navigation
,
search
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
== #5 Initials to spreadsheets == # Make a dictionary <code>girl_initials</code> that says, for each letter of the alphabet (a-z), how many unique girl names begin with that letter. # Do the same for boy names to make <code>boy_initials</code>. # Create a "tab separated values" (TSV) file that reports the data in <code>girl_initials</code>. Be sure to include a descriptive header columns! You will probably want the file to end with <code>.tsv</code> so that your computer knows it's a TSV file. # Now do the same for <code>boy_initials</code> (be sure to save it into a different file!) # Once you've done this, load up the two files into Google Sheets or Excel. # For every letter, be ready to tell if there are more boys names or girls names. # Play around with graphing and see if you can build some instructive graph that shows us something. '''Note:''' Obviously, you won't be able to include your Google Sheet result into your notebook. Instead, please put it online somewhere (e.g., in Google Drive, or OneDrive, or Dropbox or similar) create a link for sharing that doesn't requiring signing in, and put that link into your notebook so we can click through and look at it!
Summary:
Please note that all contributions to CommunityData are considered to be released under the Attribution-Share Alike 3.0 Unported (see
CommunityData:Copyrights
for details). If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource.
Do not submit copyrighted work without permission!
To protect the wiki against automated edit spam, we kindly ask you to solve the following CAPTCHA:
Cancel
Editing help
(opens in new window)
Tools
What links here
Related changes
Special pages
Page information