查找value + nan的行索引

Question

我有一个数据帧，下面一些行的所有值都是nan(例如第0,2行)。有些行有值和南． 我想找出有value的行的下标，value + nan。(即我想排除那些行，他们的所有值都是nan)。例如，在下面的数据帧中，我希望index = [1,3,4,5].

import pandas as pd
df1 = pd.DataFrame()
df1['val1']  = [np.nan, 100, np.nan, 30, 40, 1]
df1['val2']  = [np.nan, 30, np.nan, np.nan, -40,2]
df1['val3']  = [np.nan, 10, np.nan, 300, np.nan, 3]

Answer 1

Try with notna with any

out = df1.index[df1.notna().any(1)].tolist()
Out[341]: [1, 3, 4, 5]