**using jupyter notebook (Python)** Task 1Consider the following table of data containing module marks for 5 students:Student_ID CIT4020 CCIT4088 CCIT409220201234642981200762361621422020122470625820213134161751202012997950611. Create five lists. Name it as student1, student2, .. , student5. Each of the list contains the Student ID, marks of CCIT4020, marks of CCIT4088 and marks ofCCIT4092 of the student.2. Create a numpy array named data which is a 2D array contains the 5 lists formed in Step (1).3. Create a list named column_names based on the column header of the given table.4. Create a DataFrame named df with column_names and data.5. Display df.6. Display only the list of student IDs.7. Using the function iloc (), extracts only the marks of the students from df. Stores the result in a variable named marks.8. Show the summary statistics of the extracted frame marks.9. Calculate the average of each of the course using marks. Stores the result in avg.10. Visualize the average of each of the course using the pandas build-in function plot() with kind=' bar'.

Answered: Image /qna-images/answer/056a2eaf-15cb-463b-a00e-89855f3b7442.jpg

Consider the following table of data containing module marks for 5 students: Student_ID CCIT4020 CCIT4088 CCIT4092 20201234 64 29 81 20076236 16 21 42 20201224 70 62 58 20213134 16 17 51 20201299 79 50 61

Consider the following table of data containing module marks for 5 students: Student_ID CCIT4020 CCIT4088 CCIT4092 20201234 64 29 81 20076236 16 21 42 20201224 70 62 58 20213134 16 17 51 20201299 79 50 61

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter3: Performing Calculations With Formulas And Functions

Section: Chapter Questions

Problem 3.9CP

See similar textbooks

Related questions

Q: 9. Two 12-bit unsigned numbers are multiplied using Carry Save Addition (CSA). Find the total number...

A: Lets see the solution in the next steps

