我有一个这样的数据帧。我需要将列所用时间的字符串从string转换为time或number以汇总此列。你知道吗
Date User Used time Used
31-07-19 Member (GTV1) 1Hour 1Minute 5083
31-07-19 Member (NHOKON) 4Minute 333
31-07-19 Member (GA) 42Minute 3500
31-07-19 Member (VIET125) 2Hour 32Minute 12667
31-07-19 Member (LUAN123) 40Minute 3333
31-07-19 Member (MMINH) 2Hour 47Minute 13917
31-07-19 Member (MMINH) 0Minute 0
31-07-19 Member (MMINH) 2Hour 11Minute 10917
31-07-19 Member (MMINH) 53Minute 4417
30-07-19 Member (KHANH00) 41Minute 3417
30-07-19 Member (CHIEN2) 1Hour 40Minute 8333
30-07-19 Member (CHIEN2) 9Minute 750
30-07-19 Guest 0Minute 2000
30-07-19 Member (DUYTQ111) 1Hour 3Minute 5250
29-07-19 Member (TRUNGTQ2) 42Minute 3500
29-07-19 Guest 1Hour 9Minute 7000
29-07-19 Member (MMINH) 2Hour 15Minute 11250
我的代码
T = df['Used time'].str.split(expand=True)
H = pd.to_numeric(T[0].str.replace('Hour',''))
M = round(pd.to_numeric(T[1].str.replace('Minute',''))/60, 1)
df['Used time'] = H + M
但这不适用于row只有分钟。请帮帮我
尝试使用
rpartition()
而不是split。你知道吗如果缺少小时,可以将
0Hour
添加到开头。你知道吗如何使用regex查找
Hour
的数字和Minute
的数字,将所有数字转换为分钟和sum
?你知道吗相关问题 更多 >
编程相关推荐