Question

Need assistance solving computer problem.

Create File (inventory.csv) Snickers,8 Milkyway,5 Reeses,3 Butterfinger,4 Create File (prices.csv): Snickers,1.35 Milkyway,2.00 Reeses,1.50 Butterfinger,3.15 Write a program in any programming language that will read these files and calculate and then output the current total value of all inventory in these 2 files.

Answer 1

Below is the code in R language that will read two csv files and multiply their values to give the result. Pls. follow the comments to understand the code.

R Code-

# Reading csv files
inventory <- read.csv("inventory.csv", header = FALSE)
prices <- read.csv("prices.csv", header = FALSE)
inventory # displaying the values
prices
# Copying the value of the first data frame (inventory) to the new variable total
total <- inventory
# Multiplying the values V2 of total and prices
total$V2 <- total$V2 * as.numeric(as.character(prices$V2))
total

Code screenshot-

# Reading csv files inventory <-read.csv (''inventory.csv", header = FALSE) prices <-read.csv("prices.csv'', header = FALSE) inventory # displaying the values prices # Copying the value of the first data frame (inventory) to the new variable total total <- inventory # Multiplying the values V2 of total and prices totalSV2 <- totalSV2 *as.numeric(as.character(prices $V2)) total

Output-

V1 V2 1 Snickers 10.8 Milkway 10.0 Reeses 4.5 4 Butterfinger 12.6 2