Swipe to show menu

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.

Task

Swipe to start coding

Group data:

Extract only columns 'day', 'cost', 'money_spent' from the df DataFrame.
Group by the column 'day'.
Apply sum() function to grouped data.
Apply reset_index() function.

Create column 'ROI':

Subtract df['cost'] from df['money_spent']
Divide the result by df['cost'].

Solution

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 4. Chapter 10

Ask AI

Ask anything or try one of the suggested questions to begin our chat

ROI 2/2

The next step of our research is to check if we have unprofitable days.

Task

Swipe to start coding

Group data:

Extract only columns 'day', 'cost', 'money_spent' from the df DataFrame.
Group by the column 'day'.
Apply sum() function to grouped data.
Apply reset_index() function.

Create column 'ROI':

Subtract df['cost'] from df['money_spent']
Divide the result by df['cost'].

Solution

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 4. Chapter 10

Switch to desktop for real-world practiceContinue from where you are using one of the options below