31-3月 -18 11.24.01.000000000 上午 格式转为标准时间格式
首先使用apply函数将“上午”、“下午”替换:(lambda x:str(x).replace('.000000000 上午',' AM'))
然后使用pd.to_datetime函数转化为时间格式 (data['col'], format="%d-%m月 -%y %I.%M.%S %p")
format参考https://www.dataindeendent.com/pandas/pandas-to-datetime/
Format Code | Description | Examples |
%a | Weekday, abbreviated | Mon, Tues, Sat |
%A | Weekday, full name | Monday, Tuesday, Saturday |
%w | Weekday, decimal. 0=Sunday | 1, 2, 6 |
%d | Day of month, zero-padded | 01, 02, 21 |
%b | Month, abbreviated | Jan, Feb, Sep |
%B | Month, full name | January, February, September |
%m | Month number, zero-padded | 01, 02, 09 |
%y | Year, without century, zero-padded | 02, 95, 99 |
%Y | Year, with century | 1990, 2020 |
%H | Hour (24 hour), zero padded | 01, 22 |
%I | Hour (12 hour) zero padded | 01, 12 |
%p | AM or PM | AM, PM |
%M | Minute, zero-padded | 01, 02, 43 |
%S | Second, zero padded | 01, 32, 59 |
%f | Microsecond, zero-padded | 000001, 000342, 999999 |
%z | UTC offset ±HHMM[SS[.ffffff]] | +0000, -1030, -3423.234 |
%Z | Time zone name | ITC, EST, CST |
%j | Day of year, zero-padded | 001, 365, 023 |
%U | Week # of year, zero-padded. Sunday first day of week | 00, 01, 51 |
%W | Week # of year, zero-padded. Monday first day of week | 00, 02, 51 |
%c | Appropriate date and time | Monday Feb 01 21:30:00 1990 |
%x | Appropriate Date | 02/01/90 |
%X | Appropriate Time | 21:22:00 |
%% | Literal '%' – Use this when you have a % sign in your format. | % |