Getting only True values and their respective indices from a Pandas series

Question

I have a pandas series that looks like this, extracted on querying a dataframe.

t_loc= 312 False 231 True 324 True 286 False 123 False 340 True

I want only the indices that have 'True' boolean value.

I tried t_loc.index gives me all the indices. t_loc['True'] or t_loc[True] are both futile. Need help. Also, I need to update these locations with a single number if True. How can I update a column in a dataframe given the location numbers ?

Desired O/P: [231,324,340]

Need to update eg. df[col1] @ 231.. is it df[col1].loc[231] ? How to specify multiple locations? Can we pass the entire list since I need to update it with only one value for all the locations ?

Great !! Worked.. Thanks.. For the column update can I use df['col1'].loc[a] = 40 (The value I want to update) given a= t_loc.index[t_loc] — Sudarsana Shankar
– Sudarsana Shankar, Commented Aug 1, 2019 at 21:06

Mehdi Fekih · Accepted Answer · 2022-04-12 20:17:21Z

1

This actually works too :

t_loc.index[t_loc == True/False]

answered Apr 12, 2022 at 20:17

Mehdi Fekih

951 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Muhammad Dyas Yaskur · Accepted Answer · 2020-06-04 19:35:37Z

0

u can try this as well

t_loc.astype(int).index[t_loc == 1]

edited Jun 4, 2020 at 19:35

Muhammad Dyas Yaskur

8,35811 gold badges62 silver badges91 bronze badges

answered Jun 3, 2020 at 11:40

Aakash Raut

1

Collectives™ on Stack Overflow

Getting only True values and their respective indices from a Pandas series

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related