Python giving me datetime Value Error from CSV
I have one Python file that helps me pull and organize datetime data from a server into a pandas DataFrame, and then export out into a nice and usable CSV. My second Python script needs to read the CSV and analyze the data. If I do not touch the exported CSV, the analysis can read the CSV and runs smoothly. However, as soon as I try to merge a few CSV files together with Excel/other spreadsheet software, I get a datetime error
ValueError("time data %r does not match format %r" %
ValueError: time data '2019-12-26 23:00' does not match format '%Y-%m-%d %H:%M:%S'
Even though, it is a direct copy/paste and still saved as a CSV. Any guru can provide some insight on this matter?
Pretty sure this is an Excel issue, not a Python problem.
If you load a .csv that has timestamp strings into Excel, Excel recognizes the datetimes - and formats them. This format seems to default to MM.DD.YYYY hh:mm (the date component might be different depending on your locale):
If you save the file in Excel, the seconds are removed in the .csv!
The only procedure that seems to reliably prevent this behavior is to set a specific date/time format for the respective column, e.g. DD.MM.YYYY hh:mm:ss. AFAIK, You'll have to do this manually for each workbook
Or perhaps write a macro. In older Excel versions, I had a PERSONAL.XLSB for that; should still work with newer versions, you'll have to put it in
C:\Users\[username]\AppData\Roaming\Microsoft\Excel\XLSTARTyou can use .xlsx format instead of .csv, presumably you won't loose format information there
- Access the Alexa Shopping and To-Do Lists with Python3 request module
- How to change the button colors onclick event?
- hash method implementation not working along set() [Python]
- How can I make the layout of the interface fit other screen resolutions,?
- Python class function return super()
- Unable to import Pandas Profiling
- Django one of 2 fields must not be null
- problem with insert GIF in python(TKinter)?
- Pythonic way to hex dump files
- Error <Figure size 1000x600 with 1 Axes> even with plt.figure () before plt.plot
- On GitHub actions, "pip install playsound" failed with the "OSError: could not get source code" error
- Raspberry Pi (Python) - button press (and hold) to run a script loop
- how to create a venv with a different python version
- How does defining what a function will return work
- why does my python asyncio task report that it is done when it hasn't even been executed?
- django.db.utils.ProgrammingError: column "role" of relation "APP_profile" does not exist
- Python pip error "externally managed environment" after upgrading to Ubuntu 23.04
- Is there any way to catch and handle infinite recursive functions that create Tkinter windows?
- Why does casting a column with numeric Categorical datatype to an integer in Polars result in unexpected behavior?
- Cannot find play button on a web page in selenium using python
- Dynamically change one of f-string variables
- speed up my function about build bill of materials with pandas
- How to find values that can be found in other columns in polars quickly
- Teardown method from add_finalizer of PyTest fixture doesn't work
- How to pass variables during pytest call via python script(not command line)?
- Unit testcase with parameterized class fixture in Pytest framework is throwing error
- How to upload photo into main album at my community via vk_api
- Selenium (Python): No such driver version 115.0.5790.114 for mac-arm64
- How to use User Profile With SeleniumBase?
- Selenium undetected chromedriver with different chrome-versions?