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 (Spain, Switzerland, Sweden). 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. It supports both monolingual and multilingual PX files. The package was initially developped by the [Instituto Cántabro de Estadistica](https://www.icane.es) and is now jointly maintained by ICANE and the [Swiss Data Science Center](https://datascience.ch). 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 = 'https://www.ine.es/jaxiT3/files/t/es/px/2184.px' px = pyaxis.parse(EXAMPLE_URL, encoding='ISO-8859-2') print(px['DATA']) print(px['METADATA'])
For Multilingual PX files
Typical usage often looks like this:
from pyaxis import pyaxis EXAMPLE_URL = 'https://www.pxweb.bfs.admin.ch/DownloadFile.aspx?file=px-x-0602000000_107' # Swiss PX files are in German(de), French(fr), Italian(it), and English(en) px = pyaxis.parse(EXAMPLE_URL, encoding='ISO-8859-2', lang='fr') print(px['DATA']) print(px['METADATA']) print(px['TRANSLATION'])
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
File details
Details for the file pyaxis-0.4.3.tar.gz.
File metadata
- Download URL: pyaxis-0.4.3.tar.gz
- Upload date:
- Size: 239.3 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/6.2.0 CPython/3.9.10
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
dc17697d61bc6ba9b25c64823e2f527fbe4ae7beb49fde07c970ef67c6403ee5
|
|
| MD5 |
a76b8730d984ca0580679341972356c9
|
|
| BLAKE2b-256 |
7e1492fbf27ddb0dbf890d4801d759ff0f53993a23c1356c55d759820e239fc4
|