Jovian
Sign In
Learn practical skills, build real-world projects, and advance your career
alt

JSON, SQL, Pandas, and Python: The Happy Family

import pandas as pd
import sqlite3 as sql
import json
pd.options.display.max_columns = 80
pd.options.display.max_rows = 80

Importing JSON Data:

with open('unece.json') as file:
    data = json.load(file)

Column Names:

  • The fields below are the column names and data for Hungary, 2010
  • After conversion to dataframe, these column names MUST be fixed before anything else can be done