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 vote174 views1 answer
How to make a plt plot for na image bigger
Python
0 vote195 views1 answer
Solution TypeError: 'list' object is not callable
Python
0 vote210 views1 answer
Regex_2/_regex.c:50:10: fatal error: Python.h: No such file or directory
Python
0 vote198 views1 answer
Pybind11 python37_d.dll access violation
Python
0 vote185 views1 answer
Try: if '1' != 1: raise "someError" else: print("someError has not occurred") except "someError": print ("someError has occurred")
Python
29 votes175 views5 answers
Python date and time
Python
12 votes189 views6 answers
Print()
Python
-1 vote169 views1 answer
Numpy split array into chunks of equal size
Python
0 vote178 views1 answer
Python turtle triangle
Python
1 vote172 views1 answer
How to remove every other letter from a string python
Python