Saving new df as xpt file

[sbjain]

Hi, can you explain how we can save the dataframe (df) to new xpt file?

Thanks,
Sagar

[meyergt]

I do it using this line to convert it to a list of dictionaries:

data = df.T.to_dict().values()

And then these two lines to write the .xpt file:

with open('file.xpt', 'wb') as f:
    xport.from_rows(data, f)

[selik]

New API. #34

In [1]: import pandas as pd

In [2]: import xport.v56

In [3]: df = pd.DataFrame()

In [4]: with open('example.xpt', 'wb') as f:
   ...:     xport.v56.dump(df, f)
   ...:

However, it'll be best if you use the xport.Dataset to set metadata for your dataset.