f = open('pc-full_200900331.csv').readlines() f = [ ':'.join(l.split(',')[:2]) + '\n' for l in f ] open('postcodes', 'w').writelines(f)