Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn How Much Do We Earn | Becoming an Analyst
Introduction to Python for Data Analysis

bookHow Much Do We Earn

You may recognize the column 'money_spent' that corresponds to the amount of money the user spent and gained. In this chapter, we will find if there is any dependence between the day of the week and the amount of money we have!

But firstly, recall some functions:

Group Data:


              
12

            
df = df[['columns which we group']]
         .groupby(['columns on which we group'])
copy

Visualization:


              
1234

            
sns.barplot(df = DataFrame,
                 x = 'column for x-axis',
                 y = 'column for y-axis')
plt.show()
copy
Task

Swipe to start coding

  1. Group data:
  • Extract only columns 'day', 'money_spent' from the df DataFrame.
  • Group by the column 'day'.
  • Apply .mean() function to grouped df.
  • Apply .reset_index() function.
  1. Create a barplot:
  • Use df as the first argument.
  • Use column 'day' for x-axis.
  • Use the column 'money_spent' for the y-axis.
  1. Output barplot.

Solution

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 4. ChapterΒ 8
single

single

Ask AI

expand

Ask AI

ChatGPT

Ask anything or try one of the suggested questions to begin our chat

close

Awesome!

Completion rate improved to 2.08

bookHow Much Do We Earn

Swipe to show menu

You may recognize the column 'money_spent' that corresponds to the amount of money the user spent and gained. In this chapter, we will find if there is any dependence between the day of the week and the amount of money we have!

But firstly, recall some functions:

Group Data:


              
12

            
df = df[['columns which we group']]
         .groupby(['columns on which we group'])
copy

Visualization:


              
1234

            
sns.barplot(df = DataFrame,
                 x = 'column for x-axis',
                 y = 'column for y-axis')
plt.show()
copy
Task

Swipe to start coding

  1. Group data:
  • Extract only columns 'day', 'money_spent' from the df DataFrame.
  • Group by the column 'day'.
  • Apply .mean() function to grouped df.
  • Apply .reset_index() function.
  1. Create a barplot:
  • Use df as the first argument.
  • Use column 'day' for x-axis.
  • Use the column 'money_spent' for the y-axis.
  1. Output barplot.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

close

Awesome!

Completion rate improved to 2.08
SectionΒ 4. ChapterΒ 8
single

single

some-alt