How to reverse range value in dataframe pandas

Question

hello everything is working fine but i gave custom range so now it is showing 10,9,8,7,6...1 , i want it from 1,2,3,4,5..10 , i am new to pandas so please help me out

data = pd.DataFrame(pd.read_csv("data.csv")
ConditionData = data.loc[:,['Country/Region','Confirmed']].sort_values(by="Confirmed",ascending=False).head(10)
ConditionData.index = range(10, 0, -1)
print(ConditionData)


    Country/Region  Confirmed
10              US    4290259
9           Brazil    2442375
8            India    1480073
7           Russia     816680
6     South Africa     452529
5           Mexico     395489
4             Peru     389717
3            Chile     347923
2   United Kingdom     301708
1             Iran     293606

somebody please help me

mozway · Accepted Answer · 2021-09-07 03:46:29Z

2

You can reset_index and add 1. This way you do not need to care about the number of rows:

ConditionData = ConditionData.reset_index(drop=True)
ConditionData.index += 1

NB. Indexing in python starts from 0, so unless you have a particular need for starting from 1, you might leave it as a zero based range

answered Sep 7, 2021 at 3:46

mozway

267k13 gold badges56 silver badges106 bronze badges

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

Comments

U13-Forward · Accepted Answer · 2021-09-07 03:07:00Z

0

Do you mean by...

ConditionData.index = range(1, 11)

Or reverse it with:

ConditionData.index = list(range(10, 0, -1))[::-1]

answered Sep 7, 2021 at 3:07

U13-Forward

71.8k15 gold badges100 silver badges125 bronze badges

Collectives™ on Stack Overflow

How to reverse range value in dataframe pandas

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related