CODEWITHSUNDEEP
pythonpandasdataframe
Tikhon
Tikhon

Reputation: 451

Pandas best practice: remove column names?

I'm sorting a dataframe containing stock capitalisations from largest to smallest row-wise (I will compute the ratio of top 10 stocks vs the whole market as a proxy for concentration).

f = lambda x: pd.Series(x.sort_values(ascending=False, na_position='last').to_numpy(), index=stock_mv.columns)
stock_mv = stock_mv.apply(f, axis=1)

When I do this, however, the column names (tickers) no longer make sense. I read somewhere that you shouldn't delete column names or have them set to the same thing.

What is the best practice thing to do in this situation?

Thank you very much - I am very much a novice coder.

Upvotes: 0

Views: 191

Answers (1)

ashkangh
ashkangh

Reputation: 1624

If I understand your problem right, you want to sort a dataframe row-wise. If that's the case, Try this:

stock_mv = stock_mv.sort_values(axis=1, ascending=False)

Upvotes: 1

Related Questions