python 3文字列転送日

2719 ワード

1.環境
python3、 pandas
2.質問
pandasパッケージを使用してファイルからdataframeデータ構造にデータを読み込み、そのうちの1列が時間です.
その列のタイプは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']) =  
 type(time_block) =  
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) =  
2017-05-14 00:00:00
 type(time_date)  
2017-05-14 00:00:00
 type(time_date.date()) =  
2017-05-14
 type(time_date.time()) =  
00:00:00
type(time_in) =  
2017-05-14 01:00:00
 type(time_date)  
2017-05-14 01:00:00
 type(time_date.date()) =  
2017-05-14
 type(time_date.time()) =  
01:00:00
type(time_in) =  
2017-05-14 02:00:00
 type(time_date)  
2017-05-14 02:00:00
 type(time_date.date()) =  
2017-05-14
 type(time_date.time()) =  
02:00:00
type(time_in) =  
2017-05-14 03:00:00
 type(time_date)  
2017-05-14 03:00:00
 type(time_date.date()) =  
2017-05-14
 type(time_date.time()) =  
03:00:00
type(time_in) =  
2017-05-14 04:00:00
 type(time_date)  
2017-05-14 04:00:00
 type(time_date.date()) =  
2017-05-14
 type(time_date.time()) =  
04:00:00

Process finished with exit code 0