pandas.read_csv() won't read back in complex number dtypes from pandas.DataFrame.to_csv() #9379
Description
How can I read back in dataframes from CSV files which I export using to_csv() that have complex numbers?
test case:
data = pd.DataFrame([1+2j,2+3j,3+4j],columns=['a']) print 'a=' print data['a'] print 'a*2=' print data['a']*2 filename = 'testcase1.csv' data.to_csv(filename) print "\nReadback..." data2 = pd.read_csv(filename) print data2['a'] print data2['a']*2 output:
a= 0 (1+2j) 1 (2+3j) 2 (3+4j) Name: a, dtype: complex128 a*2= 0 (2+4j) 1 (4+6j) 2 (6+8j) Name: a, dtype: complex128 Readback... 0 (1+2j) 1 (2+3j) 2 (3+4j) Name: a, dtype: object 0 (1+2j)(1+2j) 1 (2+3j)(2+3j) 2 (3+4j)(3+4j) Name: a, dtype: object