Reindex dataframe based on column values using Pandas

Asked May 31 '23 at 00:25

Active May 31 '23 at 04:22

Viewed 47 times

Data

ID  Q1  Q2  Q3
AA  1   2   4
BB  5   5   5
CC  6   7   7

Desired

ID  Q1  Q2  Q3
BB  5   5   5
CC  6   7   7
AA  1   2   4

Doing

df = pd.DataFrame(df, index = ["BB","CC","AA"])

This is simply adding the row name, I wish to rea arrange row order based on name. Any suggestion is appreciated.

edited May 31 '23 at 01:14

Ynjxsjmh

asked May 31 '23 at 00:25

Lynn

What's the arrange logic? – Ynjxsjmh May 31 '23 at 01:16
No Particular arrange logic, just looking to see if it is possible to reindex based on column values and not the row number @Ynjxsjmh – Lynn May 31 '23 at 01:55
Suppose `df` is DataFrame. reindex by `df.reindex(["BB","CC","AA"])` is that right? – Nguyen May 31 '23 at 02:59
I’ll try this , not sure if I can actually rearrange using values unless using loc. l try thanks @Nguyen – Lynn May 31 '23 at 03:53

0 Answers0