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 thedf
DataFrame. - 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']
.
Soluzione
Grazie per i tuoi commenti!
single
Chieda ad AI
Chieda ad AI
Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione
Awesome!
Completion rate improved to 2.08
ROI 2/2
Scorri per mostrare il menu
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 thedf
DataFrame. - 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']
.
Soluzione
Grazie per i tuoi commenti!
Awesome!
Completion rate improved to 2.08single