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) [source]

A class for writing Stata binary dta files from array-like objects

Parameters:

Parameters:	fname : str or buffer String path of file-like object convert_dates : dict Dictionary mapping columns containing datetime types to stata internal format to use when wirting 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. dataset_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.
Raises:	NotImplementedError If datetimes contain timezone information Column dtype is not representable in Stata ValueError Columns listed in convert_dates are noth either 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.

fname : str or buffer

String path of file-like object

convert_dates : dict

Dictionary mapping columns containing datetime types to stata internal format to use when wirting 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.

dataset_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.

Raises:

NotImplementedError

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

ValueError

Columns listed in convert_dates are noth either 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.

Examples

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

Or with dates

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

Links:

http://pandas.pydata.org/pandas-docs/version/0.19.2/generated/pandas.DataFrame.to_stata.html

doc_Pandas

2017-01-12 04:46:46

Comments