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

Group Data 2.0

Let's imagine the situation where you want to group by job_title, but then you want to group by experience_level , for example.

Here, everything is so simple you need just put several columns in needed order to groupby function:


              1234567
            
import pandas as pd

df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/INTRO+to+Python/ds_salaries.csv', index_col = 0)

df = df.groupby(['job_title', 'experience_level']).mean()

print(df)

Look at the output.

output

By the way, if you don't want to group the whole table, you can specify the name of columns for which we should apply grouping. For instance, look at the previous code. If we want to calculate the mean value only for the 'salary' column, we specify needed columns, but do not forget about columns that should be grouped:


              1234567
            
import pandas as pd

df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/INTRO+to+Python/ds_salaries.csv', index_col = 0)

df = df[['salary','job_title', 'experience_level']].groupby(['job_title', 'experience_level']).mean()

print(df)

Be careful; if you want to work with several columns, you have to put them into [[]] (look at the example).

Look at the result:

result

Task

Swipe to start coding

Your task here is to work with the known dataset and count amount of users for each plan depending on the status of their trial. To do it, follow the algorithm:

Group by 'plan' column, then by 'trial' column, using only three columns: 'user_id', 'plan', 'trial'. Apply the count() function.
Print the df using only print() function.

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

Group Data 2.0

Let's imagine the situation where you want to group by job_title, but then you want to group by experience_level , for example.

Here, everything is so simple you need just put several columns in needed order to groupby function:


              1234567
            
import pandas as pd

df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/INTRO+to+Python/ds_salaries.csv', index_col = 0)

df = df.groupby(['job_title', 'experience_level']).mean()

print(df)

Look at the output.

output


              1234567
            
import pandas as pd

df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/INTRO+to+Python/ds_salaries.csv', index_col = 0)

df = df[['salary','job_title', 'experience_level']].groupby(['job_title', 'experience_level']).mean()

print(df)

Be careful; if you want to work with several columns, you have to put them into [[]] (look at the example).

Look at the result:

result

Task

Swipe to start coding

Your task here is to work with the known dataset and count amount of users for each plan depending on the status of their trial. To do it, follow the algorithm:

Group by 'plan' column, then by 'trial' column, using only three columns: 'user_id', 'plan', 'trial'. Apply the count() function.
Print the df using only print() function.

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

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