pandas中文时间格式转换

   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.	%