Python

Python guides and exercises to help you increase your data analytics skills. Our exercises are business focused to help you apply your new technical skills to business concepts

Python Guides & Problem Sets

​The Python tutorials are aimed to teach non-technical users how to code in Python to answer business and marketing questions. The Python exercises are specifically tailored towards business and marketing problems so you get a better understanding of how analytics plays a role in the business world.

Getting Started

This guide walks you through the process of connecting to the Strata Scratch database to query datasets using Python.

• Exploring Strata Scratch Datasets in Python (Freemium access)

Cleaning Data in Python

• How to Clean Data with Pandas​ (Freemium access)
• A Data Cleanup Exercise With the Titanic Dataset (Freemium access)
• Exploring Your Data
• Functions, Lambda Functions, Loops, and List Comprehensions
• Combining Data for Analysis (Joining/Merging Dataframes)​

Practice Problems

• A Short NumPy Tutorial, A Primer to Get Started With Python
• A Short Pandas Tutorial For Data Analysis (Freemium access)
• Pandas Exercises for Practice
• Datetime
• Creating Visualizations
• Problem Set: Online Retail
• Interactive Notebooks
• From Excel to Pandas
• Statistics
• Machine Learning
• Problem Set: Medical Appointments
• Web Scraping