/Python/Select rows from a DataFrame based on column values?

Select rows from a DataFrame based on column values?

#To select rows whose column value equals a scalar, some_value, use ==:
df.loc[df['A'] == 'foo']

#To select rows whose column value is in an iterable, some_values, use isin:
df.loc[df['B'].isin(['one','three'])]

#Combine multiple conditions with &:
df.loc[(df['column_name'] >= A) & (df['column_name'] <= B)]

Source: codegrepper.com

Similar codes

4 votes230 views1 answer
Pandas add dataframe to the bottom of another
Python
1 vote217 views1 answer
Pip install torch error
Python
0 vote246 views2 answers
How to give order in boxplot matplotlib
Python
14 votes233 views4 answers
Python lambda function if else
Python
0 vote234 views1 answer
Convert string ranges list python
Python
0 vote236 views1 answer
Print input in python
Python
0 vote243 views1 answer
How to change the type of a values in list from str to object python
Python
0 vote257 views1 answer
Invalid comparison between dtype=datetime64[ns] and date filter
Python
22 votes243 views6 answers
Readlines from file python
Python
13 votes229 views5 answers
How to check for missing values in pandas
Python