transform-disqus.py

import csv
sourcefile = './src/origin.csv'
destinationfile = './dist/https-comments.csv'
data = []
print('Opening write file %r' % destinationfile)
with open(destinationfile, 'w') as writeFile:
  writer = csv.writer(writeFile, delimiter=',')
  print('Opening read file %r' % sourcefile)
  with open(sourcefile, newline='') as csvfile:
    disqussrc = csv.reader(csvfile, delimiter=' ', quotechar='|')
    for row in disqussrc:
      if 'https://' in row[0]: continue
      data.append([row[0], row[0].replace('http://', 'https://')])
     
    writer.writerows( data );
    print('done')