Advertisement
Guest User

Untitled

a guest
Oct 12th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. import json
  2. import csv
  3. import sys
  4. input = []
  5. for line in open('test.txt', 'r'):
  6. input.append(json.loads(line))
  7.  
  8. with open("data.csv","w") as data_list:
  9. output = csv.writer(data_list)
  10. keys = input[1].keys()
  11. output.writerow(keys)
  12. for row in input:
  13. data = [row.get(key, "") for key in keys]
  14. output.writerow(data)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement