KEMBAR78
Data Frame Questions For Practical File | PDF
Scribd
Upload
39 views3 pages

Data Frame Questions For Practical File

The document contains a series of programming tasks related to data frames, focusing on operations such as extracting specific columns, adding new columns, calculating totals and averages, and determining statistical measures like mode and median. It includes examples of data frames for student marks and team performances, requiring the implementation of various calculations. The tasks are designed to enhance practical skills in data manipulation using programming.

Uploaded by

NEEMA GANDHI
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
39 views3 pages

Data Frame Questions For Practical File

The document contains a series of programming tasks related to data frames, focusing on operations such as extracting specific columns, adding new columns, calculating totals and averages, and determining statistical measures like mode and median. It includes examples of data frames for student marks and team performances, requiring the implementation of various calculations. The tasks are designed to enhance practical skills in data manipulation using programming.

Uploaded by

NEEMA GANDHI
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

DATA FRAME QUESTIONS FOR PRACTICAL FILE

1. write a program to print only the values from the maths marks column for

each row for the given dataframe:

Name Maths

0 Ram 70

1 Shyam 95

2 Sam 80

2. Write a program to add one column for science marks.

3. write a program to find total of maths and science marks and add total column

to the dataframe.

4. write a program to claculate total points earned by both the teams in each

round.Team's performance is given as below:

Team 1's performance

P1 P2

1 700 490

2 975 460

3 970 570

4 900 590

Team 2's performance

P1 P2

1 1100 1400

2 1275 1260
3 1270 1500

4 1400 1190

5. Given two dataframes storing points of a 2 player teams in four rounds. write

a program to calculate average points obtained by each player in each round.

6. consider the above dataframe given in q-4 and write a program to print

maximum and minimum score of player one (P1) in both teams.

7. create a dataframe as shown below:

Abhi Ami Raju Ratik

Accounts 99 94 92 99

Economics 94 94 92 97

English 95 89 91 89

IP 94 87 90 94

B.st. 97 98 99 96

consider the above dataframe.

(A) write a program to claculate mode for each student.

(B) write a program to calculate mode for each subject.

(C) write a program to calculate median value for each student.

(D) write a program to calculate median value for each subject.

(E) write a program to calculate average value(mean) for each student.

(F) write a program to calculate average value (mean) for each subject.

(G) write a program to calculate total marks for each subject.

You might also like