Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a pandas DataFrame containing the information below: Name Major GPA Hourly Salary Rian ISYE Elise ISYE KevinISYE Melinda CS 3.9 9.95 3.8 9.75 3.7

image text in transcribed

Create a pandas DataFrame containing the information below: Name Major GPA Hourly Salary Rian ISYE Elise ISYE KevinISYE Melinda CS 3.9 9.95 3.8 9.75 3.7 9.50 3.6 10.00 Add a new column to the dataframe with heading Age and values 23 22 21 and 29 Add a new row to the dataframe to include a person named Bob who is an EE major with a 3.3 gpa making 8.95 an hour. Increase the salary 50 cents for each person in the dataframe that has a GPA over 3.7. Print out the average gpa. Print out the average salary for all the people who are over 21 Save your Jupyter notebook as a .py file and attach it to this quiz to turn it in

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

Advanced Oracle Solaris 11 System Administration

Authors: Bill Calkins

1st Edition

0133007170, 9780133007176

More Books

Students also viewed these Databases questions

Question

4. Did the presenter offer a clear and memorable summary?

Answered: 1 week ago