Question: (c) Write a program that creates the following DataFrame from a Dictionary. Iyou don't know how to use Dictionary to represent 2D data, use the

 (c) Write a program that creates the following DataFrame from a

(c) Write a program that creates the following DataFrame from a Dictionary. Iyou don't know how to use Dictionary to represent 2D data, use the Internet to find it out. The order of the columns should be the same as the table below. 3 pts] Name ID Mark 0 Jane 100 74 1 Jan 102 92 2 John 104 58 3 Jabin 106 81 4 Jace 108 66 Figure 1: DataFrame 1 (d) Repeat the previous step using list instead of Dictionary. Also, change the index so that the DataFrame looks like: 3 pts Name ID Mark a Jane 100 74 b Jan 10 92 c John 10458 d Jabin 106 81 e Jace 108 6 Figure 2: DataFrame 2 (e) Write a program that creates a 2D DataFrame from NumPy arrays. The first array is a column of student ID numbers named 'ID' with values from 1000 to 1049, and the second array is a column of50 random integer nmbers between 60 and 100 named Mark'. (hint: use the arange function from the NumPy package to create the irst TD array, and use randint function from the numpy.random package to create the 'Mark' array. Next, find a way to combine the two arrays together to have a single 2D array, and then convert it to a DataFrame.) 13 pts|

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!