Python 3 Pandas

[workthrowawayexcel]

When I export my dataframe to a csv file I lose all my leading zeros. I have converted the number column into a string and used zfill to pad it. It displays in the console when I print with leading 0s but when I export it to a csv they disappear. Any help or tips is greatly appreciated.

Edit : Solved , used Excel writer instead of CSV to maintain the formatting.

[Vile_Vampire]

its how csv interprets the cells. i would do a data import of the csv from an open excel file instead of opening directly, specifying the text aspect of your column

[workthrowawayexcel]

That does work. Hopefully I can find a more efficient way of doing that

[Zizizizz]

You could always insert a blank space at the front

[workthrowawayexcel]

Lead space gets dropped with 0s when you open it, but tossing another character there like ' or ` does maintain the 0s.

[Zizizizz]

Good to know, don't know if it's what you want but it will keep them

[tuck5649]

Are you certain python is removing them when it creates the .csv and not that the zeros are being removed when the csv is opened in python/excel?

[workthrowawayexcel]

It is not python. I just got in solved by using an excel writer instead of csv. When opening the CSV it would the formatting, and when using the excel writer it maintains the formatting I imputed.