Excelの日付フォーマットを変換 CSV `format="%Y-%m-%d"` **CSV:** A 21-05-25 14:47:47 ** ():** A 21-05-25 **:** result, tz_parsed = tslib.array_to_datetime( File "pandas\_libs\tslib.pyx", line 352, in pandas._libs.tslib.array_to_datetime File "pandas\_libs\tslib.pyx", line 496, in pandas._libs.tslib.array_to_datetime ValueError: time data 21-05-25 14:47:27 doesn't match format specified **:** import pandas as pd with codecs.open(filename, "r", "Shift-JIS", "ignore") as file: df1 = pd.read_table(file, delimiter=",") df2=pd.to_datetime(df1['A'], format="%Y-%m-%d") print(df2)

`pandas.read_table()` `date_parser`


import pandas as pd
import codecs
from datetime import datetime as dt

with codecs.open(filename, "r", "Shift-JIS", "ignore") as file:
df2 = pd.read_table(
file, delimiter=",", parse_dates=['A'],
date_parser=lambda d: dt.strptime(d, '%y-%m-%d %H:%M:%S').date()
)
print(df2)