Python Data Science with Pandas: Master 12 Advanced Projects

Work with Pandas, SQL Databases, JSON, Web APIs & more to master your real-world Machine Learning & Finance Projects

4.70 (912 reviews)

Udemy

platform

English

language

Finance

What you will learn

Advanced Real-World Data Workflows with Pandas you won´t find in any other Course.

Working with Pandas and SQL-Databases in parallel (getting the best out of two worlds)

Working with APIs, JSON and Pandas to import large Datasets from the Web

Bringing Pandas to its Limits (and beyond...)

Machine Learning Application: Predicting Real Estate Prices

Finance Applications: Backtesting & Forward Testing Investment Strategies + Index Tracking

Feature Engineering, Standardization, Dummy Variables and Sampling with Pandas

Working with large Datasets (millions of rows/columns)

Working with completely messy/unclean Datasets (the standard case in real-world)

Handling stringified and nested JSON Data with Pandas

Loading Data from Databases (SQL) into Pandas and vice versa

Loading JSON Data into Pandas and vice versa

Web-Scraping with Pandas

Cleaning large & messy Datasets (millions of rows/columns)

Working with APIs and Python Wrapper Packages to import large Datasets from the Web

Explanatory Data Analysis with large real-world Datasets

Advanced Visualizations with Matplotlib and Seaborn

Why take this course?

***Fully updated and revised in December 2023***

Welcome to the first advanced and project-based Pandas Data Science Course!

This Course starts where many other courses end: You can write some Pandas code but you are still struggling with real-world Projects because

Real-World Data is typically not provided in a single or a few text/excel files -> more advanced Data Importing Techniques are required
Real-World Data is large, unstructured, nested and unclean -> more advanced Data Manipulation and Data Analysis/Visualization Techniques are required
many easy-to-use Pandas methods work best with relatively small and clean Datasets -> real-world Datasets require more General Code (incorporating other Libraries/Modules)

No matter if you need excellent Pandas skills for Data Analysis, Machine Learning or Finance purposes, this is the right Course for you to get your skills to Expert Level! Master your real-world Projects!

This Course covers the full Data Workflow A-Z:

Import (complex and nested) Data from JSON files.
Import (complex and nested) Data from the Web with Web APIs, JSON and Wrapper Packages.
Import (complex and nested) Data from SQL Databases.
Store (complex and nested) Data in JSON files.
Store (complex and nested) Data in SQL Databases.
Work with Pandas and SQL Databases in parallel (getting the best of both worlds).
Efficiently import and merge Data from many text/CSV files.
Clean large and messy Datasets with more General Code.
Clean, handle and flatten nested and stringified Data in DataFrames.
Know how to handle and normalize Unicode strings.
Merge and Concatenate many Datasets efficiently.
Scale and Automate data merging.
Explanatory Data Analysis and Data Presentation with advanced Visualization Tools (advanced Matplotlib & Seaborn).
Test the Performance Limits of Pandas with advanced Data Aggregations and Grouping.
Data Preprocessing and Feature Engineering for Machine Learning with simple Pandas code.
Use your Data 1: Train and test Machine Learning Models on preprocessed Data and analyze the results.
Use your Data 2: Backtesting and Forward Testing of Investment Strategies (Finance & Investment Stack).
Use your Data 3: Index Tracking (Finance & Investment Stack).
Use your Data 4: Present your Data with Python in a nicely looking HTML format (Website Quality).
and many more...

I am Alexander Hagmann, Finance Professional and Data Scientist (> 7 Years Industry Experience) and best-selling Instructor for Pandas, (Financial) Data Science and Finance with Python. Looking forward to seeing you in this Course!

Screenshots

Python Data Science with Pandas: Master 12 Advanced Projects - Screenshot_01

Python Data Science with Pandas: Master 12 Advanced Projects - Screenshot_02

Python Data Science with Pandas: Master 12 Advanced Projects - Screenshot_03

Python Data Science with Pandas: Master 12 Advanced Projects - Screenshot_04

Reviews

Dilshan

August 10, 2023

This is early to give the complete recommendation of the course, however so far this is understandable. as well as if you offer a live coding experience that might be better for the learners

Aysenur

April 15, 2023

It's a very good, well organized course. After finishing some courses in Data Analytics with Python and learning so much stuff I was left confused. I learned a lot but didn't know what to do with all those information. Well, it's not the case any more. Alexander's method for the projects not just teaches you new methods in Pandas it also gives you a solid understanding of what it's really like working on a project. The road map of Data Analysis. Now, I feel confident to start my own projects. Thank you Alexander for this very professional content!

Matías

March 21, 2023

The concepts are perfectly understood (I am from Latin America and I have a B2 English). The practice was also very entertaining and the projects, although some seemed a bit basic to me, are very good.

Cincy

February 19, 2023

I enjoy learning this course. Most of them are very helpful in learning advanced codings and data processing. Thank you, Alex.

Ana

February 9, 2023

Overall poor quality: - Poor audio quality - Accent not helpful so I chose to use the subtitles but they are horrible and don't help at all. They confused me even more so I had to removed them - Each section is basically written code in (given) Jupyter Notebooks where the Instructor does the job of basically code comments. It seems like he is not explaining and he has not prepared the class at all (seen by the "unexpected" results he sometimes had). - The most useful section was the pandas crash course which was actually an optional section of this course. However, this is a work training for me, so I will finish this course.

Evan

December 6, 2022

The instructor is clear and logical and easy to follow (I am only an hour or so in, but I have done tons of courses. So it does not take long to know.) He also explains much of the reason behind everything, so that helps internalize the information. It is definitely going to be the next step I need to never be embarrassed for not knowing an obscure Pandas function in an interview ever again!

Michela

October 12, 2022

I love it! Alexander explains really well and I'm actually learning something. Would definitely buy another course from him.

Madhuri

September 20, 2022

It was very beneficial to learn how to do projects. I highly recommend this course to anyone who wants to do data science projects

Vishal

September 15, 2022

I am halfway through this course and I am amzed by the delivery and instructor's comprehension and grasp of Pandas. The challanges presented in this course are something definitely what I was looking for and the Alexander is very engaging and hits all the points at once.

Thomas

September 5, 2022

please make a clear pronoun , and subs sometimes diffrent, for newbie really need all clear make us understand

Sunil

August 26, 2022

Course content is very reach and valuable. As the course title confirms, it offers mastery of projects, not 1 or 2, it is 12. Highly recommended for its targeted audience. Specially for mastering complexity of real life project situations.

Akira

August 8, 2022

The contents are always great with Alex. I wish that they have more variety in terms of the materials and skills to be acquired, as are bits and pieces from his other lectures and make up as a different lectuer.

Muhammad

August 1, 2022

i have bought several courses from alex, this course is one of the best in leveling up my pandas skill. keep going alex, you do great always

Adam

July 21, 2022

I'm a bit more than a novice so this course was very exciting for me. It showed simple ways of doing things that I was struggling with. He has a clear and focused process for cleaning, analyzing, and teasing the data. It also showed a number of visual and other statistical commands that I had never run across before with Python. I really enjoyed this course and already have plans to use what I learned.

張嘉桐