Question: 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()
 \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

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!