CBSE CS and IP

CBSE Class 11 & 12 Computer Science and Informatics Practices Python Materials, Video Lecture

Descriptive Statistics (4 Marks Questions)


  1. Consider the Dataframe(DF) and write the python program to find the following:
    Name Of Employee Sales Quarter State
    0 Mohak 1000 1 Rajasthan
    1 Vijay 300 1 Panjab
    2 Tapasi 400 1 Gujarat
    3 Mansi 500 1 Goa
    4 Bipin 800 2 Rajasthan
    5 Mohak 1000 2 Gujarat
    6 Vijay 500 2 Panjab
    7 Tapasi 700 2 Gujarat
    8 Mansi 50 2 Rajasthan
    9 Bipin 60 2 Rajasthan
    10 Mohak 1000 3 Rajasthan
    • Find total sales per employee in above dataframe. (Ex:- Mohak sales is 3000)
    • Find total sales by state in above dataframe(Ex:-Rajasthan sales is 2910 )
  2. Consider the above Dataframe(DF) and write the python program to find the following:
    • Find Max individual sale by State in above dataframe
    • Find Mean, median and min sales by Each State in above dataframe

1 comment: