DataCamp Projects

Some training projects performed on the Datacamp platform using Python and SQL

Projects using Python

Generating Keywords for Google Ads

https://github.com/dgizdevans/datacamp/tree/main/ads-keywords

Automatically generate keywords for a search engine marketing campaign using Python.

A/B Testing with Cookie Cats Mobile Games

https://github.com/dgizdevans/datacamp/tree/main/abtest

Analyze an A/B test from the popular mobile puzzle game, Cookie Cats.

Writing Functions for Product Analysis

https://github.com/dgizdevans/datacamp/tree/main/nps

Use coding best practices and functions to improve a script!

A Network Analysis of Game of Thrones

https://github.com/dgizdevans/datacamp/tree/main/got

Analyze the network of characters in Game of Thrones and how it changes over the course of the books. This project uses a dataset parsed by Andrew J. Beveridge and Jie Shan.

The Android App Market on Google Play

https://github.com/dgizdevans/datacamp/tree/main/android-app

Load, clean, and visualize scraped Google Play Store data to gain insights into the Android app market. The data for this project was scraped from the Google Play website.

A Visual History of Nobel Prize Winners

https://github.com/dgizdevans/datacamp/tree/main/nobel

Explore a dataset from Kaggle containing a century's worth of Nobel Laureates. Who won? Who got snubbed? The dataset used in this project is from The Nobel Foundation on Kaggle.

Exploring the Bitcoin Cryptocurrency Market

https://github.com/dgizdevans/datacamp/tree/main/bitmarket

You will explore the market capitalization of Bitcoin and other cryptocurrencies. Warning: The cryptocurrency market is exceptionally volatile, and any money you put in might disappear into thin air. Never invest money you can't afford to lose.

Comparing Search Interest with Google Trends

https://github.com/dgizdevans/datacamp/tree/main/karda

Manipulate and plot time series data from Google Trends to analyze changes in search interest over time.

Designing a Bank Marketing Database

https://github.com/dgizdevans/datacamp/blob/main/marketing-database/notebook.ipynb

Cleaning, storing data with Python and pulling daya to SQL

Projects using SQL

Analyze International Debt Statistics

https://github.com/dgizdevans/datacamp/tree/main/sql-debt

The data used in this project is provided by The World Bank. It contains both national and regional debt statistics for several countries across the globe as recorded from 1970 to 2015.

Analyzing NYC Public School Test Result Scores

https://github.com/dgizdevans/datacamp/tree/main/sql-nyc-schools

Use summary statistics and filters to analyze test scores across New York City's public schools!

What and Where are the World's Oldest Businesses

https://github.com/dgizdevans/datacamp/tree/main/sql-optimize

Use joining techniques to discover the oldest businesses in the world.

Optimizing Online Sports Retail Revenue

https://github.com/dgizdevans/datacamp/tree/main/sql-optimize

Sports clothing is a booming sector! In this notebook, I used my SQL skills to analyze product data for an online sports retail company.

When Was the Golden Age of Video Games?

https://github.com/dgizdevans/datacamp/tree/main/sql-videogames

Use joins and set theory to discover the best years for video games!