CODEWITHSUNDEEP
python-3.xsas
Goose
Goose

Reputation: 11

Is there an equivalent to SAS sas7bdat table files in Python?

Is there a Python equivalent to reading and writing tabular files such as SAS sas7bdat files?

My team is moving away from SAS and we'd like to replicate the SAS process in Python with our methodology as follows:

1) Pull data from various sources i.e. Excel, CSV, DBs etc.

2) Update our Data Warehouse with the new information and export this data as a Python table file (to be used next)

3) Rather than pulling data from our warehouse (super slow) we'd like to read in those Python table files and then do some data matching on a bigger set of data.

We're trying to avoid using the sas7bdat altogether (SASPy) files since we won't have SAS for much longer

Any advice, insights is greatly appreciated!

Upvotes: 1

Views: 837

Answers (2)

user667489
user667489

Reputation: 9569

Parquet is also worth considering.

Upvotes: 1

Regi Mathew
Regi Mathew

Reputation: 2873

Unlike SAS, Python doesn't have a native data format. However, there are modules that implements binary protocols for serializing and de-serializing a Python object. Consider using HDF5 format to save and read files (https://www.h5py.org/). Another possibility is Pickle (https://docs.python.org/3/library/pickle.html).

Upvotes: 1

Related Questions