ROI 2/2
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.
Swipe to start coding
- 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'].
Ratkaisu
Kiitos palautteestasi!
single
Kysy tekoälyä
Kysy tekoälyä
Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme
Awesome!
Completion rate improved to 2.08ROI 2/2
Pyyhkäise näyttääksesi valikon
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.
Swipe to start coding
- 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'].
Ratkaisu
Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoistaKiitos palautteestasi!
Awesome!
Completion rate improved to 2.08single
