I’m trying to read this json. I need values: PoolID, PoolSystemCapacityGb2,NumPagesUsedPool, and others.. But i can only read values for the ‘PooID’:1, not for the PooID’:90 How can i parse this kind of json? My code: thanks for help. Answer If you need to get all objects from JSON wit…
Tag: json
Extract content of with python inf Beautiful Soup [duplicate]
This question already has answers here: How can I parse (read) and use JSON? (5 answers) Closed 24 days ago. 1/ I get my data with this code and then im trying to extract the value of the attribute “sku”: 2/ this is the data that i get. my goal is to extract the value of the attribute “sku&#…
Extracting key and value from tuple of dictionaries (taken from json file) in python
I have a JSON file which is a tuple of multiple dictionaries and I want to extract keys and values from some of them. The file looks something like this (this is just an example of the structure with random keys and values): What I want to extract all names (Ana, Bob, Chloe) and their ids something like this:…
Convert multi level Json File into a DataFrame PYTHON
How to convert this JSON file into a Pandas DataFrame. PYTHON ”’ ”’ Answer Use pd.json_normalize:
How to fix memory error while importing a very large csv file to mongodb in python?
Given below is the code for importing a pipe delimited csv file to monogdb. Below is the error I get when running the above code. I if modify the code with some indents under the for loop. The MongoDB gets imported with the same data all over again without stopping. Answer The memory issue can be solved by in…
Read JSON Lines file as String in Python
I have a JSON Lines file that I would like to read as a string in Python. The file contains multiple JSON objects in this format: I tried the following code in Python but it returned an error. I was able to load the file as a list of dictionaries using lines = [] but apprently it doesn’t work for
Cannot add/append element to JSON File
So, I was making a discord bot for an RP server with 4k members in emergency. My goal was to store the lawyers database in a json file that would be hosted on one of my computers for testing. Here is my code: Here is the Compiler Error (Python 3.9): I tried to look at other posts to see if
Adding a different value to a list based on number of iteration in a for loop
I’m new to Python and programming in general and I am having trouble with a website parsing project. This is the code I managed to write: What I’m trying to do and can’t find a solution to, is to add to item_list the name of the item which the url refers to. e.g. index platinum quantity R…
Flatting a JSON file into Pandas Dataframe in Python
I have the json in this format: I want it to be in a dataframe format where each of the three field names are separate rows. Where one row has a column(e.g “format”) where others are blank should be assumed to be NULL. I have tried to use the flatten_json function which I found on here, but doesn&…
Python pandas extract data from nested list
For a personal project, I’m calling data from the Google Books API and uploading the fields I want to mySQL. I’ve successfully made the API request and received data. The data received is nested and i want to place this in a dataframe. Now my code works with the “first” column (no inde…