How to select rows in a dataframe based on values in three columns?

Question

I have a dataframe with more than 1000 rows, and three columns with different values (integers). I would like to select rows, in which the values of three columns are within 2-folds or less of each other. I have tried this:

df = df[(df['B'] >  | < | == 2 * df['D']) & (df['B'] > | < | == 2 * df['F'])]

which it did not work! I am new to Pandas.

Stefan · Accepted Answer · 2015-12-09 19:36:10Z

2

Looks like you might want to try:

df = df[((df.B>df.D) & (df.B<df.D*2)) & ((df.B>df.F) & (df.B<df.F*2))]

answered Dec 9, 2015 at 19:36

Stefan

43.1k13 gold badges80 silver badges84 bronze badges

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

Collectives™ on Stack Overflow

How to select rows in a dataframe based on values in three columns?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related