Pandas DataFrame Exercise 1

1. Read the excel file, to create the DataFrame.
2. How many rows and columns are there?
3. Read the first 4 rows
4. How many rows are there?
5. Display the columns of the DataFrame
6. Display the first 5 recrods of NAME column of the DataFrame
7. Display highest 5 records based on the MARK column.
8. Display all classes in CLASS column ( Unique class )

Read the excel file, to create the DataFrame.

import pandas as pd 
my_data = pd.read_excel('D:\student.xlsx',index_col='id')
print(my_data)

How many rows and columns are there?

print(my_data.shape) # ( 35, 5)

Read the first 4 rows

print(my_data.head(4))

          name  class  mark     sex
id                                 
1     John Deo   Four    75  female
2     Max Ruin  Three    85    male
3       Arnold  Three    55    male
4   Krish Star   Four    60  female

How many rows are there?

print(len(my_data)) #  35

Display the columns of the DataFrame

print(my_data.columns)

Index(['id', 'name', 'class', 'mark', 'sex'], dtype='object')

Display the first 5 recrods of NAME column of the DataFrame

print(my_data['name'][:5]) # Five rows of name column

0      John Deo
1      Max Ruin
2        Arnold
3    Krish Star
4     John Mike

Display highest 5 records based on the MARK column.

my_dt=my_data.sort_values(['mark'],ascending=False)
print(my_dt[:5])

    id       name  class  mark     sex
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

Display all classes in CLASS column ( Unique class )

print(my_data['class'].unique())

['Four' 'Three' 'Five' 'Six' 'Seven' 'Nine' 'Eight']

print(len(my_data['class'].unique())) # 7