fetch('data.json')
выполняется на компьютере пользователя внутри его браузера, а файл вы сохранили в файловой системе сервера, в каталоге где запущено ваше приложение.import yaml
with open('test.json', encoding='utf-8') as f:
data = yaml.load(f, yaml.CSafeLoader)
wrong_json = '{"name":"Максимальная дальность","unit":cH,"value":"invalid_key"}'
print(yaml.load(wrong_json, yaml.BaseLoader))
sys.getdefaultencoding()
> 'íåæèëîãî'.encode('latin1').decode('cp1251')
'нежилого'
получить информацию из огромного json массива
{'text': 'нажми на это сообщение',
'bold': True,
'color': 'dark_red',
'clickEvent': {'action': 'run_command',
'value': '/give @p written_book{pages:["{\\"text\\":\\"нажми на это сообщение\\",\\"bold\\":true,\\"color\\":\\"dark_red\\",\\"clickEvent\\":{\\"action\\":\\"run_command\\",\\"value\\":\\"/give @p oak_sign{BlockEntityTag:{Text1:\\\\\\"{\\\\\\\\\\\\\\"text\\\\\\\\\\\\\\":\\\\\\\\\\\\\\"нажми на это сообщение\\\\\\\\\\\\\\",\\\\\\\\\\\\\\"bold\\\\\\\\\\\\\\":true,\\\\\\\\\\\\\\"color\\\\\\\\\\\\\\":\\\\\\\\\\\\\\"dark_red\\\\\\\\\\\\\\",\\\\\\\\\\\\\\"clickEvent\\\\\\\\\\\\\\":{\\\\\\\\\\\\\\"action\\\\\\\\\\\\\\":\\\\\\\\\\\\\\"run_command\\\\\\\\\\\\\\",\\\\\\\\\\\\\\"value\\\\\\\\\\\\\\":\\\\\\\\\\\\\\"/title @a title {\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"text\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\":\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"ТЫ ПРИЁМНЫЙ\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\",\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"bold\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\":true,\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"color\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\":\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"gold\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"}\\\\\\\\\\\\\\"}}\\\\\\",id:\\\\\\"Sign\\\\\\"}}\\"}}"],title:"Custom Book",author:Player}'}}
Unexpected token p in JSON at position 0 at JSON.parse
parseResults({"response":{"Header":
jq -c ".[]"
split -l 10 -d - my_chunk_prefix_
for f in my_chunk_prefix_*; do cat $f | sed '1s/^/[/; $!s/$/,/; $s/$/]/' | jq "" > $f.json ; rm $f ; done
jq -c ".[]" my_big.json | split -l 10 -d - my_chunk_prefix_
for f in my_chunk_prefix_*; do cat $f | sed '1s/^/[/; $!s/$/,/; $s/$/]/' | jq "" > $f.json ; rm $f ; done
import struct
import json
filepath = 'hits.dat'
events = {}
with open(filepath, 'rb') as fp:
buffer = fp.read(28)
while len(buffer) == 28:
event_id, track_id, x, y, z = struct.unpack(">HHddd", buffer)
buffer = fp.read(28)
event = events.setdefault(event_id, dict(event_id=event_id, tracks={}))
track = event['tracks'].setdefault(track_id, dict(coordinates=[]))
track['coordinates'].append(dict(x=x, y=y, z=z))
with open('hits.json', 'w') as fp:
json.dump(events, fp, indent=2)
events = {
1: {
'event_id': 1,
'tracks': {
1: {
'track_id': 1,
'coordinates': [
{'x': 1, 'y': 2, 'z': 3},
{'x': 4, 'y': 5, 'z': 6}
]
},
2: {
'track_id': 2,
'coordinates': [
{'x': 12, 'y': 22, 'z': 33},
{'x': 44, 'y': 55, 'z': 66}
]
}
}
}
}
echo '[{"name": "ha-collector-data-test1"}, {"name": "ha-collector-data-test2"}]' | py "[item['name'] for item in json.load(sys.stdin) if item['name'].startswith('ha-collector-data-')]"
import json
FILTER='[{"name": "ha-collector-data-test1"}, {"name": "ha-collector-data-test2"}, {"name": "ha-collector-data-test3"}]'
filter_data = json.loads(FILTER)
items = [
item['name']
for item in filter_data
if item['name'].startswith('ha-collector-data-')
]
import csv
import sys
import typing
import json
def deep_walk(j, path=()):
if isinstance(j, dict):
for k, v in j.items():
yield from deep_walk(v, path + (f'.{k}',))
elif isinstance(j, list):
for i, v in enumerate(j):
yield from deep_walk(v, path + (f'[{i}]',))
else:
yield path, j
def json2csv(data: typing.Union[dict, list], dest: typing.TextIO = None):
field_set = set()
records = []
if isinstance(data, dict):
data = [data]
for item in data:
record = {''.join(path).lstrip('.'): value for path, value in deep_walk(item)}
records.append(record)
field_set.update(record.keys())
w = csv.DictWriter(dest or sys.stdout, fieldnames=list(sorted(field_set)))
w.writeheader()
w.writerows(records)
if __name__ == '__main__':
if sys.argv[1:]:
with open(sys.argv[1]) as f:
json2csv(json.load(f))
else:
json2csv(json.load(sys.stdin))