How to change the order of columns while converting to excel in Pandas?

Asked Jan 19 '18 at 18:59

Active Jan 19 '18 at 21:35

Viewed 336 times

I have a dictionary, 'values', in Python. The 'values' contains lists of integers, except the 'RowHeaders'. I would like to have the 'RowHeaders' as the first column in the excel file. In the following code, I cannot add a condition in 'from_items' method to put it as the first column. When I run this code, it doesn't put the 'RowHeaders' data in the first column.

values['RowHeaders'] = list_of_headers

for feat in features:
    values.setdefault(feat, list())
    for p in data:
        values[feat].append(int(data[p][feat]))

writer = pd.ExcelWriter('output.xlsx')
df = pd.DataFrame.from_items([(f,values[f]) for f in values])
df.to_excel(writer, 'Sheet1', index=False)    
writer.save()

Thanks.

edited Jan 19 '18 at 21:35

asked Jan 19 '18 at 18:59

mpourreza

Please provide some data, then it is easier to help. And also change the tag, this is a pandas not a scipy question. – Cleb Jan 19 '18 at 20:16
Thank you for your reply. I update the description and the code. – mpourreza Jan 19 '18 at 21:35
Can you provide an example of `values`? You might also want to check [this link](https://stackoverflow.com/help/mcve). – Cleb Jan 19 '18 at 21:41
Check [here](https://stackoverflow.com/q/13148429/2000793) and/or [here](https://stackoverflow.com/q/41968732/2000793). – Eric Ed Lohmar Jan 19 '18 at 22:29
@EricEdLohmar The first linked worked for me! – mpourreza Jan 19 '18 at 22:57

How to change the order of columns while converting to excel in Pandas?

0 Answers0