pandas字符串转换日期,将字符串转成时间

1 .环境

python3，pandas

2 .问题

使用pandas包将数据从文件读取到dataframe数据结构。其中一个是时间。

该列的类型为Series，时间默认为字符串类型

3 .代码

导入pandas as PD

导入日期时间

input _ path=' d :/code/python code/data science/resources/data/xx.CSV '

df=PD.read_CSV(input_path ) )

打印(type ) df(time_block ) )、类型(df ) time_block ) )

time _ block=df [ ' time _ block ' ].head (

print('type(time_block ) )、type (time _ block ) )

打印(time _ block )。

for time_in in time_block:

print('type(time_in )='，type (time _ in ) )

print(time_in )是

time _ date=datetime.datetime.strp time (time _ in，' %Y-%m-%d %H:%M:%S ' )

打印(type ) time_date )、type ) time_date ) )

打印(time _ date )是

print('type(time_date.date ) )、type (time _ date.date ) ) )

print(time_date.date ) )

print('type(time_date.time ) )、type (time _ date.time ) ) )

print(time_date.time ) )

4 .结果

d :softdeveloperpyanacondapython.exed :/code/python code/data science/com/fanzs/demo/ttta

d :softdeveloperpyanacondalibsite-packagesstats modelscompatpandas.py :56565653333:

from pandas.core导入日期工具

type(df(time_block ) )=type (time _ block )=02017-05-14 0033600336000

1 2017-05-14 01:00:00

2 2017-05-14 02:00:00

3 2017-05-14 03:00:00

4 2017-05-14 04:00:00

Name: time_block，dtype: object

type(time_in )=2017-05-14 00:00:00

type(time_date ) 2017-05-14 00:00:00