Conditional Select on a dataframe column

Question

Hi I am wondering how conditional select on a pandas column works. In the Below code

In [162]: euro16
Out[162]: {'Goals': [16, 8], 'Team': ['Germany', 'England']}

In [163]: euro16_df = pd.DataFrame(euro16)

In [164]: euro16_df[euro16_df.Team == 'Germany']
Out[164]:
   Goals     Team
0     16  Germany

However when you try a conditional on the team that involved string access ie: Say all teams starting with 'G'. I get a KeyError.I would greatly appreciate any information on what might be happening here.

euro16_df[euro16_df.Team[0] == 'G']

Nickil Maveli · Accepted Answer · 2017-03-25 18:01:11Z

3

Use the str string accessor

euro16_df[euro16_df.Team.str[0] == 'G']

edited Mar 25, 2017 at 18:01

Nickil Maveli

29.8k10 gold badges86 silver badges88 bronze badges

answered Mar 25, 2017 at 17:24

piRSquared

296k68 gold badges509 silver badges654 bronze badges

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

3 Comments

Pradyot Over a year ago

Thanks! Much appreciated. How is it that it can compare with the original string "Germany" without needing an accessor. I totally missed this while and would love to read more about this.

piRSquared Over a year ago

@Pradyot there are a bunch of methods that can be done pandas does a good job of making the most important ones available without an accessor. Otherwise pandas groups like methods together. There is also a date time/time delta accessor 'dt'. Category accessor 'cat'.

Pradyot Over a year ago

Again. Really appreciate the direction.

Shenglin Chen · Accepted Answer · 2017-03-25 17:41:35Z

1

Also str startswith.

euro16_df[euro16_df.Team.str.startswith('G')]

answered Mar 25, 2017 at 17:41

Shenglin Chen

4,56413 silver badges11 bronze badges

Collectives™ on Stack Overflow

Conditional Select on a dataframe column

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related