Sort dataframe by multiple columns while ignoring case

Question

I want to sort a dataframe by multiple columns like this:

df.sort_values( by=[ 'A', 'B', 'C', 'D', 'E' ], inplace=True )

However i found out that python first sorts the uppercase values and then the lowercase.

I tried this:

df.sort_values( by=[ 'A', 'B', 'C', 'D', 'E' ], inplace=True, key=lambda x: x.str.lower() )

but i get this error:

TypeError: sort_values() got an unexpected keyword argument 'key'

If i could, i would turn all columns to lowercase but i want them as they are.

Any hints?

please create a [reproducible example with a desired output](https://stackoverflow.com/questions/20109391/how-to-make-good-reproducible-pandas-examples) and add in the question body to make it clear. — anky, Nov 04 '20 at 10:53

score 3 · Accepted Answer · answered Nov 04 '20 at 11:02

If check docs - DataFrame.sort_values for correct working need upgrade pandas higher like pandas 1.1.0:

key - callable, optional

Apply the key function to the values before sorting. This is similar to the key argument in the builtin sorted() function, with the notable difference that this key function should be vectorized. It should expect a Series and return a Series with the same shape as the input. It will be applied to each column in by independently.

New in version 1.1.0.

Sample:

df = pd.DataFrame({
        'A':list('MmMJJj'),
        'B':list('aYAbCc')
})
df.sort_values(by=[ 'A', 'B'], inplace=True, key=lambda x: x.str.lower())
print (df)
   A  B
3  J  b
4  J  C
5  j  c
0  M  a
2  M  A
1  m  Y

Sort dataframe by multiple columns while ignoring case

1 Answers1

Linked