python3 字符串转日期

1. 环境

python3、 pandas

2. 问题

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

那一列为的类型为Series,  时间默认为字符串类型

3. 代码

import pandas as pd
import datetime

INPUT_PATH = "D:/Code/pythonCode/dataScience/resources/data/xx.csv"


df = pd.read_csv(INPUT_PATH)

print(" type(df['time_block']) = ", type(df['time_block']))
time_block = df['time_block'].head()

print(" type(time_block) = ", type(time_block))
print(time_block)

for time_in in time_block:
    print("type(time_in) = ", type(time_in))
    print(time_in)
    time_date = datetime.datetime.strptime(time_in, "%Y-%m-%d %H:%M:%S")
    print(" type(time_date) ", type(time_date))
    print(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:\Soft\Developer\py\anaconda\python.exe D:/Code/pythonCode/dataScience/com/fanzs/demo/test.py
D:\Soft\Developer\py\anaconda\lib\site-packages\statsmodels\compat\pandas.py:56: FutureWarning: The pandas.core.datetools module is deprecated and will be removed in a future version. Please use the pandas.tseries module instead.
  from pandas.core import datetools
 type(df['time_block']) =  <class 'pandas.core.series.Series'>
 type(time_block) =  <class 'pandas.core.series.Series'>
0    2017-05-14 00:00:00
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) =  <class 'str'>
2017-05-14 00:00:00
 type(time_date)  <class 'datetime.datetime'>
2017-05-14 00:00:00
 type(time_date.date()) =  <class 'datetime.date'>
2017-05-14
 type(time_date.time()) =  <class 'datetime.time'>
00:00:00
type(time_in) =  <class 'str'>
2017-05-14 01:00:00
 type(time_date)  <class 'datetime.datetime'>
2017-05-14 01:00:00
 type(time_date.date()) =  <class 'datetime.date'>
2017-05-14
 type(time_date.time()) =  <class 'datetime.time'>
01:00:00
type(time_in) =  <class 'str'>
2017-05-14 02:00:00
 type(time_date)  <class 'datetime.datetime'>
2017-05-14 02:00:00
 type(time_date.date()) =  <class 'datetime.date'>
2017-05-14
 type(time_date.time()) =  <class 'datetime.time'>
02:00:00
type(time_in) =  <class 'str'>
2017-05-14 03:00:00
 type(time_date)  <class 'datetime.datetime'>
2017-05-14 03:00:00
 type(time_date.date()) =  <class 'datetime.date'>
2017-05-14
 type(time_date.time()) =  <class 'datetime.time'>
03:00:00
type(time_in) =  <class 'str'>
2017-05-14 04:00:00
 type(time_date)  <class 'datetime.datetime'>
2017-05-14 04:00:00
 type(time_date.date()) =  <class 'datetime.date'>
2017-05-14
 type(time_date.time()) =  <class 'datetime.time'>
04:00:00

Process finished with exit code 0