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.


  • Working with SQLite data in Python.
  • Generating visualizations from SQLite results.

Mission Outline

1. Overview of the Data
2. Summary Statistics
3. Exploring Outliers
4. Histograms
5. Next Steps


Course Info:


The median completion time for this course is 6.3 hours. View Details

This course requires a basic subscription and includes five missions and one guided project.  It is the 11th course in the Data Analyst in Python path and the Data Scientist in Python path.


Take a Look Inside