Getting started with pandas
Data ingestion, tweaking, and summarizing
Python’s pandas library can make your data or programming life easier because it enables painless ingestion, exporting, transformation, and visualization of your data. It’s no surprise then that pandas is very popular among data scientists, quants, Excel junkies, and Python developers. But if you're only familiar with Python (yet new to pandas and numeric libraries in Python), you may encounter a few gotchas as you get started with pandas.
Join Matt Harrison to jumpstart your pandas journey. By the end of this three-hour hands-on course, you’ll be importing, exploring, and tweaking data with pandas, using the Jupyter Notebook as the basis for your exploratory analysis. You’ll also be prepared for the second course in this series, Mastering pandas, where you’ll learn more advanced skills, such as filtering, plotting, and pivoting your data.
What you'll learn-and how you can apply it
By the end of this live online course, you’ll understand:
- How pandas can make life easier for data scientists and programmers
- How to use Jupyter to interact with Python scripts
And you’ll be able to:
- Import, explore, and tweak data with pandas
- Understand how to get help when you get stuck
- Practice debugging doing analytics with pandas
This training course is for you because...
- You're a data scientist with experience in R or SAS who wants to learn about pandas and the Python ecosystem.
- You're a developer with programming experience in Python who wants to start using pandas.
- Programming experience with Python
- Watch Introduction to Pandas for Developers (video, 5h 34m)
- Read Learning the Pandas Library (book)
- Read chapters 2 and 5–10 in Python for Data Analysis (book)
- Take Mastering pandas (live online training course with Matt Harrison)
About your instructor
Matt runs MetaSnake, a Python and Data Science training and consulting company. He has over 15 years of experience using Python across a breadth of domains: Data Science, BI, Storage, Testing and Automation, Open Source Stack Management, and Search.
The timeframes are only estimates and may vary according to how the class is progressing
Set up and introduction to Jupyter (15 minutes)
- Lecture: Jupyter features
Introduction to pandas (25 minutes)
- Lecture: pandas basic data structures
- Break (5 minutes)
Loading data (35 minutes)
- Lecture: Ingesting data from the web and CSV files; exploring some of the options for manipulation during loading
- Hands-on exercise: Load data
Inspecting data (35 minutes)
- Lecture: Examining your data, characterizing it, and seeing what it looks like
- Hands-on exercise: Inspect your data
- Break (5 minutes)
Tweaking data (40 minutes)
- Lecture: Changing the types of the values for your data, fixing them, or ignoring them
- Hands-on exercise: Tweak your data
Wrap-up and Q&A (10 minutes)