StrataScratch - Business Analytics Cases and Tool
  • Platform
  • Educational Resources
    • SQL >
      • SQL Interview Questions
      • Advanced SQL Exercises
      • SQL Guides >
        • Basics of a SQL Query
        • Filtering and Conditions
        • The Having condition
        • SQL Aggregate Functions
    • Python
  • Pricing
  • Blog
  • About Us
  • Contact

Python

We have got Python guides and different sets of python interview questions and various tutorials to help you increase your data analytics skills. Our exercises are business focused to help you apply your new technical skills to business concepts!
StrataScratch - data analysis and dataset storage

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.
​
On the other hand, if you’re preparing to appear in a Python interview, our exercises and guides are not going to disappoint you. We cover up most of the top Python interview questions. So, sign up for our guides and get all your doubts cleared related to Python programming.

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
Home
Pricing
Education

Educational Articles
Contact Us
​
team@stratascratch.com
Strata Scratch
San Francisco, CA​ 
​Copyright © 2017 
  • Platform
  • Educational Resources
    • SQL >
      • SQL Interview Questions
      • Advanced SQL Exercises
      • SQL Guides >
        • Basics of a SQL Query
        • Filtering and Conditions
        • The Having condition
        • SQL Aggregate Functions
    • Python
  • Pricing
  • Blog
  • About Us
  • Contact