pandas select rows by multiple conditions

Add Answer

Grieving Goose answered on March 30, 2020 Popularity 10/10 Helpfulness 4/10

answer pandas select rows by multiple conditions

related select rows with multiple conditions pandas query

related get df based on multiple conditions in column

related pandas multiple between conditions

related select rows with multiple conditions pandas query

related Filter DataFrame with multiple conditions

pandas select rows by multiple conditions

Comment

>>> df["A"][(df["B"] > 50) & (df["C"] == 900)]
2    5
3    8
Name: A, dtype: int64
    
>>> df.loc[(df["B"] > 50) & (df["C"] == 900), "A"]
2    5
3    8
Name: A, dtype: int64
>>> df.loc[(df["B"] > 50) & (df["C"] == 900), "A"].values
array([5, 8], dtype=int64)
>>> df.loc[(df["B"] > 50) & (df["C"] == 900), "A"] *= 1000
>>> df
      A   B    C
0     9  40  300
1     9  70  700
2  5000  70  900
3  8000  80  900
4     7  50  900

Popularity 10/10 Helpfulness 4/10 Language python

Source: stackoverflow.com

Tags: multiple-conditions pandas python rows select

Link to this answer
Share Copy Link

Contributed on Mar 30 2020

Grieving Goose

0 Answers Avg Quality 2/10

Closely Related Answers

select rows with multiple conditions pandas query

Comment

df.loc[(df['Salary_in_1000']>=100) & (df['Age']< 60) & (df['FT_Team'].str.startswith('S')),['Name','FT_Team']]

Popularity 10/10 Helpfulness 6/10 Language python

Source: kanoki.org

Tags: multiple-conditions mult

Link to this answer
Share Copy Link

Contributed on Jun 20 2020

Blue-eyed Buzzard

0 Answers Avg Quality 2/10

select rows with multiple conditions pandas query

Comment

df.query('Salary_in_1000 >= 100 & Age < 60 & FT_Team.str.startswith("S").values')

Popularity 10/10 Helpfulness 3/10 Language python

Source: kanoki.org

Tags: multiple-conditions mult

Link to this answer
Share Copy Link

Contributed on Jun 20 2020

Blue-eyed Buzzard

0 Answers Avg Quality 2/10

get df based on multiple conditions in column

Comment

user_df[user_df['colA'].isnull() & user_df['colB'] > 0]

Popularity 9/10 Helpfulness 3/10 Language python

Source: Grepper

Tags: get multiple-conditions

Link to this answer
Share Copy Link

Contributed on Oct 19 2022

Rishabh Kesarwani

0 Answers Avg Quality 2/10

pandas multiple between conditions

Comment

Filter a dataframe using multiple between conditions

df = df[
 	df['colA'].between(-0.10, 0.10)
  & df['colB'].between(-0.10, 0.10)
]

Popularity 9/10 Helpfulness 2/10 Language python

Source: Grepper

Tags: between

Link to this answer
Share Copy Link

Contributed on Mar 29 2023

Trained Tuna

0 Answers Avg Quality 2/10

select rows with multiple conditions pandas query

Comment

df.loc[idx]

Popularity 10/10 Helpfulness 1/10 Language python

Source: kanoki.org

Tags: multiple-conditions mult

Link to this answer
Share Copy Link

Contributed on Jun 20 2020

Blue-eyed Buzzard

0 Answers Avg Quality 2/10

Filter DataFrame with multiple conditions

Comment

-1

df['good_or_east'] = df['team'].str.contains('|'.join(['Good', 'East']))

Popularity 10/10 Helpfulness 1/10 Language python

Source: Grepper

Tags: dataframe data

Link to this answer
Share Copy Link

Contributed on Feb 14 2023

Bright Baboon

0 Answers Avg Quality 2/10

pandas select rows by multiple conditions

Contents

More Related Answers

pandas select rows by multiple conditions

Closely Related Answers

select rows with multiple conditions pandas query

select rows with multiple conditions pandas query

get df based on multiple conditions in column

pandas multiple between conditions

select rows with multiple conditions pandas query

Filter DataFrame with multiple conditions

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.