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
  Downloading time zone aware files, getting wrong files(by date))s tester_V 9 513 Jul-23-2023, 08:32 AM
Last Post: deanhystad
  Formatting a date time string read from a csv file DosAtPython 5 516 Jun-19-2023, 02:12 PM
Last Post: DosAtPython
  naming entities(city abbreviations) tirumalaramakrishna 1 891 May-06-2022, 11:22 AM
Last Post: jefsummers
  Wait til a date and time KatManDEW 2 1,115 Mar-11-2022, 08:05 PM
Last Post: KatManDEW
  Date format and past date check function Turtle 5 2,803 Oct-22-2021, 09:45 PM
Last Post: deanhystad
  Python Style and Naming Variables rsherry8 3 1,861 Jun-07-2021, 09:30 PM
Last Post: deanhystad
  Check last time file was accessed Pavel_47 4 2,393 Jun-01-2021, 05:47 PM
Last Post: Yoriz
  find the header location in a .bin file without reading the whole file at a time SANJIB 0 1,933 Mar-05-2021, 04:08 PM
Last Post: SANJIB
  How to add previous date infront of every unique customer id's invoice date ur_enegmatic 1 1,906 Feb-06-2021, 10:48 PM
Last Post: eddywinch82
  Update Date based on Time/String stevezemlicka 1 1,777 Jan-08-2021, 06:54 PM
Last Post: Gribouillis

Forum Jump:

User Panel Messages

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