In this project, we are going to explore the database, ‘chinook.db’. We are going to come up with some business questions that might be interesting. Then we’ll try to answer them with SQL. First, ...

In this project, we are going to look at ‘bike_rental_hour.csv’, a dataset that contains the hourly and daily count of rental bikes between years 2011 and 2012 in the Capital bikeshare system. From...

In this project, we are going to apply machine learning algorithms to predict the price of a house using ‘AmesHousing.tsv’. In order to do so, we’ll have to transform the data and apply various fea...

In this project we are going to look at ‘imports-85.data’. This file contains specifications of vehicles in 1985. For more information on the data set click here. We are going to explore the funda...

In this project, we’ll look at 20,000 rows of the jeopardy dataset in “jeopardy.csv”. We want to see if there are patterns in the questions asked so we can get a little bit of an edge to win. Firs...

In this project, we willl analyze various movie review websites using “fandango_score_comparison.csv” We will use descriptive statistics to draw comparisons between fandango and other review websit...

In this project, we will prepare data in preparation for SQL. We’ll have to first clean the data. import pandas as pd df = pd.read_csv('academy_awards.csv', encoding='ISO-8859-1') #Turns off warn...

In this project we will use the cleaned data from the previous mission and work mainly in SQL. We will use SQL to transform the nominations tables into new tables, and create relations across these...

In this project we’ll be working with SQL in combination with Python. Specifically we’ll use sqlite3. We will analyze the database file “factbook.db” which is the CIA World Factbook. We will write ...

In this project we will be looking at a star wars survey, ‘star_wars.csv’. This project will focus on data cleaning so we have a data set ready for analysis. Let’s begin by reading the csv file and...