在python中迭代json提要

2条回答

网友

1楼 · 编辑于 2024-09-28 01:31:42

JSON文件很棘手。我对草稿文件做了类似的处理。
https://gist.github.com/doyousketch2/8c1d07923554c78ed888b089e45536e2
这将为您获取密钥和条目。
如果你需要更多的帮助来解决如何解析这些问题，只需回复。在

#!/usr/bin/python3
# -*- coding: utf-8 -*-
##=========================================================
##  SiriJsonExtract.py  ~~~~~~~~~~~~~~~~~~~~~  17 Mar, 2017
##
##  Eli Innis
##  Twitter:  @ Doyousketch2
##  Email:  Doyousketch2 @ yahoo.com
##  GNU GPLv3  gnu.org/licenses/gpl-3.0.html
##=========================================================
##  libs  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

import json               ##  convert .json file into dicts

##=========================================================
##  vars  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

defaultDir  = '/home/eli/Programming/Python/siri/'
siri  = 'siri.json'
msg = []

##=========================================================
##  open file  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

with open((defaultDir + siri), 'r') as data:               ##  "with" is Python's crash resistant file open
    jay = json .load(data)                                 ##  load JSON file into the variable jay

##==============================================
##  In order to use a JSON file, we need to traverse down it's branches.
##  I modified code that was intended for recursive printing:
##  code.activestate.com/recipes/578094-recursively-print-nested-dictionaries

##  'item' is the item we are currently scanning
##  'depth' is how far we are within it, ie  this[0] [1] [2] [3]
##  'key' is used for dictionaries, so we can get the correct values associated with that particular key

def scan(item, depth = 0, key = ''):
    global msg
    tabs = lambda n: ' ' * n                               ##  simple spaces will suffice for tabs

    if isinstance(item, dict):                             ##  if we have a dictionary entry
        for key, value in sorted(item .items()):           ##  iterate through keys & values
            msg .append(tabs(depth) + 'key:   %s' % key)
            scan(value, depth + 2, key)                    ##  scan deeper

    elif isinstance(item, list):                           ##  if we have a list entry
        for listitem in item:                              ##  iterate through list items
            scan(listitem, depth + 2)                      ##  go even deeper in this list

    else:                                                  ##  can't go down. number, boolean, or empty set
        msg .append(tabs(depth) + 'item:   %s\n' % item)   ##  append the command or arg,  with a bit of padding,
                                                           ##  so the next one we paste doesn't collide.
    return msg

##==============================================
##  main  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

scan(jay)  ##  begin our scan here

text = '\n' .join(msg)
print(text)

##==============================================
##  eof  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

网友

2楼 · 编辑于 2024-09-28 01:31:42

在first answer中更容易看到它是如何迭代JSON条目的。
这里变得更复杂了。一半是法语。
我爸爸会说法语，但我只听过一些零碎的东西。在

如果我能看到期望的输出是什么样子，那会有帮助。
我不知道什么是RATP。这好像是公车时刻表？
我不明白为什么一切都要转换成秒。在

你能把你想要的输出写一个大概的草稿吗？在

#!/usr/bin/python3
# -*- coding: utf-8 -*-
##=========================================================
##  SiriJsonExtract.py  ~~~~~~~~~~~~~~~~~~~~~  17 Mar, 2017
##
##  Eli Innis
##  Twitter:  @ Doyousketch2
##  Email:  Doyousketch2 @ yahoo.com
##
##  GNU GPLv3  gnu.org/licenses/gpl-3.0.html
##
##=========================================================
##  libs  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

import datetime
import time
import pytz
import json
from dateutil.parser import parse

##=========================================================
##  vars  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

defaultDir  = '/home/eli/Programming/Python/siri/'
siri  = 'siri.json'

##=========================================================
##  global placeholder

msg = []

##=========================================================
##  open file  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

with open((defaultDir + siri), 'r') as data:               ##  "with" is Python's crash resistant file open
    jay = json .load(data)                                 ##  load JSON file into the variable jay

##=========================================================
##  scan funct  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

