How to filter data by string

Question

Please, it would be great if someone gives me a clue as to resolve my willing to filter data with str 'Трафик с мобильных устройств'. Now, if I run this code:

data.query('Segment == Трафик с мобильных устройств')

I'll get this message: Segment ==Трафик с мобильных устройств ^ SyntaxError: invalid syntax

If do this:

data[data['Segment] == Трафик с мобильных устройств']

I will get: data[data['Segment] == Трафик с мобильных устройств']

I have: enter image description here

I want: enter image description here

Sorry, I have done a mistake. In the second case, I will get this message "SyntaxError: unexpected EOF while parsing" — and_and
– and_and, Commented Feb 1, 2020 at 7:45

jezrael · Accepted Answer · 2020-02-01 07:59:09Z

1

Missing "", if first ':

data.query('Segment == "Трафик с мобильных устройств"')
#alternative with swapped " -> '
#data.query("Segment == 'Трафик с мобильных устройств'")

For second:

data[data['Segment'] == 'Трафик с мобильных устройств']
#alternative
#data[data["Segment"] == "Трафик с мобильных устройств"]

Sample:

data = pd.DataFrame({'Segment':['Трафик с мобильных устройств',
                                'Трафик',
                                'Трафик с мобильных устройств']})

df = data.query('Segment == "Трафик с мобильных устройств"')
print (df)
                        Segment
0  Трафик с мобильных устройств
2  Трафик с мобильных устройств

df = data[data['Segment'] == 'Трафик с мобильных устройств']
print (df)
                        Segment
0  Трафик с мобильных устройств
2  Трафик с мобильных устройств

edited Feb 1, 2020 at 7:59

answered Feb 1, 2020 at 7:43

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

5 Comments

and_and Over a year ago

@ ezraelcool, but if I run this I got it UndefinedVariableError: name 'Segment' is not defined, the same the second KeyError: 'Segment'

jezrael Over a year ago

@Andrew - It is not column name? what is print (data.columns.tolist()) ?

and_and Over a year ago

['Category', 'Month', 'Segment ', 'Revenue', 'Quantity ', 'Average_price', 'Average_quantity']

jezrael Over a year ago

@Andrew - Added sample data, for me working perfectly.

and_and Over a year ago

@ ezrael Got it, I have a space in 'Segment ', it works ) Thank you!!!

Collectives™ on Stack Overflow

How to filter data by string

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related