Das deutsche Python-Forum

Code: Alles auswählen

g=open(r"c:\results.csv","r")
datei = g.readlines()


g.close()

for splitten in datei:
    splitten = line.split(";")


instr=open(r"c:\instruments.csv","r")
instrDatei = instr.readlines()

instr.close()

for lines in instrDatei:
    splitinstr = line.split(";")

#joinen

m = splitten[3]

outputdatei=[]

for n in range(1,len(datei)):
    for datei[n]in datei:
        for k in range(1,len(instrDatei)):
            for instrDatei[k] in instrDatei:
                if m in splitinstr[3]:
                    z=datei[n].join(splitinstr[4])
outputdatei.append(z)   

[code=]

Code: Alles auswählen

instruments = dict()
with open(r"c:\instruments.csv") as fo:
    for line in fo:
        parts = line.split(";")
        instruments[int(parts[2])] = parts[3]

result = list()
with open(r"c:\results.csv") as fo:
    for line in fo:
        fields = line.split(";")
        fields[2] = instruments.get(int(fields[2]), 'Unknown Instrument')
        result.append(fields)

Code: Alles auswählen

instruments = {}
with open("./instruments.csv") as fi:
    for line in fi:
        data = line.strip().split(",")
        instruments[data[2]] = data[3]
print(instruments)

results = []
with open("./results.csv") as fr:
    for line in fr:
        data = line.strip().split(",")
        results.append([data[0], 
                        data[1], 
                        instruments.get(data[2], data[2]), 
                        data[3]])
print(results)