Sorting dataframe by two columns in Python

Question

I'm getting the following error from the code below:

***File "<ipython-input-61-517e344a129d>", line 1
    df.sort_values(by "Script Count", "Drug Name"), axis=0, ascending=True, inplace=False, kind='quicksort',
                                   ^
SyntaxError: invalid syntax*** (the carrot is pointing to the second " following "Script Count")

Code:

import pandas as pd

import numpy as np

df = pd.read_csv('/Users/rmartin/Desktop/DE_Highmark.csv')

df.sort_values(by "Script Count", "Drug Name"), axis=0, ascending=True, inplace=False, kind='quicksort', na_position='last')

I know this must be super simple, but I've driven myself crazy trying to figure it out. I'm trying to sort the dataframe based on the "Script Count" and "Drug Name" columns from a dataframe. The CSV was successfully imported as a dataframe, but the sort function is giving me trouble.

Try df.sort_values(by = [ "Script Count", "Drug Name"], axis=0, ascending=True, inplace=False, kind='quicksort', na_position='last') — Vaishali
– Vaishali, Commented May 30, 2017 at 19:32

Marcel · Accepted Answer · 2017-05-31 12:03:04Z

2

Refering to the docs, the right syntax is:

 DataFrame.sort_values(by, axis=0, ascending=True, inplace=False, kind='quicksort', na_position='last')

so in your case, it should be:

df.sort_values(by=[ "Script Count", "Drug Name"], ascending=[True,True])

edited May 31, 2017 at 12:03

user2285236

answered May 30, 2017 at 19:46

Marcel

2,8041 gold badge27 silver badges40 bronze badges

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

1 Comment

Scott Boston Over a year ago

Let's get the current version docs. pandas.pydata.org/pandas-docs/stable/generated/…

Collectives™ on Stack Overflow

Sorting dataframe by two columns in Python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related