237 questions
0
votes
2
answers
104
views
How to Create a Pandas Dataframe from JSON Nested Objects [closed]
I'm trying to create a Pandas DataFrame from a JSON file that looks like this:
{
"GameID": "1,218,463,841",
"Date - Start": "1761097369",
"Date - End&...
2
votes
2
answers
95
views
Unnesting a pandas json column and keeping an "id" column
I am working on some nested NoSQL data. I would like to unnest it using json_normalize but keep the "id de transação" column so I could merge the resulting dataframe into other dataframes.
...
- 457
1
vote
0
answers
38
views
Attempting to flatten a list of dictionaries to a Dataframe but can't get to the lowest level information with json-normalise [duplicate]
Below is the output of an API call - it is a dictionary which contains a list of dictionaries I'm interested in under 'response'
I filter fixture_ids for 'response' because the rest is not useful ...
- 13
0
votes
1
answer
103
views
I'm trying to normalize this Json structure
I'm finding an error message when I try to normalize a Json structure that follows.
I pasted the JSON structure and the python code to normalize that is giving the ERROR message
GOAL: Normalize ...
- 15
-3
votes
2
answers
173
views
Using json_normalize with pandas
I'm using the following code in python to flatten the json structure below, however it doesn't work for all levels. I'm interested in the tags.tags column data specifically shown on the picture below
...
- 15
0
votes
1
answer
146
views
How do I use json_normalize on a json containing a list of nested lists
I'm dealing with a complex JSON string in Python, and I'm having trouble getting the data into a Pandas Data Frame. Sample data, current output, and expected output are all below. I'm attempting to ...
- 43
1
vote
1
answer
106
views
pandas retaining column after flattening json
I have a pandas dataframe where each row corresponds to a news article, and each cell in the row contains one dictionary that contains stock ticker information as well as some metrics. The dataframe ...
- 13
0
votes
1
answer
93
views
i have a nested list json file and i am using json_normalize to have the data but i am facing TypeError
i have a dataset of 3 objects, i am intrested of the data in object 1 which has, but it have nested lists, the file looks like this :
[{'ob1': [{'values':{'ID':2133 ,'STATUS': closed,'name':'Sara'}}
...
- 1
1
vote
1
answer
233
views
Flatten list of dict (array) as new columns not working with json normalize
Apologies as I'm quite inexperienced with Python and looking for assistance here 🙏
I am trying to flatten a list of dicts into new columns in an existing dataframe, with using key as column names and ...
- 11
0
votes
1
answer
66
views
Parse dict column and add new columns to dataframe [duplicate]
The pandas df is created by reading CSV file with more than 100+ columns and 2+ mil rows which looks similar to
project_code,dict_data
A001,{"a": "1", "b": "2", ...
- 187
0
votes
1
answer
155
views
Unable to explode the nested list within a json using pd.json_normalize
I tried different ways to get this done, but unable to do so. Please help here.
I am trying to explode a nested json list using python pd.json_normalize. After exploding the output is coming in two ...
- 103
0
votes
1
answer
579
views
How to normalise complex JSON with multiple levels of nested information in Python
I get the data in a predefined format I cannot change:
data =
{
"id": 12345,
"name": "Doe",
"gender": {
"textEn": "Masculin"
},
...
- 3
0
votes
1
answer
128
views
Flattening of json file
I am having problems while converting the json file to the dataframe. The json file structure is like this:
"results": [
{
"submissions": [
{
"...
- 1
0
votes
1
answer
521
views
Flattening the nested json file to dataframe using pandas json_normalise
I hace a big json file data and I want to convert it in to tabular form. I am trying to flatten the data in to dataframe using json_nomalise. so Far I have this :
code so far
I want to further flatten ...
- 1
0
votes
1
answer
139
views
How to Normalize JSON data into a pandas dataframe with json_normalize
I'm trying to transform this complex object into a pandas dataframe
data={
"customers": [
{
"a": 'true',
"addresses": [{"city&...
- 75
