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
Smile How to further boost the data read write speed using pandas tjk9501 1 130 Nov-14-2022, 01:46 PM
Last Post: jefsummers
  how to parse this array with pandas? netanelst 1 689 May-17-2022, 12:42 PM
Last Post: netanelst
Thumbs Up can't access data from URL in pandas/jupyter notebook aaanoushka 1 920 Feb-13-2022, 01:19 PM
Last Post: jefsummers
Question Sorting data with pandas TheZaind 4 1,418 Nov-22-2021, 07:33 PM
Last Post: aserian
  Pandas Data frame column condition check based on length of the value aditi06 1 1,737 Jul-28-2021, 11:08 AM
Last Post: jefsummers
  [Pandas] Write data to Excel with dot decimals manonB 1 3,153 May-05-2021, 05:28 PM
Last Post: ibreeden
  pandas.to_datetime: Combine data from 2 columns ju21878436312 1 1,760 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 3,442 Jul-24-2020, 01:56 PM
Last Post: onenessboy
  Adding data in 3D array from 2D numpy array asmasattar 0 1,690 Jul-23-2020, 10:55 AM
Last Post: asmasattar
  pandas read_csv can't handle missing data mrdominikku 0 1,671 Jul-09-2020, 12:26 PM
Last Post: mrdominikku

Forum Jump:

User Panel Messages

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