Mercurial > hg > LGDataverses
view scripts/search/tab2json-dvs @ 10:a50cf11e5178
Rewrite LGDataverse completely upgrading to dataverse4.0
author | Zoe Hong <zhong@mpiwg-berlin.mpg.de> |
---|---|
date | Tue, 08 Sep 2015 17:00:21 +0200 |
parents | |
children |
line wrap: on
line source
#!/usr/bin/env python import sys from optparse import OptionParser import csv try: import json except ImportError: import simplejson as json parser = OptionParser() options, args = parser.parse_args() if args: csv_file = open(args[0]) else: csv_file = sys.stdin reader = csv.DictReader(csv_file, delimiter="\t") rows = [row for row in reader] for row in rows: if "contactEmail" in row: contactArray = [] contactHash = {} contactHash["contactEmail"] = row["contactEmail"] contactArray.append(contactHash) row["dataverseContacts"] = contactArray del row["contactEmail"] if "subject" in row: subjectsArray = [] subjectsArray.append(row["subject"]) row["dataverseSubjects"] = subjectsArray del row["subject"] print json.dumps(row) csv_file.close()