Pandas dataframe only select the columns that have all True

Question

Given a dataframe df, I need to select the columns that have only True values
df = 
      A      B      C       D       E
    True    False   True   False   True

Output should be
output = [A, C, E]

ericl16384 · Answer

Try iterating through it and putting the keys in a list (you can easily modify this to result in a dict, though).
result = []
for i in df.keys():
    if df[i].all():
        result.append(i)

Quang Hoang · Answer

Try boolean indexing with all (for only True values):
df.columns[df.all()]

Output:
Index(['A', 'C', 'E'], dtype='object')

Pandas dataframe only select the columns that have all True

2 Answers

Add your own answers!

Ask a Question