Instagram
youtube
Facebook
Twitter

Concatenate Two Pandas DataFrames Vertically

 

A Concatenate Two Pandas DataFrames Vertically?
Code Explanation:
Data Creation: Two DataFrames (df1 and df2) are created, but only df1 is used.
Concatenation: pd.concat([df1, df1], axis=0) combines df1 with itself vertically (row-wise).
Index: The original indices are retained. So, you get repeated indices (0,1,0,1).
Output Display: The new DataFrame df4 is printed, showing duplicated rows from df1.

 

Program:

import pandas as pd

df1 = pd.DataFrame({'ID': [1, 2], 'Name': ['Alice', 'Bob']})

df2 = pd.DataFrame({'ID': [1, 2], 'Score': [90, 95]})

df4 = pd.concat([df1, df1], axis=0)

print(df4)