how to convert json to csv with python?
Ho Yeung Lee
davidbenny2000 at gmail.com
Sat Jun 3 07:32:15 EDT 2017
after edit the file,
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 364, in decode
obj, end = self.raw_decode(s, idx=_w(s, 0).end())
File "C:\Python27\lib\json\decoder.py", line 380, in raw_decode
obj, end = self.scan_once(s, idx)
ValueError: Expecting property name: line 38 column 1 (char 871)
got another error
Chris Warrick於 2017年6月3日星期六 UTC+8下午7時20分34秒寫道:
> 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
More information about the Python-list
mailing list