Python: Parsing json list

Question

HI guys I basically want to parse this json data.

[
    {
        "id": 417862,
        "name": "octokit.rb",
        "full_name": "octokit/octokit.rb",
        "owner": {
            "login": "octokit",
            "id": 3430433,
            "avatar_url": "https://avatars0.githubusercontent.com/u/3430433?v=4",
            "gravatar_id": "",
            "url": "https://api.github.com/users/octokit",
            "html_url": "https://github.com/octokit",
            "followers_url": "https://api.github.com/users/octokit/followers",
            "following_url": "https://api.github.com/users/octokit/following{/other_user}",
            "gists_url": "https://api.github.com/users/octokit/gists{/gist_id}",
            "starred_url": "https://api.github.com/users/octokit/starred{/owner}{/repo}",
            "subscriptions_url": 
        } ]

My question is how do I get the value of "id": 417862 from json

Thanks.

Possible duplicate of [Parsing values from a JSON file?](https://stackoverflow.com/questions/2835559/parsing-values-from-a-json-file) — Mohamed Chaawa, Oct 28 '17 at 01:36

score 0 · Accepted Answer · answered Oct 28 '17 at 02:25

How about:

mylist = [{
  "id": 417862,
  "name": "octokit.rb",
  "full_name": "octokit/octokit.rb",
  "owner": {
    "login": "octokit",
    "id": 3430433,
    "avatar_url": "https://avatars0.githubusercontent.com/u/3430433?v=4",
    "gravatar_id": "",
    "url": "https://api.github.com/users/octokit",
    "html_url": "https://github.com/octokit",
    "followers_url": "https://api.github.com/users/octokit/followers",
    "following_url": "https://api.github.com/users/octokit/following{/other_user}",
    "gists_url": "https://api.github.com/users/octokit/gists{/gist_id}",
    "starred_url": "https://api.github.com/users/octokit/starred{/owner}{/repo}",
    "subscriptions_url": "cats"
  }
}]

print mylist[0]['id']

This returns prints the id attribute of the 0th (i.e. first) member of mylist, which equals 417862.

score 0 · Answer 2 · edited Aug 21 '21 at 15:01

0

Let's assume you are using pandas:

create a function and return the 1st value of list,

def get_json_data(mylist):
    return mylist[0]

Create a new column and apply the function:

df['new_col']=df.apply(lambda df: get_json_data(df['old_col']),axis=1)

Once you get the data, just normalize it:

pd.io.json.json_normalize(df['new_col'])

Hope this helps :)

edited Aug 21 '21 at 15:01

marc_s

732,580
175
1,330
1,459

answered Jan 27 '20 at 16:34

Mantej Singh

392
4
8

Python: Parsing json list

2 Answers2