I am trying to append an empty row at the end of dataframe but unable to do so even trying to understand how pandas work with append function and still not getting it Here s the code import pandas as pd excel names ARMANI EMPORIO AR0143-book xlsx excels pd ExcelFile name for name in excel names frames x parse x sheet names 0 header None index col None dropna how all for x in excels for f in frames f append 0 float NaN f append 2 float NaN There are two columns and random number of row with print f in for loop i Get this 0 1 0 Brand Name Emporio Armani 2 Model number AR0143 4 Part Number AR0143 6 Item Shape Rectangular 8 Dial Window Material Type Mineral 10 Display Type Analogue 12 Clasp Type Buckle 14 Case Material Stainless steel 16 Case Diameter 31 millimetres 18 Band Material Leather 20 Band Length Women s Standard 22 Band Colour Black 24 Dial Colour Black 26 Special Features second-hand 28 Movement Quartz

Append an empty row in dataframe using pandas

Add a new pandas.Series using pandas.DataFrame.append().

If you wish to specify the name (AKA the "index") of the new row, use:

df.append(pandas.Series(name='NameOfNewRow'))

If you don't wish to name the new row, use:

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

where df is your pandas.DataFrame.

~ Answered on 2019-01-23 14:53:16