我有一个 Series 对象:
0 1211.0
1 2214.0
2 1317.0
3 NaN
4 NaN
5 812.0
Name: Time, Length: 6, dtype: float64
我想从中得到两个独立的系列:
0 12
1 22
2 13
3 NaN
4 NaN
5 8
Name: Hours, Length: 6, dtype: float64
0 11
1 14
2 17
3 NaN
4 NaN
5 12
Name: Minutes, Length: 6, dtype: float64
我定义了两个函数:
def hours(col):
hours = str(int(col)).strip()[:-2]
return hours
def minutes(col):
minutes = str(int(col)).strip()[-2:]
return minutes
我曾想过这样的事情,但由于 NaNs 而行不通:
hours = Time.apply(hours)
minutes = Time.apply(minutes)
我应该怎么做才能让这个功能按照我希望的方式工作?
请您参考如下方法:
一种方法是使用一些数学 -
series1, series2 = s//100, s-100*(s//100)
series1.name = 'Hours'
series2.name = 'Minutes'
sample 运行-
In [424]: s # input series
Out[424]:
0 1211.0
1 2214.0
2 1317.0
3 NaN
4 NaN
5 812.0
Name: Time, dtype: float64
In [425]: series1, series2 = s//100, s-100*(s//100)
...: series1.name = 'Hours'
...: series2.name = 'Minutes'
...:
In [426]: series1
Out[426]:
0 12.0
1 22.0
2 13.0
3 NaN
4 NaN
5 8.0
Name: Hours, dtype: float64
In [427]: series2
Out[427]:
0 11.0
1 14.0
2 17.0
3 NaN
4 NaN
5 12.0
Name: Minutes, dtype: float64
