pandas insert row into dataframe code example

Example 1: add rows to dataframe pandas

df = df.append({'a':1, 'b':2}, ignore_index=True)

Example 2: how to add row in spark dataframe

# Create hard coded row
unknown_list = [[‘0’, ‘Unknown’]]
# turn row into dataframe
unknown_df = spark.createDataFrame(unknown_list)
# union with existing dataframe
df = df.union(unknown_df)

Example 3: how to add a row to a dataframe in python

import pandas as pd

data = {'name': ['Somu', 'Kiku', 'Amol', 'Lini'],
	'physics': [68, 74, 77, 78],
	'chemistry': [84, 56, 73, 69],
	'algebra': [78, 88, 82, 87]}

	
#create dataframe
df_marks = pd.DataFrame(data)
print('Original DataFrame\n------------------')
print(df_marks)

new_row = {'name':'Geo', 'physics':87, 'chemistry':92, 'algebra':97}
#append row to the dataframe
df_marks = df_marks.append(new_row, ignore_index=True)

print('\n\nNew row added to DataFrame\n--------------------------')
print(df_marks)