#!/usr/bin/env python def main(): f = open('game_log.tsv', encoding='utf-8') wf = open('game_log_new.csv', 'w', encoding='utf-8') for i, l in enumerate(f.readlines()): if i == 0: wf.write('event_time,event_lat,event_lng,tracker_trigger,comments\n') else: l = l.replace('None', '') data = l.strip().split('\t') data[0] = data[0].replace(' ', '-', 1) wf.write('%s\n' % ','.join(data)) wf.close() f.close() if __name__ == '__main__': main()