Pandas

Data Analysis with Python Course: How to read, wrangle, and analyze data

For anyone in the NYC area, I will be holding an in-person training session December 3rd on doing data analysis with Python. We will be covering the pandas, pyodbc, and matplotlib packages. Please register at Eventbrite here: https://www.eventbrite.com/e/data-analysis-with-python-how-to-read-wrangle-and-analyze-data-tickets-51945542516.

Overview

Learn how to apply Python to read, wrangle, visualize, and analyze data!  This course provides a hands-on session where we’ll walk through a prepared curriculum on doing data analysis with Python.  All code and practice exercises during the session will be made available after the course is complete.  

 

About the course

During this hands-on class, you will learn the fundamentals of doing data analysis in Python, the powerful pandas package, and pyodbc for connecting to databases.

We will walk through using Python to analyze and answer key questions on sales data, as well as utilizing historical stock price data to learn how to work with time series in Python. We will also cover how to create data visualizations with matplotlib.

 

What you’ll learn

  • How to import data from multiple sources (Excel, HTML, databases)
  • How to construct DataFrames and Series
  • How to merge datasets
  • The apply and map methods for performing column calculations
  • Rearranging and pivoting data
  • Adding and deleting columns
  • Subsetting and sorting
  • Working with time series data
  • Handling missing and duplicate values
  • Creating visualizations with matplotlib

 

Who is this for?

Anyone looking to learn how to analyze data with Python or increase their Python skills!

 

Prerequisites

Andrew Treadway

Recent Posts

Software Engineering for Data Scientists (New book!)

Very excited to announce the early-access preview (MEAP) of my upcoming book, Software Engineering for…

1 year ago

How to stop long-running code in Python

Ever had long-running code that you don't know when it's going to finish running? If…

2 years ago

Faster alternatives to pandas

Background If you've done any type of data analysis in Python, chances are you've probably…

3 years ago

Automated EDA with Python

In this post, we will investigate the pandas_profiling and sweetviz packages, which can be used…

3 years ago

How to plot XGBoost trees in R

In this post, we're going to cover how to plot XGBoost trees in R. XGBoost…

3 years ago

Python collections tutorial

In this post, we'll discuss the underrated Python collections package, which is part of the…

3 years ago