CODEWITHSUNDEEP
pythonpandasdataframeoperators
ShieldScrub
ShieldScrub

Reputation: 1

Python & operator in dataframe

I'm trying to combine these two parts as an AND statement.

dataframe = df.loc[~(df['Name'] < -1000)]
dataframe = df.loc[~(df['Name'] > 1000)]

I want it to do something like this:

dataframe = df.loc[~(df['Name'] < -1000)] & df.loc[~(df['Name'] > 1000)]

I have tried using & and AND, and both returned errors, need help.

Upvotes: 0

Views: 87

Answers (2)

Mark Wang
Mark Wang

Reputation: 2757

How about removing the ~

dataframe = df[df['Name'].between(-1000, 1000)]

Upvotes: 0

TUI lover
TUI lover

Reputation: 552

Try something like this, you don’t need to use .loc

dataframe = df[~(df['Name'] < -1000) & ~(df['Name'] > 1000)]

Upvotes: 1

Related Questions