Saving pandas excel dataframe with dynamic filename

Question

I am trying to save a dataframe to Excel and unfortunately I am not getting around the Syntax. I want to save the file to a path and Name it by today date.

df.to_excel(r'\\folderA\folderB\Dokumente\'',today.strftime("%d%m%Y")+'delmedf.xlsx')

Am I doing something wrong with the quote signs?

You can try change , to + like df.to_excel(r'\\folderA\folderB\Dokumente\' + today.strftime("%d%m%Y")+'delmedf.xlsx'), because you concanecate strings. — jezrael
– jezrael, Commented Feb 25, 2016 at 11:21
this works now, but I am getting a ' in front of the filename. '25022016delmedf.xlsx — Markus W
– Markus W, Commented Feb 25, 2016 at 11:23
Try remove one ' in the end of '\\folderA\folderB\Dokumente\' — jezrael
– jezrael, Commented Feb 25, 2016 at 11:25
please check df.to_excel(r'\\folderA\folderB\Dokumente\'' + dt.datetime.today().strftime("%d%m%Y")+'delmedf.xlsx') — jezrael
– jezrael, Commented Feb 25, 2016 at 11:33

jezrael · Accepted Answer · 2016-02-25 11:40:41Z

4

I think you can try add () to today and + before:

import datetime as dt

print dt.datetime.today().strftime("%d%m%Y")
25022016

df.to_excel(r'\\folderA\folderB\Dokumente\\' + dt.datetime.today().strftime("%d%m%Y")+'delmedf.xlsx')

edited Feb 25, 2016 at 11:40

answered Feb 25, 2016 at 11:32

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

4 Comments

Markus W Over a year ago

I Keep getting the ` '` in front of the filename. '25022016delmedf.xlsx. I am not sure if this is some problem of how to set the backslashes and quotations?

jezrael Over a year ago

Yes, I see it - try modified solution.

Markus W Over a year ago

awesome! This is working now. Thanks a lot. The Setting of this backslashes is really a bit odd...

jezrael Over a year ago

And maybe I found better solution df.to_excel(r'\\folderA\folderB\Dokumente' + '\\' + dt.datetime.today().strftime("%d%m%Y")+'delmedf.xlsx')

Collectives™ on Stack Overflow

Saving pandas excel dataframe with dynamic filename

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related