Convert PC-Axis to CSV

Convert PC-Axis files to CSV files. This will store all the dimensions inside the PC-Axis cube as a flat row. What the heck is a PC-Axis file?

Run yourself

First install the required dependencies. You need a new Node version (> 4.7).

npm install -g px-to-csv

Now download a PC Axis file from your statistical data provider.

wget -O households.px https://www.pxweb.bfs.admin.ch/DownloadFile.aspx?file=px-x-0102020000_402

Invoke the index.js file with the PX file and specify the output CSV file.

px-to-csv -i households.px -o households.csv

⚠️ Convert the PX files to UTF-8 first!

iconv -f WINDOWS-1252 -t UTF-8  households.px