import pandas as pd
my_data = pd.read_excel('D:\student.xlsx',index_col='id')
print(my_data)
print(my_data.shape) # ( 35, 5)
print(my_data.head(4))
Output
name class mark gender
id
1 John Deo Four 75 female
2 Max Ruin Three 85 male
3 Arnold Three 55 male
4 Krish Star Four 60 female
print(len(my_data)) # 35
print(my_data.columns)
Output
Index(['id', 'name', 'class', 'mark', 'gender'], dtype='object')
print(my_data['name'][:5]) # Five rows of name column
Output
0 John Deo
1 Max Ruin
2 Arnold
3 Krish Star
4 John Mike
my_dt=my_data.sort_values(['mark'],ascending=False)
print(my_dt[:5])
Output
id name class mark gender
32 33 Kenn Rein Six 96 female
11 12 Recky Six 94 female
31 32 Binn Rott Seven 90 female
10 11 Ronald Six 89 female
24 25 Giff Tow Six 88 male
print(my_data['class'].unique())
Output
['Four' 'Three' 'Five' 'Six' 'Seven' 'Nine' 'Eight']
To get the number of columns
print(len(my_data['class'].unique())) # 7
14-07-2021 | |
You are doing amazing job. |