Onnowpurbo: Created page with " author = 'seandolinar' import json import csv import io ''' creates a .csv file using a Twitter .json file the fields have to be set manually ''' data_json..."

2017-01-28T04:12:49Z

Created page with " __author__ = 'seandolinar' import json import csv import io ''' creates a .csv file using a Twitter .json file the fields have to be set manually ''' data_json..."

New page

__author__ = 'seandolinar'

import json
import csv
import io

'''
creates a .csv file using a Twitter .json file
the fields have to be set manually
'''

data_json = io.open('raw_tweets.json', mode='r', encoding='utf-8').read() #reads in the JSON file
data_python = json.loads(data_json)

csv_out = io.open('tweets_out_utf8.csv', mode='w', encoding='utf-8') #opens csv file

fields = u'created_at,text,screen_name,followers,friends,rt,fav' #field names
csv_out.write(fields)
csv_out.write(u'\n')

for line in data_python:

#writes a row and gets the fields from the json object
#screen_name and followers/friends are found on the second level hence two get methods
row = [line.get('created_at'),
'"' + line.get('text').replace('"','""') + '"', #creates double quotes
line.get('user').get('screen_name'),
unicode(line.get('user').get('followers_count')),
unicode(line.get('user').get('friends_count')),
unicode(line.get('retweet_count')),
unicode(line.get('favorite_count'))]

row_joined = u','.join(row)
csv_out.write(row_joined)
csv_out.write(u'\n')

csv_out.close()

==Referensi==

* https://raw.githubusercontent.com/seandolinar/Twitter-Tutorial/master/twitter_JSONParser_UTF8.py

Twitter JSONParser UTF8.py - Revision history

Onnowpurbo: Created page with " __author__ = 'seandolinar' import json import csv import io ''' creates a .csv file using a Twitter .json file the fields have to be set manually ''' data_json..."

Onnowpurbo: Created page with " author = 'seandolinar' import json import csv import io ''' creates a .csv file using a Twitter .json file the fields have to be set manually ''' data_json..."