Question

Write a short python program in the Jupyter notebook using the TIPS dataset. Take a screenshot of your program as shown on your Python program. The output of your bar chart show look like the image below: 0.20 0.15 tip_rate 0.10 0.05 0.00 Sun Sat Thur Fri day It should show the tip rate on a certain weekdays as shown in the flow chart. Create a ratio column in the Dataframe and the tip rate should be calculated by dividing the tip by the total_bill.

Answer 1

#!/usr/bin/env python
# coding: utf-8

# In[1]:


import pandas as pd
#Importing pandas Library


# In[2]:


dataset = pd.read_csv("tips.csv")
# Importing dataset into the varaible as pandas dataframe


# In[3]:


dataset["tip_rate"] = dataset["tip"]/dataset["total_bill"]
# Adding new column tip_rate to the dataset by diving tip and total_bill


# In[4]:


import matplotlib.pyplot as plt
# Importing matplotlib library of python to plot the bar graph


# In[5]:


plt.bar(dataset["day"],dataset["tip_rate"])
# Defining x and y varaibles of the graph
plt.xlabel("days")
plt.ylabel("tip_rate")
# Giving label to the bar graph
plt.show()
# Statement to show the plot

Screenshot of output:-

t:

0.7 0.6 0.5 0.4 tip_rate 0.3 0.2 0.1 0.0 Sun Sat Thur Fri days

Screenshots of Code:

In [1]: import pandas as pd #Importing pandas Library In [2]: dataset = pd.read_csv("tips.csv") # Importing dataset into the varaible as pandas dataframe In [4]: dataset["tip_rate"] dataset["tip"]/dataset["total_bill"] # Adding new column tip_rate to the dataset by diving tip and total_bill In [6]: import matplotlib.pyplot as plt # Importing matplotlib Library of python to plot the bar graph

In [22]: plt.bar(dataset["day"], dataset["tip_rate"]) # Defining x and y varaibles of the graph plt.xlabel("days") plt.ylabel("tip_rate") # Giving Label to the bar graph plt.show() # Statement to show the plot 0.7 0.6 0.5 tip rate 0.3 0.2 T 0.1 0.0 Sun Sat Thur Fri days Activa Go to S.

Above is the code to calculate display bar graph as asked in the question. The dataset i used was similar to what is asked in question but it has some diffrent values. It would run perfectly on your dataset too.

I have to use this dataset because you haven't provided any dataset.

Explantion:

• First, we have imported the pandas library of python to get values from the CSV file.
• After that, the CSV file is read by using the read_csv function of pandas and the value of dataframe is assigned to variable named dataset.
• After that, a new column named tip_rate is added by dividing tip by total_bill.
• Then, I have imported matplotlib library of python to plot the bar graph.
• After that we have plotted the graph using tip_rate and days column of the dataset. Then labels are assigned to x-axis and y-axis.
• After that plot is displayed which was required.

ScreenShot of the dataset that i used:

B c D E LL G H — time size day Sun Sun 2 3 A 1 (total_bill tip 2 16.99 3 10.34 4 21.01 23.68 24.59 7 25.29 Sun 3 Sun 2 5 6 Sun 4 NO Sun 4 8 8.77 No Sun N 9 26.88 Sun 4 10 15.04 No Sun 2 11 14.78 Sun N 12 sex smoker 1.01 Female No 1.66 Male No 3.5 Male No 3.31 Male No 3.61 Female No 4.71 Male 2 Male 3.12 Male No 1.96 Male 3.23 Male No 1.71 Male No 5 Female No 1.57 Male No 3 Male No 3.02 Female No 3.92 Male No 1.67 Female No 3.71 Male No 3.5 Female No 3.35 Male No 4.08 Male 2.75 Female No Sun N 10.27 35.26 15.42 Dinner Dinner Dinner Dinner Dinner Dinner Dinner Dinner Dinner Dinner Dinner Dinner Dinner Dinner Dinner Dinner Dinner Dinner Dinner Dinner Dinner Dinner 13 Sun 4 14 Sun N 15 18.43 Sun 4 16 N 14.83 21.58 17 Sun Sun Sun 2 18 10.33 3 19 Sun 3 16.29 16.97 20 Sun 3 21 20.65 Sat 3 22 17.92 No Sat 2 23 20.29 Sat 2 tis

If there are some doubts you can ask me in comments.

I hope, I'm clear with my answers. Please Upvote