Seksjon 4. Kapittel 10
single
ROI 2/2
Sveip for å vise menyen
As you can recognize from the previous chapter, we have some problems with ROI in general; we received -19.644756245106056%. Unfortunately, we suffer losses. In this case, we must dive deeper and find the reason.
The next step of our research is to check if we have unprofitable days.
Oppgave
Sveip for å begynne å kode
- Group data:
- Extract only columns
'day', 'cost', 'money_spent'from thedfDataFrame. - Group by the column
'day'. - Apply
sum()function to grouped data. - Apply
reset_index()function.
- Create column
'ROI':
- Subtract
df['cost']fromdf['money_spent'] - Divide the result by
df['cost'].
Løsning
Alt var klart?
Takk for tilbakemeldingene dine!
Seksjon 4. Kapittel 10
single
Spør AI
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