#21. Pandas: Merge, append, concatenate in Python - 9 | Tutorial
The video discusses merge, append and concatenate in Python.
Timeline
(Python 3.7)
00:00 - Welcome
00:09 - Outline of video
01:00 - Concepts in joins: outer, left, right, inner
02:41 - Concept: Outer join
03:48 - Concept: Left join
05:49 - Concept: Right join
06:49 - Concept: Inner join
07:59 - Concept: Join with duplication
10:58 - Open Jupyter Notebook
11:21 - Data
12:41 - Dictionary of DataFrames
13:58 - Concat DataFrames in a Dictionary
15:39 - Append a Series as a row to a DataFrame
16:54 - Append a list of Dictionaries to a DataFrame
20:26 - Merge
21:19 - Merge - default
22:21 - Merge - outer
22:52 - Merge - inner
23:34 - Merge - left
25:15 - Merge - right
26:27 - Merge on two keys
29:20 - Check duplicate keys — validate=
31:56 - Check type of join — indicator=
33:45 - Join on index
36:51 - Join on index and column both
38:23 - Join multiple DataFrames
40:11 - .combine_first() for DataFrames
41:50 - .update() a DataFrame
42:36 - Ending notes