Python PANAS查询DataFrame列列表值是否有任何项为空

发布于11月21日

我有一个下面这样的数据框

               name            ...                         agg_data
787                 418 Media  ...                        [0.37]
799         A3 Artists Agency  ...                        [0.85]
801         A3 Artists Agency  ...                        [0.08]
808         A3 Artists Agency  ...                        [0.13]
811         A3 Artists Agency  ...                        [0.55]
...                       ...  ...                           ...
7028  Young and Profiting LLC  ...                        [0.35]
7031  Young and Profiting LLC  ...                        [0.07]
7032  Young and Profiting LLC  ...                        [0.06]
7035  Young and Profiting LLC  ...                        [0.33]
7040                Zaddy Inc  ...                        [0.15]

AGG_DATA列的值可能类似于[0.15,null]

我想查询VAL的长度为2，但长度为空

我试着像

 condition = lambda x:  any(val == '' or val is None for val in x) and len(x) == 2 

 condition = (result['agg_data'].isnull().any() &
               (len(result['agg_data'] == 2))

但它不起作用

有什么帮助吗谢谢

推荐答案

对pandas.isna和any使用列表解析，或者创建helper DataFrame并对DataFrame.isna和DataFrame.any进行测试:

result = pd.DataFrame({'agg_data':[[0.37], [4,None, 7], [7, None], [None, 8]]})
print (result)
       agg_data
0        [0.37]
1  [4, None, 7]
2     [7, None]
3     [None, 8]

condition = (result['agg_data'].str.len().eq(2) & 
             [any(pd.isna(y) for y in x) for x in result['agg_data']])
print (condition)
0    False
1    False
2     True
3     True
Name: agg_data, dtype: bool

condition = (result['agg_data'].str.len().eq(2) & 
             pd.DataFrame(result['agg_data'].to_list(), 
                          index=result.index).isna().any(axis=1))
print (condition)
0    False
1    False
2     True
3     True
Name: agg_data, dtype: bool