Скачать или смотреть How to Modify the Output of JSON in Python with json.loads()

Learn how to modify the output of a JSON object in Python by removing unwanted values from the result returned by `json.loads()`.
---
This video is based on the question https://stackoverflow.com/q/71117557/ asked by the user 'xtekky' ( https://stackoverflow.com/u/18175181/ ) and on the answer https://stackoverflow.com/a/71117782/ provided by the user 'Kelly Bundy' ( https://stackoverflow.com/u/12671057/ ) 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 modify result returned from json.loads()?

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.
---
How to Modify the Output of JSON in Python with json.loads()

When working with data from APIs, it's common to deal with JSON objects. In Python, the json library provides a convenient way to convert a JSON string into a Python object using the json.loads() function. But what if you want to modify the data after loading it? In this guide, we'll explore how to manipulate the output from json.loads() to fit your needs better.

The Problem: Unwanted Data in the Result

Consider you are working with cryptocurrency prices obtained from the CoinGecko API, and the result you get is structured like this:

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

In this data, each price is accompanied by a timestamp, and you might only be interested in the price values themselves. Specifically, you want to remove the first number (the timestamp) from each price entry so that your output looks like this:

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

Step-by-Step Solution

1. Load the JSON Data

First, you need to load the JSON data from the API. Here's how you can do that using the requests library and json:

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

2. Remove Unwanted Values

Next, you can iterate through the entries under the "prices" key and delete the first element of each sub-array (which contains the timestamp). Here's how you can do that in just a few lines of code:

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

3. Resulting Output

After executing the loop, your data['prices'] list will now only contain the prices, neatly stripped of their associated timestamps. You can print the modified data to verify:

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

Final Output Example

The output will now look as follows:

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

Make sure to format it as needed if you want a flat list, like this:

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

This will produce:

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

Conclusion

Manipulating JSON data in Python allows you to customize the information you work with in a flexible and efficient way. By using json.loads() in combination with simple loops, you can tailor data to meet your requirements. This approach is especially useful when handling large datasets from APIs, making your data analysis much cleaner and more precise.

If you have any questions or need further clarifications on modifying JSON data in Python, feel free to leave a comment!