python DataFrame data export to stata using to_stata() raise ValueError

Question

I use to_stata() to exporting my DataFrame

AppliedTariff.to_stata('Applied%s.dta' % name, write_index = False)

raise ValueError('Writing general object arrays is not supported')

I do not know how to continue.

when I use to_csv() to do this, it works ok. but I want to obain the dta version. — Eric
– Eric, Commented Mar 24, 2018 at 9:58

Martien Lubberink · Accepted Answer · 2018-07-14 02:09:25Z

3

See the answer via this link.

Find out which columns are of the object type:

list(df.select_dtypes(include=['object']).columns)

Convert them to something else: df['col'] = df['col'].astype(str)

answered Jul 14, 2018 at 2:09

Martien Lubberink

2,7671 gold badge23 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1