Issue in getting the required data from nested json and store it in a pandas datafram

Thread Rating:

2 Vote(s) - 3.5 Average
1
2
3
4
5

Thread Modes

Issue in getting the required data from nested json and store it in a pandas datafram

volcano63
Verb Conjugator

Posts: 566

Threads: 10

Joined: Apr 2017

Reputation: 26

May-20-2018, 11:02 AM

(May-20-2018, 06:30 AM)PrateekG Wrote: Can anyone please try with above json data and share me the required dataframe?

You are kidding, right? Or you want to pay someone to do it for you?

You can, of course, write a recursive function - that will traverse your JSON searching for name keys - and attaching ID of the parent record together with the name to your dataset.

Test everything in a Python shell (iPython, Azure Notebook, etc.)

Someone gave you an advice you liked? Test it - maybe the advice was actually bad.
Someone gave you an advice you think is bad? Test it before arguing - maybe it was good.
You posted a claim that something you did not test works? Be prepared to eat your hat.

Find

Messages In This Thread

Issue in getting the required data from nested json and store it in a pandas datafram - by PrateekG - May-20-2018, 06:30 AM

RE: Issue in getting the required data from nested json and store it in a pandas datafram - by volcano63 - May-20-2018, 11:02 AM

RE: Issue in getting the required data from nested json and store it in a pandas datafram - by scidam - May-20-2018, 11:25 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	[Numpy] How to store different data type in one numpy array?	water	7	701	Mar-26-2024, 02:18 PM Last Post: snippsat
	Grouping in pandas/multi-index data frame	Aleqsie	3	725	Jan-06-2024, 03:55 PM Last Post: deanhystad
	How to further boost the data read write speed using pandas	tjk9501	1	1,287	Nov-14-2022, 01:46 PM Last Post: jefsummers
	Parse Nested JSON String in Python	rwalde	4	3,014	Sep-08-2022, 10:32 AM Last Post: rwalde
	can't access data from URL in pandas/jupyter notebook	aaanoushka	1	1,890	Feb-13-2022, 01:19 PM Last Post: jefsummers
	Sorting data with pandas	TheZaind	4	2,384	Nov-22-2021, 07:33 PM Last Post: aserian
	Pandas Data frame column condition check based on length of the value	aditi06	1	2,723	Jul-28-2021, 11:08 AM Last Post: jefsummers
	[Pandas] Write data to Excel with dot decimals	manonB	1	5,943	May-05-2021, 05:28 PM Last Post: ibreeden
	Pandas replace function not working on datafram with floats	bcrypto	1	2,943	Apr-12-2021, 08:59 PM Last Post: bcrypto
	pandas.to_datetime: Combine data from 2 columns	ju21878436312	1	2,480	Feb-20-2021, 08:25 PM Last Post: perfringo

Users browsing this thread: 2 Guest(s)

View a Printable Version

Issue in getting the required data from nested json and store it in a pandas datafram

User Panel Messages

Announcements