PYTHON

add empty row to pandas dataframe

df = df.append(pd.Series(), ignore_index=True)

how to add rows to empty dataframe

# Append rows in Empty Dataframe by adding dictionaries
dfObj = dfObj.append({'User_ID': 23, 'UserName': 'Riti', 'Action': 'Login'}, ignore_index=True)
dfObj = dfObj.append({'User_ID': 24, 'UserName': 'Aadi', 'Action': 'Logout'}, ignore_index=True)
dfObj = dfObj.append({'User_ID': 25, 'UserName': 'Jack', 'Action': 'Login'}, ignore_index=True)

insert blank row in data frame

dict = {'First Name': 'Vikram', 'Last Name': 'Aruchamy', 'Country': 'India'}

df = df.append(dict, ignore_index = True)

df

insert blank row in data frame

import pandas as pd

df = pd.DataFrame()

df

insert blank row in data frame

df2 = pd.DataFrame({'First Name': ['Kumar'],
                    'Last Name' : ['Ram'],
                    'Country' : ['India']})

df = pd.concat([df, df2], ignore_index = True, axis = 0)

df

insert blank row in data frame

df.iloc[1] = ['India', 'Shivam', 'Pandey']

df