Guided Project: Analyzing CIA Factbook Data Using SQL (SQL Skills Path)

Hi Dataquest community

I am sharing my first guided project. Really would like to hear your feedback

Thank you


Analyze Factbook Data With SQL - Guided Project | Dataquest

Guided Project Analyzing CIA Factbook Data Using SQL.ipynb (148.2 KB)

Click here to view the jupyter notebook file in a new tab

1 Like

Hi Tomas,

Welcome to the Community and congratulations on finishing your first project! :star2:

Here are some suggestions from me for your consideration:

  • Your code looks correct, and so it brings correct results. However, your project seems to lack the story behind it: project title, goals, intruduction, markdown comments analyzing and explaining the results after each code cell, conclusion summarizing the main results of the project. You might find these guidelines useful for this purpose, and also, probably, looking through other people’s guided projects on the same topic can give you some interesting ideas.
  • A good practice is to re-run an already completed project, to have all the code cells in order and start from 1.
  • In some code cells ([16], [32]) you can consider using ROUND.
  • The code cells [32], [51]: it’s enough to cast into float or only numerator, or only denominator, not necessarily both of them. This will make the code cleaner.
  • For the code cells [32], [45], [51] you can consider using LIMIT (showing only TOP10 or BOTTOM10, for example).
  • You might find helpful this SQL style guide, especially the section “Spaces” (so-called “rivers”).
  • Please remove the last empty code cell.

Hope my ideas were useful. Good luck with your future projects!
Happy learning!


Thank you Elena :slightly_smiling_face:

1 Like