pandas concat df code example

Example 1: pandas left join

df.merge(df2, left_on = "doc_id", right_on = "doc_num", how = "left")

Example 2: concat dataframe from list of dataframe

import pandas as pd
df = pd.concat(list_of_dataframes)

Example 3: concat pandas python

>>> s1 = pd.Series(['a', 'b'])
>>> s2 = pd.Series(['c', 'd'])
>>> pd.concat([s1, s2])
0    a
1    b
0    c
1    d
dtype: object