这是我手动写的:
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])
