PYTHON

select specific rows from dataframe in python

select_color = df.loc[df['Color'] == 'Green']

pandas return specific row

df.iloc[1] # replace index integer with specific row number

pandas return row

1. 	Selecting data by row numbers (.iloc)
	# myrow = data.iloc[<row selection>]
 	myrow = data.iloc[7]
    myrow = data.iloc[0:9]
    
2. 	Selecting data by label or by a conditional statement (.loc)
	# myrow = data.loc[<row selection.]
  	myrow = data.loc['University ABC']
    
3. 	Selecting in a hybrid approach (.ix) (now Deprecated in Pandas 0.20.1)
	# Works like a .loc but also accepts integers - may lead to unexpected results

how to select rows with specific values in pandas

#To select rows whose column value is in an iterable array, which we'll define as array, you can use isin:
array = ['yellow', 'green']
df.loc[df['favorite_color'].isin(array)]