我想更改資料的日期格式，但它似乎不起作用。
這是我嘗試運行代碼時出現的錯誤“ValueError：時間資料'14.03.2022 00:00:00.000 GMT-0400'不匹配格式'%d.%m.%Y %H:% M:%S.%f %z' (匹配) "
這是我的代碼：
import pandas as pd
import numpy as np
from scipy.signal import argrelextrema
import matplotlib.pyplot as plt
# import our historical data
data = pd.read_csv('Data/EURUSD.csv')
data.columns = ['Date', 'open', 'high', 'low', 'close', 'volume']
data = data.drop_duplicates(keep=False)
data.Date = pd.to_datetime(data.Date, format='%d.%m.%Y %H:%M:%S.%f %z')
data = data.set_index(data.Date)
data = data['open','high','low','close','volume']
price = data.close.iloc[:100]
# find our relative extrema
max_idx = argrelextrema(price.values, np.greater, order=1)
min_idx = argrelextrema(price.values, np.less, order=1)
print(max_idx)
print(min_idx)
EURUSD.CSV
Local time,Open,High,Low,Close,Volume
14.03.2022 00:00:00.000 GMT-0400,1.09049,1.09177,1.09015,1.09175,6011.13
14.03.2022 01:00:00.000 GMT-0400,1.09175,1.09186,1.09089,1.09116,7262.199999999998
14.03.2022 02:00:00.000 GMT-0400,1.09114,1.09231,1.09093,1.09178,5828.28
14.03.2022 03:00:00.000 GMT-0400,1.09177,1.09407,1.09109,1.09320,12058.280000000004
14.03.2022 04:00:00.000 GMT-0400,1.09321,1.09601,1.09303,1.09567,14770.299999999996
uj5u.com熱心網友回復：
根據strtime.org %z是
格式為 ±HHMM[SS[.ffffff]] 的 UTC 偏移量（如果物件是幼稚的，則為空字串）。
所以顯然GMT-0400這不是有效的價值。
由于您已經在使用pandas，您可能根本不提供格式，這將導致pandas自動檢測它，請考慮以下示例
import pandas as pd
timestring = '14.03.2022 00:00:00.000 GMT-0400'
timestamp = pd.to_datetime(timestring)
print(timestamp)
輸出
2022-03-14 00:00:00 04:00
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/448654.html