Skip to main content
 首页 » 编程设计

python之将行中的代码应用到数据集 pandas

2024年11月01日9yjmyzz

  • 这是我手动写的:

    p = [[45.1024,7.7498],[45.1027,7.7513],[45.1072,7.7568],[45.1076,7.7563]] 
    q = [[45.0595,7.6829],[45.0595,7.6829],[45.0564,7.6820],[45.0533,7.6796],[45.0501,7.6775]] 
    
  • 为移除 NaN 执行此操作(非常适合我):

    p = np.array([i for i in p if np.any(np.isfinite(i))], np.float64) 
    q = np.array([i for i in q if np.any(np.isfinite(i))], np.float64) 
    

但是当涉及到数据集时:

    1           1.1     2           2.1     3           3.1     4           4.1     5           5.1 
0   43.1024     6.7498  NaN         NaN     NaN         NaN     NaN         NaN     NaN         NaN 
1   46.0595     1.6829  25.0695     3.7463  NaN         NaN     NaN         NaN     NaN         NaN 
2   25.0695     5.5454  44.9727     8.6660  41.9726     2.6666  84.9566     3.8484  44.9566     1.8484 
3   35.0281     7.7525  45.0322     3.7465  14.0369     3.7463  NaN         NaN     NaN         NaN 

我想用 df.iloc[0](第一行)执行上面相同的“NaN 删除”过程:

p = df.iloc[0] np.array([i for i in p if np.any(np.isfinite(i))], np.float64)

请您参考如下方法:

由于数组的长度不同,我认为我们只能使用 apply

df.apply(lambda x: np.array(x.dropna()), 1) 
#0                                    [43.1024, 6.7498] 
#1                   [46.0595, 1.6829, 25.0695, 3.7463] 
#2    [25.0695, 5.5454, 44.9727, 8.666, 41.9726, 2.6... 
#3    [35.0281, 7.7525, 45.0322, 3.7465, 14.0369, 3.... 
#dtype: object 

堆栈 + groupby.

当从宽到长时,堆叠会移除 NaN 值。这一次得到他们,然后只需选择一个你想要的。性能可能与上述相似或更差。

import numpy as np 
 
s = df.stack().groupby(level=0).apply(np.array) 
#0                                    [43.1024, 6.7498] 
#1                   [46.0595, 1.6829, 25.0695, 3.7463] 
#2    [25.0695, 5.5454, 44.9727, 8.666, 41.9726, 2.6... 
#3    [35.0281, 7.7525, 45.0322, 3.7465, 14.0369, 3.... 
#dtype: object 
 
s.iloc[0] 
#array([43.1024,  6.7498])