Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import json
- import csv
- import io
- data_json = io.open('tweets.json', mode='r', encoding='utf-8').read()
- data_python = json.loads(data_json)
- csv_out = io.open('tweets_out_utf8.csv', mode='w', encoding='utf-8')
- fields = u'created_at,text,screen_name,followers,friends,rt,fav'
- csv_out.write(fields)
- csv_out.write(u'n')
- for line in data_python:
- row = [line.get('created_at'),
- '"' + line.get('text').replace('"','""') + '"',
- line.get('user').get('screen_name'),
- str(line.get('user').get('followers_count')),
- str(line.get('user').get('friends_count')),
- str(line.get('retweet_count')),
- str(line.get('favorite_count'))]
- row_joined = u','.join(row)
- csv_out.write(row_joined)
- csv_out.write(u'n')
- csv_out.close()
Add Comment
Please, Sign In to add comment