IO Methods¶
io module has some methods to parse specific types of XMML/JSON.
read_jstat¶
Read JSON-stat file.
In [1]: import pyopendata as pyod
In [2]: pyod.io.read_jstat('http://json-stat.org/samples/us-gsp.json')
Out[2]:
concept Gross State Product \
year state
2013 Alabama 174400
Alaska 45600
Arizona 261300
Arkansas 105800
California 2080600
... ...
Virginia 427700
Washington 351100
West Virginia 66600
Wisconsin 251400
Wyoming 38200
concept Gross State Product as percentage of national GDP \
year state
2013 Alabama 1.20
Alaska 0.31
Arizona 1.80
Arkansas 0.73
California 13.34
... ...
Virginia 2.95
Washington 2.42
West Virginia 0.46
Wisconsin 1.73
Wyoming 0.26
concept Gross State Product per capita Population
year state
2013 Alabama 36333 4.8
Alaska 65143 0.7
Arizona 40828 6.4
Arkansas 36483 2.9
California 51914 37.3
... ... ...
Virginia 53463 8.0
Washington 52403 6.7
West Virginia 35053 1.9
Wisconsin 44105 5.7
Wyoming 63667 0.6
[51 rows x 4 columns]