I would like to do a search within the name field in this CSV file to search for specific info.My code below is what I have so far I am not sure how to narrow it down farther. I would also like to export the finished product to a different CSV, and I dont know that code either. I am doing this in python any help would be appreciated thanks.
import csv import re data = []
with open('customerData.csv') as csvfile: reader = csv.DictReader(csvfile) for row in reader: data.append(row) fout=open("required.csv","w") fout.write("Name,Email,Credit Card,Purchases Past 30 Days,Spent Past 30 Days, ") for d in data: fout.write(d["Name"]+","+d["Email"]+","+d["Credit Card"]+","+d["Purchases Past 30 Days"]+","+d["Spent Past 30 Days"]+", ") print(d["Name"],d["Email"],d["Credit Card"],d["Purchases Past 30 Days"],d["Spent Past 30 Days"]) fout.close()
A picture of the CSV is below
Microsoft Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW A.EE-9- wrap Tet General A Merge & Center . $ . 96 , 29 conditional Format as Cell Insert Delete Format Sort &Find& 1 Name Gender SSN Member [Phone SaeZil Credit Car Credit Car Credit Car Gender Favorite RPurchases Spent Pas Purchases Spent Pas Purchases Spent Past 12 Month Email Credit CarCredit Car Credit Car Gender 23-Sep female Favorite R Purchases Spent Pas Purchases Spent Pas Purchases Spent Past 12 Months WMMZ 2 Mamie Mafemale 459-69-66 Mon Aug 9.47E+09 Indiana 82439-361 m.masonaVisa 4263xxxxx 4 Sue Roberale 431-17-58iFri Jun 03 (387) 395- Virginia 97198 s.robercan 3446xxxxx 21-Sep female WING 5 Gilbert Hmale 469-80-88i Wed May 5.78E+09 Kentucky 59108-039 g.houston Mastercar 5149xxxxx26-Jul le OGV 6 Randy Griale 936-86-68 2/4/2006 (310) 611are 22646-108 r-griffithri Diners Clu 5430xxxx 22-Jan maleWMP 7Lucile Bist female 443-08-62 Tue May 3 (808) 609- Utah 57189-731 bishopis Discover C6011xxxxx 25-Mar female KAC 8 Mr. Shane male 278-42-75! ######## 3.36E+09 Pennsylva 67098-359 s.hughesu Visa 4694xxxxx 23-Jun male TV 9 Larry Spar male 211-00-39:28/9/2007 6.67E+09 IN 10 Dr. Sadieale 425-51-14 Mon Jul 0: 3.19E+09 Kansas 97873-145 s.HoganVisa 4061xxxxx 18-Jun female KDHH 11 Vera Sharifemale 337-52-65 7/3/2015 8.68E+09 C.O 12 Amanda Cfemale 373-59-41 Sun Aug 1 (951) 347- Michigan65251 a.craigraig American 3404xxxxx 18-Mar female WTHN 13 Mister Art male 120-54-77:13/12/200 (562) 988- W.A 14 Joe Estrad male 603-37-08! ######## 8.31E-09 M.T. KLTX 15 Ophelia Le female 549-30-5614/7/2007 3.46E+09 California 83688-434 o.Lee@tu Diners Clu 5429xxxxx 23-Jul female KFRX 16 Miss Leon female 432-20-27: Wed Apr C (812) 887- M.S. 03831-4171.Fox@kak Mastercar 5178xxxxx 19-Apr female WILF 81455-515 l.sparkspa Mastercar 5117xxxxx 23-Feb male WBME 3806 v.sharpha Discover C6011xxxxx 19-Jul female KBMB 89954 a.wallacea Discover C6011xxxxx 23-Jul male 88094-194 j.estradas Diners Clu5480xxxxx 17-No male KAYZ KFNN 26609-998 s.MoranDiscover C6011xxxxx 26-Mar female KPDE Miss Lena female 937-21-87Sat Aug 01(986) 478- OK 31468-464 l.doyleoyl Mastercar 5192xxxxx 17-Feb feale 18Curtis Pov male 332-30-7514/12/200 (919) 727-Nevada 47519-635 c.powersc Discover (6011xxxxx 22-Oct male 19 Susie Mor female 523-10-31 6/3/2017 8.16E+09 I.A. 20 Mister Ray male 337-02-84 ######## (288) 821-Wyoming 85533 r.mendez. Visa 4433xxxxx 21-Jan male 21 Clyde Male 429-61-70! 2/5/2016 4.06E+09 R.I 22 Mister Mil male 869-64-4 6/3/2016 (225) 275-GA. 23 Mr. Vinceimale 57-47-86:23/10/201 4.86E+09 Delaware 69139 v.robertsc Mastercar 5160xxxxx 22-Nov male KWXT WBWE 4337xxxxx 20-Aug male WTHG 61790-516 c.Mendoz Discover C6011xxxxx 26-Apr male WMNK 0
