Library to handle PC-Axis data in python using pandas DataFrames.
Project description
pyaxis is a python library for PC-Axis (or PX) formatted data manipulation which allows reading and writing PC-Axis [1] format with python, using the DataFrame structures provided by the widely accepted pandas library [2]. PX is a standard format for statistical files used by a large number of statistical offices. A package of software has been developed for this format: PX-Win, PX-Web and PX-Edit. pyaxis eases reading and parsing of PX files data and metadata into a pandas Dataframe and a dict structure, allowing their manipulation in a tabular and pythonic manner. pyaxis is provided under the Apache License 2.0.
Installation
For installation:
pip install pyaxis
Usage
From PX to pandas DataFrame
Typical usage often looks like this:
from pyaxis import pyaxis EXAMPLE_URL = 'http://www.ine.es/jaxiT3/files/t/es/px/2184.px' px = pyaxis.parse(EXAMPLE_URL, encoding=encoding='ISO-8859-2') print px['DATA'] print px['METADATA']
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.