E LOW yur u0 LIIIS by CredLing %23 storing a list containing your class mates details in each element of the list. # EXTENSION # 1. Research dictionaries in Python, create a copy of the file and re-write the code using a dictionary instead. # 2. Explain which is more suited to the task # Create empty list called 'database' to hold each record database = [] # Create an empty list to store the details of each student # Boolean value used to check if data entry is complete data_complete = False # loop whilst data entry is not complete while not data_complete: # get student information and add it to the list 'student' # this should include name, age, nationality and favourite colour # add a copy of the list 'student' to list 'database' - if you don't make it a copy, all the data will be the same!! # clear the list 'student' of any data ready for next data entry # check if data entry is complete option = input("Is data entry complete? y/n \n").lower() # update Boolean value only if user enters 'y'

E LOW yur u0 LIIIS by CredLing %23 storing a list containing your class mates details in each element of the list. # EXTENSION # 1. Research dictionaries in Python, create a copy of the file and re-write the code using a dictionary instead. # 2. Explain which is more suited to the task # Create empty list called 'database' to hold each record database = [] # Create an empty list to store the details of each student # Boolean value used to check if data entry is complete data_complete = False # loop whilst data entry is not complete while not data_complete: # get student information and add it to the list 'student' # this should include name, age, nationality and favourite colour # add a copy of the list 'student' to list 'database' - if you don't make it a copy, all the data will be the same!! # clear the list 'student' of any data ready for next data entry # check if data entry is complete option = input("Is data entry complete? y/n \n").lower() # update Boolean value only if user enters 'y'

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

