发生这个错误说明你使用了错误的格式。正确的可选格式如下:
-
%A
:返回星期的英文
示例:import pandas as pd data = pd.DataFrame([['2019-1-5'], ['2020-9-6']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%A') print(data)
输出:
-
%a
返回星期的英文缩写
示例:import pandas as pd data = pd.DataFrame([['2019-1-5'], ['2020-9-6']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%a') print(data)
输出:
-
%B
返回月份的英文
示例:import pandas as pd data = pd.DataFrame([['2019-1-5'], ['2020-9-6']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%B') print(data)
输出:
-
%b
返回月份的英文缩写
示例:import pandas as pd data = pd.DataFrame([['2019-1-5'], ['2020-9-6']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%b') print(data)
输出:
-
%c
返回日期+时间的字符串
示例:import pandas as pd data = pd.DataFrame([['2019-1-5'], ['2020-9-6']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%c') print(data)
输出:
-
%d
返回当前时间是当月第几天
示例:import pandas as pd data = pd.DataFrame([['2019-1-5'], ['2020-9-6']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%d') print(data)
输出:
-
%I
以12小时制表示当前小时
示例:import pandas as pd data = pd.DataFrame([['2019-1-5 19:23:7'], ['2020-9-6 8:00:49']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%I') print(data)
输出:
-
%H
以24小时制表示当前小时
示例:import pandas as pd data = pd.DataFrame([['2019-1-5 19:23:7'], ['2020-9-6 8:00:49']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%H') print(data)
输出:
-
%j
返回当天是当年第几天
示例:import pandas as pd data = pd.DataFrame([['2019-1-5 19:23:7'], ['2020-9-6 8:00:49']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%j') print(data)
输出:
-
%m
返回月份数字
示例:import pandas as pd data = pd.DataFrame([['2019-1-5 19:23:7'], ['2020-9-6 8:00:49']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%m') print(data)
输出:
-
%M
返回分钟
示例:import pandas as pd data = pd.DataFrame([['2019-1-5 19:23:7'], ['2020-9-6 8:00:49']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%M') print(data)
输出:
-
%p
返回上/下午
示例:import pandas as pd data = pd.DataFrame([['2019-1-5 19:23:7'], ['2020-9-6 8:00:49']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%p') print(data)
输出:
-
%S
返回秒数
示例:import pandas as pd data = pd.DataFrame([['2019-1-5 19:23:7'], ['2020-9-6 8:00:49']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%S') print(data)
输出:
-
%U
返回当周是当年的第几周(以周日为第一天)
示例:import pandas as pd data = pd.DataFrame([['2019-1-5 19:23:7'], ['2020-9-6 8:00:49']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%U') print(data)
输出:
-
%W
返回当周是当年的第几周(以周一为第一天)
示例:import pandas as pd data = pd.DataFrame([['2019-1-5 19:23:7'], ['2020-9-6 8:00:49']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%W') print(data)
输出:
-
%w
返回当天在当周的天数
示例:import pandas as pd data = pd.DataFrame([['2019-1-5 19:23:7'], ['2020-9-6 8:00:49']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%w') print(data)
输出:
-
%x
日期字符串
示例:import pandas as pd data = pd.DataFrame([['2019-1-5 19:23:7'], ['2020-9-6 8:00:49']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%x') print(data)
输出:
-
%X
时间字符串(如9:0:0)
示例:import pandas as pd data = pd.DataFrame([['2019-1-5 19:23:7'], ['2020-9-6 8:00:49']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%X') print(data)
输出:
-
%y
年份末两位
示例:import pandas as pd data = pd.DataFrame([['2019-1-5 19:23:7'], ['2020-9-6 8:00:49']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%y') print(data)
输出:
-
%Y
年份
示例:import pandas as pd data = pd.DataFrame([['2019-1-5 19:23:7'], ['2020-9-6 8:00:49']], columns=['Date']) print(data) print('\n') data['Date'] = pd.to_datetime(data['Date']) # 将指定列转为datetime对象 data['Date'] = data.Date.dt.strftime('%Y') print(data)
输出: