Python Forum
Read json array data by pandas
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Read json array data by pandas
we have an existing script to read json file from S3 and convert into parquet format, data receiving below format and we are able to read by below code,

json file content: [ {"Id":"123124","Account__c":"0ereeraw334U","Active__c":"true"} ]

existing code to convert into data frame: df = pd.read_json(obj['Body'],dtype='unicode',convert_dates=False)

But we are unable to read below json data in same way, getting incorrect data.

Json content: {"cust_land_detail":[ {"Id":"45634653","Account__c":"sersff23se","Active__c":"true"} ] }

NB: file has a root element, so unable to encode data.

Possibly Related Threads…
Thread Author Replies Views Last Post
  how to parse this array with pandas? netanelst 1 322 May-17-2022, 12:42 PM
Last Post: netanelst
Thumbs Up can't access data from URL in pandas/jupyter notebook aaanoushka 1 625 Feb-13-2022, 01:19 PM
Last Post: jefsummers
Question Sorting data with pandas TheZaind 4 1,067 Nov-22-2021, 07:33 PM
Last Post: aserian
  Pandas Data frame column condition check based on length of the value aditi06 1 1,363 Jul-28-2021, 11:08 AM
Last Post: jefsummers
  [Pandas] Write data to Excel with dot decimals manonB 1 2,182 May-05-2021, 05:28 PM
Last Post: ibreeden
  pandas.to_datetime: Combine data from 2 columns ju21878436312 1 1,484 Feb-20-2021, 08:25 PM
Last Post: perfringo
  How to compare two json and write to third json differences with pandas and numpy onenessboy 0 2,982 Jul-24-2020, 01:56 PM
Last Post: onenessboy
  Adding data in 3D array from 2D numpy array asmasattar 0 1,434 Jul-23-2020, 10:55 AM
Last Post: asmasattar
  pandas read_csv can't handle missing data mrdominikku 0 1,425 Jul-09-2020, 12:26 PM
Last Post: mrdominikku
  Pandas data frame creation from Kafka Topic vboppa 0 1,117 Jul-01-2020, 04:23 PM
Last Post: vboppa

Forum Jump:

User Panel Messages

Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020