gistfile1.txt

import json
import sys

"""
HEADERS = [
    ('index', 'index'),
    ('product/productId', 'product_id'),
    ('product/productTitle', 'product_title'),
    ('product/price', 'price'),
    ('review/userId', 'review_user_id'),
    ('review/profileName', 'review_profile_name'),
    ('review/score', 'review_score'),
    ('review/helpful', 'review_helpful'),
    ('review/ratings', 'review_ratings'),
    ('review/time', 'review_time'),
    ('review/summary', 'review_summary'),
    ('review/text', 'review_text')
]
"""

HEADERS = [
    ('index', 'index'),
    ('product/price', 'price'),
    ('product/productId', 'productId'),
    ('review/helpful', 'helpfulessScore'),
    ('review/ratings', 'helpfulnessCount'),
    ('review/profileName', 'profileName'),
    ('review/score', 'score'),
    ('review/summary', 'summary'),
    ('review/text', 'text'),
    ('review/time', 'time'),
    ('review/userId', 'userId')
]

def encode(val):
    if val is None:
        return "\\N"
    elif isinstance(val, str):
        return val.replace("\t", "\\t").replace("\n", "\\n")
    else:
        return str(val)

print("\t".join([h[1] for h in HEADERS]))

for line in sys.stdin:
    doc = json.loads(line)
    
    print("\t".join([encode(doc[h[0]]) for h in HEADERS]))