#20. Pandas: Concatenate, Append in Python - 8 | Tutorial

The video discusses concatenate and append series/dataframes in Python.

Timeline & Data & Exercise
(Python 3.7)

00:00 - Welcome
00:09 - Outline of video
00:49 - Open Jupyter Notebook
01:13 - Data
02:41 - ————————— Correction: Here, I mean to say: “We still have four columns” * * *
03:16 - Create a list of DataFrames
03:40 - Concatenate multiple DataFrames from a list
05:02 - Concatenate with a key
06:13 - Use .loc(key) to get rows from DataFrame
07:00 - Concatenate DataFrames with different indices
09:55 - Concatenate with join conditions: outer
10:55 - Concatenate with join conditions: inner
11:39 - Concatenate using .reindex()
14:48 - Append DataFrames
17:52 - ———————— Correction: Here, I mean to say: “Columns m and n do not appear in df4 ” * * *
18:39 - Append multiple DataFrames
19:18 - Ignore index
22:17 - Concatenate DataFrame to Series
25:00 - Concatenate Series to Series to create a DataFrame
25:55 - Using keys to label column names in a DataFrame
26:28 - Ending notes

################
### Data
################
# Series
a = pd.Series(['a1','a2','a3'], name='sa')
b = pd.Series(['b1','b2','b3'])
c = pd.Series(['c1','c2','c3'])

# DataFrame
df1 = pd.DataFrame({
'm':['m1','m2','m3'],
'n':['n1','n2','n3'],
'o':['o1','o2','o3'],
'p':['p1','p2','p3']},
index=[0,1,2]
)

df2 = pd.DataFrame({
'm':['m4','m5','m6'],
'n':['n4','n5','n6'],
'o':['o4','o5','o6'],
'p':['p4','p5','p6']},
index=[3,4,5]
)

df3 = pd.DataFrame({
'm':['m7','m8','m9'],
'n':['n7','n8','n9'],
'o':['o7','o8','o9'],
'p':['p7','p8','p9']},
index=[6,7,8]
)

df4 = pd.DataFrame({
'o':['o3','o7','o9'],
'p':['p3','p7','p9'],
'q':['q3','q7','q9'],
'r':['r3','r7','r9']},
index=[1,2,7]
)

################



learndataa exercise for this video can be found at link below:
https://github.com/learndataa/exercises

Thank you