Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Help Parsing JSON
#4
You can loop.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
data = {
    "12345": {
        "2021-01-20": {
            "a": 1,
            "b": 3,
            "c": 0
        },
        "2021-01-21": {
            "a": 1,
            "b": 3,
            "c": 0
        }
    },
    "12346": {
        "2021-01-20": {
            "a": 1,
            "b": 3,
            "c": 0
        },
        "2021-01-21": {
            "a": 1,
            "b": 3,
            "c": 0
        }
    }
}
 
 
for customer_id, dates in data.items():
    for date, values in dates.items():
        for key, value in values.items():
            print(customer_id, date, key, value, sep=", ")
            # here is maybe one level too deep
            # depends on your task
Or you can access data directly with subscription:

1
value = data["12345"]["2021-01-20"]["c"]
Almost dead, but too lazy to die: https://sourceserver.info
All humans together. We don't need politicians!
Reply


Messages In This Thread
Help Parsing JSON - by kfwydfo1x - Jan-25-2021, 12:57 PM
RE: Help Parsing JSON - by buran - Jan-25-2021, 01:12 PM
RE: Help Parsing JSON - by kfwydfo1x - Jan-25-2021, 01:29 PM
RE: Help Parsing JSON - by DeaD_EyE - Jan-25-2021, 01:33 PM
RE: Help Parsing JSON - by buran - Jan-25-2021, 01:44 PM
RE: Help Parsing JSON - by DeaD_EyE - Jan-26-2021, 10:42 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Parsing large JSON josvink66 5 2,088 Jan-10-2024, 05:46 PM
Last Post: snippsat
  Parsing JSON pyStund 4 6,557 Jul-31-2022, 02:02 PM
Last Post: pyStund
  Json Parsing sshree43 5 2,979 May-04-2022, 09:21 PM
Last Post: snippsat
  json api data parsing elvis 0 1,366 Apr-21-2022, 11:59 PM
Last Post: elvis
  string indices must be integers when parsing Json ilknurg 3 10,118 Mar-10-2022, 11:02 AM
Last Post: DeaD_EyE
  Parsing JSON with backslashes bazcurtis 3 11,786 Feb-08-2020, 01:13 PM
Last Post: bazcurtis
  JSON parsing (nested) fakka 0 3,637 Nov-25-2019, 09:25 PM
Last Post: fakka
  Parsing json - dictionary with in dictionary krish216 6 4,737 Jul-30-2019, 10:01 PM
Last Post: cvsae
  JSON Parsing PythonLearner007 3 3,283 Jan-31-2019, 10:47 AM
Last Post: gontajones

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020