Learn machine learning the modern way
Practical tutorials for modern data science workflows: conversational notebooks, AutoLab experiments, and production-ready AutoML with clear reports.
How to Add Machine Learning Predictions to Excel with AutoML
Train an AutoML regression model on historical Excel data, predict insurance charges for new customers, and save the predictions as a new Excel column.
Find Near-Duplicate Rows in Excel with Python and AI
Find fuzzy duplicates in Excel with Python and RapidFuzz, review similar company records, test the matching threshold, and save a deduplicated workbook.
Python for Excel Users: Filter, Sort, Add Columns, and Save Excel Files
Learn Python through familiar Excel tasks: inspect rows, select columns, filter and sort sales, add a VAT calculation, and save a new workbook.
Turn an Excel Spreadsheet into a Web App with AI and Python
Turn an Excel spreadsheet into an interactive Python web app with filters, KPIs, charts, and tables using MLJAR Studio, AI, and Mercury.
Clean Messy Excel Data with Python and AI
Clean a messy Excel file with AI-generated Python: remove duplicates, handle missing values, parse mixed dates, standardize categories, and save a reviewed workbook.
Excel Formulas in Python: SUM, SUMIF, COUNTIF
Translate familiar Excel formulas into reviewed pandas operations for totals, conditional calculations, and grouped sales summaries.
Fix Mixed Date Formats in Excel with Python
Inspect mixed Excel date formats, parse them safely with Python, and verify that every value survived the conversion.
Handle Missing Values in Excel with Python
Find hidden missing values in Excel, convert placeholder text into proper nulls, and restore a numeric column with reviewed Python.
Remove Duplicate Rows from Excel with Python
Find exact duplicate rows in Excel, check repeated customer IDs for conflicts, remove only safe duplicates, and save a reviewed workbook with Python.
Standardize Text Categories in Excel with Python
Inspect inconsistent Excel categories, map text variants to reviewed standard names, and verify that every record remains accounted for.
Merge All Excel Files in a Folder with Python
Merge every Excel file in a folder with Python, detect inconsistent columns, verify monthly totals, and save a clean full-year workbook.
Merge Excel Files in Python with AI
Merge Excel files in Python with AI using MLJAR Studio, preserve every row's source file, verify the results, and save a reusable workbook.
AutoML in HR: Predict Employee Attrition with a Built-In Fairness Report
A beginner-friendly tutorial that shows how to use AutoML to predict employee attrition and inspect model fairness for Gender.
Decision Tree in Healthcare: Predict Insurance Costs with Explainable Machine Learning
A simple beginner-friendly tutorial that shows how to use a decision tree model to predict medical insurance charges and explain the prediction logic.
AutoML in Python: Beginner Tutorial with House Prices
Start with machine learning basics and move to AutoML. This tutorial shows how to build a house price prediction model in Python using MLJAR.