gistfile1.py

import sys
import re
f = open('~/Documents/spillovers/tech_proximity2/orbis_patents_titles.csv').read()
patents = {}
rows = f.split('\n')[1:]
numbers = [j.split(',')[0] for j in rows]
titles = [j.split(',')[1:] for j in rows]
for i in range(0,len(numbers)):
    patents[numbers[i]] = titles[i]
for i in len(titles)
    titles[i] = re.replace(',','',titles[i])
f = open('patenttitles.csv','w')
f.truncate()
f.write('numbers','titles')
for i in range(0,len(patents.keys())):
    f.write('\n'+patents.keys()[i]+','+patents.values()[i])
f.close()