How to sort rows by group in dataframe

Question

Assume that I have a dataframe as below

Name Language
Tom  Japanese
Rose Japanese
……
Jack Chinese
Jack Japanese
Mike Japanese
Mike French

I want to leave the people who only speak Japanese but not speak others by checking the language column and get the output like:

Name Language
Tom  Japanese
Rose Japanese

Jack and Mike speak 2 languages so I only want to keep Tom and Rose.

`df.query('Language == "Japanese"')` – mozway Sep 24 '21 at 13:39 — mozway, Sep 24 '21 at 13:39

score 1 · Answer 1 · answered Sep 24 '21 at 13:45

1

Assuming your dataframe is called df. The following code will set the df equal to where the Language column equals Japanese.

df = df[df['Language'] == 'Japanese']

answered Sep 24 '21 at 13:45

Brian

1 Answers1