Question
Download the following two files you will need for this activity: customerData.csv This file contains randomly generated fictitious customer data. customer_regex.py This is a Python
Download the following two files you will need for this activity:
- customerData.csv
This file contains randomly generated fictitious customer data.
- customer_regex.py
This is a Python script that imports the customer data into a list of customer details.
In your personal playground in Codio, upload the two files and investigate the contents before considering the task you will pose to your peers.
Assume the position of a manager of an online retailer. Pose a question to your IT expert about a task you would like to do with the customer data files. Provide a brief explanation (two to three sentences) describing why this task might be relevant. Examples of tasks you may pose include the following:
- Correct data errors
- Normalize the format of data
- Search for certain customers based on a business need
- Identify trends based on frequency of the customers
In your responses to your peers:
- Provide the regex code that would be required to meet the task presented.
- Describe the relevance of the task: Were regular expressions the best or only way to approach the task? What other data or tasks could be used to increase effectiveness or better achieve the goal presented?
this is the actual question:
Hello IT Department,
I need your expert skills once again. Im looking for a count of how many Visa cardholders have made less than TWO purchases in the past 30 days.
In addition, I need each of these customers': Name & email, with the following message attached to each customer, We want to thank you for your continued loyalty with a 35% off coupon for your next purchase! Thank you, Visa.
I look forward to the finished product.
Thank you
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started