How to append a list to a Pandas DataFrame using append() in Python?

PythonServer Side ProgrammingProgramming

To append a list to a DataFrame using append(), let us first create a DataFrame. The data is in the form of lists of team rankings for our example −

# data in the form of list of team rankings
Team = [['India', 1, 100],['Australia', 2, 85],['England', 3, 75],['New Zealand', 4 , 65],['South Africa', 5, 50]]

# Creating a DataFrame and adding columns
dataFrame = pd.DataFrame(Team, columns=['Country', 'Rank', 'Points'])

Let’s say the following is the row to be append −

myList = [["Sri Lanka", 6, 40]]

Append the above row in the form of list using append() −

dataFrame = dataFrame.append(pd.DataFrame(myList, columns=['Country', 'Rank', 'Points']), ignore_index=True)

Example

Following is the code −

import pandas as pd

# data in the form of list of team rankings
Team = [['India', 1, 100],['Australia', 2, 85],['England', 3, 75],['New Zealand', 4 , 65],['South Africa', 5, 50]]

# Creating a DataFrame and adding columns
dataFrame = pd.DataFrame(Team, columns=['Country', 'Rank', 'Points'])

print"DataFrame...\n",dataFrame

# row to be appended
myList = [["Sri Lanka", 6, 40]]

# append the above row in the form of list
dataFrame = dataFrame.append(pd.DataFrame(myList, columns=['Country', 'Rank', 'Points']), ignore_index=True)

# display the update dataframe
print"\nUpdated DataFrame after appending a row...\n",dataFrame

Output

This will produce the following output −

DataFrame...
        Country   Rank   Points
0         India      1      100
1     Australia      2       85
2       England      3       75
3   New Zealand      4       65
4  South Africa      5       50

Updated DataFrame after appending a row...
        Country   Rank   Points
0         India      1      100
1     Australia      2       85
2       England      3       75
3   New Zealand      4       65
4  South Africa      5       50
5     Sri Lanka      6       40
raja
Published on 21-Sep-2021 08:12:00
Advertisements