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
#1
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.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
Question Sorting data with pandas TheZaind 4 517 Nov-22-2021, 07:33 PM
Last Post: aserian
  Pandas Data frame column condition check based on length of the value aditi06 1 812 Jul-28-2021, 11:08 AM
Last Post: jefsummers
  [Pandas] Write data to Excel with dot decimals manonB 1 1,030 May-05-2021, 05:28 PM
Last Post: ibreeden
  pandas.to_datetime: Combine data from 2 columns ju21878436312 1 1,087 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,166 Jul-24-2020, 01:56 PM
Last Post: onenessboy
  Adding data in 3D array from 2D numpy array asmasattar 0 1,118 Jul-23-2020, 10:55 AM
Last Post: asmasattar
  pandas read_csv can't handle missing data mrdominikku 0 1,117 Jul-09-2020, 12:26 PM
Last Post: mrdominikku
  Pandas data frame creation from Kafka Topic vboppa 0 841 Jul-01-2020, 04:23 PM
Last Post: vboppa
  Generate Test data (.csv) using Pandas Ashley 5 1,388 Jun-15-2020, 02:51 PM
Last Post: jefsummers
  Can't read text file with pandas zinho 6 7,432 May-24-2020, 06:13 AM
Last Post: azajali43

Forum Jump:

User Panel Messages

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