如何将字符串范围转换为平均值的float或int dtype ?

Question

我有这样的数据:

datetime      range 
2022-10-10    50-54
2022-10-12    30-36

range是对象dtype。

如何到达:

datetime      range   mean 
2022-10-10    50-54    52.0
2022-10-12    30-36    33.0

Answer 1

您可以在-上split字符串，然后转换为整数并获得每行mean:

df['mean'] = df['range'].str.split('-', expand=True).astype(int).mean(axis=1)

或者使用numpy:

import numpy as np
df['mean'] = np.loadtxt(df['range'], delimiter='-').mean(axis=1)

输出:

datetime  range  mean
0  2022-10-10  50-54  52.0
1  2022-10-12  30-36  33.0