Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Apprendre ROI 2/2 | Becoming an Analyst
Introduction to Python for Data Analysis
course content

Contenu du cours

Introduction to Python for Data Analysis

Introduction to Python for Data Analysis

1. Introduction to Python 1/2
2. Introduction to Python 2/2
3. Explore Dataset
4. Becoming an Analyst

book
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.

Tâche

Swipe to start coding

  1. 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.
  1. Create column 'ROI':
  • Subtract df['cost'] from df['money_spent']
  • Divide the result by df['cost'].

Solution

Switch to desktopPassez à un bureau pour une pratique réelleContinuez d'où vous êtes en utilisant l'une des options ci-dessous
Tout était clair ?

Comment pouvons-nous l'améliorer ?

Merci pour vos commentaires !

Section 4. Chapitre 10
toggle bottom row

book
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.

Tâche

Swipe to start coding

  1. 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.
  1. Create column 'ROI':
  • Subtract df['cost'] from df['money_spent']
  • Divide the result by df['cost'].

Solution

Switch to desktopPassez à un bureau pour une pratique réelleContinuez d'où vous êtes en utilisant l'une des options ci-dessous
Tout était clair ?

Comment pouvons-nous l'améliorer ?

Merci pour vos commentaires !

Section 4. Chapitre 10
Switch to desktopPassez à un bureau pour une pratique réelleContinuez d'où vous êtes en utilisant l'une des options ci-dessous
We're sorry to hear that something went wrong. What happened?
some-alt