查找excel表的指定数据
需求
- 妈妈的公司人工搜集了一些用户注册的电话号码（含有每次收集的日期时间）
- 现在向银行提交这些电话号码过后，银行表示有些号码有异常，可能没有注册成功，或者是其他原因
- 但是银行不知道注册的时间（我真的佛了，这个时间不是应该正好是银行有的吗。。。但是银行没有）
- 所以要找出这些时间
代码
import numpy as np
excel1 = open("./message_20200116.csv", "r",encoding="utf-8")
excel2 = open("./Phone.csv", "r",encoding="utf-8")
excel3 = open("./excel1.csv", "w+")
excel4 = open("./excel2.csv", "w+")
data1 = np.loadtxt(excel1, dtype=str, delimiter=",", skiprows=0)
data2 = np.loadtxt(excel2, dtype=str, delimiter=",", skiprows=0)
row3 = data2[0][2]
j = 0
for i in range(len(data2)-1):
if(len(data2[i][2]) != 8):
data2[i][2] = row3
data2[i][0] = j
j = j + 1
for n in range(4):
excel4.write(str(data2[i][n]) + ',')
excel4.write('\n')
else :
try:
row3 = data2[i][2]
j = 0
data2[i][0] = j
j = j + 1
for i in range(4):
excel4.write(str(data2[i][n]) + ',')
excel4.write('\n')
except ValueError:
data2[i][2] = row3
data2[i][0] = j
j = j + 1
for n in range(4):
excel4.write(str(data2[i][n]) + ',')
excel4.write('\n')
count = 0
for i in range(len(data1)-1):
data1data = ''
for n in range(11):
try:
data1data = data1data + data1[i][n]
except IndexError:
count = count
for j in range(len(data2)-1):
if(data2[j][1] == data1data):
print(data2[j])
for m in range (len(data2[j])):
excel3.write(data2[j][m] + ',')
excel3.write('\n')
count = count + 1
print(count)
excel1.close()
excel2.close()
excel3.close()
excel4.close()
输出结果
['6' '15181454047' '20191120' '' '' '' '']
['7' '18048610843' '20191120' '' '' '' '']
['13' '15325230225' '20191120' '' '' '' '']
['19' '18188386873' '20191120' '' '' '' '']
['22' '15225356977' '20191120' '' '' '' '']
['23' '18999012235' '20191120' '' '' '' '']
['87' '13990190967' '20191120' '' '' '' '']
['104' '18030942127' '20191120' '' '' '' '']
['105' '15228763260' '20191120' '' '' '' '']
['126' '18981184957' '20191120' '' '' '' '']
['132' '19113621101' '20191120' '' '' '' '']
['164' '18030930112' '20191120' '' '' '' '']
['165' '17378660628' '20191120' '' '' '' '']
['182' '15308118298' '20191120' '' '' '' '']
['200' '13668326089' '20191120' '' '' '' '']
['218' '18081250879' '20191120' '' '' '' '']
['222' '15082105268' '20191120' '' '' '' '']
['259' '15181657787' '20191120' '' '' '' '']
['273' '13308115669' '20191120' '' '' '' '']
['281' '17362167282' '20191120' '' '' '' '']
['293' '15983630667' '20191120' '' '' '' '']
['298' '13352955230' '20191120' '' '' '' '']
['304' '15881637143' '20191120' '' '' '' '']
['319' '18148010131' '20191120' '' '' '' '']
['396' '18981775541' '20191120' '' '' '' '']
['397' '18181178741' '20191120' '' '' '' '']
['414' '15386666527' '20191120' '' '' '' '']
['420' '13388365293' '20191120' '' '' '' '']
['436' '18989297283' '20191120' '' '' '' '']
['446' '13198675231' '20191120' '' '' '' '']
['462' '15680124778' '20191120' '' '' '' '']
['464' '18284102798' '20191120' '' '' '' '']
['477' '18081242079' '20191120' '' '' '' '']
['489' '18191381982' '20191120' '' '' '' '']
['496' '13981195155' '20191120' '' '' '' '']
['522' '1340.816657' '20191120' '' '' '' '']
['524' '15981698376' '20191120' '' '' '' '']
['528' '13881133628' '20191120' '' '' '' '']
['534' '13098765080' '20191120' '' '' '' '']
['545' '15182313059' '20191120' '' '' '' '']
['548' '15280968029' '20191120' '' '' '' '']
['549' '19915988011' '20191120' '' '' '' '']
['555' '18789159089' '20191120' '' '' '' '']
['558' '13990103419' '20191120' '' '' '' '']
['585' '18330997687' '20191120' '' '' '' '']
['589' '15082163129' '20191120' '' '' '' '']
['604' '13881193085' '20191120' '' '' '' '']
['605' '18081219739' '20191120' '' '' '' '']
['606' '15386664348' '20191120' '' '' '' '']
['607' '15288162353' '20191120' '' '' '' '']
['609' '15582305285' '20191120' '' '' '' '']
['614' '18780365386' '20191120' '' '' '' '']
['615' '13550808105' '20191120' '' '' '' '']
['635' '15681152189' '20191120' '' '' '' '']
['637' '13990136506' '20191120' '' '' '' '']
['655' '18990123922' '20191120' '' '' '' '']
['657' '15882854123' '20191120' '' '' '' '']
['665' '13381597778' '20191120' '' '' '' '']
['684' '18990193911' '20191120' '' '' '' '']
['691' '18008452863' '20191120' '' '' '' '']
['696' '18228187282' '20191120' '' '' '' '']
['711' '13458316261' '20191120' '' '' '' '']
['712' '15228365916' '20191120' '' '' '' '']
['720' '15229637579' '20191120' '' '' '' '']
['731' '13668335346' '20191120' '' '' '' '']
['737' '19982713356' '20191120' '' '' '' '']
['741' '18281508670' '20191120' '' '' '' '']
['804' '18148409974' '20191120' '' '' '' '']
['817' '15881691589' '20191120' '' '' '' '']
['819' '18281997631' '20191120' '' '' '' '']
['830' '13508438716' '20191120' '' '' '' '']
['831' '13890141082' '20191120' '' '' '' '']
['834' '13131167832' '20191120' '' '' '' '']
['836' '13508427575' '20191120' '' '' '' '']
['855' '18981183365' '20191120' '' '' '' '']
['858' '15508161128' '20191120' '' '' '' '']
['866' '18934777541' '20191120' '' '' '' '']
['875' '13148429132' '20191120' '' '' '' '']
['883' '15882411390' '20191120' '' '' '' '']
['891' '15231699069' '20191120' '' '' '' '']
['912' '15196222345' '20191120' '' '' '' '']
['918' '17138088224' '20191120' '' '' '' '']
['926' '15278761291' '20191120' '' '' '' '']
['937' '18990110318' '20191120' '' '' '' '']
['955' '18084896682' '20191120' '' '' '' '']
['979' '15182419668' '20191120' '' '' '' '']
['991' '13548416350' '20191120' '' '' '' '']
['993' '13550899744' '20191120' '' '' '' '']
['1050' '18281644368' '20191120' '' '' '' '']
['1063' '18308566699' '20191120' '' '' '' '']
['1066' '15983694921' '20191120' '' '' '' '']
['1075' '18081210655' '20191120' '' '' '' '']
['1' '15181449736' '20191211' '' '' '' '']
['28' '1878039173' '20191211' '' '' '' '']
['58' '15196281061' '20191211' '' '' '' '']
['61' '13330931510' '20191211' '' '' '' '']
['4' '15228451166' '未扫码登注册成功' '' '' '' '']
['17' '14386622789' '未扫码登注册成功' '' '' '' '']
['23' '19981137908' '未扫码登注册成功' '' '' '' '']
['20' '10881222269' '20191213' '' '' '' '']
['25' '15228336462' '20191213' '' '' '' '']
['46' '19890197529' '20191213' '' '' '' '']
['66' '18148422892' '20191213' '' '' '' '']
['69' '13198682336' '20191213' '' '' '' '']
['73' '15518211449' '20191213' '' '' '' '']
['82' '15808163083' '20191213' '' '' '' '']
['98' '15528566989' '20191213' '' '' '' '']
['99' '17738435573' '20191213' '' '' '' '']
['118' '13981139401' '20191213' '' '' '' '']
['122' '17713654360' '20191213' '' '' '' '']
['152' '18781133140' '20191213' '' '' '' '']
['153' '18281645508' '20191213' '' '' '' '']
['172' '15883774528' '20191213' '' '' '' '']
['180' '17340461317' '20191213' '' '' '' '']
['182' '17716822680' '20191213' '' '' '' '']
['186' '13154453264' '20191213' '' '' '' '']
['209' '13281521898' '20191213' '' '' '' '']
['210' '18030954557' '20191213' '' '' '' '']
['215' '13547161603' '20191213' '' '' '' '']
['236' '18196074106' '20191213' '' '' '' '']
['245' '17378691195' '20191213' '' '' '' '']
['284' '18381691611' '20191213' '' '' '' '']
['298' '13458018871' '20191213' '' '' '' '']
['303' '15386643308' '20191213' '' '' '' '']
['308' '13309010043' '20191213' '' '' '' '']
['314' '15308349630' '20191213' '' '' '' '']
['342' '13568437727' '20191213' '' '' '' '']
['344' '13350975845' '20191213' '' '' '' '']
['349' '13036480191' '20191213' '' '' '' '']
['363' '15281954067' '20191213' '' '' '' '']
['368' '13541740590' '20191213' '' '' '' '']
['373' '15782714931' '20191213' '' '' '' '']
['385' '18081218429' '20191213' '' '' '' '']
['404' '15908161937' '20191213' '' '' '' '']
['405' '18081237843' '20191213' '' '' '' '']
['409' '17386760623' '20191213' '' '' '' '']
['428' '13550834386' '20191213' '' '' '' '']
['429' '13096235860' '20191213' '' '' '' '']
['440' '18081249058' '20191213' '' '' '' '']
['452' '15280995502' '20191213' '' '' '' '']
['455' '15181642815' '20191213' '' '' '' '']
['475' '17313596539' '20191213' '' '' '' '']
['479' '13320893695' '20191213' '481' '' '' '']
['8' '18780390843' '20191225' '' '' '' '']
['37' '19881145615' '20191225' '' '' '' '']
['93' '18291538319' '20191225' '' '' '' '']
['106' '13790192420' '20191225' '' '' '' '']
['109' '18950822276' '20191225' '' '' '' '']
['138' '15378210916' '20191225' '' '' '' '']
['161' '15008156124' '20191225' '' '' '' '']
['192' '48381649970' '20191225' '' '' '' '']
['202' '13398481263' '20191225' '' '' '' '']
['229' '18981164093' '20191225' '' '' '' '']
['272' '15280910420' '20191225' '' '' '' '']
['275' '17704880923' '20191225' '' '' '' '']
['0' '13981165455' '20200103' '1' '' '' '']
['1' '15308305057' '20200103' '2' '' '' '']
['16' '15378236325' '20200103' '17' '' '' '']
['31' '18990160047' '20200103' '32' '' '' '']
['50' '1801103418' '20200103' '51' '' '' '']
['56' '13890178866' '20200103' '57' '' '' '']
['69' '18380565720' '20200103' '70' '' '' '']
['80' '15386653349' '20200103' '81' '' '' '']
['83' '18980595626' '20200103' '84' '' '' '']
['97' '18030984469' '20200103' '98' '' '' '']
['106' '13658139189' '20200103' '107' '' '' '']
['111' '15983081157' '20200103' '112' '' '' '']
['116' '13990170725' '20200103' '117' '' '' '']
['141' '18008160510' '20200103' '142' '' '' '']
['163' '17364973908' '20200103' '164' '' '' '']
['164' '13778163384' '20200103' '165' '' '' '']
['166' '13990102388' '20200103' '167' '' '' '']
['196' '15881680681' '20200103' '197' '' '' '']
['197' '15228472616' '20200103' '198' '' '' '']
['199' '13350967167' '20200103' '200' '' '' '']
['250' '19683653274' '20200103' '251' '' '' '']
['261' '18161017898' '20200103' '262' '' '' '']
['278' '1318999756' '20200103' '279' '' '' '']
['287' '13618776884' '20200103' '288' '' '' '']
['293' '18280792856' '20200103' '294' '' '' '']
['305' '15384034782' '20200103' '306' '' '' '']
['324' '13890128462' '20200103' '325' '' '' '']
['329' '15228378183' '20200103' '330' '' '' '']
['331' '13808116819' '20200103' '332' '' '' '']
['337' '15328217171' '20200103' '338' '' '' '']
['342' '13398557189' '20200103' '343' '' '' '']
['352' '15681147135' '20200103' '353' '' '' '']
['367' '18990106478' '20200103' '368' '' '' '']
['370' '13035688369' '20200103' '371' '' '' '']
['5' '15351230632' '20200110' '' '' '' '']
['54' '13696284849' '20200110' '' '' '' '']
['66' '13208266645' '20200110' '' '' '' '']
['82' '13568439868' '20200110' '' '' '' '']
['87' '13398391618' '20200110' '' '' '' '']
['121' '13619666017' '20200110' '' '' '' '']
['124' '15386665627' '20200110' '' '' '' '']
['133' '15528586603' '20200110' '' '' '' '']
['140' '18781196114' '20200110' '' '' '' '']
['141' '15908206065' '20200110' '' '' '' '']
['145' '15386620359' '20200110' '' '' '' '']
['149' '15284032733' '20200110' '' '' '' '']
['169' '15281121827' '20200110' '' '' '' '']
['171' '18781117225' '20200110' '' '' '' '']
['178' '15881606683' '20200110' '' '' '' '']
['182' '15282966595' '20200110' '' '' '' '']
['187' '15390156516' '20200110' '' '' '' '']
['200' '13990197763' '20200110' '' '' '' '']
['207' '17709026202' '20200110' '' '' '' '']
['209' '15386662844' '20200110' '' '' '' '']
['210' '18990159849' '20200110' '' '' '' '']
['213' '15308325241' '20200110' '' '' '' '']
['232' '17331567990' '20200110' '' '' '' '']
['251' '18048613372' '20200110' '' '' '' '']
['255' '15678237418' '20200110' '' '' '' '']
['258' '18048614587' '20200110' '' '' '' '']
['271' '13541749613' '20200110' '' '' '' '']
['299' '13398386546' '20200110' '' '' '' '']
['324' '18161016167' '20200110' '' '' '' '']
['329' '18990101776' '20200110' '' '' '' '']
['381' '15378490096' '20200110' '' '' '' '']
['433' '13541731281' '20200110' '' '' '' '']
221
