SAS XPORT, XPT file reader
Project description
Python reader for SAS XPORT data transport files (*.xpt).
What’s it for?
XPORT is the binary file format used by a bunch of United States government agencies for publishing data sets. It made a lot of sense if you were trying to read data files on your IBM mainframe back in 1988.
The official SAS specification for XPORT is relatively straightforward. The hardest part is converting IBM-format floating point to IEEE-format, which the specification explains in detail.
How do I use it?
This module mimics the csv module of the standard library:
import xport with open('example.xpt', 'rb') as f: for row in xport.reader(f): print row
Each row will be a namedtuple, with an attribute for each field in the dataset. Values in the row will be either a unicode string or a float, as specified by the XPT file metadata. Note that since XPT files are in an unusual binary format, you should open them using mode 'rb'.
You can also use the xport module as a command-line tool to convert an XPT file to CSV (comma-separated values).:
$ python -m xport example.xpt > example.csv
The reader object also has a handful of metadata:
reader.fields – Names of the fields in each observation.
reader.version – SAS version number used to create the XPT file.
reader.os – Operating system used to create the XPT file.
reader.created – Date and time that the XPT file was created.
reader.modified – Date and time that the XPT file was last modified.
Random access to records
If you want to access specific records, you should either consume the reader in a list (lst = list(xport.reader(f)))) or use one of itertools recipes for quickly consuming and throwing away unncessary elements.
Recent changes
Improved the API.
Fixed handling of NaNs.
Fixed piping the file from stdin in Python 3.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.