Sveip for å vise menyen

Data Extraction

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

Oppgave

Swipe to start coding

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

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 in items_sold variable and output its value.
Calculate total revenue using sum() function. Save in the total_revenue variable and output its value.
Find out the average price of the sold item - divide total_revenue by items_sold.

Bytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor

Alt var klart?

Takk for tilbakemeldingene dine!

Seksjon 2. Kapittel 7

Spør AI

Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår

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

Oppgave

Swipe to start coding

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

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 in items_sold variable and output its value.
Calculate total revenue using sum() function. Save in the total_revenue variable and output its value.
Find out the average price of the sold item - divide total_revenue by items_sold.

Bytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor

Alt var klart?

Takk for tilbakemeldingene dine!

Seksjon 2. Kapittel 7

Bytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor