pandas append dataframes
# Basic syntax:
import pandas as pd
appended_dataframe = dataframe_1.append(dataframe_2)
# or:
appended_dataframe = pd.concat([dataframe_1, dataframe_2])
# Example usage:
dataframe_1 = pd.DataFrame([[1, 2], [3, 4]], columns=list('AB'))
dataframe_2 = pd.DataFrame([[5, 6], [7, 8]], columns=list('AB'))
appended_dataframe = dataframe_1.append(dataframe_2)
print(appended_dataframe)
A B
0 1 2
1 3 4
0 5 6
1 7 8
# Note, add "ignore_index = False" if you want new sequential row indices
# Note, append does not modify the dataframes in place, which is why
# running just dataframe_1.append(dataframe_2) doesn't change
# dataframe_1
# Note, if the column names aren't the same, the dataframes will be
# appended with NaNs like:
A B C D
0 1.0 2.0 NaN NaN
1 3.0 4.0 NaN NaN
0 NaN NaN 5.0 6.0
1 NaN NaN 7.0 8.0