Conditional row select with Pandas

Question

I want to select a sub-set of a pandas dataframe df where the column text has the value '0.0, 0.0'. I thought the command for this would be df.ix[df['text'] == "0.0, 0.0"] but this returns

<console>:1: error: identifier expected but symbol literal found.
   df.ix[df['text'] == "0.0, 0.0"]
            ^
<console>:1: error: unclosed character literal
   df.ix[df['text'] == "0.0, 0.0"]
                 ^

What am I doing wrong?

It works fine when I try it. Can you add versions of your Python/pandas installations, which environment you are using etc? — user2285236
– user2285236, Commented Sep 13, 2016 at 17:32
@DSM I just realized I'm in a Zeppelin notebook and hadn't specified that it should be using the Py interpreter. My bad! Will question delete in 5 mins — Danny David Leybzon
– Danny David Leybzon, Commented Sep 13, 2016 at 17:37

Community · Accepted Answer · 2017-05-23 12:32:42Z

1

As DSM pointed out, the error appears to be an error from the Scala programming language. This is because I was using a Zeppelin Notebook, and had failed to specify that the code should be interpreted with the pyspark interpreter. After specifying the interpreter, the code worked as expected.

edited May 23, 2017 at 12:32

CommunityBot

11 silver badge

answered Sep 13, 2016 at 17:45

Danny David Leybzon

6801 gold badge9 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Conditional row select with Pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related