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

Dive Deeper into Visualization

Let's imagine that it is essential for you to sort out the user continued subscription after the trial period. Let's move to the dataset that we use, for example:

Look at the code:


              12345678910
            
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns

df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/783d7288-e86b-4b89-9966-a2fe97995277/section_2_dataset_upd.csv', index_col = 0)

df = df.groupby(['plan', 'trial']).sum().reset_index()

sns.barplot(data = df, x = 'plan', y = 'price', hue = 'trial')
plt.show()

As you can see, we just add the hue parameter, which helps you sort out data by categories. For instance, here, hue = 'trial', the column 'trial' has two categories: True and False.

And here is the output:

barplot

Task

Visualize the sum of money you receive from users depending on their subscription plan. Take into account if the user continued the subscription after the trial period.

Import the seaborn with the sns alias.
Import the matplotlib.pyplot with the plt alias.
Prepare data for visualization using the .groupby() function:

Extract columns 'plan', 'price', 'trial' for grouping
Group by column 'plan' and then by 'trial'.
Calculate the sum of all prices for each plan.
Reset indices.

Create the barplot using the seaborn:

Use df as the data argument.
Use the 'plan' column for x-axis.
Use the 'price' column for y-axis.
Use the 'trial' column for hue variable.

Display the plot.

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 3. Chapter 17

Dive Deeper into Visualization

Let's imagine that it is essential for you to sort out the user continued subscription after the trial period. Let's move to the dataset that we use, for example:

Look at the code:


              12345678910
            
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns

df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/783d7288-e86b-4b89-9966-a2fe97995277/section_2_dataset_upd.csv', index_col = 0)

df = df.groupby(['plan', 'trial']).sum().reset_index()

sns.barplot(data = df, x = 'plan', y = 'price', hue = 'trial')
plt.show()

As you can see, we just add the hue parameter, which helps you sort out data by categories. For instance, here, hue = 'trial', the column 'trial' has two categories: True and False.

And here is the output:

barplot

Task

Visualize the sum of money you receive from users depending on their subscription plan. Take into account if the user continued the subscription after the trial period.

Import the seaborn with the sns alias.
Import the matplotlib.pyplot with the plt alias.
Prepare data for visualization using the .groupby() function:

Extract columns 'plan', 'price', 'trial' for grouping
Group by column 'plan' and then by 'trial'.
Calculate the sum of all prices for each plan.
Reset indices.

Create the barplot using the seaborn:

Use df as the data argument.
Use the 'plan' column for x-axis.
Use the 'price' column for y-axis.
Use the 'trial' column for hue variable.

Display the plot.

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 3. Chapter 17

Dive Deeper into Visualization

Let's imagine that it is essential for you to sort out the user continued subscription after the trial period. Let's move to the dataset that we use, for example:

Look at the code:


              12345678910
            
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns

df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/783d7288-e86b-4b89-9966-a2fe97995277/section_2_dataset_upd.csv', index_col = 0)

df = df.groupby(['plan', 'trial']).sum().reset_index()

sns.barplot(data = df, x = 'plan', y = 'price', hue = 'trial')
plt.show()

As you can see, we just add the hue parameter, which helps you sort out data by categories. For instance, here, hue = 'trial', the column 'trial' has two categories: True and False.

And here is the output:

barplot

Task

Visualize the sum of money you receive from users depending on their subscription plan. Take into account if the user continued the subscription after the trial period.

Import the seaborn with the sns alias.
Import the matplotlib.pyplot with the plt alias.
Prepare data for visualization using the .groupby() function:

Extract columns 'plan', 'price', 'trial' for grouping
Group by column 'plan' and then by 'trial'.
Calculate the sum of all prices for each plan.
Reset indices.

Create the barplot using the seaborn:

Use df as the data argument.
Use the 'plan' column for x-axis.
Use the 'price' column for y-axis.
Use the 'trial' column for hue variable.

Display the plot.

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

Everything was clear?

Thanks for your feedback!

Let's imagine that it is essential for you to sort out the user continued subscription after the trial period. Let's move to the dataset that we use, for example:

Look at the code:


              12345678910
            
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns

df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/783d7288-e86b-4b89-9966-a2fe97995277/section_2_dataset_upd.csv', index_col = 0)

df = df.groupby(['plan', 'trial']).sum().reset_index()

sns.barplot(data = df, x = 'plan', y = 'price', hue = 'trial')
plt.show()

As you can see, we just add the hue parameter, which helps you sort out data by categories. For instance, here, hue = 'trial', the column 'trial' has two categories: True and False.

And here is the output:

barplot

Task

Visualize the sum of money you receive from users depending on their subscription plan. Take into account if the user continued the subscription after the trial period.

Import the seaborn with the sns alias.
Import the matplotlib.pyplot with the plt alias.
Prepare data for visualization using the .groupby() function:

Extract columns 'plan', 'price', 'trial' for grouping
Group by column 'plan' and then by 'trial'.
Calculate the sum of all prices for each plan.
Reset indices.

Create the barplot using the seaborn:

Use df as the data argument.
Use the 'plan' column for x-axis.
Use the 'price' column for y-axis.
Use the 'trial' column for hue variable.

Display the plot.

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

Section 3. Chapter 17

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