Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

JDBC Database Programming With J2ee

Authors: Art Taylor

1st Edition

0130453234, 978-0130453235

More Books

Students also viewed these Databases questions