我有一个由 6 列组成的 csv,第一列具有特定的日期格式,因此我需要将其转换为美国格式 YYYY-mm-dd
阅读 CSV 文件的内容后,我继续修改“日期”列,但不断收到以下错误
CSV
Gmt time,Open,High,Low,Close,Volume
01.01.2021 00:00:00.000,1.22174,1.22174,1.22174,1.22174,0
01.01.2021 01:00:00.000,1.22174,1.22174,1.22174,1.22174,0
01.01.2021 02:00:00.000,1.22174,1.22174,1.22174,1.22174,0
01.01.2021 03:00:00.000,1.22174,1.22174,1.22174,1.22174,0
01.01.2021 04:00:00.000,1.22174,1.22174,1.22174,1.22174,0
PYTHON
import pandas as pd
df = pd.read_csv('history/EURUSDhours.csv')
df.columns = [['date','open','high','low','close','volume']]
df.date= pd.to_datetime((df.date),format='%d.%m.%Y %H:%M:%S.%f')
print(df.head)
DTYPES
date object
open float64
high float64
low float64
close float64
volume int64
dtype: object
ERROR
Traceback (most recent call last):
File "eurusd.py", line 5, in <module>
df.date= pd.to_datetime((df.date),format='%d.%m.%Y %H:%M:%S.%f')
File "\venv\lib\site-packages\pandas\core\tools\datetimes.py", line 808, in to_datetime
result = _assemble_from_unit_mappings(arg, errors, tz)
File "\venv\lib\site-packages\pandas\core\tools\datetimes.py", line 899, in _assemble_from_unit_mappings
unit = {k: f(k) for k in arg.keys()}
File "\venv\lib\site-packages\pandas\core\tools\datetimes.py", line 899, in <dictcomp>
unit = {k: f(k) for k in arg.keys()}
File "\venv\lib\site-packages\pandas\core\tools\datetimes.py", line 894, in f
if value.lower() in _unit_map:
AttributeError: 'tuple' object has no attribute 'lower'