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

  Write a python program to implement the diff command

Without using the system() function to call any bash commands, write a python program that will implement a simple version of the diff command.

  Write a program for checking a circle

Write a program for checking a circle program must either print "is a circle: YES" or "is a circle: NO", appropriately.

  Prepare a python program

Prepare a Python program which evaluates how many stuck numbers there are in a range of integers. The range will be input as two command-line arguments.

  Python atm program to enter account number

Write a simple Python ATM program. Ask user to enter their account number, and print their initail balance. (Just make one up). Ask them if they wish to make deposit or withdrawal.

  Python function to calculate two roots

Write a Python function main() to calculate two roots. You must input a,b and c from keyboard, and then print two roots. Suppose the discriminant D= b2-4ac is positive.

  Design program that asks user to enter amount in python

IN Python Design a program that asks the user to enter the amount that he or she has budget in a month. A loop should then prompt the user to enter his or her expenses for the month.

  Write python program which imports three dictionaries

Write a Python program called hours.py which imports three dictionaries, and uses the data in them to calculate how many hours each person has spent in the lab.

  Write python program to create factors of numbers

Write down a python program which takes two numbers and creates the factors of both numbers and displays the greatest common factor.

  Email spam filter

Analyze the emails and predict whether the mail is a spam or not a spam - Create a training file and copy the text of several mails and spams in to it And create a test set identical to the training set but with different examples.

  Improve the readability and structural design of the code

Improve the readability and structural design of the code by improving the function names, variables, and loops, as well as whitespace. Move functions close to related functions or blocks of code related to your organised code.

  Create a simple and responsive gui

Please use primarily PHP or Python to solve the exercise and create a simple and responsive GUI, using HTML, CSS and JavaScript.Do not use a database.

  The program is to print the time

The program is to print the time in seconds that the iterative version takes, the time in seconds that the recursive version takes, and the difference between the times.

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!

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