Guest User

Untitled

a guest
Jan 23rd, 2019
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. import json
  2. import csv
  3. import io
  4.  
  5.  
  6. data_json = io.open('tweets.json', mode='r', encoding='utf-8').read()
  7. data_python = json.loads(data_json)
  8. csv_out = io.open('tweets_out_utf8.csv', mode='w', encoding='utf-8')
  9.  
  10.  
  11. fields = u'created_at,text,screen_name,followers,friends,rt,fav'
  12. csv_out.write(fields)
  13. csv_out.write(u'n')
  14.  
  15. for line in data_python:
  16.  
  17. row = [line.get('created_at'),
  18. '"' + line.get('text').replace('"','""') + '"',
  19. line.get('user').get('screen_name'),
  20. str(line.get('user').get('followers_count')),
  21. str(line.get('user').get('friends_count')),
  22. str(line.get('retweet_count')),
  23. str(line.get('favorite_count'))]
  24.  
  25. row_joined = u','.join(row)
  26. csv_out.write(row_joined)
  27. csv_out.write(u'n')
  28.  
  29. csv_out.close()
Add Comment
Please, Sign In to add comment