Archives
Trending
Support
Login
clear text
XML
Django
JavaScript
MATLAB
C
C++
C#
Python
SQL
Shell
Bash
Markdown
YAML
JSON
HTML
CSS
PHP
Java
Ruby
Go
Rust
Swift
Kotlin
Arduino
TypeScript
Perl
Autohotkey
Lua
SQF
R
Scala
Haskell
Groovy
Dart
Clojure
VB.NET
Objective-C
PowerShell
Bash
CoffeeScript
Verilog
#!/usr/bin/env python import sys, getopt import csv import json #usage if ((len(sys.argv) < 3)): print """\ USAGE: csv2json -i users.csv -o users.json -f pretty """ sys.exit(1) #Get Command Line Arguments def main(argv): input_file = '' output_file = '' format = '' try: opts, args = getopt.getopt(argv,"hi:o:f:",["ifile=","ofile=","format="]) except getopt.GetoptError: print 'csv_json.py -i
-o
-f
' sys.exit(2) for opt, arg in opts: if opt == '-h': print 'csv_json.py -i
-o
-f
' sys.exit() elif opt in ("-i", "--ifile"): input_file = arg elif opt in ("-o", "--ofile"): output_file = arg elif opt in ("-f", "--format"): format = arg read_csv(input_file, output_file, format) #Read CSV File def read_csv(file, json_file, format): csv_rows = [] with open(file) as csvfile: reader = csv.DictReader(csvfile) title = reader.fieldnames for row in reader: csv_rows.extend([{title[i]:row[title[i]] for i in range(len(title))}]) write_json(csv_rows, json_file, format) #Convert csv data into json and write it def write_json(data, json_file, format): with open(json_file, "w") as f: if format == "pretty": f.write(json.dumps(data, sort_keys=False, indent=4, separators=(',', ': '),encoding="utf-8",ensure_ascii=False)) else: f.write(json.dumps(data)) if __name__ == "__main__": main(sys.argv[1:])
Mark as private (unlisted)
for 30 minutes
for 6 hours
for 1 day
for 1 week
for 1 month
for 1 year
everlasting (like CCCP)