Log In
★ 4.8 /
600 reviews

Python Data Manipulation: A Pandas Crash Course

Learn how to use Python and Pandas for data analysis and data manipulation. Transform, clean, and merge data with Python. This course is made for you if you wish to improve your data manipulation skills. Work with data smarter, not harder!

Author: Samuel Hinton
12965 Participants
Last Update: May 2023
US $19
US $190 90% discount
End of sale: 2 hours

We guarantee your money back

For any reason the course does not meet your expectations, we have you covered. Email support within 14 days at hello@sacrill.com for a full refund, no questions ask.

Course includes

55 video lessons
Unlimited time access to all course materials

In this course you will learn how to

  • Basic and advanced Pandas data manipulation strategies and techniques for creating a final product for analysis.
  • Most time saving and efficient ways to work with raw data.
  • Getting best result by solving the initial problem instead of data processing.
  • Making machine learning and analyzing of statistics easy.
  • Learn newest standards of data analyzing with Pandas libraries for Python.

Why choose this course?

You can make a process of processing raw data into a final product much faster. As a data scientist you may more efficient and productive.

Free up your time to the most important: with Pandas library for Python you can spend more time for problem-solving! Don't drown in the data browsing.

All of it tightly packed in one course!

Pandas DataFrame will get you ready to learn advanced data manipulation techniques. Main purpose of this course is to get raw data sorted and pivoted up into a pre-analysis product with better visualization for a final product.

Almost all the leading companies use Pandas for analyzing: JP Morgan, Google, Facebook and many more. Pandas is a truly most popular Python library in data science.

Performing data analysis with Python's Pandas library can help you do a lot, but it does have its downsides. And this course enables you to beat them head-on:

  • This course introduces you to all the peculiarities and difficulties of Pandas library, you will gradually conquer all the steps. Suitable for both beginners and intermediate users.
  • This course addresses another problem too. It will be your guide into advanced techniques of Pandas: when manuals are not enough you can find gather the knowledge you need.

Get exercises and reminder sheet at the end of the course – learn and practice, all in one!

Show More

Academic plan

56 video lessons

Introduction
  • Introduction
  • Who Am I? And how to get help
  • Setting up python and editors
  • Live Install
  • Get the materials
Dataset Basics
  • Finding Datasets
  • Jupyter Notebooks and Loading Data
  • Pandas vs Numpy
  • Creating DataFrames
  • Saving and Serialising
  • Inspecting DataFrames
Visual exploration
  • Introduction and super basic plots
  • Pandas vs Matplotlib
  • Visualising 1D distributions
  • Visualising 2D distributions
  • Styling Pandas Table outputs
  • Higher dimension visualisations
  • Summary
Basic Data Manipulations
  • Introduction, Labelling and Ordering
  • Slicing and Filtering
  • Replacing and Thresholding
  • Removing and adding data
  • Apply, map and vectorised functions
  • Summary
Grouping
  • Introduction and motivation
  • Basic grouping syntax
  • Intelligent imputation
  • Grouping aggregation
  • Summary
Merging
  • Introduction and basic syntax
  • Different types of merging
  • Helpful merging functions
  • Summary
Advanced Manipulation - MultiIndex, Pivoting and more
  • Introduction and basic MultiIndexes
  • MultiIndex II - MultiIndex Strikes Back
  • Stacking and Unstacking
  • Pivoting
  • Pivot Margins
  • Crosstab
  • Melting
  • Summary
Time Series Data
  • Introduction and the Datetime Index
  • Reindexing
  • Resampling
  • Rolling functions
  • Time Zones
  • Summary
Conclusion
  • A recap and a thank you
  • Extra - Customising Jupyter Notebooks
  • Extra - Chapter 2 Data Runthrough
  • Extra - Chapter 3 Visualisation Runthrough
  • Extra - Chapter 4 Basics Runthrough
  • Extra - Chapter 5 Grouping Runthrough
  • Extra - Chapter 6 Merging Runthrough
  • Extra - Chapter 7 Advanced Runthrough
  • Extra - Chapter 8 TimeSeries Runthrough

Meet the course author

author-photo

Hi, I'm Sam and I'm an astrophysicist, data scientist, robotics and software engineer, astronomer and public presenter.

My work right now is all about renewable energy. Battery assets, optimising their utilisation and trading energy in markets to cut out as many fossil fuel generators as humanly possible.

In academia, my primary work involves investigating the nature of dark energy, however I also spend a lot of time advocating of open-source development and proper coding practices.

With years of experience from the financial software industry to machine learning pipelines classifying objects in the night sky, and teaching experience in statistics, software engineering, data manipulation, computational physics, and much more, I'm dedicated to increasing the level of coding proficiency in the scientific fields, and bringing basic coding knowledge to any eager student.

On top of my research work, I've run national coding workshops with content ranging from complete novices up to research experts. I'm excited to bring my knowledge and content to a wider audience, and hope that my direct and to-the-point teaching attitude allows students to understand the core concepts faster and better, saving students time and stress!

If after 14 days, you still aren't happy, no worries. We still will refund the price of the course no questions asked. Drop us an email to support at hello@sacrill.com

After payment, you can immediately start practicing

  • Click the "Get Access" button, enter your email in the field and you will be taken to a secure payment page.
  • Complete the order process and you will instantly receive a password to access your personal SACRILL account.
  • Take lessons, perform practical tasks, ask the author questions and discover new courses.

FAQ

For how long do I have access to the course?
You have unlimited time access to the course. You can take the course at your convenience, at your own pace.
When does the course start?
After you pay and sign up you will receive an email link witn an access password to your personal cabinet where all course materials are already in place.
How do I get access to the course?
To access the course you have to make a payment and give your email address, to which you will receive an email with a link and a password.
How do I pay for the course?
You can pay for the course using any Visa, MasterCard, Maestro, Visa Electron cards.
Can I buy the course as a present for someone?
Yes. In that case, when you register for the course please provide us with the email address of the person you want to receive the gift, and you will receive an authorization letter and access to your personal account.
If I don't like the course, can I get my money back?
Yes, you can. You do not run any risks. If the course doesn't meet your expectations within the first 14 days of purchase, we'll give you a full refund on your card, no questions asked. Just email our support at hello@sacrill.com
Kate Fox — Customer Happiness Manager
Kate Fox — Customer Happiness Manager
Our care and customer support team is ready to help at any time. If you have any questions, just email hello@sacrill.com
US $19