Selecting multiple rows base on attributes in python jupyter notebook

Asked Aug 22 '18 at 11:08

Active Aug 22 '18 at 11:08

Viewed 14 times

df2 = df.loc[df['AustralianPort'] == 'Melbourne']

This syntax enables me to select one row, but how can I select multiple.

When I try df2 = df.loc[df['AustralianPort'] == 'Melbourne', 'Sydney', 'Brisbane','Adelaide', 'Perth']

It prompts me with an error.

Any thoughts on how to select multiple rows??

asked Aug 22 '18 at 11:08

JohnLovesMaths

1

Use `df2 = df.loc[df['AustralianPort'].isin(['Melbourne', 'Sydney', 'Brisbane','Adelaide', 'Perth'])]` – jezrael Aug 22 '18 at 11:10
1

thank you jezrael! – JohnLovesMaths Aug 22 '18 at 11:38

0 Answers0