Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Data Extraction | Data Frames
course content

Course Content

R Introduction: Part II

Data ExtractionData Extraction

Finish the section with practice on abstract local furniture store selling data!

Task

You will work with the data below. This data is stored in the store variable.

ItemPriceSold
Sofa34067
Armchair15081
Dining table11579
Bookshelf16042
Kitchen Cabinet7067

Your tasks are:

  1. Add a new column named 'Revenue' with the revenue of each item (multiply 'Price' and 'Sold'). To access columns, use the $ sign.
  2. Using the sum() function, calculate the total number of items sold. Save in items_sold variable and output its value.
  3. Calculate total revenue using sum() function. Save in the total_revenue variable and output its value.
  4. Find out the average price of the sold item - divide total_revenue by items_sold.

Everything was clear?

Section 2. Chapter 7
toggle bottom row
course content

Course Content

R Introduction: Part II

Data ExtractionData Extraction

Finish the section with practice on abstract local furniture store selling data!

Task

You will work with the data below. This data is stored in the store variable.

ItemPriceSold
Sofa34067
Armchair15081
Dining table11579
Bookshelf16042
Kitchen Cabinet7067

Your tasks are:

  1. Add a new column named 'Revenue' with the revenue of each item (multiply 'Price' and 'Sold'). To access columns, use the $ sign.
  2. Using the sum() function, calculate the total number of items sold. Save in items_sold variable and output its value.
  3. Calculate total revenue using sum() function. Save in the total_revenue variable and output its value.
  4. Find out the average price of the sold item - divide total_revenue by items_sold.

Everything was clear?

Section 2. Chapter 7
toggle bottom row
some-alt