a) Make an array X that has the same data as the above table (shape of X: (4, 6)). Check whether the shape of X is (4, 6) by using assert () function. (Note: assert (cond) gives an error if cond is not true.) b) Then, extract 4 parameters (size, # of bedrooms, floors, age of house) from X and put them into a new matrix P. Check if the shape of P is (4, 4) by using assert () function. c) Find the mean value of each parameter using the numpy mean function.

a) Make an array X that has the same data as the above table (shape of X: (4, 6)). Check whether the shape of X is (4, 6) by using assert () function. (Note: assert (cond) gives an error if cond is not true.) b) Then, extract 4 parameters (size, # of bedrooms, floors, age of house) from X and put them into a new matrix P. Check if the shape of P is (4, 4) by using assert () function. c) Find the mean value of each parameter using the numpy mean function.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Assign letter grades O solutions submitted (max: 1) In the attached spreadsheet, you are given homework grades of 25 students. Sheet 1 (hw1) stores the first homework grades, Sheet 2 (hw2) is the second homework grades and so on. Use either xlsread() or readmatrix() to import the given data into Matlab. Once you have the data in Matlab; 1- Create separate arrays for each homework, name them as hw1, hw2, hw3, hw4, hw5 2- Create an average grade array named hwAvg. Store the average homework grade in hwAvg using the below weights Homework 1, 2: each 15% Homework 3, 4 : 20% Homework 5: 30% 3- Create an array named letterGrade to store letter grades, this will be an array of strings. • 4- Preallocate the letterGrade array. Make sure it has the same length as hwAvg array. 5- Assign letter grades from hwAvg array using the grading policy shown below 100 - 90 : A <90 - 80 : B <80 - 70:C <70 - 60 : D <60 :F It is recommended that you download the file, see what it looks like, figure the steps…
Below is the exercise for unsorted arrays. True or False: For each statement below, indicate whether you think it is True or False 3) For the insert function, if the array is empty, there are no comparison operations that need to be performed and you can immediately add the new element 5) Because the update algorithm depends on using linear search, its performance is O(1) in the worst case scenario 6) If you search for and delete an element in an unsorted array and then shift the rest of the elements to fill the hole, the worst case performance is O(n) 7) If you search for and delete an element in an unsorted array and then move the last element to fill the hole, the worst case performance is O(n)
Question 2 Write a function called "AddRows" that accepts two parameters: M1: a matrix of size 6x4 elements of type integer A1: a one dimensional array of size 4. For each column in M1, the function will calculate and store in the corresponding element of array A1, the sum of the elements located in odd rows of M1. For Example if M1 = 1 7 12 4 7 6. 8 10 2 10 8 4 5 12 12 10 Then A1 = 18 31 22 17 3.
There is an array with n integers, but the values are hidden to us. Our goal is to partition the elements in the same group should have the same value, 4. elements into groups based on their values while elements in different groups have different values. The values are hidden to us so you cannot directly call for a value, like Arr[i]. However, we can probe the array by calling the function query(). The function takes a subset of elements as inputs and returns the number of unique integers in this subset. Design an algorithm to partition these n elements in O(nlog n) queries. (query() is called O(nlog n) times)
ASSIGNMENT: Working with Vectors Write a menu-driven program that will allow the user to run any of the following questions. Please put the functions headers in h file and the functions definitions in a .cpp file. 1. Write C++ code for a loop that simultaneously computes both the maximum and minimum element in a given vector. 2. Write a function double scalar_product(vector a, vector b) that computes the scalar product of two vectors. The scalar product of two vectors A[al, a2, a3) and B(bl, b2, b3} is another vector C given by C{c1, c2, c3} where cl = al * b1, c2 = a2 + b2, c3 = a3 + b3. 3. Write a function that computes the alternating sum of all elements in a vector. For example, if alternatingSum() is called with a vector containing 149 16 9 7 4 9 11 then it computes 1-4+9-16+9-7+4-9+11=-2 4. Write a procedure reverse that reverses the sequence of elements in a vector. For example, if reverse is called with a vector containing 1 49 16 9 7 4 9 11 then the vector is changed 11 9 4 7…
Study the scenario and complete the question(s) that follow: Two dimensional arraysA two-dimensional array is actually an array in which each element is a one-dimensional array. The length of an array x is the number of elements in the array, which can be obtained using length. x[0],x[1], . . . , and x[x.length − 1] are arrays. Their lengths can be obtained using x[0].length,x[1].length, . . . , and x[x.length − 1].length. Source: Liang D. (2018) Create a Java application that consists of two-dimensional array of 4 by 6. Assign the array to a matrix. Use any integer values for your matrix. Create three methods that will do the following: 3.1 Print out all the elements in the matrix. 3.2 Calculate the sum of each row of the matrix. 3.3 Calculate the largest number of each row of the matrix. 3.4 The main method must implement all three methods and output the results for each line.
Write a function (cubeArt) to cube the first N elements in an array of doubles. The function should be passed the array and the number of elements to be cubed (the value will be replaced with its third power, e.g., if an array element is 3, it will be replaced by 27). The function should return nothing.
Go to Sheet1. In cell C11 type a VLOOKUP function to find the corresponding letter grade for the score in B11. Use absolute references for the table array parameter (A4 to B8). Use FALSE for the range lookup parameter. Copy the formula in C11 to C12:C15Notice this formula only works correctly in C11 and C15. That is because you used FALSE for the range lookup parameter. FALSE means search for an exact match. The only scores in C11:C15 that exactly match values in the table array are 80 and 90. In cell D11 type a VLOOKUP function to find the corresponding letter grade for the score in B11. The table array parameter is the same as in C11. Do not type anything for the range lookup parameter. Copy the formula in D11 to D12:D15Notice this formula works correctly for all cells. The default value for the range lookup parameter is TRUE. (You could have typed TRUE and it would work the same way, However, why type when you don't need to?) TRUE means search for an approximate match - the last…
Modify sample program of parallel array attached here. Using this data: Assign names = ["Lisa", "Michael", "Ashley", "Jacob", "Emily"] Assign ages = [49, 48, 26, 19, 16]and will give an output of the names and corresponding age.
Using For-Loop and If-statement, find the smallest number divisible by 4 in the 1D array "a1". Do not use any shortcut functions. The code should be able to work with any 1D array of numbers | of any length. a1=np.array([-1,2,4,5,-10, 0, 4, 0,-8, 2.5, 2, 14])
Question 17 Aa .You are given a sorted list of n numbers stored in an array A, where n can be arbitrarily large. Now randomly generate a number k and search the number in the list (i.e., in A). Now randomly select two subarrays of A, each of size n^1/2 . Then repeat the same procedure on each of the subarrays. The procedure stops after the subarray sizes become 1. Analyze the time complexity of finding the total number of successful searches in the entire procedure using big O-notation Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line