from urllib import request

class converter:
    
    out ="/var/tmp/out.csv"
    url = "http://md.mpiwg-berlin.mpg.de/purls/search?q="  # /permanent/library/W028ATN3
    def read(self,fn):
        
        of = open(self.out,"w")
        
        fl = open(fn,"r")
        
        for line in fl.readlines():
            line = line.replace("\n","")
            line = line.replace('"','')
            splitted = line.split(",")
            
            path = splitted[0].replace('"','')
            path = path.replace("/mpiwg/online","")
            
            qr = self.url + path
            
            g = request.urlopen(qr, data=bytearray(path,"utf-8"))
            
            p = g.read().decode('utf-8')
            
            spl = p.split("\t")
            
            if len(spl) > 1:
                dri = spl[1]
                
                splitted.append(dri)
                
                print (splitted)
                
                of.write(",".join(splitted)+"\n")
                
        
        of.close()
            
        
            
        
cv =converter()

cv.read("/var/tmp/archive.csv")