def scan(item, depth = 0, key = ''):
    global msg
    EPOCH = datetime.datetime(1970, 1, 1, tzinfo=pytz.utc)
    # stoptime = ent.trip_update.stop_time_update.add()
    tabs = lambda n: ' ' * n                               ##  simple spaces will suffice for tabs

    if isinstance(item, dict):                             ##  if we have a dictionary entry
        for key, value in sorted(item .items()):           ##  iterate through keys & values
            if key .endswith('ArrivalTime') :
                msg .append(tabs(depth) + 'Arrival:   %s  Time: %s' % (key, parse(value)))
                arrival_time = (parse(value) - EPOCH).total_seconds()
                # stoptime.arrival.time = int(arrival_time)

            elif key .endswith('DepartureTime') :
                msg .append(tabs(depth) + 'Departure:   %s  Time: %s' % (key, parse(value)))
                departure_time = (parse(value) - EPOCH).total_seconds()
                # stoptime.departure.time = int(departure_time)

            elif key == 'recordedAtTime':
                msg .append(tabs(depth) + 'recordedAtTime:   %s' % parse(value))

            elif key .startswith('datedVehicle'):
                msg .append(tabs(depth) + 'Operator:   %s' % value['value'])

            elif key == 'originName':
                if len(value) > 0:
                    msg .append(tabs(depth) + 'originName:   %s' % value[0]['value'])

            elif key == 'originRef':
                if len(value) > 0:
                    msg .append(tabs(depth) + 'originRef:   %s' % value['value'])

            elif key == 'directionName':
                if len(value) > 0:
                    msg .append(tabs(depth) + 'directionName:   %s' % value[0]['value'])

            elif key == 'publishedLineName':
                msg .append(tabs(depth) + 'publishedLineName:   %s' % value[0]['value'])

            elif key == 'destinationName':
                msg .append(tabs(depth) + 'destinationName:   %s' % value[0]['value'])

            elif key == 'destinationRef':
                msg .append(tabs(depth) + 'destinationRef:   %s' % value['value'])

            elif key == 'operatorRef':
                if len(value) > 0:
                    msg .append(tabs(depth) + 'operatorRef:   %s' % value['value'])

            elif key == 'vehicleMode':
                if len(value) > 0:
                    msg .append(tabs(depth) + 'vehicleMode:   %s' % value[0])

            elif key == 'lineRef':
                msg .append(tabs(depth) + 'lineRef:   %s' % value['value'])

            elif key == 'vehicleJourneyName':
                if len(value) > 0:
                    msg .append(tabs(depth) + 'vehicleJourneyName:   %s' % value[0]['value'])

            elif key == 'firstOrLastJourney':
                if len(value) > 0:
                    msg .append(tabs(depth) + 'firstOrLastJourney:   %s' % value)

            elif key == 'stopPointRef':
                if len(value) > 0:
                    msg .append(tabs(depth) + 'stopPointRef:   %s' % value['value'])

            elif key == 'producerRef':
                if len(value) > 0:
                    msg .append(tabs(depth) + 'producerRef:   %s' % value)

            elif key .endswith('Timestamp'):
                msg .append(tabs(depth) + '%s:   %s' % (key, parse(value)))

            elif key == 'status':
                if len(value) > 0:
                    msg .append(tabs(depth) + 'status:   %c' % value[0])

            elif key == 'value':
                msg .append(tabs(depth) + 'Value:   %s' % value)

            else:
                msg .append(tabs(depth) + 'key:   %s' % key)
                scan(value, depth + 2, key)                ##  scan deeper

    elif isinstance(item, list):                           ##  if we have a list entry
        for listitem in item:                              ##  iterate through list items
            scan(listitem, depth + 2)                      ##  go even deeper in this list

    else:                                                  ##  can't go down. number, boolean, or empty set
        msg .append(tabs(depth) + 'item:   %s\n' % item)   ##  append the command or arg,  with a bit of padding,
                                                           ##  so the next one we paste doesn't collide.
    return msg

##=========================================================
##  main    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

scan(jay)  ##  begin our scan here

text = '\n' .join(msg)
print(text)

##=========================================================
##  eof  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

相关问题更多 >

编程相关推荐

热门问题

热门文章

在python中迭代json提要

相关问题 更多 >

编程相关推荐

热门问题

热门文章

相关问题更多 >