how to add a row to a dataframe in pandas code example
Example 1: add rows to dataframe pandas
df = df.append({'a':1, 'b':2}, ignore_index=True)
Example 2: 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]}
df_marks = pd.DataFrame(data)
print('Original DataFrame\n------------------')
print(df_marks)
new_row = {'name':'Geo', 'physics':87, 'chemistry':92, 'algebra':97}
df_marks = df_marks.append(new_row, ignore_index=True)
print('\n\nNew row added to DataFrame\n--------------------------')
print(df_marks)
Example 3: pandas insert row
df.loc[-1] = [2, 3, 4]
df.index = df.index + 1
df = df.sort_index()
Example 4: add new row to dataframe pandas
dfObj.loc['k'] = ['Smriti', 26, 'Bangalore', 'India']