Skip to main content
237 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
41 views

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&...
Margot Sibson's user avatar
  • 11
1 vote
0 answers
38 views

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 ...
David27's user avatar
  • 13
-3 votes
2 answers
168 views

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 ...
lpca's user avatar
  • 15
1 vote
1 answer
106 views

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 ...
phx88's user avatar
  • 13
1 vote
1 answer
230 views

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 ...
Fat_princess's user avatar
  • 11
0 votes
1 answer
155 views

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 ...
Arun.K's user avatar
  • 103
0 votes
1 answer
122 views

I am having problems while converting the json file to the dataframe. The json file structure is like this: "results": [ { "submissions": [ { "...
Nano's user avatar
  • 1
0 votes
1 answer
136 views

I'm trying to transform this complex object into a pandas dataframe data={ "customers": [ { "a": 'true', "addresses": [{"city&...
Herojos's user avatar
  • 75
0 votes
1 answer
115 views

I am trying to convert a nested JSON to a dataframe. The JSON file is deeply nested and I am used the meta parameter to specify the nested structure so that all the JSON attributes can be stored as ...
Nidhin_toms's user avatar
  • 737
1 vote
2 answers
74 views

I am trying to create a dataframe from nested json file but running into trouble. [ { "rec_id": "1", "user": { "id": "12414&...
hktx80's user avatar
  • 23
0 votes
1 answer
71 views

I have a CSV file named test.csv with the following data: ,ts,snapshot 0,1686321823605,"{'asks': [['26566.1', '1.451456']], 'bids': [['26566', '4.17579913']]}" 1,1686321823705,"{'asks': ...
djg's user avatar
  • 1
0 votes
1 answer
104 views

I have the following nested dictionary that contains the information that a person publicly reported to the organization. `person_json={'basicInformation': {'individualId': 5429958, 'firstName': '...
SChatcha's user avatar
  • 147
0 votes
1 answer
38 views

How json_normalize from pandas parses the ISODates that include timezone hours? i.e. "startDate" : ISODate("2021-02-01T22:37:37.000+02:00"), "entryDate" : ISODate(...
vfarmak's user avatar
  • 13
10 votes
2 answers
27k views

python 3.9.2-3 pandas 2.0.0 pandas-io 0.0.1 Error: from pandas.io.json import json_normalize ImportError: cannot import name 'json_normalize' from 'pandas.io.json' (/home/casaos/.local/lib/...
Joe Greene's user avatar
  • 351
2 votes
1 answer
378 views

I have the following JSON; { "data": [ { "gid": "1203715497540179", "completed": false, "custom_fields": [ { ...
user2876983's user avatar
  • 321
0 votes
1 answer
86 views

Suppose a list of objects: one, two, three,... Every object is composed of name, foo1, and foo2 fields. [{ 'name':'one', 'foo2':{ 'id':'1.1', 'id':'1.2' }, 'foo1':[ ...
Diego Quirós's user avatar
  • 997
1 vote
2 answers
2k views

I have this JSON list in Python: [{'id': 'TC2-FFA', 'shortCode': 'TC2-FFA', 'dataSet': {'datumPrecision': 2, 'id': 'TC2_37', 'shortCode': 'TC2_37', 'shortDescription': 'Clean Continent to ...
neutralname's user avatar
  • 477
0 votes
1 answer
282 views

I have a dataframe like (with one example row): raw_data = [{'id': 1, 'name': 'FRANK', 'attributes': '{"deleted": false, "rejected": true, "handled": true, "order&...
Angie's user avatar
  • 333
0 votes
2 answers
64 views

I have a data structure which is a very complex/nested JSON. After reading other solutions on SO, I am comfortable with the fact that I may need to make multiple DFs and merge them together (e.g ...
lummers's user avatar
  • 789
0 votes
1 answer
348 views

Using json_normalize I created a dataframe, the data I parsed includes a list of dictionaries, hence I used the parameters "record_path" and "meta". The issue is that I get a ...
Horacio Nesman's user avatar
  • 111
-1 votes
2 answers
633 views

I'm trying to get the metadata out from a json using pandas json_normalize, but it does not work as expected. I have a json fine with the following structure data=[ {'a':'aa', 'b':{'b1':'bb1','...
fil's user avatar
  • 81
0 votes
1 answer
61 views

Would you help, please, to parce 2-arrayed json via python, json_normalize. Here is the code: import json from pandas.io.json import json_normalize data5 = { "id": "0001", &...
Semyon-coder's user avatar
  • 737
0 votes
2 answers
790 views

I've been trying to convert a json response from an api to a full panadas dataframe. I tried json normalize to achieve it unfortunately i was able to split it only to one level. response = { "...
anuof90's user avatar
  • 29
1 vote
2 answers
608 views

From an API, I get information about who has filled a particular form and when they have done it as a json object. I get the below data from 2 forms formid = ["61438732", "48247759dc&...
Vikas Bagur's user avatar
  • 31
1 vote
1 answer
70 views

I'm trying to extract data in a dataframe. My attempts with pd.json_normalize did not work... I must be doing something wrong. Exemple : { "data": [ { "date"...
Melvin's user avatar
  • 17

1
2 3 4 5