Python Forum
Naming the file as time and date.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Naming the file as time and date.
#1
I have a script that scrapes web data then puts it into an excel file and names it "Results". I'm looking to get the file name to show the current time and date. I'm very new to learning to code and I've had a good go at it myself but I cant work it out without getting errors. Any help would be greatly appreciated.

markets = main("10932509, 7129730, 35, 37, 117, 81, 59, 55, 9404054")
#print(markets)

df = pd.DataFrame(markets)
df.to_excel('Results.xlsx')
Reply
#2
Have a look at the facilities provided by the datetime module: https://docs.python.org/3/library/datetime.html, specifically the datetime class and the following section: https://docs.python.org/3/library/datetime.html.

If you're having problems and getting errors, you need to show all the relevant code and the full traceback.
Reply
#3
You may look also at pandas.Timestamp.now

e.g. check

import pandas as pd
print(pd.Timestamp.now().strftime('%Y_%m_%d_%H_%M_%S'))
print(f"{pd.Timestamp.now().strftime('%Y_%m_%d_%H_%M_%S')}.xlsx")
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply
#4
Thanks for the feedback. I'll have a good read up and give it another go.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Compare current date on calendar with date format file name Fioravanti 1 129 Mar-26-2024, 08:23 AM
Last Post: Pedroski55
  Date Time Series Help...Please spra8560 2 314 Feb-01-2024, 01:38 PM
Last Post: spra8560
  Python date format changes to date & time 1418 4 518 Jan-20-2024, 04:45 AM
Last Post: 1418
  Downloading time zone aware files, getting wrong files(by date))s tester_V 9 961 Jul-23-2023, 08:32 AM
Last Post: deanhystad
  Formatting a date time string read from a csv file DosAtPython 5 1,162 Jun-19-2023, 02:12 PM
Last Post: DosAtPython
  naming entities(city abbreviations) tirumalaramakrishna 1 1,198 May-06-2022, 11:22 AM
Last Post: jefsummers
  Wait til a date and time KatManDEW 2 1,390 Mar-11-2022, 08:05 PM
Last Post: KatManDEW
  Date format and past date check function Turtle 5 4,079 Oct-22-2021, 09:45 PM
Last Post: deanhystad
  Python Style and Naming Variables rsherry8 3 2,171 Jun-07-2021, 09:30 PM
Last Post: deanhystad
  Check last time file was accessed Pavel_47 4 2,761 Jun-01-2021, 05:47 PM
Last Post: Yoriz

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020