<h2 id="heading-get-json-from-remote-link-and-load-into-pandas-data-frame">Get JSON from remote link and load into pandas data frame</h2>
<pre><code># load the remote data into a Pandas DataFrame
import pandas as pd
df = pd.read_json('https://archive.org/download/crowdflower/text_emotion.json', encoding='latin-1')
df
</code></pre><a target="_blank" href="https://colab.research.google.com/drive/1k9mJ53Mnjb7fhy_41oyA7rYmz4-L3wUO#scrollTo=FNoxma95rqv6">see colab example</a>
<h2 id="heading-get-json-from-upload-object-and-load-into-pandas-data-frame">Get JSON from upload object and load into pandas data frame</h2>
<pre><code># using upload object to upload json
from google.colab import files
import pandas as pd
import io

uploaded = files.upload()
# assume that the user uploaded only one file
# and the file is a json format
df = pd.read_json(io.StringIO(uploaded[list(uploaded.keys())[0]].decode('utf-8')))
df
</code></pre><a target="_blank" href="https://colab.research.google.com/drive/1k9mJ53Mnjb7fhy_41oyA7rYmz4-L3wUO#scrollTo=AXS4UknYsAfn">see colab example</a>

## Get JSON from remote link and load into pandas data frame
```
# load the remote data into a Pandas DataFrame
import pandas as pd
df = pd.read_json('https://archive.org/download/crowdflower/text_emotion.json', encoding='latin-1')
df
```
[see colab example](https://colab.research.google.com/drive/1k9mJ53Mnjb7fhy_41oyA7rYmz4-L3wUO#scrollTo=FNoxma95rqv6)

## Get JSON from upload object and load into pandas data frame
```
# using upload object to upload json
from google.colab import files
import pandas as pd
import io

uploaded = files.upload()
# assume that the user uploaded only one file
# and the file is a json format
df = pd.read_json(io.StringIO(uploaded[list(uploaded.keys())[0]].decode('utf-8')))
df
```
[see colab example](https://colab.research.google.com/drive/1k9mJ53Mnjb7fhy_41oyA7rYmz4-L3wUO#scrollTo=AXS4UknYsAfn)

Working with JSON on COLAB

Table of contents

Get JSON from remote link and load into pandas data frame

Get JSON from upload object and load into pandas data frame