how to convert json to csv with python?

[Chris Warrick]

On 3 June 2017 at 13:00, Ho Yeung Lee <davidbenny2000 at gmail.com> wrote:
> 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"
> },
> [snip]

This is invalid JSON. You need to wrap all your dicts in a JSON array,
like this:

[
  {
     "ip": "…"
  },
  {
     "ip": "…"
  }
]

(just add [ and ] to the start and end of your file)

-- 
Chris Warrick <https://chriswarrick.com/>
PGP: 5EAAEA16