Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

table [ [ Student ID , First Name,Last Name,Major,State ] , [ 2 0 1 9 1 4 5 6 , NAN,Mahaguna,Finance,CA ] ,

\table[[Student ID,First Name,Last Name,Major,State],[20191456,NAN,Mahaguna,Finance,CA],[NAN,Justing,Chau,Management,AZ],[20211345,Chenyi,Yuan,Accounting,CA],[20182367,Andrew,Brown,Accounting,GG],[20000000,Phillip,NAN,Economics,NY]]
Suppose this data set is in a Data Frame named MyStudents. How to fix the missing data for Student ID in the second row?
MyStudents["Student ID"].fillna(MyStudents["Student ID"].mean(), inplace = True)
MyStudents.dropna()
MyStudents.loc[1,"Student ID"]= MyStudents["Student ID"].mean()
MyStudents.drop(index =1)
MyStudents.loc[2,"Student ID"]= MyStudents["Student ID"].median()
image text in transcribed

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

More Books

Students also viewed these Databases questions

Question

Is Chloe eligible to claim and receive the Earned Income Credit?

Answered: 1 week ago

Question

How do modern Dashboards differ from earlier implementations?

Answered: 1 week ago