Add empty row in excel using python pandas

Question

I want to add an empty row to all of my excel files using python pandas.

I leave you an example so you can understand.

I have this: Excel example

And I want to add this row before name and city: Example

I need to do that, but not opening the excels files cause this is just a small example of what I really need.

Thanks!

You are going to have to open the file.. how else would you read/write to the file? — Farhan.K
– Farhan.K, Commented Nov 2, 2017 at 16:21
You know you can decide where the start row to input the data in excel right ? — BENY
– BENY, Commented Nov 2, 2017 at 16:29
@Wen yes, but i still need to add some extra empty rows at the top or middle, etc. — Danitsu
– Danitsu, Commented Nov 2, 2017 at 16:36
Add empty row at particular index without replacing row values use : df1 = pd.DataFrame(np.insert(df1.values, index+1, values=[" "] * len(df1.columns), axis=0),columns = df1.columns) — Anonymous
– Anonymous, Commented Feb 1, 2019 at 7:32

asterCraker · Accepted Answer · 2020-09-18 14:28:22Z

4

You can use startrow for this

writer = pd.ExcelWriter('demo.xlsx')
df.to_excel(writer, sheet_name='Concentrado',startrow=1, startcol= 1, encoding='utf-8')

answered Sep 18, 2020 at 14:28

asterCraker

715 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

MaxU - stand with Ukraine · Accepted Answer · 2017-11-02 16:23:10Z

1

Demo:

In [107]: df
Out[107]:
   a    b
0  a  zzz
1  b  yyy

In [108]: pd.DataFrame([[''] * len(df.columns)], columns=df.columns).append(df)
Out[108]:
   a    b
0
0  a  zzz
1  b  yyy

answered Nov 2, 2017 at 16:23

MaxU - stand with Ukraine

212k37 gold badges402 silver badges437 bronze badges

2 Comments

Danitsu Over a year ago

Thanks, i saw that answer on another post but i still got problems with that.

MaxU - stand with Ukraine Over a year ago

@Danitsu, what kind of problems?

Collectives™ on Stack Overflow

Add empty row in excel using python pandas

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related