Pandas select column by index

Select columns pandas

df1 = df.iloc[:,0:2] # Remember that Python does not slice inclusive of the ending index.

Source: stackoverflow.com

Pandas select column by index

#    A  B  C
# 0  1  3  5
# 1  2  4  6

column_B = a_dataframe.iloc[:, 1]
print(column_B)

# OUTPUT
# 0    3
# 1    4

Source: kite.com

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

Retrieve row by index pandas

rowData = dfObj.loc[ 'b' , : ]

Source: thispointer.com

Similar codes

0 vote245 views1 answer
Dataframe rank groupby
Python
6 votes249 views1 answer
Getting dummies and input them to pandas dataframe
Python
0 vote262 views1 answer
How to check mix types in pandas column
Python
2 votes263 views1 answer
.env files in repl
Python
1 vote271 views2 answers
Np matrix drop zero column
Python
5 votes245 views1 answer
Dataframe unique values in each column
Python
8 votes284 views2 answers
Django create empty migration
Python Django
71 votes274 views6 answers
Alphabet list python
Python
11 votes276 views6 answers
Python file size
Python
43 votes259 views2 answers
For loop in df rows
Python