how to convert json to csv with python?

Ho Yeung Lee davidbenny2000 at gmail.com
Sat Jun 3 07:00:12 EDT 2017


i use
https://github.com/evidens/json2csv

Error:
Traceback (most recent call last):
  File "json2csv.py", line 148, in <module>
    loader.load(args.json_file)
  File "json2csv.py", line 53, in load
    self.process_each(json.load(json_file))
  File "C:\Python27\lib\json\__init__.py", line 291, in load
    **kw)
  File "C:\Python27\lib\json\__init__.py", line 339, in loads
    return _default_decoder.decode(s)
  File "C:\Python27\lib\json\decoder.py", line 367, in decode
    raise ValueError(errmsg("Extra data", s, end, len(s)))
ValueError: Extra data: line 10 column 2 - line 50 column 2 (char 224 - 1179)

sample file is
{
  "ip": "184.85.123.122",
  "hostname": "No Hostname",
  "city": "Cambridge",
  "region": "Massachusetts",
  "country": "US",
  "loc": "42.3626,-71.0843",
  "org": "AS20940 Akamai International B.V.",
  "postal": "02142"
},
{
  "ip": "203.185.0.32",
  "hostname": "203185000032.ctinets.com",
  "city": "Central District",
  "region": "",
  "country": "HK",
  "loc": "22.2910,114.1500",
  "org": "AS9269 HKBN AS10103"
},
{
  "ip": "184.85.123.122",
  "hostname": "a184-85-123-122.deploy.static.akamaitechnologies.com",
  "city": "Cambridge",
  "region": "Massachusetts",
  "country": "US",
  "loc": "42.3626,-71.0843",
  "org": "AS20940 Akamai International B.V.",
  "postal": "02142"
},
{
  "ip": "203.185.0.32",
  "hostname": "No Hostname",
  "city": "Central District",
  "region": "",
  "country": "HK",
  "loc": "22.2910,114.1500",
  "org": "AS9269 HKBN AS10103",
},
{
  "ip": "184.85.123.122",
  "hostname": "a184-85-123-122.deploy.static.akamaitechnologies.com",
  "city": "Cambridge",
  "region": "Massachusetts",
  "country": "US",
  "loc": "42.3626,-71.0843",
  "org": "AS20940 Akamai International B.V.",
  "postal": "02142"
}

outline is
{
  "map": [["ip","ip"],["hostname", "hostname"],["city", "city"],["region", "region"],["country" ,"country"],["loc", "loc"],["org", "org"],["postal", "postal"]] }




More information about the Python-list mailing list