Pandas sort by list

Python sort dataframe by list

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

Source: stackoverflow.com

Pandas sort by list

# 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

Source: stackoverflow.com

Similar codes

0 vote339 views1 answer
Pandas : stratification (mean)
Python
1 vote395 views1 answer
Django template tags capitalize
Python Django
1 vote372 views1 answer
Min max scaler sklearn
Python
0 vote425 views1 answer
Setting flask app environment variable
Python Flask
0 vote323 views1 answer
How to make bot commands case insensitive in discord.py
Python
0 vote330 views1 answer
Ajouter élément liste python
Python
1 vote371 views1 answer
Python markdown indent
Python
7 votes347 views1 answer
For loop with index python3
Python
3 votes379 views2 answers
Python selenium type in input
Python
0 vote385 views1 answer
I=int(input("enter the number")); sum=0; pro=1; while(i>0): d=1%10; if (d%2==0): sum=sum+d; else: pro=pro*d; i=i//10; print("sum=",sum,"product=",pro);
Python