Data Extraction
Finish the section with practice on abstract local furniture store selling data!
Aufgabe
Swipe to start coding
You will work with the data below. This data is stored in the store
variable.
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
.
Lösung
War alles klar?
Danke für Ihr Feedback!
Abschnitt 5. Kapitel 7
single
Fragen Sie AI
Fragen Sie AI
Fragen Sie alles oder probieren Sie eine der vorgeschlagenen Fragen, um unser Gespräch zu beginnen
Awesome!
Completion rate improved to 2.27
Data Extraction
Swipe um das Menü anzuzeigen
Finish the section with practice on abstract local furniture store selling data!
Aufgabe
Swipe to start coding
You will work with the data below. This data is stored in the store
variable.
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
.
Lösung
War alles klar?
Danke für Ihr Feedback!
Awesome!
Completion rate improved to 2.27Abschnitt 5. Kapitel 7
single