Retrieve specific data by splitting json data into chunks with python

Question

how can I get the "symbol" data in a json data like below? I am using Python.

Also, how can I replace the "}" object in this data with replace?

[
{"symbol": "ZILUSDT", "positionAmt": "0", "entryPrice": "0.00000", "markPrice": "0.01728152", "unRealizedProfit": "0.00000000", "liquidationPrice": "0", "leverage": "20", "maxNotionalValue": "25000", "marginType": "cross", "isolatedMargin": "0.00000000", "isAutoAddMargin": "false", "positionSide": "SHORT"}, 
{"symbol": "FLMUSDT", "positionAmt": "0", "entryPrice": "0.0000", "markPrice": "0.00000000", "unRealizedProfit": "0.00000000", "liquidationPrice": "0", "leverage": "20", "maxNotionalValue": "25000", "marginType": "cross", "isolatedMargin": "0.00000000", "isAutoAddMargin": "false", "positionSide": "BOTH"}, 
{"symbol": "FLMUSDT", "positionAmt": "0", "entryPrice": "0.0000", "markPrice": "0.00000000", "unRealizedProfit": "0.00000000", "liquidationPrice": "0", "leverage": "20", "maxNotionalValue": "25000", "marginType": "cross", "isolatedMargin": "0.00000000", "isAutoAddMargin": "false", "positionSide": "LONG"}, 
{"symbol": "FLMUSDT", "positionAmt": "0", "entryPrice": "0.0000", "markPrice": "0.00000000", "unRealizedProfit": "0.00000000", "liquidationPrice": "0", "leverage": "20", "maxNotionalValue": "25000", "marginType": "cross", "isolatedMargin": "0.00000000", "isAutoAddMargin": "false", "positionSide": "SHORT"}
]

symbols = [x['symbol'] for x in data].

ekhumoro
– ekhumoro

2020-10-30 15:58:10 +00:00
Commented Oct 30, 2020 at 15:58 — ekhumoro
– ekhumoro, Commented Oct 30, 2020 at 15:58

avarice · Accepted Answer · 2020-10-30 16:01:46Z

0

You can iterate over the list of dictionaries after loading it as JSON (assuming it is d):

print(*[x['symbol'] for x in d],sep="\n")

Readable way:

for x in d:
  print(x['symbol'])

Load from a file:

import json
with open('json.txt') as f:
  d = json.load(f)

answered Oct 30, 2020 at 16:01

avarice

15.6k3 gold badges19 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Fatih mzm Over a year ago

Thank you very much for the sample. How can I tabulate this with "pypi.org/project/Columnar"?

John Gordon · Accepted Answer · 2020-10-30 15:58:34Z

0

That is a list of dictionaries.

import json

with open('myfile.json') as file:
    items = json.load(file)

for item in items:
    print(item['symbol'])

answered Oct 30, 2020 at 15:58

John Gordon

33.8k9 gold badges48 silver badges72 bronze badges

3 Comments

Fatih mzm Over a year ago

Thank you very much for the sample. How can I tabulate this with "pypi.org/project/Columnar"?

John Gordon Over a year ago

@Fatihmzm Perhaps you should ask a new question for that.

Fatih mzm Over a year ago

I opened a new topic, can you help me? stackoverflow.com/questions/64612074/…

Fantantonio · Accepted Answer · 2020-10-30 16:04:54Z

0

To read json data use the json.load() function.

# Python program to read 
# json file 


import json 

# Opening JSON file 
f = open('data.json',) 

# returns JSON object as 
# a dictionary 
data = json.load(f) 

# Iterating through the json 
# list 
for i in data['symbol']: 
    print(i) 

# Closing file 
f.close()

Source https://www.geeksforgeeks.org/read-json-file-using-python/

edited Oct 30, 2020 at 16:04

answered Oct 30, 2020 at 15:58

Fantantonio

4276 silver badges17 bronze badges

4 Comments

John Gordon Over a year ago

I don't see an emp_details key in the sample data.

Fantantonio Over a year ago

That's because it's referred to the source code I added to the bottom...thanks for pointing it out; I just edited it to print "symbol" as the question asks.

Fatih mzm Over a year ago

Thank you very much for the sample. How can I tabulate this with "pypi.org/project/Columnar"?

Fantantonio Over a year ago

You should open a new question to ask that, anyway writing something like: data = [] table = columnar(data, headers=['Race', 'Date', 'Location', 'Distance'], patterns=patterns) print(table) And replacing print(i) with data.append(i)

Collectives™ on Stack Overflow

Retrieve specific data by splitting json data into chunks with python

3 Answers 3

1 Comment

3 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

3 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related