Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

1 2 3 Data Base Techniques

Authors: Dick Andersen

1st Edition

0880223464, 978-0880223461

More Books

Students also viewed these Databases questions

Question

3. What should a contract of employment contain?

Answered: 1 week ago

Question

1. What does the term employment relationship mean?

Answered: 1 week ago