Python

Download the following two files you will need for this activity:

• customerData.csv

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

m.masonason@gig.org

Visa

4263xxxxxxxx1913

23-Sep

female

WMMZ

4

########

7

########

9

########

Dr. Jorge Leonard

male

267-90-8144

########

(482) 962-5537

Pennsylvania

44795

j.leonardeonard@leiwauhi.gov

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

s.robertsonobertson@odejo.co

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

g.houstonouston@fuzsi.co

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

r.griffithriffith@iptiipu.ca

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

l.bishopishop@fudkilso.com

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

s.hughesughes@leh.net

Visa

4694xxxxxxxx8259

23-Jun

male

WJTV

2

########

7

########

8

########

Larry Sparks

male

211-00-3913

28/9/2007

6.67E+09

IN

81455-5156

l.sparksparks@gafnecnuc.au

Mastercard

5117xxxxxxxx7913

23-Feb

male

WBME

4

########

5

########

8

########

Dr. Sadie Hogan

female

425-51-1446

Mon Jul 02 2007 21:31:31 GMT-0400 (Eastern Daylight Time)

3.19E+09

Kansas

97873-1458

s.Hogan@wo.gov

Visa

4061xxxxxxxx0424

18-Jun

female

KDHH

0

$0

3

########

10

########

Vera Sharp

female

337-52-6574

7/3/2015

8.68E+09

C.O.

73806

v.sharpharp@vulos.edu

Discover Card

6011xxxxxxxx0859

19-Jul

female

KBMB

3

########

4

########

9

########

Amanda Craig

female

373-59-4142

Sun Aug 17 2014 08:44:20 GMT-0400 (Eastern Daylight Time)

(951) 347-3265

Michigan

65251

a.craigraig@lu.nz

American Express

3404xxxxxxx6419

18-Mar

female

WTHN

0

$0

5

########

8

########

Mister Arthur Wallace

male

120-54-7783

13/12/2008

(562) 988-4539

W.A.

89954

a.wallaceallace@wiclacpud.net

Discover Card

6011xxxxxxxx8686

23-Jul

male

KHST

4

########

5

########

13

########

Joe Estrada

male

603-37-0899

########

8.31E+09

M.T.

88094-1943

j.estradastrada@te.info

Diners Club United States & Canada

5480xxxxxxxx5609

17-Nov

male

KLTX

2

$982.99

4

########

13

########

Ophelia Lee

female

549-30-5657

14/7/2007

3.46E+09

California

83688-4346

o.Lee@tudde.info

Diners Club United States & Canada

5429xxxxxxxx5084

23-Jul

female

KFRX

4

########

5

########

7

########

Miss Leona Fox

female

432-20-2722

Wed Apr 08 2009 12:50:08 GMT-0400 (Eastern Daylight Time)

(812) 887-7136

M.S.

03831-4171

l.Fox@kak.ca

Mastercard

5178xxxxxxxx6824

19-Apr

female

WILF

2

########

3

########

13

########

Miss Lena Doyle

female

937-21-8751

Sat Aug 01 2015 13:47:43 GMT-0400 (Eastern Daylight Time)

(986) 478-9204

OK

31468-4649

l.doyleoyle@ovo.gov

Mastercard

5192xxxxxxxx0458

17-Feb

female

KAYZ

4

########

5

########

8

########

Curtis Powers

male

332-30-7548

14/12/2007

(919) 727-4554

Nevada

47519-6358

c.powersowers@wo.org

Discover Card

6011xxxxxxxx3280

22-Oct

male

KFNN

2

########

6

########

15

########

This file contains randomly generated fictitious customer data.

• customer_regex.py

  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"])

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

This is the question that needs to be answered

Can you create a list that will give me a list of radio stations and the number of our customers that listen to each station?

I will use the list to make a decision about where our advertisement dollars for store sales would be most beneficial. Additionally, this list could also be used to make decision about products to carry in the store that will be based on the type of music our customers enjoy.