Filter Pandas dataframe one column for only True boolean values?

Asked Sep 08 '22 at 13:07

Active Sep 08 '22 at 13:07

Viewed 12 times

When I run the following code: Pd_file[:]['raw_end_of_event'], I get:

0        False
1        False
2        False
3        False
4        False
         ...  
40508    False
40509    False
40510    False
40511    False
40512    False

Some of the rows are True, and I would like to filter for those rows. Any idea how I would achieve this, and let me know please if I have not given enough information.

asked Sep 08 '22 at 13:07

Patrick_Chong

Use `Pd_file[Pd_file['raw_end_of_event']]` – jezrael Sep 08 '22 at 13:08
It doesn't work- it returns all of the columns, with just the last row – Patrick_Chong Sep 08 '22 at 13:09
Syntax error... I don't get it. The column is called `raw_end_of_event` – Patrick_Chong Sep 08 '22 at 13:11
So need `Pd_file.loc[Pd_file['raw_end_of_event'], 'raw_end_of_event']` ? – jezrael Sep 08 '22 at 13:11
Okay, but I don't assign `True` anywhere?- I only want the rows with True – Patrick_Chong Sep 08 '22 at 13:12
If got only one row it means there is one `True`, check number of Trues by `print (Pd_file['raw_end_of_event'].sum())` – jezrael Sep 08 '22 at 13:12

Filter Pandas dataframe one column for only True boolean values?

0 Answers0