Breaking News: Grepper is joining You.com. Read the official announcement!

Python sort dataframe by list

Tough Tuatara answered on December 29, 2020 Popularity 9/10 Helpfulness 8/10

answer Python sort dataframe by list

related pandas sort by list

Python sort dataframe by list

Comment

# sorts the dataframe so resulting order of ColumnName matches order in list
df = df.set_index(ColumnName).reindex(list_to_sort_by).reset_index()

Popularity 9/10 Helpfulness 8/10 Language python

Source: stackoverflow.com

Tags: dataframe list python

Link to this answer
Share Copy Link

Contributed on Jun 06 2021

Tough Tuatara

0 Answers Avg Quality 2/10

Closely Related Answers

pandas sort by list

Comment

# Convert Tm-column to category and in set the sorter as categories hierarchy
# Youc could also do both lines in one just appending the cat.set_categories()
df.Tm = df.Tm.astype("category")
df.Tm.cat.set_categories(sorter, inplace=True)

print(df.Tm)
Out[48]: 
0    CHH
1    VAN
2    TOT
3    OKC
4    DAL
Name: Tm, dtype: category
Categories (38, object): [TOT < ATL < BOS < BRK ... UTA < VAN < WAS < WSB]

df.sort_values(["Tm"])  ## 'sort' changed to 'sort_values'
Out[49]: 
   Age   G           Player   Tm  Year     id
2   22  60      Ratko Varda  TOT  2001  13950
0   27   6    Cedric Hunter  CHH  1991   2967
4   31  81  Adrian Caldwell  DAL  1997   6169
3   34  52       Ryan Bowen  OKC  2009   6141
1   25   7    Maurice Baker  VAN  2004   5335

Popularity 9/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: list

Link to this answer
Share Copy Link

Contributed on Dec 29 2020

Fierce Fox

0 Answers Avg Quality 2/10

Python sort dataframe by list

Contents

More Related Answers

Python sort dataframe by list

Closely Related Answers

pandas sort by list

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.