Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Last First SSN Test1 Test2 Test3 Test4 Final Alfalfa Aloysius 123-45-6789 40 90 100 83 49 Alfred University 123-12-1234 41 97 96 97 48 Gerty

Last First SSN Test1 Test2 Test3 Test4 Final
Alfalfa Aloysius 123-45-6789 40 90 100 83 49
Alfred University 123-12-1234 41 97 96 97 48
Gerty Gramma 567-89-0123 41 80 60 40 44
Android Electric 087-65-4321 42 23 36 45 47
Bumpkin Fred 456-78-9012 43 78 88 77 45
Rubble Betty 234-56-7890 44 90 80 90 46
Noshow Cecil 345-67-8901 45 11 -1 4 43
Buff Bif 632-79-9939 46 20 30 40 50
Airpump Andrew 223-45-6789 49 1 90 100 83
Backus Jim 143-12-1234 48 1 97 96 97
Carnivore Art 565-89-0123 44 1 80 60 40
Dandy Jim 087-75-4321 47 1 23 36 45
Elephant Ima 456-71-9012 45 1 78 88 77
Franklin Benny 234-56-2890 50 1 90 80 90
George Boy 345-67-3901 40 1 11 -1 4
Heffalump Harvey 632-79-9439 30 1 20 30 40
Alfalfa Aloysius 123-45-6789 40 90 100 83 49

Create a simple program that will load in the CSV file.

A quick way to compute the average of a column is:

print(data.Test2.mean()) 

But, I want you to demonstrate that you can compute an average manually.

So, after loading the CSV file, your program should loop through all the Test 2 values and use this loop to compute their average.

Make sure that your average is the same answer as the "quick way" I give above.

Once you get that to work, do the same for manually finding the min and max Test 2 value, and check your answers against:

 

print(data.Test2.min())

print(data.Test2.max())

Show screenshots of your code and results.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Support For Data Mining Applications Discovering Knowledge With Inductive Queries Lnai 2682

Authors: Rosa Meo ,Pier L. Lanzi ,Mika Klemettinen

2004th Edition

3540224793, 978-3540224792

More Books

Students also viewed these Databases questions

Question

5. How would you describe your typical day at work?

Answered: 1 week ago

Question

7. What qualities do you see as necessary for your line of work?

Answered: 1 week ago