Я подозреваю, что json_normalize поможет. Он перенесет ваш файл json в плоскую структуру таблицы.
documents_link
например:
from pandas.io.json import json_normalize
with open('example_1.json') as data_file:
d = json.load(data_file)
df = json_normalize(d)
from c in Customers
join o in Orders on c.CustomerID equals o.CustomerID into g
select new { c.FName, c.LName, Count=g.Count() }
from c in db.Customers
let theCount = c.Orders.Count()
select new {c.FName, c.LName, theCount}
http://msdn.microsoft.com/en-us/library/bb425822.aspx#linqtosql_topic11
These access operations translate to more complicated joins or correlated sub-queries in the equivalent SQL, allowing you to walk through your object graph during a query.