python: pandas - order of data frame column

Question

I have following code to output a dataFrame:

output = pd.DataFrame({"id":id_test, "hum":y_pred})
output.to_csv("myOutput.csv", index=False)

Then in myOutput.csv, I got hum as the first column, id as the second column. Is there a way to make id the first column instead? Thanks!

EdChum · Accepted Answer · 2016-05-26 15:36:33Z

2

Just reorder the columns:

output.ix[:,['id','hum']].to_csv("myOutput.csv", index=False)

Because you used a dict as the data, the column order is not necessarily the same order as the key creation order in the dict

answered May 26, 2016 at 15:36

EdChum

397k204 gold badges837 silver badges583 bronze badges

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

1 Answer 1