Python implements two text merges
Work number and name are recorded in the employee file
Copy the Code code as follows:
Cat Employee.txt:
Jason Smith
John Doe
Sanjay Gupta
Ashok Sharma
Record work number and salary in bonus file
Copy the Code code as follows:
Cat Bonus.txt:
100 $5,000
200
300 $3,000
400 $1,250
Request to merge two files and output as follows, processing the result:
Copy the Code code as follows:
Ashok Sharma $1,250
Jason Smith $5,000
John Doe
Sanjay Gupta $3,000
This is supposed to be written by the shell, but my shell is not very good, I use Python to achieve
Note that, according to the title, the output file also needs to be sorted by initials.
Copy the Code code as follows:
#! /usr/bin/env python
#coding =utf-8
Fp01=open ("Bonus.txt", "R")
A=[]
For LINE01 in FP01:
A.append (LINE01)
Fp02=open ("Employee.txt", "R")
Fc02=sorted (Fp02,key=lambda x:x.split () [1])
For LINE02 in FC02:
I=0
While Line02.split () [0]!=a[i].split () [0]:
I+=1
Print "%s%s%s%s"% (Line02.split () [0],line02.split () [1],line02.split () [2],a[i].split () [1])
Fp01.close ()
Fp02.close ()