python list和series转换dataframe_Python:将dataframe列从Series转换为Datetime datatype

您可以使用带格式字符串的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/

转载文章受原作者版权保护。转载请注明原作者出处!

(0)

大家都在看

亲爱的 Coder【最近整理,可免费获取】👉 最新必读书单  | 👏 面试题下载  | 🌎 免费的AI知识星球