Limited time · 90% off Premium Membership - claim $199 deal →
For Teams For Libraries Sign in
EN
Start unlimited
Catalog Courses Books Assets Newsletter Merch About Contact Blogs
Cart Sign in Start unlimited
Catalog / All levels / From Excel to Python: Transform Data Science Workflows
Mammoth Club All levels 6 sections 18 lectures

From Excel to Python: Transform Data Science Workflows

Stop crashing your spreadsheet and start coding. Make the leap from Analyst to Data Scientist.

Created by Team Mammoth
·
18 lectures
01
Skill level
All levels
02
Sections
6
03
Lectures
18
04
Instructor
Team Mammoth
What's inside

This course includes.

✓
6
Sections
✓
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.

6 sections · 18 lectures
+ Course overview - Excel to Python 2 lectures Preview
00 Course Overview - Excel To Python Locked
Full Course Soruce Files Locked
+ Excel automation with Python data modeling 5 lectures
00 Project Overview - Excel Automation With Python Data Modeling Locked
01 Read Excel File With Python Locked
02 Reshape Data For Data Modeling Locked
03 Build A Linear Regression Model With Python Locked
04 Visualize Machine Learning Predictor With Python Locked
+ Use Excel File in Python 3 lectures
01 Use Excel File In Python Locked
02 Manipulate Excel File With Python Locked
03 Build Dictionaries With Python Locked
+ Manipulate Excel Sheets with Python 3 lectures
01 Import Data File Into A Pandas Dataframe Locked
02 Excel Sheet Manipulation With Python Locked
03 Get Excel Sheet Information With Python Locked
+ Build Excel Filters in Python 3 lectures
01 Build View Excel Functions In Python Locked
02 Build Filter Excel Functions In Python Locked
03 Build Filter Functions On Blockchain Dataset Locked
+ Aggregate Excel Data with Python 2 lectures
01 Aggregate Excel Data With Python Locked
02 Build Excel Pivot Tables In Python Locked
Description

About this course.

Excel is great, but Python is limitless. This transition course is designed for spreadsheet users ready to graduate to Pandas and NumPy for heavy-duty data science.

• Translate VLOOKUPs and Pivot Tables into Python code.

• Handle datasets that are too large for standard spreadsheets.

• Automate repetitive reporting tasks.

✔️ 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?

Stop crashing your spreadsheet and start coding. Make the leap from Analyst to Data Scientist.

Buy lifetime access →