Create a table using a two-dimensional list that stores a Fahrenheit temperature and the equivalent Celsius temperature. Use the following range of Fahrenheit temperatures: -10 through 100 in increments of 10. Thus the temperatures will be: -10, 0, 10, 20, 30, 40, 50, etc. Display the contents of the list. Similarly create tables/lists for: Miles to kilometers Gallons to liters Pounds to kilograms d. Inches to centimeters Starting at 0 through 100 in increments of 10. Display the contents of each list.

Create a table using a two-dimensional list that stores a Fahrenheit temperature and the equivalent Celsius temperature. Use the following range of Fahrenheit temperatures: -10 through 100 in increments of 10. Thus the temperatures will be: -10, 0, 10, 20, 30, 40, 50, etc. Display the contents of the list. Similarly create tables/lists for: Miles to kilometers Gallons to liters Pounds to kilograms d. Inches to centimeters Starting at 0 through 100 in increments of 10. Display the contents of each list.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter3: Performing Calculations With Formulas And Functions

Section: Chapter Questions

Problem 3.9CP

See similar textbooks

Similar questions

Given numRows and numColumns, print a list of all seats in a theater. Rows are numbered, columns lettered, as in 1A or 3E. Print a space after each seat, including after the last. Ex: numRows = 2 and numColumns = 3 prints: 1A 1B 1C 2A 2B 2C
1 Date: Create a list of lists. The individual lists should contain, in the correct order, the height (in inches), the weight (in pounds) and the age of the baseball players. Heights: 74 74 72 72 73 69 69 71 76 71 73 73 74 74 69 70 73 75 78 79 Weights: 180 215 210 210 188 176 209 200 231 180 188 180 185 160 180 185 189 185 219 230 Ages: 23 35 31 36 36 30 31 36 31 28 24 27 24 27 28 35 28 23 23 26 Convert the list of lists into a NumPy array named np_baseball. Using NumPy functionality, convert the unit of height to m and that of weight to kg. Print the resulting array.
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
8. Use an expression of the form listOfLists Table[Table ... ] so that listOfLists // TableForm produces the following: 10 6 8 10 8 10 9 7 6 10 8. 7 6 4 10 9 8. 7 6. 4 3 2 10 9 8 7 6 5 4 3 2 1 0
Build a list of contacts for New Jersey manufacturers as follows: ContactFirstName, ContactLastName, Phone. HINT: To do this you will need to split the contact name into two columns. You will need to embed string functions within string functions. It may be helpful to use Substring and Charindex. For last name, you can use a literal of 20 characters as the length to ensure you pick up all the characters to the end of the field.)
b. ID: A Name: 0. A summer camp offers a morning session and an afternoon session. The list morningList contains the names of all children attending the morning session, and the list afternoonList contains the names of all children attending the afternoon session. Only children who attend both sessions eat lunch at the camp. The camp director wants to create lunchList, which will contain the names of children attending both sessions. The following code segment is intended to create lunchList, which is initially empty. It uses the procedure IsFound (list, name), which returns true if name is found in list and returns false otherwise. FOR EACH child IN morningList 11 Which of the following could replace so that the code segment works as intended? IF ((IsFound (morningList, child)) OR (IsFound (afternoonList, child))) IF (ISFound (afternoonList, child)) APPEND (lunchList, child) APPEND (lunchList, child) a. { C. IF (IsFound (lunchList, child) ) IF (IsFound (morningList, child)) APPEND…
The Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020. -- Your SELECT statement goes hereSELECT *FROM HorseWHERE (Height >= '15.0' AND Height <= '16.0') OR BirthDate >= '2020-01-01';
Write code to find the number of students who Fail/pass in CS course, if the passing mark is40. The list has 150 students.
The Movie table has the following columns: ID - positive integer Title - variable-length string Genre - variable-length string RatingCode - variable-length string Year - integer Write ALTER statements to make the following modifications to the Movie table: Add a Producer column with VARCHAR data type (max 50 chars). Remove the Genre column. Change the Year column's name to ReleaseYear, and change the data type to SMALLINT.
LAB - Select horses with logical operators The Horse table has the following columns: • ID integer, primary key • RegisteredName - variable-length string • Breed - variable-length string • Height-decimal number • BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020.
Fill in the loop table with the correct values, Each row should represent the values of the variables at the line with the comment LOCATION. You don't necessarily need to fill out all of the rows on the provided fable. If you don't fill up the whole table, that isn't necessarily wrong! 1 - 2 a - 10 name - 'AL' while i < 9: if name 'AL': 1: 2 nam AL intinl else: if name < 'NAPOLEON': name - 'NASH elif name < 'NATE': name - 'SAM' else: name- 'AL ' # LOCATION
Generate a table of conversions from inches to centimeters. Start the inches column at 0.0 and increment by 0.5 in. The last line should contain the value 20.0 in. (Recall that 1 in = 2.54 cm.) Include a table heading and column headings for the tables.