Скачать или смотреть How to Filter JSON and Output to New JSON File in Python

Learn how to effectively filter a JSON structure in Python to obtain specific data and output the results to a new JSON file or console.
---
This video is based on the question https://stackoverflow.com/q/63893554/ asked by the user 'Geoff_S' ( https://stackoverflow.com/u/7954280/ ) and on the answer https://stackoverflow.com/a/63893665/ provided by the user 'pythomatic' ( https://stackoverflow.com/u/4598067/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: How to filter json and print into new json file?

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Introduction

Handling JSON data is a common task in various programming projects, especially when dealing with APIs or structured data. While parsing JSON is straightforward with Python, filtering it to extract specific information and manipulate the structure can pose some challenges for beginners. In this guide, we address a common problem: how to filter a JSON object to retain only certain nodes and remove unwanted ones.

Scenario: You have a JSON object, and you want to:

Keep only nodes that have a price_cat of 'C'.

Remove the entire History node from each object.

Let’s dive into how you can achieve this in Python.

Understanding the Problem

Given the JSON data structure, your aim is to filter the data so that it includes only relevant items. The first step is to transform the JSON string into a Python object. After that, you can filter out the nodes based on your criteria.

Here’s what the input JSON looks like:

[[See Video to Reveal this Text or Code Snippet]]

In this example, we need to keep only the entries marked as price_cat: "C" and discard the history field.

Solution Steps

To solve this using Python, follow these steps:

1. Load the JSON data

Transform the JSON string into Python objects, allowing manipulation of the data.

[[See Video to Reveal this Text or Code Snippet]]

2. Filter the data

Now, you can filter the data according to your criteria. The approach here involves iterating through each item and checking if any of its prices contain a price_cat of 'C'. If it does, we will append that object to a new list, while also removing the history node.

[[See Video to Reveal this Text or Code Snippet]]

3. Convert back to JSON

Finally, convert the filtered Python object back into a JSON string.

[[See Video to Reveal this Text or Code Snippet]]

Final Output

After running the above code, you will get the following filtered output:

[[See Video to Reveal this Text or Code Snippet]]

Conclusion

Filtering JSON data in Python involves understanding the structure of your data and applying appropriate logic to manipulate it. By following the steps outlined above, you can easily retain the necessary information while discarding unwanted nodes. This approach enhances your ability to work effectively with JSON formats, making your coding tasks more efficient and manageable.

Now go ahead and implement this method in your projects for better data handling!