python - 如何将 pandas 数据帧的对象值转换为小时数？

Question

我有这个数据框

number_of_hrs  number_of_pts
65             1
7              1
31             1
6 DAY          1
23             1
21             1
5.0            1

我想将“6 DAY”之类的值转换为小时数。这可能吗？

Answer 1

使用pd.eval与 Series.str.replace .

df['number_of_hrs'] = pd.eval(df['number_of_hrs'].str.replace('DAY','*24'))
print(df)
#  number_of_hrs  number_of_pts
#0            65              1
#1             7              1
#2            31              1
#3           144              1
#4            23              1
#5            21              1
#6             5              1

或

from ast import literal_eval
df['number_of_hrs'] = df['number_of_hrs'].str.replace('DAY','*24').apply(literal_eval)
#Alternative
#df['number_of_hrs'] = [literal_eval(s) for s in df['number_of_hrs'].str.replace('DAY','*24')]