Question

Python programming-

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.

My classmate asked that I would like to know more about my customers. Knowing what gender the majority of my customers are tells me how I should advertise and where I might be able to get more customers. My question is how many female vs male customers do we have?

Here is the code from the first link:

import csv
import re
data = []

with open('customerdata.csv') as csvfile:
reader = csv.DictReader(csvfile)
for row in reader:
data.append(row)
print(data[0])
print(data[1]["Name"])
print(data[2]["Spent Past 30 Days"])

customerdata.csv is a large file, I will simply copy and paste a small section of it, enough to answer the question:

Name

Gender

SSN

Member Date

Phone

State

Zip

Email

Credit Card

Credit Card_Number

Credit Card Exp

Gender

Favorite Radio Station

Purchases Past 30 Days

Spent Past 30 Days

Purchases Past 6 Months

Spent Past 6 Months

Purchases Past 12 Months

Spent Past 12 Months

Mamie Mason

female

459-69-6647

Mon Aug 01 2016 12:06:01 GMT-0400 (Eastern Daylight Time)

9.47E+09

Indiana

82439-3619

[email protected]

Visa

4263xxxxxxxx1913

23-Sep

female

WMMZ

4

########

7

########

9

########

Dr. Jorge Leonard

male

267-90-8144

########

(482) 962-5537

Pennsylvania

44795

[email protected]

American Express

3430xxxxxxx6344

22-Jun

male

WLRS

4

########

5

########

15

########

Sue Robertson

female

431-17-5882

Fri Jun 03 2016 01:34:30 GMT-0400 (Eastern Daylight Time)

(387) 395-7066

Virginia

97198

[email protected]

American Express

3446xxxxxxx4624

21-Sep

female

WING

4

########

9

########

13

########

Gilbert Houston

male

469-80-8860

Wed May 02 2012 00:45:29 GMT-0400 (Eastern Daylight Time)

5.78E+09

Kentucky

59108-0390

[email protected]

Mastercard

5149xxxxxxxx7215

26-Jul

male

WOGV

0

$0

5

########

6

########

Randy Griffith

male

936-86-6880

2/4/2006

(310) 611-5796

Delaware

22646-1080

[email protected]

Diners Club United States & Canada

5430xxxxxxxx1269

22-Jan

male

WJMP

4

########

8

########

10

########

Lucile Bishop

female

443-08-6297

Tue May 31 2016 06:26:56 GMT-0400 (Eastern Daylight Time)

(808) 609-2200

Utah

57189-7317

[email protected]

Discover Card

6011xxxxxxxx4095

25-Mar

female

KACJ

1

$869.04

5

########

6

########

Mr. Shane Hughes

male

278-42-7591

########

3.36E+09

Pennsylvania

67098-3590

[email protected]

Visa

4694xxxxxxxx8259

23-Jun

male

WJTV

2

########

7

########

8

########

Answer 1

As Gren data The udpe e data, the quickes woy, mast litely l be to tege the cocuntor c las's mat tommon methad the counter cla can be inforteed from colfeaten tohat you xs tate) For x indata] mod common State couner (Stabs). mot comionla Pleage find belas cade port cev FoTat re data csvAle with open ('Customa cah c as readey cev Dict reades (csAe for YOw Yeady data append Gow) Count o Print (*three Fouasite radio stoteni) Locping thheigh lasof ordexed dictsstoed cah Tox Cut tomar in cbita loceping thiough oudered lest for firchg Radio Station coloumn For cushmes key. val in Custmer, tems ) favoarde key=Faanite Kado Sta-tan'and Court 3 Prirt (val) Count count+1 Cs Scanned with Camscanner

Sompe out aut 935 ) ) ol! buhr MNA 40 Vaash Thriee fauaoite vodio Statond: WMM2 NLRS Process finishad Wth exit code o so 1in nA Cs Scanned with CamScanner