how to append to a dataframe in python code example
Example 1: append to pandas dataframe
df = df.append({'index1': value1, 'index2':value2,...}, ignore_index=True)
Example 2: append dataframe pandas
>>> df = pd.DataFrame([[1, 2], [3, 4]], columns=list('AB'))
>>> df
A B
0 1 2
1 3 4
>>> df2 = pd.DataFrame([[5, 6], [7, 8]], columns=list('AB'))
>>> df.append(df2)
A B
0 1 2
1 3 4
0 5 6
1 7 8
Example 3: pandas add dataframe to the bottom of another
import pandas as pd
appended_dataframe = dataframe_1.append(dataframe_2)
appended_dataframe = pd.concat([dataframe_1, dataframe_2])
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
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