Q: Is it possible to get further information about the proposed specifications of the 5G network (for e...

A: 5G is a 5th generation mobile network that will eventually replace 4G LTE. The new on demand broadb...

Q: Computer Science Scenario: Suppose you were to let your friend use your computer for a couple of hou...

A: The answers for the given questions are as follows.

Q: When precisely did John von Neumann die?

A: John von Neumann original name is János Neumann.

Q: Write a Python program to show the use of the isinstance() function to check whether the value 0.5 i...

A: The isinstance() function in python is a method that is used to check whether a certain entity type ...

Q: Given the following defect origin/where found matrix data, 1. Compute the phase effectiveness (DRE) ...

A: One of most huge difficulties in computing a DRE rate is deciding the all out number of imperfection...

Q: Assume that the box below represents the 14th section. Darken in the area of the section that is rep...

A: Answer: I have given answered in the handwritten format in brief explanation

Q: Question:: What's the difference between Stored Procedures and Scripts? WWhat is the purpose of each...

A: Answer: I have given answered in the brief explanation

Q: Suppose we have two arrays, a and b, containing numbers of size n and m, respectively. a and b seque...

A: Algorithm: Start Read n and m values Iterate through the loop from i=0 to i=n and read elements int...

Q: What is RTOS stand for?

A: RTOS is only applied to the embedded application.

Q: PROVIDE JS SOURCE CODE Design a web page with a text box (username) where the user can enter a name ...

A: Code : <!DOCTYPE html><html lang="en"><head> <meta charset="UTF-8"&gt...

Q: Do parallel/distributed databases have a distinct advantage over centralized ones?

Q: Q-1: Write a program In Assembly language using MIPS Instruction set that reads an integer number N ...

A: Assembly language: Assembly language is a low level programming language. It is used to tell directl...

Q: 1-Draw the internal representation for the following lisp list(s). c. (cons '( (orange grape ((()ap...

Q: w int[a.length]; for(int i = 0; i < a.length; i++) { for(int j = 0; j < b

A: explained as,

Q: 2-Determine the output of the following functions (You must show your works) b. (cddaar '(((orange...

A: Answer: -

Q: 6-Write a Scheme procedure that takes a list and returns the list created by switching successive el...

A: -Write a Scheme procedure that takes a list and returns the list created by switching successive ele...

Q: By examining the featur programs if applicable, Excel spreadsheet?

A: Microsoft Excel Spreadsheet The data is displayed in horizontal and vertical rows using Microsoft Ex...

Q: etween a system subsystem and a logical division

A: given - Is there a difference between a system subsystem and a logical division?

Q: What is an informatics nursing specialisť's role?

A: Introduction: The informatics nurse specialist applies medical expertise to information technology (...

Q: Write a Python program to show the use of the isinstance() function to check whether the value 0.5 i...

A: # Check if "0.5" is an object of float or notif isinstance(0.5, float): # If 0.5 is an object of fl...

Q: Write a program to enter the value of three variables in TextBoxes. Find and print (the maximum and ...

A: Program Code: Public Class FunctionPractice 'Name: 'Program to demonstrate the functions. ...

Q: 1. Even after running the spell checker, why is it important to proofread information that you input...

A: A spreadsheet is a computer application for computation, organization, analysis and storage of data ...

Q: What is included in computer printouts when automated methods are used?

Q: Answer this question ASAP Develop an algorithm and flow chart for two students detail managemen

A: Develop an algorithm and flow chart for two students detail management

Q: What are the advantages of using interfaces? Why not explicitly instantiate objects of a class?

A: Introduction: Interface's Benefits Interfaces are used to define the behavior that all classes must ...

Q: QUESTION 11 Which of the following statements regarding R functions is true? O a user-defined functi...

A: Answer: I have given answered in the brief explanation

Q: hat's the difference between Stored Procedures and Scripts? What is the purpose of each? How does ro...

A: given - What's the difference between Stored Procedures and Scripts? What is the purpose of each How...

Q: What type of possible error messages you can get when you try to login with the ssh-i option?

A: SSH:- A socket shell used in a network protocol is known as a Secure socket shell. This lets us acce...

Q: Demonstrate how to create the tot credits (year, num credits) view, which displays the total amount ...

A: Introduction: A view tot credits (year, num credits) utilizing relational data from the University D...

Q: eJC69 model)

A: Logical backup is the process of extracting and storing logical data from a database.

Q: #include int i = 0; #define loop for(;i<3;i++) int main () { char *chegg_ptr loop printf (chegg_ptr ...

A: Answer : Cheggheggegg is the output of the above C program.

Q: Hotel Saymoon is a very renowned hotel in Cox’s Bazar. Their services are so good that they have a g...

A: Guidelines for Using Case Diagrams: Whilst the use case model will be used for a range of functions,...

Q: Write a Python program to show the use of the isinstance() function to check whether the value 0.5 i...

A: Given: Python program to show the use of the isinstance() function to check whether the value 0.5 is...

Q: Grouping information to enhance memory efficiency is described as ____.

A: Chunking is defined as the process of taking individual pieces of information and grouping them into...

Q: You will design a program that will get each of the required from the user and output the user's fin...

A: In this question, we are asked to write a C++ program which calculate the final grade of the student...

Q: Explain how the three properties of big data (volume, velocity, and variety) apply to the data colle...

A: Introduction: The three characteristics of bi data are Volume, Velocity, Variety. They are the helpf...

Q: 2. Create a program that will accept 10 scores and will display the MAXIMUM SCORE. USE JAVA PROGRAM...

A: A program that accepts 10 numbers, will accept it in an array. It will only print the maximum score ...

Q: Question 15 The LEA instruction is used to write into a register. O data an instruction O the PC an ...

A: Here, we are going to discuss LEA instruction.

Q: What is included in computer printouts when automated methods are used?

A: AUTOMATED METHODS: Automated methods refers to those methods which does not requires high interacti...

Q: Is there a difference between a system subsystem and a logical division?

A: Introduction: Subsystem: A unit or piece of equipment is part of a more extensive system. For examp...

Q: how does spim/mars handle file i/o??

A: how does spim/mars handle file i/o

Q: a) (-1, 3, -5, 7, -9, 13, -15, 17, -19, 23) on TextBox as shown in Figure 1, by using Do... Loop Unt...

Q: By examining the features of each and when they would be employed as personal computer programs if a...

A: By examining the features of each and when they would be employed as personal computer programs if a...

Q: -map and compare it to

A: 1.

Q: 1-what is Active Directory Sites and Services 2- explain Active Directory Sites and Services and gi...

A: Active Directory Sites and Services is a management console for managing directory redundancy. This ...

Q: What are the advantages of an enterprise data model for Mercy? Is it more or less important for Merc...

A: Introduction: We'll start with the first question since there are others. Please submit just that q...

Q: 17 LAB: Warm up: Variables, input, and type conversion Prompt the user to input an integer between 3...

A: Step 1 of 1 In the below code : Input user_int, user_float, user_character, user_string Display valu...

Q: -Encrypt the plaintext message that contains (your "forename" and "surname") using the Caesar cipher...

A: For the given question, we need to encrypt the plain text to cipher text using Caesar cipher. In Cae...

Q: By examining the features of each and when they would be employed as personal computer programs if a...

A: The differences between a Microsoft access database and an excel spread sheet.

Question

**using jupyter notebook (Python)**

Task 1
Consider the following table of data containing module marks for 5 students:
Student_ID CIT4020 CCIT4088 CCIT4092
20201234
64
29
81
20076236
16
21
42
20201224
70
62
58
20213134
16
17
51
20201299
79
50
61
1. Create five lists. Name it as student1, student2, .. , student5. Each of the list contains the Student ID, marks of CCIT4020, marks of CCIT4088 and marks of
CCIT4092 of the student.
2. Create a numpy array named data which is a 2D array contains the 5 lists formed in Step (1).
3. Create a list named column_names based on the column header of the given table.
4. Create a DataFrame named df with column_names and data.
5. Display df.
6. Display only the list of student IDs.
7. Using the function iloc (), extracts only the marks of the students from df. Stores the result in a variable named marks.
8. Show the summary statistics of the extracted frame marks.
9. Calculate the average of each of the course using marks. Stores the result in avg.
10. Visualize the average of each of the course using the pandas build-in function plot() with kind=' bar'.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Answer properly What type of data is being stored into a list and identify the name of the list being processed. //Create variables//stores data from the dog table in listsvar dogList = getColumn("Dogs", "Name");var breedList = getColumn("Dogs", "Breed Group");var temperamentList = getColumn("Dogs", "Temperament"); var breedGroup = "";var tempGroup = "";var message = "";var message2 = ""; //Filtered listsvar filteredDogList = [];var filteredTemperamentList = []; //Filtered list to filter filteredDogListvar filteredDogList2 = []; //Button to filter the dogs by breed and takes you to the next screen that displays the filtered dogsonEvent("nextButton", "click", function( ) {breedGroup = getText("breedDropdown");setScreen("dogTypesScreen");filter();updateScreen1();}); //Button to sort the filtered dogs by temperament and takes you to the next screen that displays themonEvent("temperamentButton", "click", function( ) {tempGroup =…
The stack that based on linked list has Select one: a. No data attributes b. Two data attributes c. One data attribute d. Three data attributes
Delete the index named ITEM_INDEX3.
True or False For each statement below, indicate whether you think it is True or False. If you like, you can provide a description of your answer for partial credit in case you are incorrect. 5) Update is O(n) because it needs to perform a search for the element in the list 6) In the delete algorithm, the “previous” node reference is needed in case the element is not found in the list 7) Appending a new node to the end of the list is O(log n) 8) If the data is sorted in a Linked List, you can use binary search to find an element and its performance is O(log n)
Review concepts for VB.net: Please explain the following concepts (what they do and how to use them): - dvgList.DataSource = query.ToList - dgvList.CurrentCell = Nothing - dgvList.Columns(“name”).HeaderText = “Student Name” - dgvList.RowHeadersVisible = True or False
Mr. Patrick is fond of reading books he is looking for a computerized way to keep record of hisbook collection, you have been given the responsibility to meet up his following requirements.(Use appropriate data structure to accomplish your task), develop following methods:1. Add(): adds a new book to the list ( A book contains name of the book, author name)NOTE: every new book will have access to its neighboring books (previous and next)2. Remove():in case any book is removed from the pile update your list3. countBooks(): displays the total number of books 4. search(): returns true if the given book is present in the list else returns false 5. display(): shows the book collection
You were hired to create a registration system for the athletes of Oman Sports Association. The program will start by asking the team name, the game name, and the number of players. The number of players will indicate the number of times registration fee is to be entered by the user. Store the registration fee in a list called Registration. The uniform allowance has a fixed value of 12 OMR. Compute for the accident insurance. If the registration fee is more than 175 OMR, the accident insurance is computed as 85% of the registration fee, otherwise it is 50% of the registration fee. Store the computed accident insurance in a list called Insurance. Finally, compute for the team allowance which is computed as registration fee plus accident insurance plus uniform allowance. Store the team allowance in a list called Allowance. Display the following: a. Value of the three lists. b. Highest allowance c. Lowest accident insurance d. Sum of all registration fee
Create a list to save the elements and search if a specific key is in the list. Header file typedef struct list { int array[100]; int size; }SqList; Source file #include <stdio.h> #include <stdlib.h> #include "list.h" void create(SqList *l)//create the sequential list of n elements { } void seqSearch(SqList *l, int key)//sequential search { } void binSearch(SqList *l, int x)//binary search { } void main()//main function { SqList *L; L=(SqList *)malloc(sizeof(SqList)); }
How do you index a CLOB datatype for faster search operations?
snapshot of the complete trace table. you should show a column for the array since its elements' values will change. Just abbreviate it to [4,2,3] for example.
Lists at_bus_stop and on_board are read from input, representing passengers waiting to board a bus and passengers on the bus, respectively. Perform the following tasks: Remove the first element from at_bus_stop and output 'Passenger left bus stop: ' followed by the element. Add all the remaining elements of at_bus_stop to the end of on_board.
C sharp Table: Student (the headers are the field names in the Students table) StudentID Name Age Gender ProgramID 791 Stephanie Brown 19 Female BCS 236 Shannon Dawn 25 Female BA 618 Geoff Berg 24 Male ARET 256 Andrew Schilling 22 Male BSC 902 Gary Sang 23 Male DAAD Note: There is a StudentDataSet with a Student table, a StudentTableAdapter, a StudentBindingSource, and a StudentDataGridView control on the form.Note: There is an Average query, named Average, that returns the average age of the student from the Student table.Note: There is also Max query, named Highest, that returns the highest age of the student from the Student table.Write the code you would place in the AverageButton click event on your form to call the Average query and the Highest query and display in a DifferenceLabel, the difference between the highest age of a student and the average age.