I found a quick and easy solution to what I wanted using json_normalize() included in pandas 1.01.
from urllib2 import Request, urlopen
import json
import pandas as pd
path1 = '42.974049,-81.205203|42.974298,-81.195755'
request=Request('http://maps.googleapis.com/maps/api/elevation/json?locations='+path1+'&sensor=false')
response = urlopen(request)
elevations = response.read()
data = json.loads(elevations)
df = pd.json_normalize(data['results'])
This gives a nice flattened dataframe with the json data that I got from the Google Maps API.
Answer from pbreach on Stack OverflowPandas
pandas.pydata.org › docs › reference › api › pandas.DataFrame.to_json.html
pandas.DataFrame.to_json — pandas 3.0.1 documentation
For other URLs (e.g. starting with “s3://”, and “gcs://”) the key-value pairs are forwarded to fsspec.open. Please see fsspec and urllib for more details, and for more examples on storage options refer here. ... Specify the IO mode for output when supplying a path_or_buf. Accepted args are ‘w’ (writing) and ‘a’ (append) only. mode=’a’ is only supported when lines is True and orient is ‘records’. ... If path_or_buf is None, returns the resulting json format as a string.
Top answer 1 of 14
324
I found a quick and easy solution to what I wanted using json_normalize() included in pandas 1.01.
from urllib2 import Request, urlopen
import json
import pandas as pd
path1 = '42.974049,-81.205203|42.974298,-81.195755'
request=Request('http://maps.googleapis.com/maps/api/elevation/json?locations='+path1+'&sensor=false')
response = urlopen(request)
elevations = response.read()
data = json.loads(elevations)
df = pd.json_normalize(data['results'])
This gives a nice flattened dataframe with the json data that I got from the Google Maps API.
2 of 14
50
Check this snip out.
# reading the JSON data using json.load()
file = 'data.json'
with open(file) as train_file:
dict_train = json.load(train_file)
# converting json dataset from dictionary to dataframe
train = pd.DataFrame.from_dict(dict_train, orient='index')
train.reset_index(level=0, inplace=True)
Hope it helps :)
Videos
07:15
How to Convert JSON to Pandas Dataframe in Python with Jupyter ...
04:48
Converting Complex JSON to Pandas DataFrame - YouTube
01:56
Converting JSON Data to a Pandas DataFrame in Python - YouTube
01:54
How to Convert JSON to a DataFrame in Python with Pandas - YouTube
05:03
Pandas Tutorial | How to convert a Pandas DataFrame object to a ...
How to Convert a Pandas DataFrame to JSON Format in ...
Top answer 1 of 9
115
In newer versions of pandas (0.20.0+, I believe), this can be done directly:
df.to_json('temp.json', orient='records', lines=True)
Direct compression is also possible:
df.to_json('temp.json.gz', orient='records', lines=True, compression='gzip')
2 of 9
101
The output that you get after DF.to_json is a string. So, you can simply slice it according to your requirement and remove the commas from it too.
out = df.to_json(orient='records')[1:-1].replace('},{', '} {')
To write the output to a text file, you could do:
with open('file_name.txt', 'w') as f:
f.write(out)
Spark By {Examples}
sparkbyexamples.com › home › pandas › pandas – convert dataframe to json string
Pandas - Convert DataFrame to JSON String - Spark By {Examples}
November 5, 2024 - How do I convert a DataFrame to JSON in Python using pandas? You can use the to_json() method in Pandas to convert the DataFrame to JSON.
Oreate AI
oreateai.com › blog › unlocking-data-seamlessly-converting-json-to-pandas-dataframes › acda9e349ae4d41b4988f3d7f1e365e1
Unlocking Data: Seamlessly Converting JSON to Pandas DataFrames - Oreate AI Blog
February 17, 2026 - What if your JSON data isn't in a file, but rather a string you've received from an API or generated elsewhere? No problem. You can still leverage Pandas. The process involves a couple of steps: First, you'll need to parse the JSON string into a Python object.
W3Schools
w3schools.com › python › pandas › pandas_json.asp
Pandas Read JSON
JSON is plain text, but has the format of an object, and is well known in the world of programming, including Pandas. In our examples we will be using a JSON file called 'data.json'. Open data.json. ... Tip: use to_string() to print the entire ...
Pandas
pandas.pydata.org › docs › reference › api › pandas.read_json.html
pandas.read_json — pandas 3.0.1 documentation
The encoding to use to decode py3 bytes. encoding_errorsstr, optional, default “strict” · How encoding errors are treated. List of possible values . ... Read the file as a json object per line.
Reddit
reddit.com › r/learnpython › pandas to json df.to_json() formatting
r/learnpython on Reddit: Pandas to JSON df.to_json() formatting
January 27, 2021 -
Suppose that I have the following dataframe:
info drinks reviews score menu funfacts
input 1.0 1 2 4 1. funfacts, 2. fun fact, 3. fun fact
How could I transform this to the required JSON format? I tried Pandas(df.to_json) however the default formatting seems incorrect.
Snippet: `df3.to_json('File Name.json', orient='records')`
Expected output:
{
"info":[
{
"drinks":[
"1.0"
],
"reviews":[
"1"
],
"score":[
"2"
],
"menu":[
"4"
],
"funfacts":[
"1. funfacts",
"2. fun fact",
"3. fun fact"
]
}
]
}
Current output:
[
{
"drinks": "1.0",
"reviews": "1",
"score": "2",
"menu": "4",
"funfacts": "1. funfacts ,2. fun facts ,3 fun facts"
}
]
Are there any arguments in pandas that I could use to get the desired format or do I need to use a different solution? Thanks
Top answer 1 of 2
2
or do I need to use a different solution You'd probably have to do it "manually" You can get a list for each value using to_dict(orient='list') >>> df.applymap(str).to_dict(orient='list') {'info': ['input'], 'drinks': ['1.0'], 'reviews': ['1'], 'score': ['2'], 'menu': ['4'], 'funfacts': ['1. funfacts, 2. fun fact, 3. fun fact']} You'd have to split the funfacts and then move "info" to the outer level >>> d = df.applymap(str).to_dict(orient='list') >>> del d['info'] >>> d['funfacts'] = d['funfacts'][0].split(', ') >>> d = {'info': [d]} You can then use the json module to turn the dict into JSON: >>> import json >>> print(json.dumps(d, indent=2)) { "info": [ { "drinks": [ "1.0" ], "reviews": [ "1" ], "score": [ "2" ], "menu": [ "4" ], "funfacts": [ "1. funfacts", "2. fun fact", "3. fun fact" ] } ] }
2 of 2
2
pandas can't guess that you want the "funfacts" split into a list, since they are just one string. So, before you convert to json, convert that string to a list. df3["funfacts"]=df3["funfacts"].str.split(",") df3.to_json('File Name.json', orient='records')
w3resource
w3resource.com › pandas › dataframe › dataframe-to_json.php
Pandas DataFrame: to_json() function - w3resource
August 19, 2022 - DataFrame.to_json(self, path_or_buf=None, orient=None, date_format=None, double_precision=10, force_ascii=True, date_unit='ms', default_handler=None, lines=False, compression='infer', index=True) ... Returns: None or str If path_or_buf is None, returns the resulting json format as a string. Otherwise returns None. ... Download the Pandas DataFrame Notebooks from here.
GeeksforGeeks
geeksforgeeks.org › pandas › pandas-convert-json-to-dataframe
Convert JSON to Pandas DataFrame - GeeksforGeeks
July 23, 2025 - When working with data, it's common to encounter JSON (JavaScript Object Notation) files, which are widely used for storing and exchanging data. Pandas, a powerful data manipulation library in Python, provides a convenient way to convert JSON data into a Pandas data frame.
GitHub
gist.github.com › Elsaveram › 3258db49eaac5e258401338ae17139a3
Convert json to pandas dataframe · GitHub
Convert json to pandas dataframe. GitHub Gist: instantly share code, notes, and snippets.
Pandas
pandas.pydata.org › pandas-docs › version › 1.3.2 › reference › api › pandas.io.json.to_json.html
pandas.io.json.to_json — pandas 1.3.2 documentation
pandas.io.json.to_json(path_or_buf, obj, orient=None, date_format='epoch', double_precision=10, force_ascii=True, date_unit='ms', default_handler=None, lines=False, compression='infer', index=True, indent=0, storage_options=None)[source]¶
GeeksforGeeks
geeksforgeeks.org › python › how-to-read-json-files-with-pandas
How to Read JSON Files with Pandas? - GeeksforGeeks
July 23, 2025 - JSON (JavaScript Object Notation) store data using key-value pairs. Reading JSON files using Pandas is simple and helpful when you're working with data in .json format. There are mainly three methods to read Json file using Pandas Some of them are:
NVIDIA Developer
developer.nvidia.com › blog › json-lines-reading-with-pandas-100x-faster-using-nvidia-cudf
JSON Lines Reading with pandas 100x Faster Using NVIDIA cuDF | NVIDIA Technical Blog
April 23, 2025 - To use information from JSON Lines in data processing pipelines, the tokens must often be converted into a Dataframe or columnar format, such as Apache Arrow. JSON readers, such as pandas.read_json convert input character data into a Dataframe organized by columns and rows.
Statology
statology.org › home › how to convert a pandas dataframe to json
How to Convert a Pandas DataFrame to JSON
July 30, 2020 - import pandas as pd #create DataFrame df = pd.DataFrame({'points': [25, 12, 15, 19], 'assists': [5, 7, 7, 12]}) #view DataFrame df points assists 0 25 5 1 12 7 2 15 7 3 19 12 · df.to_json(orient='split') { "columns": [ "points", "assists" ], "index": [ 0, 1, 2, 3 ], "data": [ [ 25, 5 ], [ 12, 7 ], [ 15, 7 ], [ 19, 12 ] ] }
AskPython
askpython.com › home › pandas read_json — convert a json string to pandas object.
Pandas read_json — Convert a JSON string to pandas object. - AskPython
January 18, 2023 - It focuses on operations on relational data, here we would convert JSON string pandas DataFrame with the help of the read_json() function. Multiple manipulations of the function will be carried out to receive the desired output.
GeeksforGeeks
geeksforgeeks.org › python › exporting-pandas-dataframe-to-json-file
Exporting Pandas DataFrame to JSON File - GeeksforGeeks
February 18, 2026 - To export a Pandas DataFrame to a JSON file we use the to_json() function. This function converts the DataFrame into a JSON format making it easy to store and share data.
Educative
educative.io › answers › how-to-convert-api-json-data-into-pandas-dataframe
How to convert API JSON data into pandas dataframe
The fetched data in form of a GET request is first converted into JSON using json() method of request library. Later it is converted into dataframe using json_normalize() method of pandas.
GitHub
github.com › pandas-dev › pandas
GitHub - pandas-dev/pandas: Flexible and powerful data analysis / manipulation library for Python, providing labeled data structures similar to R data.frame objects, statistical functions, and much more · GitHub
Flexible and powerful data analysis / manipulation library for Python, providing labeled data structures similar to R data.frame objects, statistical functions, and much more - pandas-dev/pandas
Starred by 48.2K users
Forked by 19.8K users
Languages Python 91.0% | Cython 6.2% | C 1.5% | HTML 1.2% | Meson 0.1% | CSS 0.0%
Reddit
reddit.com › r/learnpython › python pandas: convert a list of json strings into a dataframe. how do i do that?
r/learnpython on Reddit: Python pandas: convert a list of JSON strings into a dataframe. How do I do that?
April 4, 2023 -
I need to convert a list of JSON strings into a dataframe. How do I do that?