Limited time · 90% off Premium Membership - claim $199 deal →
Mammoth Club All levels 5 sections 22 lectures

Automate Excel with Data Engineering and Machine Learning in Python

Merge the simplicity of Excel with the power of Python. Bring Machine Learning to your spreadsheets.

01
Skill level
All levels
02
Sections
5
03
Lectures
22
04
Instructor
Team Mammoth
What's inside

This course includes.

5
Sections
22
Lectures
22
Resources
Certificate of completion
Included
Mobile and desktop access
Included
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content

Curriculum & lectures.

5 sections · 22 lectures
+ Course Overview 3 lectures
01 Course Overview Locked
Source Files Locked
Complete Full Course Source Files Locked
+ Load, clean and encode data 4 lectures
01 Load And Clean A Public Dataset Locked
01B What Is One-Hot Encoding Locked
02 Build X And Y Data With One Hot Encoding Locked
03 Logistic Regression With One Hot Encoding Locked
+ Data engineering for machine learning 3 lectures
01 What Is Scaling Data Locked
02 Scale And Encode Data With Scikit-Learn Locked
03 Build, Train And Test A Machine Learning Model Locked
+ Build regression and discretizer models 6 lectures
01 Compare Decision Tree And Linear Regression Models Locked
02 What Is The Kbins Discretizer Locked
03 Bin Data With Kbins Discretizer Locked
04 Compare Binned Regression Models Locked
05 Build A Linear Regression Model On Stacked Data Locked
05A What Is K Means Clustering Locked
+ Data transformation and feature selection for ridge regression 6 lectures
01 What Is Gaussian Probability Distribution Locked
02 Build Univariate Nonlinear Transformation Locked
03 What Is Poisson Distribution Locked
04 What Is Logarithmic Data Transformation Locked
05 Build X Y Data With Poisson Distribution In Numpy Locked
06 Build A Ridge Regression Model Locked
Description

About this course.

Transform Excel into a Machine Learning powerhouse. Learn to connect your workbooks to Python ML libraries to run predictive models directly on your spreadsheet data.

• Train machine learning models on Excel datasets.

• Automate data cleaning pipelines with Pandas.

• Output predictions back into your workbook.

✔️ Lifetime access

✔️ Source files included

✔️ Human-made HD video and crystal-clear audio

Instructors

Taught by people who ship.

Team Mammoth

Team Mammoth

Instructor

Produced by a team of Mammoth Club industry experts. Over 14 years, Mammoth Club has built a global student community in 190+ countries with 9+ million courses sold, releasing over 1,000+ courses and 5,000+ hours of video content.

Ready to start building?

Merge the simplicity of Excel with the power of Python. Bring Machine Learning to your spreadsheets.

Buy lifetime access →