pandas时间字符串格式

发表于 分类于 本文字数： 399 阅读时长 ≈ 1 分钟

时间字符串格式

ref: https://docs.python.org/3/library/datetime.html#strftime-and-strptime-format-codes

Directive Meaning Example
%a Weekday Sun, Mon, …, Sat (en_US)
%A Weekday full name. Sunday, Monday, …, Saturday (en_US)
%w Weekday as a decimal number, where 0 is Sunday . 0, 1, …, 6
%d Day of the month as a zero-padded decimal number. 01, 02, …, 31
%b Month as locale’s abbreviated name. Jan, Feb, …, Dec (en_US);
%B Month as locale’s full name. January, February, …, December (en_US);
%m Month as a zero-padded decimal number. 01, 02, …, 12
%y Year without century as a zero-padded decimal number. 00, 01, …, 99
%Y Year with century as a decimal number. 0001, 0002, …, 2013, 2014, …, 9998, 9999
%H Hour (24-hour clock) as a zero-padded decimal number. 00, 01, …, 23
%I Hour (12-hour clock) as a zero-padded decimal number. 01, 02, …, 12
%p Locale’s equivalent of either AM or PM. AM, PM (en_US);
%M Minute as a zero-padded decimal number. 00, 01, …, 59
%S Second as a zero-padded decimal number. 00, 01, …, 59
%f Microsecond as a decimal number, zero-padded to 6 digits. 000000, 000001, …, 999999
%z UTC offset in the form ±HHMM[SS[.ffffff]] (empty), +0000, -0400, +1030, +063415, -030712.345216
%Z Time zone name (empty string if the object is naive). (empty), UTC, GMT
%j Day of the year as a zero-padded decimal number. 001, 002, …, 366
%U Week number of the year (Sunday as the first day) 00, 01, …, 53
%W Week number of the year (Monday as the first day) 00, 01, …, 53
%c Locale’s appropriate date and time representation. Tue Aug 16 21:30:00 1988 (en_US);
%x Locale’s appropriate date representation. 08/16/88 (None);
%X Locale’s appropriate time representation. 21:30:00 (en_US);
%% A literal ‘%’ character. % 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
# === 1. 获取当前时间，返回指定的字符串 ===
import time 
now = time.strftime('%Y-%m-%d %H:%M:%S')

print(now)

from datetime import datetime
now = datetime.now().strftime('%Y-%m-%d %a %H:%M:%S')

print(now)


# === 2. 将时间字符串， 转化为时间对象 ===

from datetime import datetime
dt = datetime.strptime('2023-01-01 12:00:00', '%Y-%m-%d %H:%M:%S')

import pandas as pd
pd_dt = pd.to_datetime('2023-01-01 12:00', format='%Y-%m-%d %H:%M')

print(dt)
print(pd_dt)