select DF columns python
df = df.iloc[:,0:2]
df = df[['column1', 'column2']]select DF columns python
df = df.iloc[:,0:2]
df = df[['column1', 'column2']]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)select columns pandas
df1 = df.iloc[:,0:2] # Remember that Python does not slice inclusive of the ending index.select column in pandas dataframe
Report_Card.loc[:,"Grades"] The first argument ( : ) signifies which rows we would like
to index, and the second argument (Grades) lets us index the column we wantSelect a Column in pandas data Frame
>>> import pandas as pd>>> df = pd.read_csv('data/sample_data.csv', index_col=0)>>> dfadd an index column in range dataframe
df = df.loc[df.index.repeat(df['a'])]
df['c'] = df.groupby(level=0).cumcount() + 1
df = df.reset_index(drop=True)
print (df)
a b c
0 1 x 1
1 2 y 1
2 2 y 2
3 3 z 1
4 3 z 2
5 3 z 3Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
