Add two dataframes together

Merge two dataframes based on column

df_outer = pd.merge(df1, df2, on='id', how='outer') #here id is common column

df_outer

Combine two dataframe in pandas

# Stack the DataFrames on top of each other
vertical_stack = pd.concat([survey_sub, survey_sub_last10], axis=0)

# Place the DataFrames side by side
horizontal_stack = pd.concat([survey_sub, survey_sub_last10], axis=1)

Source: datacarpentry.org

How to merge two dataframes

df_merge_col = pd.merge(df_row, df3, on='id')

df_merge_col

Merge 2 dataframes pythom

concat = pd.merge(data_1, data_2, how='inner')

Source: stackoverflow.com

Add two dataframes together

df1 = pd.DataFrame(
   ...:     {
   ...:         "A": ["A0", "A1", "A2", "A3"],
   ...:         "B": ["B0", "B1", "B2", "B3"],
   ...:         "C": ["C0", "C1", "C2", "C3"],
   ...:         "D": ["D0", "D1", "D2", "D3"],
   ...:     },
   ...:     index=[0, 1, 2, 3],
   ...: )
   ...: 

In [2]: df2 = pd.DataFrame(
   ...:     {
   ...:         "A": ["A4", "A5", "A6", "A7"],
   ...:         "B": ["B4", "B5", "B6", "B7"],
   ...:         "C": ["C4", "C5", "C6", "C7"],
   ...:         "D": ["D4", "D5", "D6", "D7"],
   ...:     },
   ...:     index=[4, 5, 6, 7],
   ...: )
   ...: 

In [3]: df3 = pd.DataFrame(
   ...:     {
   ...:         "A": ["A8", "A9", "A10", "A11"],
   ...:         "B": ["B8", "B9", "B10", "B11"],
   ...:         "C": ["C8", "C9", "C10", "C11"],
   ...:         "D": ["D8", "D9", "D10", "D11"],
   ...:     },
   ...:     index=[8, 9, 10, 11],
   ...: )
   ...: 

In [4]: frames = [df1, df2, df3]

In [5]: result = pd.concat(frames)

Source: pandas.pydata.org

Similar codes

1 vote176 views1 answer
List shape python
Python
1 vote209 views1 answer
Backup django db from one database to another
Python Django
0 vote238 views3 answers
Converter python to c++ code
Python
7 votes175 views2 answers
Numpy create a matrix of certain value
Python
0 vote195 views1 answer
Collections counter sort by value
Python
0 vote181 views1 answer
Formula e xiaomi
Python
1 vote177 views1 answer
How to fetch all chars of a string before a space in python
Python
0 vote237 views1 answer
Is Cross policy an issue with puppeteer / headless chrome?
Python
5 votes186 views3 answers
Convert categorical column to int in pandas
Python
0 vote191 views1 answer
Pyqt button hover color
Python