Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

main.py x BD README.Md FI. README,ind 1. # Customer Data Analysis 2 3 Now that you are an expert in using Python, you are tasked

image text in transcribed
image text in transcribed
main.py x BD README.Md FI. README,ind 1. \# Customer Data Analysis 2 3 Now that you are an expert in using Python, you are tasked by Zain to analyze their custoner data to help them answer some important questions. 4 5. They have provided you with the following files: 6 7. 1. **customers.txt:** Each zain custoner is assigned a unique code to identify them. This file contains the names of all Zain customers and their unique code. So if you have the unique code of a customer, you can know their name from this file. 8 2. **360,txt**: Every time a custoner walks into the 360 zain branch and performs a transaction, their customer 10 is recorded in this file. If a customer visits onces, their ID will be stored in this file once. If they visit the store 3 time, their ID will be stored in the files 3 times ... and so on. Use this file to determine how many times a customer frequented the 360 zain branch and performed a transaction. 9 3. **avenues, txt**; The same as 360.txt but for the avenues branch. Use this file to deternine how many times a customer frequented the avenues zain branch and performed a transaction. 10. 4. **sharq.txt**: The same as 368.txt but for the sharq branch. Use this file to deteraine how many times a customer frequented the sharq zain branch and performed a transaction. 11 12 . \#\# Requirements 13 14 Write a program to analyze the data files and print out a report to answer the following questions: 15 16 - Which branch has the most transactions? 17 - Which store has the most unique customers? 18 - For each store, how many customers visit that store only and not the other stores? 19 - How many customers visit two stores? and what are these two stores? 20 - How many customers go to all stores? 21 - How many customers did only a single transaction (and no more) in any of the stores? 22 - **Hard Problen**: List the top ten customers that did the most transactions and how much transactions thev did. A Al (a) Markelown tan 1 . Tet 1 - Spaces: 2 History 22 Hard Problem : List the top ten customers that did the most transactions and how much transactions they did. 23 - Write the report into a file named 'report.txt' (using python ) 24 - Create a bar chart showing how many visits each branch got many customers visits 1 store, 2 stores, or all 3 stores. 26 27 v \#\#\# Notes 28 - The program should run once. 29 - Think about the most appropriate data structure to put your data in to answer the question. 30 - Some questions will require finding out how to do things we didn't learn in class

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Databases questions