Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. In the following question, you will create your own Pandas dataframe! a. (5 points) Start by creating a dictionary that contains all the

 

image

2. In the following question, you will create your own Pandas dataframe! a. (5 points) Start by creating a dictionary that contains all the information contained in the mini-spreadsheet below. Name Credits Garrus Vakarian 37 Matilda Bradbury 43 Cordelia Vorkosigan 36 Kira Nerys 23 Jean-Luc Picard 50 GPA 3.2 4.0 3.7 3.6 3.4 Hometown Palaven Whitestone Vashnoi Dahkur La Barre b. (5 points) Using Pandas, convert your dictionary into a dataframe. c. (5 points) Using Pandas, set the column "Name" as the index. d. (5 points) Using Pandas, print the GPA of Kira Nerys. e. (5 points) Using Pandas, change Matilda Bradbury's credits to 44. f. Hint: Print out the dataframe again to make sure the change happened! (5 points) Using Pandas, summarize statistics (using describe()) for the Credits and GPA columns. g. (5 points) Using Pandas, add a new column with data of your choice without repeating the data across all five rows. Hint: This is a little different than what we did in class. You'll want to start by creating a new list that contains the five data entries the new column will contain, then assign it to your desired new column name within the dataframe.

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_2

Step: 3

blur-text-image_3

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

Business Statistics

Authors: Norean Sharpe, Richard Veaux, Paul Velleman

3rd Edition

978-0321944726, 321925831, 9780321944696, 321944720, 321944690, 978-0321925831

More Books

Students also viewed these Programming questions

Question

-Select- -Select- *

Answered: 1 week ago