PySpark and AWS: Master Big Data with PySpark and AWS - Quiz (Select, Withcolumn, Filter)

This video tutorial guides students through a quiz involving the use of a CSV file containing student data. The tasks include reading the file into a dataframe, adding a column for total marks, calculating average marks, filtering students based on their performance in OOP and Cloud courses, and printing the results. The video encourages students to attempt solving the problem before the solution is discussed in the next video.

What is the first step in processing the student data CSV file?

• Print the names of all students

• Filter students based on marks

• Read the file into a dataframe

• Create a new column for average marks

What value should be set for each entry in the 'Total Marks' column?

• 80

• 120

• 150

• 100

How is the average marks of a student calculated?

• By dividing obtained marks by 100

• By adding obtained marks to total marks

• By multiplying obtained marks by total marks

• By dividing obtained marks by total marks and multiplying by 100

Which students are filtered into a new dataframe based on their OOP course performance?

• Students with more than 60% marks

• Students with more than 70% marks

• Students with more than 80% marks

• Students with more than 90% marks

What is the final step after filtering students based on course performance?

• Create a new column for total marks

• Calculate the average marks again

• Save the dataframe to a new CSV file

• Print the names and marks of the filtered students