User Account

All Pages

Perform the data analysis

Assignment Help Python Programming
Reference no: EM133268754

Data:

You'll be using this data to perform the data analysis. The given data has transaction information from 10 different stores over a period of 3 months.

Warmup:

1. Firstly, explore the data by looking at the provided columns.
a. What do you understand about each column from a quick scan of column names and types?
b. Columns of interest - What is the relationship between columns "BILL_AMT", "QTY", "VALUE" and "PRICE" in the given data?

Technical Analysis:

1. Sales by store - Calculate the total sales amount made by each store over the entire three months and visualize with a plot of your choice.
2. Sales by category - For each store, find the category of products that's sold the most (qty) and visualize with a plot of your choice.
3. Sales by day - For each store, find the day across all three months where the total sales amount is the highest. In other words, find the best day for each store in terms of sales amount and visualize with a plot of your choice.

Bonus:

1. Sales by month - Calculate total sales amount across all stores per month to find the best month across the given three months and visualize with a plot of your choice.

Attachment:- Data.rar

Reference no: EM133268754

Questions Cloud

How have government accounting evolved : Discuss: How have government accounting evolved since independence on your assigned country. How has this country managed its debt over the last one -two decade
Compare different measures of central tendency : Compare and contrast different measures of central tendency and describe what the strength and weakness of each are.
An institution-based view of ipr protection : Why did the United States voluntarily turn from being an IPR violator to an IPR champion? How can the lessons from this episode of IPR history in the United Sta
Implementing technological innovation : 1. What is your view on how technological innovation can help a company succeed? And as an employee or business owner, how can you help to overcome the challeng
Perform the data analysis : perform the data analysis. The given data has transaction information from 10 different stores over a period of 3 months
Explain the components of value chain analysis : Identify and explain the components of Value Chain Analysis relating to Pret a Manger (this includes: inbound logistics, operations, outbound logistics, marketi
Research the budget for the items necessary for a project : Research the budget for the following items necessary for a project:
Self-cleaning component of oven : Please analyze the following questions. Explain why the question is well-written, or rewrite the question so that it will provide a valid and reliable response.
Describe the process of converting adenosine tri-phosphate : Question - Describe the process of converting adenosine tri-phosphate (ATP) into energy within the human body

Reviews

Write a Review

Python Programming Questions & Answers

  Find a path between two state capitals

Find a path between two state capitals - algorithms searches to find a path between INITIAL and GOAL states and measure execution time (in seconds)

  Create a self-guided project and show a variety of skills

Create a self-guided project and show a variety of skills learned in class. This could be an excellent portfolio piece or part of your resume.

  How do you go about finding the index of ?extra? ?element

Given? ?two? ?sorted? ?lists with only one ?difference? ?between? ?the? lis?ts, which is an extra element, ?how do you go about finding the index of the ?extra?

  Design and implement simple software solutions

Write and implement a solution algorithm using basic programming constructs. S3. Demonstrate debugging and testing skills whilst writing code

  Create the empty usernames dictionary before the loop

Create the empty "usernames" dictionary before the loop, and add usernames to it at the end of the loop body (once you've ensured that they are long enough)

  Apply laplace smoothing to the conditional probabilities

Write a Python function which, given a dataframe, constructs (and returns) a Naïve Bayesian network - corresponds to an instance in the dataset

  Create your own function that illustrates a feature

Create your own function that illustrates a feature that you learned in this unit. The function must take at least one argument.

  BDA601 Big Data and Analytics Assignment

BDA601 Big Data and Analytics Assignment Help and Solution, Laureate International Universities - Assessment Writing Service

  Write a program that uses all of your functions

Write a program that uses all of your functions from above to carry out an RSA key generation, encryption, and decryption.

  Plot the optimal solution on the x-axis

CSE 410 - AI: Homework - Plot the optimal solution on the X-axis and the two heuristics on the Y axis. Describe two heuristics for the slide problem

  Find all frequent item sets using the apriori algorithm

Find all frequent item sets using the Apriori algorithm - List all strong association rules (with supports and confidence matching the following metarule

  Define a function that can accept two strings as input

Define a function that can accept two strings as input and print the string with maximum length in console. If two strings have the same length.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd