More Data Cleaning with Custom Functions (Data Cleaning Part 2) - Pandas | Python ~ Episode 7

Опубликовано: 08 Март 2022
на канале: David Weiss

505

Hey Coders! Badly formatted data can be as much of a problem as missing data. Thankfully, pandas provides a suite of tools to format your data in the exact way you want. With methods such as apply() and applymap(), you can quite literally define your own functions to pass the data through. For instance, you can remove special characters from a column of all strings, or calculate the residual of floats to the line of best fit. These functions plus replace() and drop() are what we'll be learning today!

Check out the source code on GitHub:
https://github.com/davidtheweiss/pand...

❤️ Support the ongoing growth of this channel, get exclusive perks, and receive consultation on your projects!   / davidweissprogramming

🧑‍💻 Pandas Documentation: https://pandas.pydata.org/docs/refere...

----------------------------------------------------------------------------------------------
🕒 Timestamps
0:00 Intro
0:55 Importing pandas and displaying our data
1:12 Replace() matched strings with another value
4:31 Apply() a custom function on your data
9:25 Applymap() across each element in your DataFrame
11:39 Drop() rows and columns from your DataFrame
----------------------------------------------------------------------------------------------
Other playlists:

-------------------------------------
Python
-------------------------------------
Pandas:
   • Pandas

-------------------------------------
Flutter
-------------------------------------
Basic Widgets:
   • Flutter - Season 2 | Basic Widgets

Dart:
   • Flutter - Season 1 | Dart

Flutter Orientation:
   • Flutter - Season 0 | Orientation

-------------------------------------
Google Cloud
-------------------------------------
Compute Engine:
   • Google Cloud - Season 2 | Compute Engine

App Engine:
   • Google Cloud - Season 1 | App Engine

Google Cloud Orientation:
   • Google Cloud - Season 0 | Orientation

-------------------------------------
Apps Script
-------------------------------------
Cache Service:
   • Apps Script - Season 17 | Cache Service

JDBC Service:
   • Apps Script - Season 16 | JDBC Service

Data Studio Service:
   • Apps Script - Season 15 | Data Studio...

Maps Service:
   • Apps Script - Season 14 | Maps Service

Utilities Service:
   • Apps Script - Season 13 | Utilities S...

Properties Service:
   • Apps Script - Season 12 | Properties ...

URL Fetch Service:
   • Apps Script - Season 11 | URL Fetch S...

Drive Service:
   • Apps Script - Season 10 | Drive Service

Forms Service:
   • Apps Script - Season 9 | Forms Service

Lock Service:
   • Apps Script - Season 8 | Lock Service

HTML Service:
   • Apps Script - Season 7 | HTML Service

Document Service:
   • Apps Script - Season 6 | Document Ser...

Slides Service:
   • Apps Script - Season 5 | Slides Service

Calendar Service:
   • Apps Script - Season 4 | Calendar Ser...

Script Service:
   • Apps Script - Season 3 | Script Service

Gmail Service:
   • Apps Script - Season 2 | Gmail Service

Spreadsheet Service:
   • Apps Script - Season 1 | Spreadsheet ...

Apps Script Orientation:
   • Apps Script - Season 0 | Orientation
----------------------------------------------------------------------------------------------