Extract part of data from JSON file using python

Question

I have been trying to extract only certain data from a JSON file using python.I wanted to create an array from my json which has some entries as below

[{"Device Name":"abc", "Device Caps":["a1", "b1", "c1"]},
{"Device Name":"def", "Device Caps":["a2", "b2", "c2"]},
{"Device Name":"ghi", "Device Caps":["a3", "b3", "c3"]},
{"Device Name":"jkl", "Device Caps":["a4", "b4", "c4"]}]

I need my output as ["a1","a2","a3","a4"]

So where did you get stuck with this? Note that once parsed, all you have is a list with dictionaries in it. Those are handled the same wherever they came from; this is not really a JSON problem. — Martijn Pieters
– Martijn Pieters, Commented Oct 18, 2016 at 17:14
Console throws error while executing this code. Error displayed below. one=[item["Device Caps"][0] for item in data] TypeError: string indices must be integers, not str — Abdul Jaleel
– Abdul Jaleel, Commented Oct 18, 2016 at 17:18

Robᵩ · Accepted Answer · 2016-10-18 17:14:56Z

1

If that is literally your input file, then the following code will produce the output you want:

import json

with open("input.json") as input_file:
    data = json.load(input_file)
data = [d["Device Caps"][0] for d in data]

print(data)

answered Oct 18, 2016 at 17:14

Robᵩ

170k20 gold badges251 silver badges323 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Abdul Jaleel Over a year ago

Traceback (most recent call last): File "C:\Users\injaleea\Desktop\test1.py", line 13, in <module> data = json.load(input_file) File "C:\Python27\lib\json_init_.py", line 290, in load **kw) File "C:\Python27\lib\json_init_.py", line 338, in loads return _default_decoder.decode(s) File "C:\Python27\lib\json\decoder.py", line 366, in decode obj, end = self.raw_decode(s, idx=_w(s, 0).end()) File "C:\Python27\lib\json\decoder.py", line 384, in raw_decode raise ValueError("No JSON object could be decoded") ValueError: No JSON object could be decoded

Abdul Jaleel Over a year ago

Traceback (most recent call last): File "C:\Users\injaleea\Desktop\test1.py", line 13, in <module> data = json.load(input_file) File "C:\Python27\lib\json_init_.py", line 290, in load **kw) File "C:\Python27\lib\json_init_.py", line 338, in loads return _default_decoder.decode(s) File "C:\Python27\lib\json\decoder.py", line 366, in decode obj, end = self.raw_decode(s, idx=_w(s, 0).end()) File "C:\Python27\lib\json\decoder.py", line 384, in raw_decode raise ValueError("No JSON object could be decoded") ValueError: No JSON object could be decoded

Abdul Jaleel Over a year ago

Returned the error below

Traceback (most recent call last):   File "C:\Users\injaleea\Desktop\test1.py", line 13, in <module>data = json.load(input_file)File "C:\Python27\lib\json\__init__.py", line 290, in load**kw)   File "C:\Python27\lib\json\__init__.py", line 338, in loadreturn _default_decoder.decode(s)   File "C:\Python27\lib\json\decoder.py", line 366, in decode  obj, end = self.raw_decode(s, idx=_w(s, 0).end())   File "C:\Python27\lib\json\decoder.py", line 384, in raw_decode     raise ValueError("No JSON object could be decoded") ValueError: No JSON object could be decoded

Robᵩ Over a year ago

From that error message, I infer that what you posted is not your JSON file.

Abdul Jaleel Over a year ago

You were right.My json had some more comment section on top. Is there a way to ignore them ?

Collectives™ on Stack Overflow

Extract part of data from JSON file using python

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related