Скачать или смотреть Appending & Merging Dataframes (concat, merge, join, ...) - Pandas | Python ~ Episode 5

Hey Coders! As mentioned before, pandas can be thought of as SQL on steroids for python. One of the hallmarks of SQL is the ability to join two tables together based on a related column. In pandas, you can also do this, but with many more features and functionality. The best way to perform an inner/left/right/outer/cross join is by using the pd.merge method. However, pandas also allows you to combine two dataframes vertically using the concat method. Everyday pandas consists of using one or more of these methods, so be sure to watch the entire video and take time to practice these functions on your own!

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
1:13 Importing pandas and displaying our data
2:39 Adding new columns to a DataFrame
7:34 Using insert() to place column in specific position
9:50 Adding new rows to a DataFrame
11:16 append() stacks dataframes vertically
14:30 concat() can stack vertically or horizontally
17:50 merge() is used to perform a SQL join
27:00 join() joins on dataframe index
30:35 tl;dr
----------------------------------------------------------------------------------------------
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 Service  

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

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

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

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

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 Service  

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

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

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

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

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

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