Write Number as string csv python

Question

I'm trying to write a csv file from json data. During that, i want to write '001023472' but its writing as '1023472'. I have searched a lot. But dint find an answer.

The value is of type string before writing. The problem is during writing it into the file.

Thanks in advance.

Look at the chapter on Strings in the Python manual. Much of it is dedicated to formatting output. docs.python.org/3.5/library/string.html — BRPocock
– BRPocock, Commented Oct 9, 2014 at 7:16
@AvinashGarg that is a SyntaxError in Python 3 (leading 0s are prohibited in numeric literals), and in Python 2 it will convert the number to octal (would be a SyntaxError if there were an 8 or 9). — Nick T
– Nick T, Commented Oct 9, 2014 at 7:22
@AvinashGarg plus it doesn't seem like the OP actually has a literal but something from a JSON. — Nick T
– Nick T, Commented Oct 9, 2014 at 7:26

Tomo · Accepted Answer · 2014-10-09 07:13:00Z

1

Convert the number to string with formatting operator; in your case: "%09d" % number.

answered Oct 9, 2014 at 7:13

Tomo

3,5415 gold badges28 silver badges29 bronze badges

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

Comments

Nick T · Accepted Answer · 2014-10-09 07:35:07Z

1

Use the format builtin or format string method.

>>> format(1023472, '09')
'001023472'
>>> '{:09}'.format(1023472)
'001023472'

If your "number" is actually a string, you can also just left-pad it with '0''s:

>>> format('1023472', '>09')
'001023472'

The Python docs generally eschew % formatting, saying it may go away in the future and is also more finnicky; for new code there is no real reason to use it, especially in 2.7+.

edited Oct 9, 2014 at 7:35

answered Oct 9, 2014 at 7:20

Nick T

26.9k14 gold badges88 silver badges128 bronze badges

4 Comments

Selva Over a year ago

still i get the value as '1023472' in my csv file. i want '001023472'

Nick T Over a year ago

Is it a string from your CSV? You could cast it to int then use the format methods, or just pad the string with 0's.

Selva Over a year ago

i'm writing in a csv file from json data. one of my json value is '001023472' which i want to write into one of columns in csv file. But there seems to be a problem while writing. the value is of type string but when i write it to csv it is changed as int.

Nick T Over a year ago

What are you writing your CSV with? I don't think the standard library csv package converts strings to ints. I'm still a bit confused as to the type() of your "json value".

Collectives™ on Stack Overflow

Write Number as string csv python

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related