Udemy - Master Data Cleaning - Python, Excel and Power Query

  • Category Other
  • Type Tutorials
  • Language English
  • Total size 1.3 GB
  • Uploaded By freecoursewb
  • Downloads 466
  • Last checked 4 hours ago
  • Date uploaded 5 months ago
  • Seeders 16
  • Leechers 4

Infohash : C1171BB6E185EB78BFA69630697192AA84A1B10B



Master Data Cleaning: Python, Excel & Power Query

https://WebToolTip.com

Published 7/2025
Created by Ravi Singh
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: All | Genre: eLearning | Language: English | Duration: 19 Lectures ( 1h 19m ) | Size: 1.32 GB

Master practical data cleaning skills with Excel formulas, Power Query automation, and Python scripts.

What you'll learn
Identify and fix messy, inconsistent, incomplete, and duplicate data across various sources.
Use functions like IF(), TRIM(), TEXT(), VLOOKUP(), and DATA VALIDATION to clean and format spreadsheets effectively.
Import messy files, transform column headers, remove blanks, filter rows, and automate repetitive cleaning using Power Query.
Use Python’s pandas library to load, clean, merge, and transform real-world datasets using functions like .dropna(), .fillna(), .str.replace(), and .groupby().
Standardize inconsistent date formats, correct column naming issues, and unify naming conventions using both Excel and code.
Identify and remove exact and near-duplicate records using Excel tools, Power Query logic, and pandas .duplicated() methods.
Build workflows that allow you to clean new data in one click using Power Query and reusable Python scripts.

Requirements
Ability to navigate files, folders, and applications confidently.
Basic understanding of Excel spreadsheets
Experience with formulas like SUM, IF, and VLOOKUP (helpful but not required)
Understanding of basic Python syntax (print(), variables, lists/dictionaries)
No advanced coding required — Python basics will be reinforced in the course
Willingness to try tools like Power Query and Python/pandas even if you're new to them.
Power Query is built-in from Excel 2016+
Python (v3.7 or later) Installed via Anaconda or Python org
Jupyter makes it easy to follow step-by-step
VS Code or any other IDE is also fine
Internet Connection Required to download data files, Python packages, or follow along with GitHub-hosted resources.

Files:

[ WebToolTip.com ] Udemy - Master Data Cleaning - Python, Excel and Power Query
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1 - Introduction to the Data Wrangler Course
    • 1 -Become a Data Wrangler - Introduction.mp4 (53.0 MB)
    • 2 -About The Author.mp4 (23.4 MB)
    • 3 -Why Data Wrangling Matters.mp4 (43.7 MB)
    • 4 -The Tools You’ll Learn in This Course.mp4 (15.1 MB)
    • 5 -Data Wrangling - Course Introduction.mp4 (14.9 MB)
    2 - What is Data Wrangling
    • 1 -What is Data Wrangling.mp4 (66.3 MB)
    • 2 -The Data Wrangling Lifecycle.mp4 (68.7 MB)
    • 3 -Where Does Wrangling Fit in Data Analytics.mp4 (26.2 MB)
    • 4 -Data Wrangling vs. Data Analysis.mp4 (41.6 MB)
    3 - Real-World Examples of Messy Data
    • 1 -Real-World Examples of Messy Data.mp4 (133.3 MB)
    4 - The Tools You need for Wrangling
    • 1 -The Tools You’ll Learn in This Course.mp4 (27.2 MB)
    • 2 -Python - Pandas for Data Wrangling.mp4 (34.0 MB)
    • 3 -Data Cleaning using Pandas - Example.mp4 (96.1 MB)
    • 4 -Data Cleaning Using Excel - With Example.mp4 (168.9 MB)
    • 5 -Data Cleaning Using Power Query - With Example.mp4 (149.3 MB)
    5 - Data Cleaning in Excel - Detail
    • 1 -Data Cleaning in Excel - Detail.mp4 (70.9 MB)
    6 - Data Cleaning in Power Query
    • 1 -Data Cleaning in Power Query.mp4 (89.6 MB)
    7 - Data Cleaning Using Pandas - Details
    • 1 -Data Cleaning Using Pandas - Details.mp4 (129.4 MB)
    9 - Export, Share and Automate Wrangling Output
    • 1 -Export, Share and Automate Wrangling Output.mp4 (108.6 MB)
    • Bonus Resources.txt (0.1 KB)

There are currently no comments. Feel free to leave one :)

Code:

  • udp://tracker.torrent.eu.org:451/announce
  • udp://tracker.tiny-vps.com:6969/announce
  • http://tracker.foreverpirates.co:80/announce
  • udp://tracker.cyberia.is:6969/announce
  • udp://exodus.desync.com:6969/announce
  • udp://explodie.org:6969/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://9.rarbg.to:2780/announce
  • udp://tracker.internetwarriors.net:1337/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • udp://open.stealth.si:80/announce
  • udp://9.rarbg.to:2900/announce
  • udp://9.rarbg.me:2720/announce
  • udp://opentor.org:2710/announce
R2-CACHE ☁️ R2 (hit) | CDN: REVALIDATED (0s) 📄 torrent 🕐 02 Jan 2026, 02:33:00 am IST ⏰ 27 Jan 2026, 02:32:59 am IST ✅ Valid for 8d 20h 🔄 Refresh Cache