Mercurial > hg > LGDataverses
view scripts/search/tab2json-dvs @ 14:be7787c36e58 default tip
new: nofity LGSercies for deleted files
author | Zoe Hong <zhong@mpiwg-berlin.mpg.de> |
---|---|
date | Mon, 02 Nov 2015 16:41:23 +0100 |
parents | a50cf11e5178 |
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()