how to extract data from json. other answers here did not work for me

Question

i want to extract Mac_Address from this json in python. anyone can help ?

{"list":
    [{
       "Group_Devices_id":3,
       "User_Id":19,
       "Mac_Address":" fe80::f17a:4a64:7192:ed68%2 ",
       "Master_Device":"T"
    }],
    "success":true}

The doc could : https://docs.python.org/2/library/json.html#basic-usage — iFlo, Feb 06 '17 at 10:04
Possible duplicate of [Parsing values from a JSON file using Python?](http://stackoverflow.com/questions/2835559/parsing-values-from-a-json-file-using-python) — iFlo, Feb 06 '17 at 10:09

score 0 · Accepted Answer · answered Feb 06 '17 at 10:07

- Import json
- data = json.loads('{"list": [{ "Group_Devices_id":3, "User_Id":19,
   "Mac_Address":" fe80::f17a:4a64:7192:ed68%2 ", "Master_Device":"T"
   }], "success":true}')
- data['list'][0]['Mac_Address']

Desc : Import json libraray, then load your data. then access any elements.

maomifadacai · Answer 2 · 2017-02-06T11:58:56.943

0

import json
data = json.loads('{"list": [{ "Group_Devices_id":3, "User_Id":19,
       "Mac_Address":" fe80::f17a:4a64:7192:ed68%2 ", "Master_Device":"T"
       }], "success":true}'

for item in data["list"]:
   print item["Mac_Address"]

1) Load data

2) Assume you need to get Mac_Address from lots of data of list, then use "for...in.." to process

edited Feb 06 '17 at 11:58

answered Feb 06 '17 at 11:27

maomifadacai

357
2
4
17

Please include some explanation around your answer as to why it solves the OP's original question. This may help - [answer] – Tom Feb 06 '17 at 11:50

how to extract data from json. other answers here did not work for me

2 Answers2