How to rearrange rows with multiple columns in python dataframe [duplicate]

Question

I have the following dataset:

Name Year  Date Value
x    year1 date1 v1
x    year1 date2 v2
x    year1 date3 v3
x    year2 date1 v4
x    year2 date2 v5
x    year2 date3 v6
z    year1 date1 v7
z    year1 date2 v8
z    year1 date3 v9
z    year2 date1 v10
z    year2 date2 v11
z    year2 date3 v12
y    year1 date1 v13
y    year1 date2 v14
y    year1 date3 v15
y    year2 date1 v16
y    year2 date2 v17
y    year2 date3 v18

I would like the following dataset output:

Name Year  Date Value
x    year1 date1 v1
x    year2 date1 v4
x    year1 date2 v2
x    year2 date2 v5
x    year1 date3 v3
x    year2 date3 v6
z    year1 date1 v7
z    year2 date1 v10
z    year1 date2 v8
z    year2 date2 v11
z    year1 date3 v9
z    year2 date3 v12
y    year1 date1 v13
y    year2 date1 v16
y    year1 date2 v14
y    year2 date2 v17
y    year1 date3 v15
y    year2 date3 v18

I tried the following code but my 'Name' column is sorting the x,y,z as well. I want the 'Name' column order to stay as x,z,y: df.sort_values(['Name', 'Date'])

Harsha Biyani · Accepted Answer · 2022-07-13 04:43:17Z

1

As per my understanding, you want data to be sort first by Name and then by Date.

So, you can try:

df.sort_values(by = ['Name', 'Date'], ascending = [True, True])

answered Jul 13, 2022 at 4:43

Harsha Biyani

7,28810 gold badges42 silver badges64 bronze badges

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

Comments

keramat · Accepted Answer · 2022-07-13 04:46:38Z

0

Use:

df.sort_values(['Name', 'Date'])

Output:

    Name    Year    Date    Value
0   x   year1   date1   v1
3   x   year2   date1   v4
1   x   year1   date2   v2
4   x   year2   date2   v5
2   x   year1   date3   v3
5   x   year2   date3   v6
6   y   year1   date1   v7
9   y   year2   date1   v10
7   y   year1   date2   v8
10  y   year2   date2   v11
8   y   year1   date3   v9
11  y   year2   date3   v12

answered Jul 13, 2022 at 4:46

keramat

4,6138 gold badges29 silver badges42 bronze badges

Collectives™ on Stack Overflow

How to rearrange rows with multiple columns in python dataframe [duplicate]

2 Answers 2

Comments

Comments

Hot Network Questions