In this python pandas program, we will add a new row in the DataFrame using the pandas library.
Steps to solve the program
- Import pandas library as pd.
- Create a Dataframe using pd.DataFrame().
- Create a new DataFrame containing the new row.
- Now add that row to the original DataFrame using df.append(df1, ignore_index=True).
- Print the output.
import pandas as pd
d = {'Sr.no.':[1,2,3,4],'Name':['Alex','John','Peter','Klaus'],'Age':[30,27,29,33]}
df = pd.DataFrame(d)
print("Original Series: ")
print(df)
df1 = {'Sr.no.':5,'Name':'Jason','Age':28}
df = df.append(df1, ignore_index=True)
print("New Series: ")
print(df)
Output :
Original Series:
Sr.no. Name Age
0 1 Alex 30
1 2 John 27
2 3 Peter 29
3 4 Klaus 33
New Series:
Sr.no. Name Age
0 1 Alex 30
1 2 John 27
2 3 Peter 29
3 4 Klaus 33
4 5 Jason 28