Pandas: Appending rows to a DataFrame
3. Append Rows to Existing DataFrame
Write a Pandas program to append rows to an existing DataFrame and display the combined data.
Test Data:
student_data1 student_id name marks 0 S1 Danniella Fenton 200 1 S2 Ryder Storey 210 2 S3 Bryce Jensen 190 3 S4 Ed Bernal 222 4 S5 Kwame Morin 199
New Row(s) student_id S6 name Scarlette Fisher marks 205 dtype: object
Sample Solution:
Python Code :
import pandas as pd
student_data1 = pd.DataFrame({
'student_id': ['S1', 'S2', 'S3', 'S4', 'S5'],
'name': ['Danniella Fenton', 'Ryder Storey', 'Bryce Jensen', 'Ed Bernal', 'Kwame Morin'],
'marks': [200, 210, 190, 222, 199]})
s6 = pd.Series(['S6', 'Scarlette Fisher', 205], index=['student_id', 'name', 'marks'])
print("Original DataFrames:")
print(student_data1)
print("\nNew Row(s)")
print(s6)
combined_data = student_data1.append(s6, ignore_index = True)
print("\nCombined Data:")
print(combined_data)
Sample Output:
Original DataFrames: student_id name marks 0 S1 Danniella Fenton 200 1 S2 Ryder Storey 210 2 S3 Bryce Jensen 190 3 S4 Ed Bernal 222 4 S5 Kwame Morin 199 New Row(s) student_id S6 name Scarlette Fisher marks 205 dtype: object Combined Data: student_id name marks 0 S1 Danniella Fenton 200 1 S2 Ryder Storey 210 2 S3 Bryce Jensen 190 3 S4 Ed Bernal 222 4 S5 Kwame Morin 199 5 S6 Scarlette Fisher 205
For more Practice: Solve these Related Problems:
- Write a Pandas program to append a new row to a DataFrame and then sort the DataFrame by a numeric column.
- Write a Pandas program to add multiple rows to a DataFrame using DataFrame.append() and then reset the index.
- Write a Pandas program to append a row with calculated values from existing rows and then verify the changes.
- Write a Pandas program to append rows to a DataFrame and then drop rows with duplicate key values.
Python Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a Pandas program to join the two given dataframes along columns and assign all data.
Next: Write a Pandas program to append a list of dictioneries or series to a existing DataFrame and display the combined data.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.