Python下拆分JSON数据块取特定值及获取symbol、替换"}"方法

Let’s break down each of your questions with practical, easy-to-follow code examples using your provided JSON data.

1. Splitting JSON Data into Chunks to Extract Specific Data #

First, you’ll need to convert the JSON string into a native Python data structure (a list of dictionaries here) using the built-in json module. Once parsed, you can iterate over each "chunk" (each dictionary in the list) to target and process the exact data you need.

Example code:

import json

# Your full JSON data as a string
json_data = '''[ {"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"} ]'''

# Parse JSON into a Python list of dictionaries
data_chunks = json.loads(json_data)

# Iterate over each chunk to process specific data
for chunk in data_chunks:
    # Example: Print the symbol and position side for each chunk
    print(f"Symbol: {chunk['symbol']}, Position Side: {chunk['positionSide']}")
    # Add your custom logic here to extract or modify specific fields

This approach lets you work with each entry as an independent chunk, making it simple to filter or manipulate subsets of the data.

2. Extracting the symbol Field from the JSON Data #

Since your parsed data is a list of dictionaries, you can access the symbol field directly by iterating through the list, or use a list comprehension for a more concise solution.

Option 1: Iterate and collect all symbols #

import json

json_data = '''[ {"symbol": "ZILUSDT", ...}, ... ]'''  # Full data as above
data_chunks = json.loads(json_data)

all_symbols = []
for entry in data_chunks:
    all_symbols.append(entry['symbol'])

print(all_symbols)  # Output: ['ZILUSDT', 'FLMUSDT', 'FLMUSDT', 'FLMUSDT']

Option 2: List comprehension (shorter syntax) #

import json

json_data = '''[ {"symbol": "ZILUSDT", ...}, ... ]'''
data_chunks = json.loads(json_data)

all_symbols = [entry['symbol'] for entry in data_chunks]
print(all_symbols)

If you need only entries with a specific symbol (e.g., FLMUSDT), add a condition:

flmusdt_entries = [entry for entry in data_chunks if entry['symbol'] == 'FLMUSDT']

3. Replacing the "}" Character Using the replace Method #

The replace method operates on strings, so you can apply it directly to the original JSON string, or convert parsed data back to a string first if you’ve already processed it.

Example 1: Replace "}" in the original JSON string #

json_data = '''[ {"symbol": "ZILUSDT", ...}, ... ]'''  # Full data as above

# Replace all instances of "}" with a custom string (e.g., "}###")
modified_json_str = json_data.replace("}", "}###")
print(modified_json_str)

Example 2: Replace after parsing (convert back to string) #

If you’ve already parsed the data into a Python object, dump it back to a JSON string first, then apply replace:

import json

json_data = '''[ {"symbol": "ZILUSDT", ...}, ... ]'''
data_chunks = json.loads(json_data)

# Convert parsed data back to a JSON string
json_str = json.dumps(data_chunks)

# Replace "}" with another character/string
modified_json_str = json_str.replace("}", "}---")
print(modified_json_str)

⚠️ Note: Be careful when modifying JSON syntax characters like }—changing them may break the validity of the JSON if you plan to reparse it later. Only do this if you don’t need to use the modified string as valid JSON anymore.

内容的提问来源于stack exchange，提问作者Fatih mzm