How to filter and select multiple columns in pandas

Question

I can't select and filter multiple columns together in Pandas. 'Name' and 'Year of Rank' are column names. Thank you!

dw[dw.Name=='El Toro' & dw['Name', 'Year of Rank']]

This is literally the first thing you learn when reading about [pandas selecting](https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html) . Try the docs in the beginning, it's likely that will be very helpful — rafaelc, Feb 14 '20 at 16:35

Adam B. · Answer 1 · 2020-02-14T16:34:57.617

4

I believe this is what you want:

dw[dw['Name'] == 'El Toro'][['Name','Year of Rank']]

or alternatively:

dw.loc[ dw['Name'] == 'El Toro', ['Name','Year of Rank']]

Edit: As pointed out in the comments, the second one is much preferred as it deals with the filtering and selection as a single entity.

edited Feb 14 '20 at 16:34

answered Feb 14 '20 at 16:23

Adam B.

192
10

2

the first one isn't [recommended](https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#indexing-view-versus-copy) – anky Feb 14 '20 at 16:28
Awesome, yes, it worked but still do not understand how it works. – Alper Feb 14 '20 at 16:29
Indeed @AlperAtakan, thanks for pointing it out! – Adam B. Feb 14 '20 at 16:35

score 0 · Answer 2 · edited Feb 14 '20 at 16:31

0

import pandas as pd

dw = pd.DataFrame([
  {'Name': 'A', 'Year of Rank':1992, 'Rank': 1},
  {'Name': 'El Toro', 'Year of Rank':1993, 'Rank': 2},
  {'Name': 'C', 'Year of Rank':1994, 'Rank': 3}])

dw[dw.Name == 'El Toro'][['Name', 'Year of Rank']]

Like this?

Next time you try provide more context like a dummy dataframe.

edited Feb 14 '20 at 16:31

anky

74,114
11
41
70

answered Feb 14 '20 at 16:29

debugme

1,041
1
10
22

score 0 · Answer 3 · answered Feb 14 '20 at 16:35

0

The following code should work:

dw[dw['Name'] == 'El Toro'][['Name','Year of Rank']]

answered Feb 14 '20 at 16:35

Xpie

43
6

How to filter and select multiple columns in pandas

3 Answers3