In [5]:

    

# -*- coding: UTF-8 -*-

# Render our plots inline
%matplotlib inline 

import pandas as pd
import matplotlib
import matplotlib.pyplot as plt
import numpy as np
import re


    

In [6]:

    

# Download and clean from OECD: 
# Demographic Statistics_TL3: Regional typology (urban=1/intermediate=2/rural=3,4,5)


    

In [7]:

    

# Load csv file first
data = pd.read_csv("list-of-municipalities-in-functional-urban-areas.csv", encoding="utf-8")


    

In [10]:

    

data.to_json("metropolitan_areas.json", orient="index")


    

In [ ]: