Question: 1 . Create and populate a CSV file named phone _ sales.csv . The file should have 5 0 0 rows and include the

1. Create and populate a CSV file named "phone_sales.csv". The file should have 500 rows and include the following columns:
Phone_Name: The name of the phone sold, e.g. iPhone 15, Samsung Galaxy S24, etc.
Contract: The months the contract was taken for, e.g.12,24 or 36.
Account_ UpToDate: Yes if the account is up to date, otherwise No.
2. Load the file into a Pandas DataFrame named sales_df.
3. Create a Dash application with the following components:
3.1.Tab 1 should contain:
a. A bold and centred heading: Accounts.
b. A dropdown menu to select a phone (The phone names should be in alphabetical order).
c. Radio buttons are used to select the month for the contract (The radio buttons should be one after another and in ascending order).
d. A bar graph showing whether the number of accounts up to date or not based on the information from the dropdown menu and radio buttons.
3.2.Tab 2 should contain:
a. A bold and centred heading: Phone Contracts.
b. A multi-bar chart to visualise the number of contracts taken per phone per contract month.
c. Customise the graph so that when you hover over each bar, the phone name, the number sold and the contract months appear, e.g.(Samsung Galaxy S24,41)36 month

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!