Challenge: Store Revenue Analysis
Task
Swipe to start coding
You are given a data frame store
that contains information on items, their prices, and the quantities sold in a small furniture shop:
Item | Price | Sold |
---|---|---|
Sofa | 340 | 67 |
Armchair | 150 | 81 |
Dining table | 115 | 79 |
Bookshelf | 160 | 42 |
Kitchen cabinet | 70 | 67 |
Your tasks are:
- Add a new column named
'Revenue'
with the revenue of each item (multiply'Price'
and'Sold'
). To access columns, use the$
sign. - Using the
sum()
function, calculate the total number of items sold. Save initems_sold
variable and output its value. - Calculate total revenue using
sum()
function. Save in thetotal_revenue
variable and output its value. - Find out the average price of the sold item - divide
total_revenue
byitems_sold
.
Solution
Everything was clear?
Thanks for your feedback!
SectionΒ 5. ChapterΒ 7
single
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 2.27
Challenge: Store Revenue Analysis
Swipe to show menu
Task
Swipe to start coding
You are given a data frame store
that contains information on items, their prices, and the quantities sold in a small furniture shop:
Item | Price | Sold |
---|---|---|
Sofa | 340 | 67 |
Armchair | 150 | 81 |
Dining table | 115 | 79 |
Bookshelf | 160 | 42 |
Kitchen cabinet | 70 | 67 |
Your tasks are:
- Add a new column named
'Revenue'
with the revenue of each item (multiply'Price'
and'Sold'
). To access columns, use the$
sign. - Using the
sum()
function, calculate the total number of items sold. Save initems_sold
variable and output its value. - Calculate total revenue using
sum()
function. Save in thetotal_revenue
variable and output its value. - Find out the average price of the sold item - divide
total_revenue
byitems_sold
.
Solution
Everything was clear?
Thanks for your feedback!
SectionΒ 5. ChapterΒ 7
single