Course Content

Introduction to Python for Data Analysis

1. Introduction to Python 1/2

First Step in Programming Deal with Variables Practice Math Skills Challenge Deal with Percents How to Attract One User?Challenge Learn Numbers Boolean Numbers Challenge Work with Strings Get Familiar with Lists How to Append New Element?

2. Introduction to Python 2/2

If/Else Challenge If/Elif/Else Challenge For Loop While Loop Challenge

3. Explore Dataset

Data Study Operations with the File How to Explore the Data Sorting Data Max, min, mean, median Challenge Group Data Dive Deeper into Grouping Data Group Data 2.0 Introduction to NumPy Pivot Tables Recall Loops .loc Function Deal with Several Conditions Challenge Visualization: First Steps Dive Deeper into Visualization

4. Becoming an Analyst

Data Study Examine Dataset Challenge СAC 1/2 CAC 2/2 Costly Customers Organic Traffic How Much Do We Earn Is Our Project Profitable? ROI 1/2 ROI 2/2 Visualize 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'.

Task

Calculate the sum of the column df['cost'], and assign it to the variable cost_sum.
Calculate the sum of the column df['money_spent'], and assign it to the variable spent_sum.
Calculate ROI:

Subtract cost_sum from the spent_sum.
Divide the subtraction by the cost_sum.

Output the ROI.

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

Task

Calculate the sum of the column df['cost'], and assign it to the variable cost_sum.
Calculate the sum of the column df['money_spent'], and assign it to the variable spent_sum.
Calculate ROI:

Subtract cost_sum from the spent_sum.
Divide the subtraction by the cost_sum.

Output the ROI.

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

Everything was clear?

Section 4. Chapter 9

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

Task

Calculate the sum of the column df['cost'], and assign it to the variable cost_sum.
Calculate the sum of the column df['money_spent'], and assign it to the variable spent_sum.
Calculate ROI:

Subtract cost_sum from the spent_sum.
Divide the subtraction by the cost_sum.

Output the ROI.

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

Task

Calculate the sum of the column df['cost'], and assign it to the variable cost_sum.
Calculate the sum of the column df['money_spent'], and assign it to the variable spent_sum.
Calculate ROI:

Subtract cost_sum from the spent_sum.
Divide the subtraction by the cost_sum.

Output the ROI.

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

Everything was clear?

Section 4. Chapter 9

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

Task

Calculate the sum of the column df['cost'], and assign it to the variable cost_sum.
Calculate the sum of the column df['money_spent'], and assign it to the variable spent_sum.
Calculate ROI:

Subtract cost_sum from the spent_sum.
Divide the subtraction by the cost_sum.

Output the ROI.

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

Task

Calculate the sum of the column df['cost'], and assign it to the variable cost_sum.
Calculate the sum of the column df['money_spent'], and assign it to the variable spent_sum.
Calculate ROI:

Subtract cost_sum from the spent_sum.
Divide the subtraction by the cost_sum.

Output the ROI.

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

Everything was clear?

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

Task

Calculate the sum of the column df['cost'], and assign it to the variable cost_sum.
Calculate the sum of the column df['money_spent'], and assign it to the variable spent_sum.
Calculate ROI:

Subtract cost_sum from the spent_sum.
Divide the subtraction by the cost_sum.

Output the ROI.

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

Section 4. Chapter 9

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