Guided Project: Analyzing CIA Factbook Data Using SQLite and Python
In this guided project, you will put together everything you've learned in the data visualization course and this course. Using the Python SQLite workflow and your Python programming, analysis, and visualization skills from previous courses in our path, you'll create a data science portfolio project analyzing data from the CIA World Factbook that you can show to employers to demonstrate proficiency in data visualization, Python, and SQL.
In this project, you will work with SQLite data in Python and generate visualizations from your SQLite SQL query results. You’ll start by connecting to a SQLite database using the sqlite3 library. Once you connect to the database, you will be query the data and save the results to a dataframe. From there, you'll create histograms and explore outliers in the dataset using your Python programming, data analysis, and data visualization skills.
Your mission will be to use the CIA World Factbook to uncover some interesting insights about the various countries in the database. To complete this project, we highly recommend downloading Jupyter Notebook and the sqlite3 library to follow along with the instructions on your local machine.
1. Overview of the Data
2. Summary Statistics
3. Exploring Outliers
5. Next Steps