I have a dataset for which I need to add two new columns to an existing dataframe at the end.
If ordering of rows of both DataFrames is same, use concat with set default index values by drop=True in DataFrame.reset_index:
concat
drop=True
DataFrame.reset_index
df = pd.concat([X_test.reset_index(drop=True), dfs], axis=1)