/Udacity-Programming-for-Data-Science-ND

Complete projects in SQL, Python and Github

Primary LanguageJupyter Notebook

Udacity-Programming-For-Data-Science-With-Python-Nanodegree

Created by Hunter Sparrow

This repository contains projects did for Udacity Programming For Data Science With Python Nanodegree.

Project 1 : Investigate a Relational Database

Overview:

This project consisted in the exploration of a provided database movie rentals in which the student had to run SQL queries and build visualizations to showcase the output of the student's queries.

For the presentation component, the student had to create four slides, and each should have

  • A question of interest.
  • A supporting SQL query needed to answer the question.
  • A supporting visualization created using the final data of the SQL queries that answer the questions of interest.
  • A small summary on each slide.

Project 2 : Explore US Bikeshare Data

Overview:

In this project, you will make use of Python to explore data related to bike share systems for three major cities in the United States? Chicago, New York City, and Washington. You will write code to import the data and answer interesting questions about it by computing descriptive statistics. You will also write a script that takes in raw input to create an interactive experience in the terminal to present these statistics.

The developed CLI program allows the user to explore an US bikeshare system database and retrieve statistics information from the database. The user is able filter the information by city, month and weekday, in order to visualize statistics information related to a specific subset of data. The user is also able to chose to view raw data and to sort this data by columns, in ascending or descending order.

Project 3 : Post your Work on GitHub

Overview:

This project consisted in using Git and GitHub with a simulated workflow to refactor Project 2.

The Project Submission consisted in the filling of a template with all the Git commands used to perform the requested tasks.