竖排文件打横
文件类型(1)
mobile1 value1
mobile1 value2
mobile1 value3
mobile1 value4
mobile2 value1
mobile2 value2
mobile2 value3
mobile2 value4
转化为文件:
mobile1 value1 value2 value3 value4
mobile2 value1 value2 value3 value4
f1 = open('var_result_3.txt','r')
f2 = open('var_result_5.txt','w')
oldmobile = ''
detail = []
lines = f1.readlines()
for line in lines:
line = line.strip().split('\t')
mobile = line[0]
value = line[1]
if (oldmobile == mobile):
detail.append(value)
else:
if len(detail) != 0:
f2.write(oldmobile+'\t')
for row1 in detail:
f2.write(row1+',')
f2.write('\n')
detail=[]
oldmobile=mobile
detail.append(value)
if len(detail) != 0:
f2.write(oldmobile+'\t')
for row1 in detail:
f2.write(row1+',')
detail=[]
oldmobile=mobile
detail.append(line[1])
f1.close()
f2.close()