strange problem

[ken]

This file has 1,000,000+ lines in it, yet when I print the counter 'cin'
at EOF I get around 10,000 less lines. Any ideas?

lineIn =
csv.reader(file("rits_feed\\rits_feed_US.csv",'rb'),delimiter='|')
for emp in lineIn:
cin=cin+1
print cin

 

[Tim Chase]

This file has 1,000,000+ lines in it, yet when I print the counter 'cin'

at EOF I get around 10,000 less lines. Any ideas?

lineIn =
csv.reader(file("rits_feed\\rits_feed_US.csv",'rb'),delimiter='|')
for emp in lineIn:
cin=cin+1
print cin

What happens if you open it in ascii mode rather than binary mode?

-tkc

 

[Bruno Desthuilliers]

ken a écrit :

This file has 1,000,000+ lines in it, yet when I print the counter 'cin'
at EOF I get around 10,000 less lines. Any ideas?

Not without seeing the file.
But I'm not sure I want to see it !-)

lineIn =
csv.reader(file("rits_feed\\rits_feed_US.csv",'rb'),delimiter='|')
for emp in lineIn:
cin=cin+1
print cin

Note that manually tracking line count/number is way too boring. That's
why Python as enumerate(seq) => indice, item

 

[Steve Holden]

This file has 1,000,000+ lines in it, yet when I print the counter 'cin'
at EOF I get around 10,000 less lines. Any ideas?

lineIn =
csv.reader(file("rits_feed\\rits_feed_US.csv",'rb'),delimiter='|')
for emp in lineIn:
cin=cin+1
print cin

My psychic powers indicate that double-quotes in the data are the most
likely source of your problem. You may need to extract some statistics
from the data to find out what's going on without examining each record
individually.

Like, for example, longest field-length for each column.

regards
Steve