How to filter pandas dataframe by string

Question

I have a dataframe with several columns. Here is an example:

A          B  C  D      MachineCall    F
0  1 2013-01-02  1  3   Machine1  foo
1  1 2013-01-02  1  3  Machine2  foo
2  1 2013-01-02  1  3   Machine3  foo
3  1 2013-01-02  1  3  Machine1  foo

I want to make a new dataframe that only uses data from rows with Machine1. I don't want to change the order of the columns.

I tried

df2 = df2[(df2 == 'Machine1')]

which got the error

TypeError: Could not compare ['Machine1'] with block values:

and

df2 = df2[(df2'MachineCall'].isin('Machine1')]

which got

TypeError: only list-like objects are allowed to be passed to Series.isin(), you passed a 'str'

Yes, I can change that. Not sure if this question will still be helpful to others, though. — jenryb
– jenryb, Commented Jul 6, 2015 at 20:34
Regarding your errors the first one is probably because you're trying to compare a df containing mixed dtype columns with a str but this will barf when the dtypes don't match, for the second error it's pretty clear, it should be a list with a single element: df2 = df2[(df2'MachineCall'].isin(['Machine1'])] — EdChum
– EdChum, Commented Jul 6, 2015 at 20:35

Keiku · Accepted Answer · 2017-10-04 07:17:49Z

4

The following code works.

df[df['MachineCall'].str.contains("Machine1")]

edited Oct 4, 2017 at 7:17

Keiku

8,9036 gold badges45 silver badges46 bronze badges

answered Jul 6, 2015 at 20:13

jenryb

2,12712 gold badges41 silver badges76 bronze badges

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

Comments

DeepSpace · Accepted Answer · 2015-07-06 20:16:41Z

1

new_df = df2[df2['MachineCall'] == 'Machine1']

answered Jul 6, 2015 at 20:16

DeepSpace

82.2k12 gold badges119 silver badges166 bronze badges

Collectives™ on Stack Overflow

How to filter pandas dataframe by string

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related