Which of the following creates a data frame? import panda as pd df = pd.DataFrame(data=['A'= {10, 100}, 'Z'= {20, 400} ] ) b. df = pd. DataFrame (data={'A'= [10, 100], 'Z'= [20, 400] } ) Oc. df = pd.DataFrame(data=['A': [10, 1001, 'Z': [20, 400] ] ) d. df = pd.DataFrame(data={'A': [10, 100], 'Z': [20, 400] } ) Which of the statements below change the value of "A" in this dictionary from 1 to 2? {"A": 1} Oa. dict[0] = 2 O b. dict["A": 21 Oc. dict += 1 Od. dict["A"] = 2

Which of the following creates a data frame? import panda as pd df = pd.DataFrame(data=['A'= {10, 100}, 'Z'= {20, 400} ] ) b. df = pd. DataFrame (data={'A'= [10, 100], 'Z'= [20, 400] } ) Oc. df = pd.DataFrame(data=['A': [10, 1001, 'Z': [20, 400] ] ) d. df = pd.DataFrame(data={'A': [10, 100], 'Z': [20, 400] } ) Which of the statements below change the value of "A" in this dictionary from 1 to 2? {"A": 1} Oa. dict[0] = 2 O b. dict["A": 21 Oc. dict += 1 Od. dict["A"] = 2

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

IN C++ Write a program that reads movie data from a CSV (comma separated values) file and output the data in a formatted table. The program first reads the name of the CSV file from the user. The program then reads the CSV file and outputs the contents according to the following requirements: Each row contains the title, rating, and all showtimes of a unique movie. A space is placed before and after each vertical separator ('|') in each row. Column 1 displays the movie titles and is left justified with a minimum of 44 characters. If the movie title has more than 44 characters, output the first 44 characters only. Column 2 displays the movie ratings and is right justified with a minimum of 5 characters. Column 3 displays all the showtimes of the same movie, separated by a space. Each row of the CSV file contains the showtime, title, and rating of a movie. Assume data of the same movie are grouped in consecutive rows. Hints: Use the find() function to find the index of a comma in each…
3. In file 'R-Factor-Basics.docx', page 4, use the factor() command to modify the column dat$Group so that the control group is plotted last.e
Attached File: a2provided: grades = [[71, 14, 41, 87, 49, 93],[66, 73, 54, 55, 94, 79],[20, 51, 77, 20, 86, 15],[79, 63, 72, 57, 63, 73],[30, 66, 78, 65, 41, 45],[11, 83, 51, 47, 68, 63],[99, 43, 85, 86, 24, 75],[67, 102, 11, 84, 64, 109],[16, 24, 101, 78, 55, 89],[100, 26, 37, 95, 106, 100],[55, 77, 30, 34, 28, 15],[87, 67, 13, 71, 67, 83],[95, 65, 94, 56, 15, 92],[102, 23, 36, 39, 60, 39],[90, 59, 96, 105, 83, 16],[101, 40, 17, 12, 44, 36],[39, 63, 96, 12, 65, 82],[95, 20, 105, 34, 69, 95],[95, 93, 75, 18, 105, 102],[35, 15, 82, 106, 73, 30],[80, 52, 67, 49, 11, 88],[86, 17, 44, 75, 78, 49],[22, 60, 74, 110, 92, 37],[13, 14, 15, 82, 75, 57],[71, 106, 15, 77, 30, 98],[43, 80, 76, 85, 102, 53],[26, 98, 60, 80, 104, 79],[12, 28, 40, 106, 88, 84],[82, 75, 101, 29, 51, 75],[20, 31, 84, 35, 19, 85],[84, 63, 56, 101, 83, 102],[25, 106, 36, 24, 61, 80],[86, 75, 89, 47, 28, 27],[38, 48, 22, 72, 53, 83],[70, 34, 46, 86, 32, 58],[83, 59, 38, 16, 94, 104],[62, 110, 13, 12, 13, 83],[90, 59, 55,…
5 Import tips.csv. This dataset has a column named sex. Write a function named recode gender that has one parameter (gender) and will recode Male to 0 and Female to 1, and will return np. nan if the value is neither Male nor Female. Apply this function to the column sex of tips using apply (). Print the first five lines of the new dataframe. Code and Output
JAVA Script Create a form that has a last name, a first name, an email address, a drop-down listing of 10 cities in Massachusetts. The list is to be sorted (hint: think array), an email address, and a zip code field. Each field is to be process through a validation function. You may use one function for each but if you are creative you should be able to use just one function. The drop-down listing will not require validation because they will be choosing from a list that you are providing. This input from must be styled and show an effect to the user as to which field that are currently providing input.
def print_table( values: tuple[float, ) -> None: ], drag_coeff: float, increments: int, step: float 3 4 Parameters: 6 values (tuple[float, ...]): mass, force, ref_area, density, init_velocity, lift_velocity, start_position, time_inc drag_coeff (float): The drag coefficient. increments (int): The number of drag coefficients displayed. step (float): The difference between each drag coefficient. 8 9 10 11 12 Returns: 13 None 14 II II 15 For this function you need to compute the distance before lift-off for a range of drag coefficients and then you need to print these results in a table. The drag coefficient of an aeroplane has a significant impact on the plane's ability to lift-off. If the drag coefficient is sufficiently high, the plane will not actually be able to generate enough speed to lift off. In this task you will write a function which will explore this phenomenon.
PYTHON CODE Using Artists.csv (link below), write a query that returns all lines that are female artists only, with begin date greater than 1950 but no greater than 2000 Write a query that will return all lines of British Male artists, who's first names starts with the letter ‘A’ and has an end date earlier than 1990 Write a query that will write to a file all lines that have Japanese Artists who’s difference of end date and begin date exceeds 100 years. I.e. if artist begins in 1900 and ends in 2005, then they would be included in the output (2005-1900 = 105 years) Write a query that will write and find to a file the artist who’s been at the Museum the longest (the widest gap between Begin Date and End Date) Artists.csv: https://media.githubusercontent.com/media/MuseumofModernArt/collection/master/Artists.csv
In Python Write a program that reads movie data from a CSV (comma separated values) file and output the data in a formatted table. The program first reads the name of the CSV file from the user. The program then reads the CSV file and outputs the contents according to the following requirements: Each row contains the title, rating, and all showtimes of a unique movie. A space is placed before and after each vertical separator ('|') in each row. Column 1 displays the movie titles and is left justified with a minimum of 44 characters. If the movie title has more than 44 characters, output the first 44 characters only. Column 2 displays the movie ratings and is right justified with a minimum of 5 characters. Column 3 displays all the showtimes of the same movie, separated by a space. Each row of the CSV file contains the showtime, title, and rating of a movie. Assume data of the same movie are grouped in consecutive rows. Ex: If the input of the program is: movies.csv and the contents…
save_compressed_image: takes a nested list and a filename (string) as input, and saves it in the compressed PGM format to a file with the given filename. If the image matrix given as input is not a valid compressed PGM image matrix, instead raise a AssertionError with an appropriate error message. >>> save_compressed_image([["0x5", "200x2"], ["111x7"]], "test.pgm.compressed") >>> fobj open("test.pgm.compressed", 'r') >>> fobj.read() = 'P2C\\n7_2\\n255\\n0x5 200x2\\n111x7\\n' >>> fobj.close() >>> image [["0x5", "200x2"], ["111x7"]] >>> save_compressed_image(image, "test.pgm") >>> image2 = >>> image True = == load_compressed_image("test.pgm") image2 • save_image: takes a nested list and a filename (string) as input. Checks the type of elements in the list If thou are intogors thon saves the posted list as a PCM imago matrix into a file with the given
File names: color_square.py, chessboard.py, test_squares.py Positions on a chess board are identified by a letter and a number. The letter identifies the column; the number identifies the row. See the image below. You will provide the functions that allow us to determine: if a chessboard square is either black or white, given its coordinates. If the row/column is valid or not for the standard chessboard For example, if we pass in “d” for the column and 4 for the row, your function that determines color should return the string: “BLACK”. If we pass in "k" for the column to your function that validates columns, that function should return the boolean False. Requirements: Your function for validating the column should be able to accept upper or lowercase strings as parameters. Your functions for validating the row should be able to accept integers or strings as parameters. Your function that determines black-or-white may assume that the input has been validated prior to us calling…
Which of the following data structures cannot hold non-homogeneous data items?
1. The timeclock.txt file contains the hours worked data for every employee as well as the shift they worked. The layout for the file is as follows: EMPLOYEE NUMBER, HOURS WORKED, SHIFT 2. The personnel.txt file contains the names of all employees and their hourly pay rates. The layout for the file is as follows: EMPLOYEE NUMBER, EMPLOYEE NAME, PAY RATE Note: Both the timeclock.txt and payroll.txt files are pre-sorted by EMPLOYEE NUMBER in ascending order. Business Rules 1. For hours <= 40, the employee gross pay is: HOURS WORKED PAY RATE 2. For hours> 40, the employee gross pay is: HOURS WORKED PAY RATE 1.5 3. For shift 3, add $1 per hour to the employee pay rate The program should: 1. Download both input files in the same folder that you will create your .py program. 2. Read both input files together. 3. Match the input files by the EMPLOYEE NUMBER. 4. For each record in the timesheet.txt file, write a record in a new output file named payroll,txt based on the business rules…