Skip to main content

Library to handle JSON-stat data in python using pandas DataFrames.

Project description

pyjstat is a python library for JSON-stat formatted data manipulation which allows reading and writing JSON-stat [1] format with python,using the DataFrame structures provided by the widely accepted pandas library [2]. The JSON-stat format is a simple lightweight JSON format for data dissemination. Pyjstat is inspired in rjstat [3], a library to read and write JSON-stat with R, by ajschumacher. Note that, like in the rjstat project, not all features are supported (i.e. not all metadata are converted). pyjstat is provided under the Apache License 2.0.

Installation

pyjstat requires pandas package. For installation:

pip install pyjstat

Usage

From JSON-stat to pandas DataFrame

Typical usage often looks like this:

from pyjstat import pyjstat
import urllib2
import json

results = pyjstat.from_json_stat(json.load(urllib2.urlopen(
                         'http://json-stat.org/samples/oecd-canada.json')))
print results

From pandas DataFrame to JSON-stat

The same data can be converted into JSON-stat, with some unavoidable metadata loss:

from pyjstat import pyjstat
import urllib2
import json

results = pyjstat.from_json_stat(json.load(urllib2.urlopen(
                         'http://json-stat.org/samples/oecd-canada.json')))
print pyjstat.to_json_stat(results)

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pyjstat-0.1.3.tar.gz (16.2 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page