Mathew K Analytics

📊 Dataset · JSON

superstore_api_page1.json dataset

Download superstore_api_page1.json free (100 rows × 6 columns, 76.1 KB). Preview the rows and columns, load it in pandas in one line and practise with 2…

Preview (first rows)

pageper_pagetotal_pagestotal_ordersnextresults
11003300superstore_api_page2.json{'order_id': 13729, 'order_date': '1/1/2
11003300superstore_api_page2.json{'order_id': 28774, 'order_date': '1/1/2
11003300superstore_api_page2.json{'order_id': 710, 'order_date': '1/1/201
11003300superstore_api_page2.json{'order_id': 39841, 'order_date': '1/1/2
11003300superstore_api_page2.json{'order_id': 59174, 'order_date': '1/1/2
11003300superstore_api_page2.json{'order_id': 2277, 'order_date': '1/1/20
11003300superstore_api_page2.json{'order_id': 16262, 'order_date': '1/1/2
11003300superstore_api_page2.json{'order_id': 17058, 'order_date': '1/1/2

Columns

ColumnTypeMissingExample
pageinteger01
per_pageinteger0100
total_pagesinteger03
total_ordersinteger0300
nexttext0superstore_api_page2.json
resultstext0{'order_id': 13729, 'order_date': '1/1/2

Load it in Python

import pandas as pd
df = pd.read_json("superstore_api_page1.json")
df.head()