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

Зміст курсу

Introduction to Python for Data Analysis

Introduction to Python for Data Analysis

1. Introduction to Python 1/2
First Step in ProgrammingDeal with VariablesPractice Math SkillsChallengeDeal with PercentsHow to Attract One User?ChallengeLearn NumbersBoolean NumbersChallengeWork with StringsGet Familiar with ListsHow to Append New Element?
2. Introduction to Python 2/2
If/ElseChallengeIf/Elif/ElseChallengeFor LoopWhile LoopChallenge
3. Explore Dataset
Data StudyOperations with the FileHow to Explore the DataSorting DataMax, min, mean, medianChallengeGroup DataDive Deeper into Grouping DataGroup Data 2.0Introduction to NumPyPivot TablesRecall Loops.loc FunctionDeal with Several ConditionsChallengeVisualization: First StepsDive Deeper into Visualization
4. Becoming an Analyst
Data StudyExamine DatasetChallengeСAC 1/2CAC 2/2Costly CustomersOrganic TrafficHow Much Do We EarnIs Our Project Profitable? ROI 1/2ROI 2/2Visualize ROI

Is Our Project Profitable? ROI 1/2

Is our project profitable? To figure this out, you can calculate one simple metric titled ROI; the formula is:

roi

  • Earnings, the sum of the column 'money_spent'.
  • Losses, the sum of the column 'cost'.

Завдання

  1. Calculate the sum of the column df['cost'], and assign it to the variable cost_sum.
  2. Calculate the sum of the column df['money_spent'], and assign it to the variable spent_sum.
  3. Calculate ROI:
  • Subtract cost_sum from the spent_sum.
  • Divide the subtraction by the cost_sum.
  1. Output the ROI.

The result was already multiplied by 100 to get it in percentage.

Завдання

  1. Calculate the sum of the column df['cost'], and assign it to the variable cost_sum.
  2. Calculate the sum of the column df['money_spent'], and assign it to the variable spent_sum.
  3. Calculate ROI:
  • Subtract cost_sum from the spent_sum.
  • Divide the subtraction by the cost_sum.
  1. Output the ROI.

The result was already multiplied by 100 to get it in percentage.

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

Все було зрозуміло?

Секція 4. Розділ 9
toggle bottom row

Is Our Project Profitable? ROI 1/2

Is our project profitable? To figure this out, you can calculate one simple metric titled ROI; the formula is:

roi

  • Earnings, the sum of the column 'money_spent'.
  • Losses, the sum of the column 'cost'.

Завдання

  1. Calculate the sum of the column df['cost'], and assign it to the variable cost_sum.
  2. Calculate the sum of the column df['money_spent'], and assign it to the variable spent_sum.
  3. Calculate ROI:
  • Subtract cost_sum from the spent_sum.
  • Divide the subtraction by the cost_sum.
  1. Output the ROI.

The result was already multiplied by 100 to get it in percentage.

Завдання

  1. Calculate the sum of the column df['cost'], and assign it to the variable cost_sum.
  2. Calculate the sum of the column df['money_spent'], and assign it to the variable spent_sum.
  3. Calculate ROI:
  • Subtract cost_sum from the spent_sum.
  • Divide the subtraction by the cost_sum.
  1. Output the ROI.

The result was already multiplied by 100 to get it in percentage.

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

Все було зрозуміло?

Секція 4. Розділ 9
toggle bottom row

Is Our Project Profitable? ROI 1/2

Is our project profitable? To figure this out, you can calculate one simple metric titled ROI; the formula is:

roi

  • Earnings, the sum of the column 'money_spent'.
  • Losses, the sum of the column 'cost'.

Завдання

  1. Calculate the sum of the column df['cost'], and assign it to the variable cost_sum.
  2. Calculate the sum of the column df['money_spent'], and assign it to the variable spent_sum.
  3. Calculate ROI:
  • Subtract cost_sum from the spent_sum.
  • Divide the subtraction by the cost_sum.
  1. Output the ROI.

The result was already multiplied by 100 to get it in percentage.

Завдання

  1. Calculate the sum of the column df['cost'], and assign it to the variable cost_sum.
  2. Calculate the sum of the column df['money_spent'], and assign it to the variable spent_sum.
  3. Calculate ROI:
  • Subtract cost_sum from the spent_sum.
  • Divide the subtraction by the cost_sum.
  1. Output the ROI.

The result was already multiplied by 100 to get it in percentage.

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

Все було зрозуміло?

Is our project profitable? To figure this out, you can calculate one simple metric titled ROI; the formula is:

roi

  • Earnings, the sum of the column 'money_spent'.
  • Losses, the sum of the column 'cost'.

Завдання

  1. Calculate the sum of the column df['cost'], and assign it to the variable cost_sum.
  2. Calculate the sum of the column df['money_spent'], and assign it to the variable spent_sum.
  3. Calculate ROI:
  • Subtract cost_sum from the spent_sum.
  • Divide the subtraction by the cost_sum.
  1. Output the ROI.

The result was already multiplied by 100 to get it in percentage.

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів
Секція 4. Розділ 9
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів
We're sorry to hear that something went wrong. What happened?
some-alt