Question: Get the data from the file named score to complete the message below and have it display on the terminal According to the data, there

Get the data from the file named score to complete the message below and have it display on the terminal

According to the data, there are pupils. They are from majors and their majors are: . They come from colleges and their college names are: .

Below is the file score.xlsx This practice is to be done with python, with openpyxl used

Student Name score1 score2 score3 major school year college
Andy 91 89 78 management Social Sciences 4 X
Alice 55 67 88 politics Social Sciences 2 X
Ann 96 92 45 chemistry Sciences 1 Y
Ava 67 52 79 sociology Social Sciences 1 Z
Amy 78 90 85 management Social Sciences 4 Y
Billy 55 66 68 politics Social Sciences 1 X
Boston 86 77 33 chemistry Sciences 4 Z
Bobo 98 79 88 Physics Sciences 4 Y
Cathy 91 57 67 management Social Sciences 3 Y
Celine 58 78 68 Physics Sciences 3 Z
Donald 78 95 45 sociology Social Sciences 1 X
Duck 75 72 78 sociology Social Sciences 3 Z
Diana 87 67 55 Physics Sciences 2 X
Rose 26 34 76 politics Social Sciences 2 Z
Lily 90 76 75 chemistry Sciences 3 X

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

I need help with this java app In this assignment, you will be creating a Java console application to maintain a daily food journal for a person who is participating in the trendy "Paleo Diet", which...

Q:

Lab #5: Graphics, Inheritance, and Problem Solving Mah Jong Tiles This programming lab continues the work began in Lab 3 to build a set of Mah Jong tiles that will be used in subsequent labs to build...

Q:

Lab #5: Graphics, Inheritance, and Problem Solving Mah Jong Tiles This programming lab continues the work began in Lab 3 to build a set of Mah Jong tiles that will be used in subsequent labs to build...

Q:

Lab #5: Graphics, Inheritance, and Problem Solving Mah Jong Tiles This programming lab continues the work began in Lab 3 to build a set of Mah Jong tiles that will be used in subsequent labs to build...

Q:

In this assignment, you will be creating a Java console application to maintain a daily food journal for a person who is participating in the trendy "Paleo Diet", which is a dietary shift to food...

Q:

Implement a load/save feature in your game. Start by downloading the starter_code that comes with this assignment then do as required below. (in java) public class Chicken extends Animal{ private...

Q:

THIS IS TO BE DONE IN C++, PLEASE READ THE INDTUCTIONS CAREFULLY AND ANSWER ALL IT SAYS, THANK YOU! # Cracking a LFSR stream cipher ## Project 2 --- #### Summary In this project we will execute a...

Q:

Here's the starter code for farmer class: package P 3 ; import java.util.Arrays; public class Farm { private double availableFood; private Animal [ ] animals; private final int MAX _ ANIMAL _ COUNT =...

Q:

What to do At a high-level, your next steps are to: Open the file bridge_functions.py. Make sure that the file is in the same directory as a2_checker.py, and pyta. Complete the function definitions...

Q:

that is java project i need code for that question and there is an output example for this project. Given a file, the program will display and write the results of: 1. 2. 3. 4. 5. Average score High...

Q:

Create a dog class with_init_() without arguments The _init_ (self) method initializes the object's state(s). Like methods, a constructor also contains a collection of statements(i.e. instructions)...

Q:

The following are the daily stock prices of a company listed at the Nairobi Stock Exchange during the month of September 2017 i) 12,16,14,17,19,15,11,19,23,15,16,18,16,24,10,20,15,24,15,15,16 Compute...

Q:

Which one of the following will increase the current value of a stock? Multiple Choice 3 : 4 4 Decrease in the dividend growth rate Increase in the required return Increase in the market rate of...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

1. [From the head of your agency] Ive heard some disturbing rumors about the way you treat our clients. a. Thats ridiculous. b. You cant believe everything you hear. c. Could you please be more...

Q:

5. Under what circumstances is introducing yourself to someone you dont know a good idea? When is introducing yourself not such a good idea?

Q:

4. [From a legislator or a member of the city council] I want to see all the information we have on the new construction project, and I want it in my office in 1 hour. a. Thats none of your business....