How do I change file name that contains a date automatically in python

Question

I am trying to copy data from one excel file to another automatically using python, currently i have to manually update the date in the excel file name every morning. Is there a way to automatically update the date in the excel file name. I am very new to any form of programming, trying to learn to keep my job.

I have tried to use the time date function and declare this as a variable and copy this into code but no luck

import datetime

Filedate= (datetime.date.today()-datetime.timedelta(1))

exceldate= Filedate.strftime("%Y",)+Filedate.strftime("%m",)+Filedate.strftime("%d",)


import pyexcel as p

p.save_book_as(file_name="Q:\Valuations\Currency Options\YieldX Daily Statsexceldate.xls",#CHANGE DATE #manual entry. 
               dest_file_name='YieldX Daily Stats20190522.xlsx')#CHANGE DATE manual entry

You need to update only one file name or multiple? The program should by working in background? — Zaraki Kenpachi
– Zaraki Kenpachi, Commented May 31, 2019 at 6:09
Multiple. Yes it does work in the background I just click run using Jupyter and it runs files I only pasted the part of the code I am struggling with. Many thanks for the quick response — Muhammad Amod
– Muhammad Amod, Commented May 31, 2019 at 6:14

Zaraki Kenpachi · Accepted Answer · 2019-05-31 06:47:00Z

3

My approach is to split filename into part that contains date and the rest, then replace date with current one.

import os
import datetime
import re

# get xls files
xls_files = [file for file in os.listdir(os.getcwd()) if file.endswith('.xls')]

# get current date
now = datetime.datetime.now()

# change names
for item in xls_files:
    # split name and date part
    name_parts = item.split('.')
    get_date = re.findall('\d+-\d+-\d+', name_parts[0])
    name_string_part = name_parts[0].replace(get_date[0], '')
    # create new name
    new_name = name_string_part + str(now.day) + '-' + str(now.month) + '-' + str(now.year) + '_' + '.xls'
    # rename file
    os.rename(item, new_name)

answered May 31, 2019 at 6:47

Zaraki Kenpachi

5,7702 gold badges17 silver badges40 bronze badges

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

1 Comment

Muhammad Amod Over a year ago

Your code is also good may use it in another way. Thanks for the response I have being struggling for weeks with the issue

Vasu Deo.S · Accepted Answer · 2019-05-31 06:22:34Z

0

I believe what you are trying to do is, open a excel file everyday, and rename its filename to current date, where the previous excel file will have the date of yesterday.

import datetime
import pyexcel as p

yesterday = (datetime.date.today()-datetime.timedelta(1)).strftime("%Y%m%d")

today = datetime.date.today().strftime("%Y%m%d")

p.save_book_as(file_name="Q:\Valuations\Currency Options\YieldX Daily Stats" + yesterday + ".xls",
               dest_file_name='YieldX Daily Stats' + today + '.xlsx')

The above code, when executed will change the name of the .xls file which was created yesterday (with its Timestamp), to the current date.

Example:-

If a file named YieldX Daily Stats20190530.xls existed yesterday, today its name will be modified to YieldX Daily Stats20190531.xls

answered May 31, 2019 at 6:22

Vasu Deo.S

1,8701 gold badge13 silver badges26 bronze badges

1 Comment

Muhammad Amod Over a year ago

Thank you thank you, this code is applicable on some many other areas,

Collectives™ on Stack Overflow

How do I change file name that contains a date automatically in python

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related