Select rows in python

Select rows from dataframe pandas

from pandas import DataFrame

boxes = {'Color': ['Green','Green','Green','Blue','Blue','Red','Red','Red'],
         'Shape': ['Rectangle','Rectangle','Square','Rectangle','Square','Square','Square','Rectangle'],
         'Price': [10,15,5,5,10,15,15,5]
        }

df = DataFrame(boxes, columns= ['Color','Shape','Price'])

select_color = df.loc[df['Color'] == 'Green']
print (select_color)

Source: datatofish.com

How to get a row of a dataframe with subset columns in python

df.iloc[1:3, 5:7]

Select rows in python

import pandas as pd

boxes = {'Color': ['Green','Green','Green','Blue','Blue','Red','Red','Red'],
         'Shape': ['Rectangle','Rectangle','Square','Rectangle','Square','Square','Square','Rectangle'],
         'Price': [10,15,5,5,10,15,15,5]
        }

df = pd.DataFrame(boxes, columns= ['Color','Shape','Price'])

color_and_shape = df.loc[(df['Color'] == 'Green') & (df['Shape'] == 'Rectangle')]
print (color_and_shape)

Source: datatofish.com

Similar codes

0 vote279 views1 answer
Journalctl not showing all python prints
Python
0 vote293 views1 answer
Must have equal len keys and value when setting with an ndarray
Python
9 votes280 views2 answers
Remove all rows without a value pandas
Python
1 vote378 views1 answer
Insert data in django models
Python Django
1 vote303 views1 answer
Check where bool in a list python
Python
0 vote282 views1 answer
How to print stdout while processing the execution in python
Python
0 vote286 views1 answer
Predict probabilities with xg boost
Python
0 vote277 views8 answers
Empaquetado y manejo dependencias en python
Python
1 vote289 views1 answer
Generate number of n bits python
Python
0 vote363 views1 answer
CACHE_TYPE flask
Python Flask