擅长:python、mysql、java
<pre><code>#suppose database files are f1.txt,f2.txt,f3.txt
#use set to get key-value format datas
def getArr(f):
i=f.readline()
arr=[]
while i:
i=i.replace('\n','')
arr.append(i.split('\t'))
i=f.readline()
return arr
if __name__=="__main__":
f1=file("f1.txt")
f2=file("f2.txt")
f3=open('f3.txt','w')
arr1=getArr(f1)
arr2=getArr(f2)
dic={}
for array in arr1:
dic[array[1]]=array[0]
for i in arr2:
keys=i[1].split(',')
print keys
line=i[0]+'\t'
for key in keys:
line+=dic.get(key)+','
line=line[:-1]+'\n'
f3.write(line)
f1.close()
f2.close()
f3.close()
</code></pre>