Skip to main content
 首页 » 编程设计

python之如何按定义元素的长度将包含 NaN 的 Series 分成两部分

2025年02月15日10daizhj

我有一个 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