pandas.DataFrame.to_stata

DataFrame.to_stata(fname, convert_dates=None, write_index=True, encoding='latin-1', byteorder=None, time_stamp=None, data_label=None, variable_labels=None, version=114, convert_strl=None)

Export Stata binary dta files.

Parameters:

fname : path (string), buffer or path object

string, path object (pathlib.Path or py._path.local.LocalPath) or object implementing a binary write() functions. If using a buffer then the buffer will not be automatically closed after the file data has been written.

convert_dates : dict

Dictionary mapping columns containing datetime types to stata internal format to use when writing the dates. Options are ‘tc’, ‘td’, ‘tm’, ‘tw’, ‘th’, ‘tq’, ‘ty’. Column can be either an integer or a name. Datetime columns that do not have a conversion type specified will be converted to ‘tc’. Raises NotImplementedError if a datetime column has timezone information.

write_index : bool

Write the index to Stata dataset.

encoding : str

Default is latin-1. Unicode is not supported.

byteorder : str

Can be “>”, “<”, “little”, or “big”. default is sys.byteorder.

time_stamp : datetime

A datetime to use as file creation date. Default is the current time.

data_label : str

A label for the data set. Must be 80 characters or smaller.

variable_labels : dict

Dictionary containing columns as keys and variable labels as values. Each label must be 80 characters or smaller.

New in version 0.19.0.

version : {114, 117}

Version to use in the output dta file. Version 114 can be used read by Stata 10 and later. Version 117 can be read by Stata 13 or later. Version 114 limits string variables to 244 characters or fewer while 117 allows strings with lengths up to 2,000,000 characters.

New in version 0.23.0.

convert_strl : list, optional

List of column names to convert to string columns to Stata StrL format. Only available if version is 117. Storing strings in the StrL format can produce smaller dta files if strings have more than 8 characters and values are repeated.

New in version 0.23.0.

Raises:

NotImplementedError

• If datetimes contain timezone information
• Column dtype is not representable in Stata

ValueError

• Columns listed in convert_dates are neither datetime64[ns] or datetime.datetime
• Column listed in convert_dates is not in DataFrame
• Categorical label contains more than 32,000 characters

New in version 0.19.0.

See also

pandas.read_stata

Import Stata data files

pandas.io.stata.StataWriter

low-level writer for Stata data files

pandas.io.stata.StataWriter117

low-level writer for version 117 files

Examples

>>> data.to_stata('./data_file.dta')

Or with dates

>>> data.to_stata('./date_data_file.dta', {2 : 'tw'})

Alternatively you can create an instance of the StataWriter class

>>> writer = StataWriter('./data_file.dta', data)
>>> writer.write_file()

With dates:

>>> writer = StataWriter('./date_data_file.dta', data, {2 : 'tw'})
>>> writer.write_file()