(PYTHON) a) get_total_cases() takes the a 2D-list (similar to database) and an integer x from this set {0, 1, 2} as input parameters. Here, 0 represents Case_Reported_Date, 1 represents Age_Group and 2 represents Client_Gender (these are the fields on the header row, the integer value represents the index of each of these fields on that row). This function computes the total number of reported cases for each instance of x in the text file, and it stores this information in a dictionary in this form {an_instance_of_x : total_case}. Finally, it returns the dictionary and the total number of all reported cases saved in this dictionary. (Suppose we want to know the total number of cases reported on each date, so use x = 0.) >>> result, total_cases = get_total_cases(database, 0) >>> display_dict(result) 2021-05-19: 8 2021-05-20: 2 2021-05-21: 1 2021-05-22: 1 >>> print(total_cases) 12
Hi, can you do it in PYTHON def delete_item(...): """ param: info_list - a list from which to remove an item param: idx (str) - a string that is expected to contain an integer index of an item in the in_list param: start_idx (int) - an expected starting value for idx (default is 0); gets subtracted from idx for 0-based indexing The function first checks if info_list is empty. The function then calls is_valid_index() to verify that the provided index idx is a valid positive index that can access an element from info_list. On success, the function saves the item from info_list and returns it after it is deleted from info_list. returns: If info_list is empty, return 0. If is_valid_index() returns False, return -1. Otherwise, on success, the function returns the element that was just removed from info_list. Helper functions: - is_valid_index() """
A list is ... Select one: a. a unordered collection of data values, were each value is identified by an index. b. a sequential collection of data values, storing index values c. a sequential collection of data values, were each value is identified by an index. d. a sequential collection of data values, storing index valued.
Create a list with 5 items having 3 distinct data types: -output the second element of the list -output the last element of the list using -negative index -positive index -len method Task 2 -Create a list with 3 items -add an item to the end of the list -remove the first item of the list -determine if an item exists in the list -if it does, display its index -if it does not, give user message Task 3 -Create a list of doubles (the data type double, minimum 3 values) -output the minimum value -output the maximum value Task 4 -Create an empty list -Ask the user for any input 5 times -Only add the input to the list if it does NOT already exist Task 5 -Ask the user for input 3 times -Convert the inputs into a tuple -Output the tuple Task 6 Ask the user for 3 inputs starting number ending number increment number using for loop output each number from 0 to starting number output each number from 1 to starting number output each number from starting number…
Dictionary-Returned Functiona) Define a function, dictSqrt() with a parameter, x: 1) Create a list, num and uses a loop to store, x numbers into the list in the range of (0, x). 2) Create a list, sqrtNum and store all sqrt of the numbers saved in the list above. 3) Use dict() and zip() to create a dictionary, sqrtDict, as the return value with numbers as the keys and their corresponding sqrt as the values.b) Define a main() function to do the following: 1) Get a random integer, n, in the range (1, 10).2) Call dictSqrt() with the argument and print the returned dictionary.c) Call main() function to initiate the tasks to be performed. Example OutputdictSqrt(3)will print the following:{0:0, 1:1, 2:1} PYTHON
File Analysis USING PYTHON- DICTIONARY NOTE FIND ATTACHED BELOW 2 FILES THA SHOULD BE USED FOR THIS ASSIGNMENT Using python, Write a program that reads the contents of two text files and compares them in the followingways:It should display a list of all the unique words contained in both files.It should display a list of the words that appear in both files.It should display a list of the words that appear in the first file but not the second.It should display a list of the words that appear in the second file but not the first.It should display a list of the words that appear in either the first or second file, but notboth.Hint: Use set operations to perform these analyses. ATTACHED FILES first FILENAME: first_file.txt The quick brown fox jumps over the lazy dog. Second FILENAME: second_file.txt Jack be nimble, Jack be quick, Jack jump over the candlestick. . For the program, you need to write: Comments for all the values, constants, and functions IPO Variables Pseudocode
A python dictionary, Bank, is created to keep track of the Current Account and the Savings Account for each client in a bank. While the first item in the list is for the current account, the second item is for the savings account. The client’s name acts as the key for this dictionary.Bank = {"Apple":[100.0, 1500.0],"Bobby":[200.0, 4000.0],"Cathy":[150.0, 3500.0],"David":[300.0, 2500.0]}Write the following functions for the dictionary Bank to maintain the clients’ current and savings accounts.1. Function printBank( ): print out the contents of the dictionary Bank2. Function deposit(Name, account_type, amount): deposit the amount of money to the account specified by the account_type under the client’s name.3. Function withdraw(Name, account_type, amount): withdraw the amount of moneyfrom the account specified by the account_type under the client’s name.4. Function creatAccount(Name): create a new entry in the dictionary and initialize both the current and savings accounts to 0.0 under…
Computer Science Client Number Address Zipcode 123 ABC 11111 124 ABD 11112 125 ABE 11114 126 ABF 11115 I have been able to export the file to python and convert it to dataframe. DataFrama being "df". How can I write an argument, where if a Zipcode is outside of a list [11111,11112,11113,11114] then it is a red flag. Thank you!
(python) 26. To delete the element 3 in a list, use the following command: a. del list[3] b. del list[4] c. list.remove(3) d. list.remove(4)
Need help with this: Given the following challenges, use append(), extend(), pop(), and insert()to change the contents of the lists. Suppose that we have the following list: Strawberry, Blueberry, Blackberry, Cranberry Define the list berries with the following elements shown in Snippet 5.11: Strawberry, Blueberry, Blackberry, Cranberry Using the built-in append() method, add the value Raspberry to the list berries. Using the built-in extend() method, extend an empty fruits list from the berries list that you created previously. Insert Mangoes into the fruits list at index 2 using the built-in method insert(). Remove the element at index 1 from the fruits list using the built-in method pop() and replace it with Apples, using the insert() built-in method. Finally, sort the elements in the fruits list by using the built-in method sort() with keyword arguments. Set the key argument to None and the reverse argument to False.
Which of the basic data structures is the most suitable if you only need to insert the elements in the back and to extract elements from the front? A. Array B. Queue C. Stack
Use python Pandas: DataFrames : Perform the following tasks with pandas DataFrames: a. Create DataFrame names temperatures from a dictionary of six temperature reading each for “A”, “B”, “C”, “D”, “E”, and “F”. b. Recreate the DataFrame temperatures in Part (a) with custom indices using the index keyword argument and a list containing ‘M’ ‘Afn’, and ‘Eve’. c. Select from temperatures the column of temperature reading for C d. Select from temperatures the column of temperature reading for A, and B e. Select from temperatures the row for ‘M’ and ‘Afn’ temperature reading