BUG: to_csv extra header line with multiindex columns

[dsm054]

This seems strange to me, but I don't often use a MultiIndex so I might be missing something obvious.

>>> pd.__version__
'0.13.1-420-g6899ed6'
>>> df2 = pd.DataFrame([1], columns=pd.MultiIndex.from_arrays([[1],[2]]))
>>> df2
   1
   2
0  1

[1 rows x 1 columns]
>>> df2.columns
MultiIndex(levels=[[1], [2]],
           labels=[[0], [0]])
>>> print df2.to_csv()
,1
,2
,
0,1

Is there supposed to be that empty line at the end of the header? Compare

>>> print df2.to_csv(header=False)
0,1

[jreback]

yes, its for the row index-names (they are None here), in theory could could not print it as the read_csv will try both ways, but that's the 'original' format.

[dsm054]

Ah, okay.

[jreback]

@dsm054 I think its reasonable to do a PR which takes out the line and see if anything breaks....(obviously a tests which exactly is supposed to match won't), but I am talking about the read_csv should still work correctly.

and I guess its more in-line with what you'd except.

[meloun]

hi i have the same issue, any workarround how to not have this empty line there?

[jreback]

pandas will read this format
what version?

[meloun]

yes pandas will, but I need an output without this extra line (it's an input for other application)
see http://stackoverflow.com/questions/24372993/pandas-dataframe-with-2-rows-header-and-export-to-csv

[jreback]

you can use tupleize_cols=True to make the header in a single line