Review Guided Project - Analyze Factbook Data with SQL

prof_cristianluca · April 13, 2020, 9:19am

Hi!

It’s my first course. I finished the project in a clumsy way. I will make more effort from here. Any recommendations are welcome.

https://app.dataquest.io/m/257/guided-project%3A-analyzing-cia-factbook-data-using-sql/7/next-steps

I don’t know how to upload my notebook (.ipynb file)!

Thank you so much!

Zubair · April 13, 2020, 11:53am

Hey @prof_cristianluca,
Thanks for reaching out to us. We want more project from you.
But I can’t have a look at your project as you have provided the Dataquest guided project link. If I click on this link, it will redirect to my course.

To resolve the issue, just download the project and make a GitHub repository of your project. After that you may paste the link to the nbviewer. If you are still confused, follow the article to get your job done.

How do I backup my Guided Projects as I'm learning?

Introduction

While you’re learning with Dataquest, backing up your Guided Projects is a great way to ensure that you never lose your work and have peace of mind.

How to Download Guided Project From Our Platform

This post covers how to download your Guided Project from our platform.

How do I download the data sets you use in your missions/projects?

Downloading Jupyter Project Data

Although Jupyter exists in a different interface than that of our regular missions, you would download the project data in the same way —via the Download Project button at the top of your notebook. Note that this will download both the dataset files as well as your project notebook file, zipped up in a .tar formatted folder.

Backup Options

Local Storage

Press the Download button as shown in the animation above
When you click the Download button, the files relevant to the project are zipped up and downloaded as a tar file.

Follow this link for instructions on how to unzip a tar file:
http://www.e7z.org/open-tar.htm

Create a dedicated folder where you want the contents of the tar file to unzip to.

You may want to rename your extracted folder so that you can easily identify the latest and oldest versions of the project.
Suggestion: Rename the folder to v1 if it’s the only version in that folder or else vX where X is the number of versions in that folder + 1

Here is how your folder may look like if you followed the suggestion:

Git Repository

Compared to Local Storage, this is the best option as you will be able to showcase your project to other people if you use GitHub as GitHub can render the Jupyter notebook file and show it’s contents. Also, GitHub will save you a lot of storage space.

Please check out this post to learn how to backup your Guided Project to GitHub?
How do I backup my Guided Project to GitHub?

prof_cristianluca · April 13, 2020, 7:24pm

Thank you, Zubair!

github.com

crisforp1/Cristian-Luca/blob/master/Guided Project_ Analyzing CIA Factbook Data Using SQL Cristian Luca.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Connected: [email protected]'"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],

This file has been truncated. show original

I hope it’s okay now!

Have a nice evening!

prof_cristianluca · April 13, 2020, 7:32pm

Hi, Zubair!

Thank you!