How to save json data in a dataframe

Thread Rating:

Thread Modes

How to save json data in a dataframe

klllmmm
Lumberjack

Posts: 107

Threads: 42

Joined: Oct 2016

Reputation: 1

Apr-15-2021, 02:44 PM

data = json.loads(test)
df = pd.json_normalize(data['geomagnetic-field-model-result'])

Messages In This Thread

RE: How to save json data in a dataframe - by klllmmm - Apr-15-2021, 02:44 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	encrypt data in json file help	jacksfrustration	1	223	Mar-28-2024, 05:16 PM Last Post: deanhystad
	how to save to multiple locations during save	cubangt	1	559	Oct-23-2023, 10:16 PM Last Post: deanhystad
	Filter data into new dataframe as main dataframe is being populated	cubangt	8	1,007	Oct-23-2023, 12:43 AM Last Post: cubangt
	Converting a json file to a dataframe with rows and columns	eyavuz21	13	4,503	Jan-29-2023, 03:59 PM Last Post: eyavuz21
	Read nested data from JSON - Getting an error	marlonbown	5	1,381	Nov-23-2022, 03:51 PM Last Post: snippsat
	Reading Data from JSON	tpolim008	2	1,093	Sep-27-2022, 06:34 PM Last Post: Larz60+
	Seeing al the data in a dataframe or numpy.array	Led_Zeppelin	1	1,150	Jul-11-2022, 08:54 PM Last Post: Larz60+
	Need help formatting dataframe data before saving to CSV	cubangt	16	5,889	Jul-01-2022, 12:54 PM Last Post: cubangt
	Convert nested sample json api data into csv in python	shantanu97	3	2,847	May-21-2022, 01:30 PM Last Post: deanhystad
	Struggling with Juggling JSON Data	SamWatt	7	1,899	May-09-2022, 02:49 AM Last Post: snippsat

Users browsing this thread: 2 Guest(s)