Python - Get column name

Question

Dataframe I have Dataframe called "returns" that have time series (index) of returns for 10 sectors. How can I use for loops going through daily time series and find the name of sectors (column) that returns positive? I've tried this below, and was able to get positive returns, but what I need is the names of sectors.

for n in range(0,len(returns))
   pos_return = returns.iloc[n][returns.iloc[n]>0]

Here is what my data looks like.

kpie · Accepted Answer · 2022-01-20 19:47:10Z

1

you can use pos_return = returns.iloc[n][returns.iloc[n]>0].index which will return an Index object which can be cast to a list or whatever.

answered Jan 20, 2022 at 19:47

kpie

11.2k7 gold badges33 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

Python - Get column name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related