Append Row to pandas DataFrame in Python (Example Code)
In this Python programming tutorial you’ll learn how to insert a new row to a pandas DataFrame.
Preparing the Example
import pandas as pd # Import pandas library in Python |
import pandas as pd # Import pandas library in Python
my_df = pd.DataFrame({'A':['x', 'y', 'x', 'y', 'z', 'z'], # Construct example DataFrame 'B':['g', 'g', 'w', 'a', 'g', 'f'], 'C':['a', 'b', 'c', 'd', 'e', 'f']}) print(my_df) # Display example DataFrame in console # A B C # 0 x g a # 1 y g b # 2 x w c # 3 y a d # 4 z g e # 5 z f f |
my_df = pd.DataFrame({'A':['x', 'y', 'x', 'y', 'z', 'z'], # Construct example DataFrame 'B':['g', 'g', 'w', 'a', 'g', 'f'], 'C':['a', 'b', 'c', 'd', 'e', 'f']}) print(my_df) # Display example DataFrame in console # A B C # 0 x g a # 1 y g b # 2 x w c # 3 y a d # 4 z g e # 5 z f f
my_row = ['lala', 'lele', 'lili'] # Construct new row |
my_row = ['lala', 'lele', 'lili'] # Construct new row
Example: Add Row to pandas DataFrame Using loc Attribute
my_df.loc[6] = my_row # Adding new row print(my_df) # Display new DataFrame # A B C # 0 x g a # 1 y g b # 2 x w c # 3 y a d # 4 z g e # 5 z f f # 6 lala lele lili |
my_df.loc[6] = my_row # Adding new row print(my_df) # Display new DataFrame # A B C # 0 x g a # 1 y g b # 2 x w c # 3 y a d # 4 z g e # 5 z f f # 6 lala lele lili