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

import are as are# A dictionary for the simplified dragon text game# The dictionary links a room to other rooms.rooms = {'Great Hall': {'South': 'Bedroom'},'Bedroom': {'North': 'Great Hall', 'East': 'Cellar'},'Cellar': {'West': 'Bedroom'}}location = 'Great Hall' # set starting room# Based on the start room (a key), what is the corresponding dictionary value?print("\n", rooms[location])# Available directionsprint(rooms[location].keys())print(*rooms[location].keys())# Available roomsprint(rooms[location].values())print(*rooms[location].values())direction = ['South', 'North', 'East', 'West']# game loopwhile direction != "exit":print('\nYou are in the',location)possible_moves = rooms[location].keys()print('possible moves', *possible_moves)direction = input("Which direction should I go?").strip().lower()print('You chose to go:', direction)I am supposed to make a program to be able to move from room to room in python, and exit, how do I finish this is as far as I have completed
Overview This is a review assignment where you will use multiple tools you have picked up so far throughout the course. If you're confused about how to do something make sure you look back at earlier assignments. In this program you will start by declaring an empty dictionary named population_dict. Then you will use a while-loop to prompt a user for a series of cities and their populations, storing the input in population_dict). After this you will prompt the user to decide what is the maximum population for a city to be considers a small down. Finally, you will open a file called populationdata.txt where you will write the results. Expected Output Example of standard out (the console): What is next city? (enter q to quit) Long Beach What is the population of Long Beach? 362000 What is next city? (enter q to quit) Los Angeles What is the population of Los Angeles? 382000000 What is next city? (enter q to quit) San Diego What is the population of San Diego? 136000000 What is next city?…
Assume that the variable data refers to the dictionary {'b':20, 'a':35}. Write the expressions that perform the following tasks: a. Replace the value at the key 'b' in data with that value's negation. b. Add the key/value pair 'c':40 to data.c. Remove the value at key 'b' in data, safely. d. Print the keys in data in alphabetical order.
Assignment 1: Prompt the user for 5 pairs of numbers. The pairs consist of a player’s jersey number (0-99) and the player’s rating (1-9). Make sure to use good prompts and check the user’s input using a while loop. Do not stop the program if the input is outside the range. You need to prompt the user until they get the numbers correct. Store the pairs in a dictionary. Since the player’s jersey number is a key, you need to check for duplicates and prompt user again if the number is already in use. After all players are entered, print the roster with the jersey numbers in ascending order. Next, print a menu for the user to be able to modify the roster. They should be able to add a new player, remove a player, update a player’s rating, output a list of players above a rating (get the cutoff from the user), output the roster, or quit. You need to turn in a written algorithm for this project before starting to write the program. Assignment 2: Change assignment 1 to use functions.…
Overview This program will have you use a loop to prompt a user for three games and their systems and then store them in a dictionary called games_dict). Then it will ask the user for the worst game, delete that game, and print out the contents of the revised games_dict. Expected Output Example 1 What is a great game? Mario What system can I play that on? Nintendo What is a great game? Sonic I play that on? Sega What system can What is a great game? Spyro What system can I play that on? layStation That's too many, let's get rid of one What game should we remove? Sonic The new dictionary is: You can play Mario on Nintendo You can play Spyro on PlayStation Specifications • You should submit a single file called M4A3.py • It should follow the submission standards outlined here: Submission Standards • Your program should start by defining an empty dictionary called games_dict • It should populate games_dict using a for-loop • It should print out games_dict using a for-loop. Tips and Tricks…
Exercise: Least Dictionary Value Description In this exercise you will find the value in a dictionary with the least value. Least means that the value is less than or equal to all other values in the dictionary. Remember that the 2 Assistant Object inspector
def city_dict(adict): """ Question 6 -Given a dictionary that maps a person to a list of countries they want to travel to, return a dictionary with the value being the list sorted by the last letter in each countries name. If two countries have the same last letter, sort by the first letter. -For an extra challenge, try doing this in one line (Optional). Args: adict (dict) Returns: dict >>> city_dict({"Pablo": ["Belgium", "Canada", "Germany"], "Athena": ["Italy", "France", "Egypt"], "Liv": ["Japan", "Bolivia", "Greece"]}) {'Pablo': ['Canada', 'Belgium', 'Germany'], 'Athena': ['France', 'Egypt', 'Italy'], 'Liv': ['Bolivia', 'Greece', 'Japan']} >>> city_dict({"Jacob": ["Bahamas", "Brazil", "Chile"], "Lexi": ["Colombia", "Finland", "Panama"], "Emily": ["Ireland", "Russia", "Kenya", "Jordan"]}) {'Jacob': ['Chile', 'Brazil', 'Bahamas'], 'Lexi': ['Colombia', 'Panama', 'Finland'], 'Emily': ['Kenya',…
SOLVE WRITE_ELEVATION_MAPS: do NOT solve for GET_elevation_maps 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 anticipate or prevent any errors from happening at all!
Please code in python there's a dictionary original_dict = {'jack': 9, 'michael': 48, 'guido': 57, 'john': 33} . Using the generator of dictionaries create a new dictionary, all the entries need to be less than 40 and divide by 3 without the remainder.) (need to use if, multiple conditions)
Perform the following tasks: Create a dictionary named color_dict containing key-value pairs 'red': 222, 'green': 184, and 'blue': 135. Read strings key_read and value_read from input. Add key_read and value_read as a new key-value pair to color_dict with key_read as the key and value_read as the value.
# Create Custom Transformer Create a custom transformer, just as we did in the lecture video entitled "Custom Transformers", that performs two computations: 1. Adds an attribute to the end of the numerical data (i.e. new last column) that is equal to $\frac{x_1^3}{x_5}$ for each observation. In other words, for each instance, you will cube the $x_1$ column and then divide by the $x_5$ column. 2. Drops the entire $x_4$ feature column if the passed function argument `drop_x4` is `True` and doesn't drop the column if `drop_x4` is `False`. (See further instructions below.) You must name your custom transformer class `Assignment4Transformer`. Your class should include an input parameter called `drop_x4` with a default value of `True` that deletes the $x_4$ feature column when its value is `True`, but preserves the $x_4$ feature column when you pass a value of `False`. This transformer will be used in a pipeline. In that pipeline, an imputer will be run *before* this transformer. Keep…
Python Programming Assignment: Create a dictionary that takes a basketball team's information (that includes team's name and points) as parameter, creates a teams_dict and returns it. Also, create a parameter for write_file parameter that opens current results text file in write mode and writes the dictionary information to file as per format and closes the file.