The wine data, whose first few rows are shown below, provides information on winestocked by an online retailer, but is missing the year of the vintage. Add the yearcolumn to the data. The vector of years has been created for you.# A tibble: 6 x 5styletype countryprice rating 1 malbecredargentina19.04.22 alvarinhowhite portugal19.04.23 riesling4 pinot noirwhite germany17.04redgermanyNA45 primitivoreditaly18.04.26 valpolicella reditaly19.44.1Complete the code to return the outputlibrary(dplyr)years <- c(2018, 2018, 2017, 2016, 2017, 2016, 2018, 2016, 2016)winewine %>%write code herewrite code here= years)head (wine)

In this, we want to add another column "year" to the data. We are going to create a new column by…

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 white portugal white germany 2 alvarinho 19.0 4.2 3 riesling 17.0 4 4 pinot noir red germany NA 4 5 primitivo italy italy red 18.0 4.2 6 valpolicella red 19.4 4.1 Complete the code to return the output library(dplyr) years <- c(2018, 2018, 2017, 2016, 2017, 2016, 2018, 2016, 2016) wine - wine %>% write code here (write code here = years) head (wine)

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 white portugal white germany 2 alvarinho 19.0 4.2 3 riesling 17.0 4 4 pinot noir red germany NA 4 5 primitivo italy italy red 18.0 4.2 6 valpolicella red 19.4 4.1 Complete the code to return the output library(dplyr) years <- c(2018, 2018, 2017, 2016, 2017, 2016, 2018, 2016, 2016) wine - wine %>% write code here (write code here = years) head (wine)

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts

Section: Chapter Questions

Problem 3.9CP

See similar textbooks

Similar questions

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
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…
The CompanyDataSet contains a table named Sales and a field named Income. Which of the following loops will accumulate the values in the Income field? a. For Each row As CompanyDataSet.Sales.Row In CompanyDataSet.Sales.Rows Sales.Row += row.Income Next row b. For Each row As CompanyDataSet.Sales.Row In CompanyDataSet.Sales.Rows dblTotal += row.Income Next row c. For Each row As CompanyDataSet.Sales.Row In CompanyDataSet.Rows dblTotal += row.Income Next row d. For Each row As CompanyDataSet.Sales In CompanyDataSet.Sales.Rows dblTotal += row.Income Next row
The InstantRide Driver Relationship team wants to learn how many travels each driver has done in the month of October. You need to send them the DRIVER_ID, and two calculated columns: DAY and RIDES. The DAY column is calculated using the DAY() function with the TRAVEL_START_TIME as the argument. The RIDES column is calculated by using the COUNT() function to determine the number of rides given for each day. Filter the results with the MONTH function.
Access: In the first blank column, add a new column named Time on Job that displays the difference between Now() and Hire Date. Divide the result by 365.25 to calculate the number of years employee has worked.
The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Delete the following rows: Horse with ID 5. All horses with breed Holsteiner or Paint. All horses born before March 13, 2013.
eBook Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered From To Price per Roll 30 $215 31 60 $195 61 120 $175 121 and up $155 Click on the datafile logo to reference the data. DATA file (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number Orders 1. 30 $215 13 31 60 $195 15 61 120 $175 37 121 and up $155 107 172 Hide Feedback
Add a new column called “HigherEd” that provides a label based on years of education according to the following rules: Educ < 12: “None” 12 <= Educ < 16: “HighSchool” 16 <= Educ < 17: “College” 17 <= Educ < 19: “Masters” Educ >= 19: “Doctorate”
import pandas as pd cars=pd.read_csv('cars2016.csv') cars name height length width brand city_mpg highway_mpg transmission_type engine_torque engine_horsepower year is_hybrid Automatic transmission 2009 Audi A3 3.2 140 143 202 Audi 18 25 236 250 2009 True 2009 Audi A3 2.0 T AT Automatic 1 140 143 202 Audi 22 28 207 200 2009 True transmission 2 2009 Audi A3 2.0T 140 143 202 Audi 21 30 Manual transmission 207 200 2000 True 2009 Audi A3 2.0 T Automatic 140 143 202 Audi 21 28 207 200 2009 True Quattro transmission Automatic transmission 2009 Audi A3 2.0T 140 143 202 Audi 21 28 207 200 2009 True Quattro 2012 Honda Pilot EX-L Automatic transmission 5070 13 253 201 Honda 18 25 253 250 2012 True 2012 Lamborghini Gallardo Coupe LP 560-4 5071 141 249 108 Lamborghini 12 20 Manual transmission 398 552 2012 True 2012 Lamborghini Gallardo LP 560-4 Spyder 5072 160 249 108 Lamborghini 12 20 Manual transmission 398 552 2012 True 2012 BMW 7401 Sedan Automatic transmission 5073 200 210 110 BMW 17 25 330…
PLZ help with the followng: List all painting titles with price greater than 5000$. How many paintings does ‘Ross Georgette’ have? Find the title of paintings that displayed on ‘L. R. Gilliam’ gallery. CREATE TABLE GALLERY (GAL_NUM char(4),GAL_OWNER varchar(35),GAL_AREACODE char(3),GAL_PHONE char(8),GAL_RATE number);INSERT INTO GALLERY VALUES('5','L. R. Gilliam','901','123-4456',0.37);INSERT INTO GALLERY VALUES('6','G. G. Waters','405','353-2243',0.45 );INSERT INTO GALLERY VALUES('1','N. D. Cosner','203','123-9956',0.67);INSERT INTO GALLERY VALUES('2','S. H. Artwork','415','154-3243',0.30); /* -- */ CREATE TABLE PAINTER (PTR_NUM char(4),PTR_LASTNAME varchar(15) NOT NULL,PTR_FIRSTNAME varchar(15) NOT NULL,PTR_AREACODE char(3),PTR_PHONE char(8));INSERT INTO PAINTER VALUES('123','Ross','Georgette','901','885-4567');INSERT INTO PAINTER VALUES('126','Itero','Julio','901','346-1112');INSERT INTO PAINTER VALUES('127','Geoff','George','615','221-4456'); /* -- */ CREATE TABLE…
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.
Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered From To Price per Roll 1 30 $215 31 60 $195 61 ཙཙ 120 $175 121 and up $155 Click on the datafile logo to reference the data. (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. $ (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number of Orders 1 30 $215 31 60 $195 61 120 $175 121 and up $155 172 12