python visual studio pandas_使用Python中的pandas和datatime从字符串中获取时间信息

我想你需要

dt.time：

print_time_range(train_likes_df.time.dt.time)

train_likes_df['time'] = pd.to_datetime(train_likes_df['time'], unit='s')

样品：

import pandas as pd

import io

temp=u"""user_id,item_id,channel,time

aa,bb,cc,1389733974

aa,bb,cc,1390459377"""

#after testing replace io.StringIO(temp) to filename

train_likes_df = pd.read_csv(io.StringIO(temp))

print (train_likes_df)

user_id item_id channel time

0 aa bb cc 1389733974

1 aa bb cc 1390459377

train_likes_df['time'] = pd.to_datetime(train_likes_df['time'], unit='s')

print (train_likes_df)

user_id item_id channel time

0 aa bb cc 2014-01-14 21:12:54

1 aa bb cc 2014-01-23 06:42:57

print (train_likes_df.time.dt.t