Q1) Create a dictionary with the following key-value pairs, 'name' with 30 names 'age' with 30 values (generate 30 random integers from 18 to 70) 'height' with 30 values (generate 30 random integers from 150 to 200) 'weight' with 30 values (generate 30 random integers from 50 to 100) 'experience' with 30 values (generate 30 random integers from 2 to 8) (hint: you must use numpy library to generate the numbers) make a dataframe from a dictionary named df. write down a statement to get columns 'name', 'weight' and 'experience' write down statements to find the maximum, the minimum, the average, the median and the variance of column 'height'. ● ● ● ● ● ● ● write down a statement to sort the values of column 'experience and make the change permanent. write down statement to get the rows where the value of weight is greater than 77 and the value of height is a multiple of 5. Q2) Solve the system of linear equations using Python (use sympy library) 7x - 13y = 51 6x 19y 244

Q1) Create a dictionary with the following key-value pairs, 'name' with 30 names 'age' with 30 values (generate 30 random integers from 18 to 70) 'height' with 30 values (generate 30 random integers from 150 to 200) 'weight' with 30 values (generate 30 random integers from 50 to 100) 'experience' with 30 values (generate 30 random integers from 2 to 8) (hint: you must use numpy library to generate the numbers) make a dataframe from a dictionary named df. write down a statement to get columns 'name', 'weight' and 'experience' write down statements to find the maximum, the minimum, the average, the median and the variance of column 'height'. ● ● ● ● ● ● ● write down a statement to sort the values of column 'experience and make the change permanent. write down statement to get the rows where the value of weight is greater than 77 and the value of height is a multiple of 5. Q2) Solve the system of linear equations using Python (use sympy library) 7x - 13y = 51 6x 19y 244

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

Question: 1 A Special Number is a number when the sum of the factorial of digits is equal to the original number (given number). For example, 145 is a Special Number because 145 = 1! + 4! + 5!. Your task is to write a Python code that takes some numbers as user input (separated by a comma) in a single line and groups the Special & Non-Special numbers in a dictionary. Note that the values corresponding to the keys in that dictionary must be in tuple format. Sample Input 1: 145, 346, 2, 83221, 7999888 Sample Output 1: {'Special': (145, 2), 'Non-Special': (346, 83221, 7999888 )} ----------------------------------------------------------------- Sample Input 2: 1431, 69716, 353, 7969828 Sample Output 2: {'Special': (), 'Non-Special': (1431, 69716, 353, 7969828)}
In R, how to find the number of rows in an object? Please use the which statement
In Python: The following statement creates an empty dictionary Mydectionary = { } True False
Given array scorePerQuiz has 10 elements. Which assigns the 7th element with the value 8? answers: 1) scorePerQuiz[6] = 8; 2) scorePerQuiz = 8; 3) scorePerQuiz[0] = 8; 4) scorePerQuiz[8] = 7;
JAVASCRIPT ===================================== const numbers = [1, 2, 3, 4, 5, 6, 7, 9]; // Using map() to create a new array with nested arrays. The second element will be the current number * 2 // Using flat() to flatten the nested arrays // Using flatMap() to create a new flattened array //Print nested array /* [ [ 1, 2 ], [ 2, 4 ], [ 3, 6 ], [ 4, 8 ], [ 5, 10 ], [ 6, 12 ], [ 7, 14 ], [ 9, 18 ] ] */ //Print flattened array /* [ 1, 2, 2, 4, 3, 6, 4, 8, 5, 10, 6, 12, 7, 14, 9, 18 ] */ //Print flat mapped array /* [ 1, 2, 2, 4, 3, 6, 4, 8, 5, 10, 6, 12, 7, 14, 9, 18 ] */
using Python. Practice 9-2 continue to practice 9-1 and I will write the birthday dictionary because I couldn't take a pic of it birthday dictionary code # This program uses a dictionary to keep friends'# names and birthdays. # Global constants for menu choicesLOOK_UP = 1ADD = 2CHANGE = 3DELETE = 4QUIT = 5 # main functiondef main(): # Create an empty dictionary. birthdays = {} # Initialize a variable for the user's choice. choice = 0 while choice != QUIT: # Get the user's menu choice. choice = get_menu_choice() # Process the choice. if choice == LOOK_UP: look_up(birthdays) elif choice == ADD: add(birthdays) elif choice == CHANGE: change(birthdays) elif choice == DELETE: delete(birthdays) # The get_menu_choice function displays the menu# and gets a validated choice from the user.def get_menu_choice(): print() print('Friends and Their Birthdays')…
In Python:
Check the elements that are returned with the operation:SELECT[Airline="FlyRight" ^ Destination="Detroit"]
need help with python...paste indented code here... QUESTION 6 Implement the following: a) Create a dictionary, grades, and initialize it with the following data:'Jimmy': 66 'Jerry': 80'Jacob': 71'James': 59'Jenny': 90 b) Use a loop to print all items of the dictionary grades as follows:name receives grade A (if the value is 90 or above).name receives grade B (if the value is 80 or above).name receives grade C (if the value is 70 or above).name receives grade D (if the value is 60 or above).name receives grade F (if the value is below 60). Example OutputJimmy receives grade D.Jerry receives grade B.Jacob receives grade C.James receives grade F.Jenny receives grade A.
LAB RESTRICTIONS, PLEASE READ:Do not add any imports, the ones that you need will be given to you.You may not use any dictionaries or dictionary methods.Do not use try-except statements, you should be able to anticipateor prevent any errors from happening at all!"""
Arrays Write a for loop to print all elements in courseGrades, following each element with a space (including the last). Print forwards, then backwards. End each loop with a newline. Ex: If courseGrades = {7,9, 11, 10}), print: 7911 10 10 119 7 Hint: Use two for loops. Second loop starts with i = NUM_VALS - 1. (Notes) Note: These activities may test code with different test values. This activity will perform two tests, both with a 4-element array (int courseGrades[4]). See "How to Use zyBooks". Also note: If the submitted code tries to access an invalid array element, such as courseGrades[9] for a 4- element array, the test may generate strange results. Or the test may crash and report "Program end never reached", in which case the system doesn't print the test case that caused the reported message. #include using namespace std; int main() { const int NUM_VALS = 4; int courseGrades[NUM_VALS]; inti; for (i = 0; i > courseGrades[i]; /* Your solution goes here */ return 0; Please help me…
5-Fully explain the following code and draw all possible outputs. JavaScript Arrays The Array.join() method returns an array as a string. const fruits = ["Banana", "Orange", "Apple", "Mango"]; document.getElementById("demo").innerHTML = fruits.join();