Answers for "add row to dataframe"

add rows to dataframe pandas

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

append one row to pandas dataframe

df = df.append({'index1': value1, 'index2':value2,...}, ignore_index=True)

dataframe add row

# append row to dataframe without index

a_row = pd.Series([1, 2])
df = pd.DataFrame([[3, 4], [5, 6]])

row_df = pd.DataFrame([a_row])
df = pd.concat([row_df, df], ignore_index=True)

print(df)
# OUTPUT
#    0  1
# 0  1  2
# 1  3  4
# 2  5  6

# append row to dataframe with index

a_row = pd.Series([1, 2])
df = pd.DataFrame([[3, 4], [5, 6]], index = ["row1", "row2"])

row_df = pd.DataFrame([a_row], index = ["row3"])
df = pd.concat([row_df, df])

print(df)
# OUTPUT
#       0  1
# row3  1  2
# row1  3  4
# row2  5  6

pandas insert row

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)

add new row to dataframe pandas

# Add a new row at index k with values provided in list
dfObj.loc['k'] = ['Smriti', 26, 'Bangalore', 'India']

pandas insert row

df.loc[-1] = [2, 3, 4]  # adding a row
 df.index = df.index + 1  # shifting index
 df = df.sort_index()  # sorting by index