Geojson to Pandas DataFrame

In [9]:
import pandas as pd
In [10]:
import json
from pprint import pprint

with open('geo.json') as data_file:    
    data = json.load(data_file)
In [11]:
geo = pd.io.json.json_normalize(data['features'])
geo.columns = geo.columns.map(lambda x: x.split(".")[-1])

geo.columns
Out[11]:
Index(['coordinates', 'type', 'amt', 'art', 'betreiber', 'bezirksreg', 'datum',
       'e32', 'eigentuemer', 'filterlage', 'gemeinde', 'grund', 'gw_art',
       'gw_entnahme', 'gw_spannung', 'gwk_id', 'kurzbez', 'messprog',
       'messprogramm', 'mstbez', 'mstnr', 'n32', 'nutzung_ezg', 'offen',
       'okfilter_m', 'operativ', 'orgnr', 'status', 'status_opt', 'stockwerk',
       'ueberblick', 'ukfilter_m', 'type'],
      dtype='object')
In [12]:
geo = geo[['coordinates', 'mstnr']]
geo.head()
Out[12]:
coordinates mstnr
0 [6.247624899112501, 51.04444314617253] 10000033