Pandas DataFrame Exercise 1

Pandas

We used DataFrame of 35 rows by reading from a Excel file. Download student.xlsx file OR Copy Sample Student DataFrame

Using the above excel file (or DataFrame ) you can try these questions on basics of Data handling.
  1. Read the excel file, or copy 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 records 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 )

  • DataFrame Basic Questions


Read the excel file, to create the DataFrame.


Read more on how to read excel file here
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

Read more on DataFrame.head()
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

How many rows are there?

print(len(my_data)) #  35

Display the columns of the DataFrame

print(my_data.columns)
Output
Index(['id', 'name', 'class', 'mark', 'gender'], dtype='object')

Display the first 5 recrods of NAME column of the DataFrame

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

Display highest 5 records based on the MARK column.

Read more about sort_values() to arrange rows in increasing or decreasing order
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

Display all classes in CLASS column ( Unique class )

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
loc mask where query

Pandas Pandas DataFrame iloc - rows and columns by integers
Subscribe to our YouTube Channel here


Subscribe

* indicates required
Subscribe to plus2net

    plus2net.com



    14-07-2021

    You are doing amazing job.

    Post your comments , suggestion , error , requirements etc here





    Python Video Tutorials
    Python SQLite Video Tutorials
    Python MySQL Video Tutorials
    Python Tkinter Video Tutorials
    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2023 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer