您可以使用带格式字符串的to_datetime()来提取日期:date = pd.to_datetime(df.Start_Time, format=’%Y, %m, %d’).dt.date
也可以修改在位日期:
^{pr2}$
或者,您可以在读取csv时将其转换为日期:to_date = lambda x: pd.to_datetime(x, format=’%Y, %m, %d’).date()
converters = dict(Start_Time=to_date, End_Time=to_date)
df = pd.read_csv(StringIO(data), converters=converters)
一个可测试的例子:import pandas as pd
from io import StringIO
data = u”””
Day_Part,Start_Time,End_Time
“Quarter 1″,”2014, 1, 1″,”2015, 3, 1”
“Quarter 2″,”2014, 3, 3″,”2014, 7, 3”
“””
df = pd.read_csv(StringIO(data))
You can use to_datetime()
with a format string to extract the date:
date = pd.to_datetime(df.Start_Time, format=’%Y,
Original: https://blog.csdn.net/weixin_28868483/article/details/114387942
Author: Duyb
Title: python list和series转换dataframe_Python:将dataframe列从Series转换为Datetime datatype
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/753796/
转载文章受原作者版权保护。转载请注明原作者出处!