Skip to content

Data science project using scraped data for visualizing database queries

Notifications You must be signed in to change notification settings

jonathanhansen808/Country_and_Capital_Geography-

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 

Repository files navigation

Country and Capital Geography

Data science project using scraped data for visualizing database queries

  • Data scraped from http://techslides.com/list-of-countries-and-capitals and saved to JSON.
  • The data included area in square miles, ratio of coast to area as coastline, birth/death-rates, infant-mortality rates, literacy rates, and phone access rates.
  • The data was put into dataframes and several summary figures are in the Country_Captial_Geography.ipynb file
  • The dataframes were then dumped into a SQLite database and similar summary questions were answered using SQL.
  • The rest of the project was visualizing those queries.

About

Data science project using scraped data for visualizing database queries

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published