Create a pandas DataFrame with two columns. The first column should be titled F for Fahrenheit, and should contain the numbers from 0 to 100, counting by fives. The second column should be titled C for Celsius, and contain the corresponding temperature in degrees Celsius for the number in the first column.

Create a pandas DataFrame with two columns. The first column should be titled F for Fahrenheit, and should contain the numbers from 0 to 100, counting by fives. The second column should be titled C for Celsius, and contain the corresponding temperature in degrees Celsius for the number in the first column.

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter8: Working With Trendlines, Pivottables, Pivotcharts, And Slicers

Section: Chapter Questions

Problem 8EYW

See similar textbooks

Similar questions

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…
Create a mailing list from the CUSTOMERS table. The mailing list should display the name, address, city, state, and zip code for each customer. Each customer’s name should be listed in order of last name followed by first name, separated with a comma, and have the column header “Name.” The city and state should be listed as one column of output, with the values separated by a comma and the column header “Location.”
Create a new workbook as shown below and save the file with the name "Call Statistics". 1 Panda EST Monthly Sales Report - July 2 3 Sales Amount 1600 1800 Total Salary 4 Emp. No. Name 5 S101 6 S105 7 S112 8 s107 9 S110 Salary Comission 2500 ? 3000 Ahmed Hassan Ali 1500 2200 Waleed Mohammed Samir 4500 3500 2000 1700 10 s103 1600 2500 11 Totals Average Highest Lowest Count 12 13 12 14 15 16 a) Create the worksheet shown above. b) Set the column widths as follows: Column A: 8, Column B: 14, Columns C & D: 15, Columns E & F: 14. c) Enter the formula to find COMMISSION for the first employee. The commission rate is 2% of sales, COMMISSION = SALES * 2% Copy the formula to the remaining employees. d) Enter the formula to find TOTAL SALARY for the first employee where: TOTAL SALARY = SALARY + COMMISSION Copy the formula to the remaining employees. e) Enter formula to find TOTALS, AVERAGE, HIGHEST, LOWEST, and COUNT values. Copy the formula to each column. f) Format numeric data to include…
Some rows of the STUGRADE table of a school are shown below: STU_CODE CLS_CODE GRADE YEAR 291 111 3.1 2010 938 101B 2.3 2011 931 M101 3.3 2040 291 M101 3.4 2018 190 111 2.0 2021 931 321 3.9 2003 You want to show all STU_CODE with average grades higher than 3.0. Which of the following gets the required data? a. SELECT STU_CODE, AVG(GRADE) FROM STUGRADE WHERE AVG(GRADE) > 3.0 GROUP BY STU_CODE b. SELECT STU_CODE, AVG(GRADE) FROM STUGRADE WHERE GRADE > 3.0 GROUP BY STU_CODE c. SELECT STU_CODE, AVG(GRADE) FROM STUGRADE GROUP BY STU_CODE HAVING AVG(GRADE) > 3.0 d. SELECT STU_CODE, AVG(GRADE) FROM STUGRADE WHERE AVG(GRADE) > 3.0 AND STU_CODE GROUP BY STU_CODE
The wine data, whose first few rows are shown below, provides information on wine stocked by an online retailer, but is missing the year of the vintage. Add the year column to the data. The vector of years has been created for you. # A tibble: 6 x 5 style type country price rating 1 malbec red argentina 19.0 4.2 2 alvarinho white portugal 19.0 4.2 3 riesling 4 pinot noir white germany 17.0 4 red germany NA 4 5 primitivo red italy 18.0 4.2 6 valpolicella red italy 19.4 4.1 Complete the code to return the output library(dplyr) years % write code here write code here = years) head (wine)
In this assignment, you should work with books.csv Download books.csvfile. This file contains the detailed information about books scraped via the Goodreads . The dataset is downloaded from Kaggle website. Each row in the file includes ten columns. Detailed description for each column is provided in the following: bookID: A unique Identification number for each book. title: The name under which the book was published. authors: Names of the authors of the book. Multiple authors are delimited with -. average_rating: The average rating of the book received in total. isbn: Another unique number to identify the book, the International Standard Book Number. isbn13: A 13-digit ISBN to identify the book, instead of the standard 11-digit ISBN. language_code: Helps understand what is the primary language of the book. num_pages: Number of pages the book contains. ratings_count: Total number of ratings the book received. text_reviews_count: Total number of written text reviews the book received.…
HW7_3 Ball bearings are hardened through a process known as quenching-submersion of the heated ball bearing in oil or water in order to cool it rapidly. The data below represent the temperature of the ball at various points in the cooling process time (sec) 0 30 Temp (C) 800 457 269 79 46 60 150 240 Plot the data (as discrete points). In the same figure window, also plot a) interpolating polynomial, (use polyfit and polyval) b) piecewise cubic interpolation (not-a-knot) and c) piecewise cubic interpolation (shape-preserving) Include a legend for the three methods used: polynomial interpolation, not-a-knot, shape-preserving. Then looking at the plot, choose the method you believe to be the best and smoothest fit of all these to predict the temperature after 3 minutes of cooling. Print the result using fprintf.
Given below the 1question.
Create a table of your courses for this semester with fictitious grades for Test 1, Test 2, and Test 3 with appropriate weighting. The next column should determine the grade using the 'if' function, with plus and minus. The grade cell should show a discrete color scheme with below C- in red; above B in green and, yellow for the rest. This should be done using conditional formatting of cells.
Q1. Write a reference, in VBA code, to each of the following ranges. (You can assume that each of these ranges is in the active worksheet of the active workbook, so that you don’t have to qualify the references by worksheet or workbook.) Here’s an example. Question: The cell one column to the right and two rows below Cell A1. Answer: Range (“A1”).Offset(2,1) The fifth cell of the range B1:B30. The cell at the intersection of the 25th row and 5th column of the range A1:Z100. The cell at the intersection of the 25th row and 5th column of the range that has been set to a Range object variable named SalesRange. The entire column corresponding to cell C5. A range of employee names, assuming the first is in cell B2 and they extend down column B (although you don’t know how many there are). Q2. Write a VBA program (consisting of a single subroutine) to check existence of a given value in a list. Specifically, you are given a list of product IDs in column A, as follows: You don’t know…
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.
1- Display contact First name and contact Last name for customers after sorting the customersby their contact Last name in ascending order.2- selects the order line items (orderNumber, orderlinenumber) from the “orderdetails” table.Also, display the subtotal (quantityOrdered * priceEach) for each line item and sorts the resultset based on the subtotal descending .3- Display unique last names from employees table ordered by last name.4- Display customerNumber, customerName and creditLimit for getting the top five customerswho have the highest creditLimit.5- Find customer Name, customer country, sales representative employee number fromcustomers who do not have a sales representative.6- For each order status, display status and count of orders have this status.7- For Each order number in order details table, Display order number, sum of quantity ordered(itemsCount) and sum of (priceEach * quantityOrdered) as total. With condition “total”greater than 1000.8- Display product code, product…