python 3文字列転送日
2719 ワード
1.環境
python3、 pandas
2.質問
pandasパッケージを使用してファイルからdataframeデータ構造にデータを読み込み、そのうちの1列が時間です.
その列のタイプはSeriesで、時間のデフォルトは文字列タイプです.
3.コード
4.結果
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