On 7/15/19 1:59 PM, Chip Wachob wrote:
> Mats,
>
> Thank you!
>
> So I included the QUOTE_NONNUMERIC to my csv.reader() call and it almost
> worked.
>
> Now, how wonderful that the scope's csv file simply wrote an s for
> seconds and didn't include quotes. Now Python tells me it can't create
> a float of s. Of course I can't edit a 4G file in any editor that I
> have installed, so I have to work with the fact that there is a bit of
> text in there that isn't quoted.
yeah, the chips don't always fall right...
not sure what you're running, there are "stream editors" that can just
work on data as it passes through, even on Windows you can install
environments (cygwin, mingw) where the old "sed" command exists. Of
course Python can do that too, by working line-at-a-time, explicitly by
calling readlines() or implicitly by looping over the file handle. The
latter looks something like this;
with open("/path/to/datafile", "r") as f:
for line in f:
if REDFLAGTEXT in line: # skip these
continue
do-something-with line
I don't want to be leading you down further ratholes, just trying to
answer the questions as they come up....
>
> Which leads me to another question related to working with these csv
> files.
>
> Is there a way for me to tell the reader to skip the first 'n' rows?
> Or, for that matter, skip rows in the middle of the file?
it's usually easier to skip based on a pattern, if you can identify a
pattern, but you can certainly also add a counter used to skip. If 'n'
is always the same!
>
> A this point, I think it may be less painful for me to just skip those
> few lines that have text. I don't believe there will be any loss of
> accuracy.
>
> But, since row is not really an index, how does one conditionally skip a
> given set of row entries?
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
https://mail.python.org/mailman/listinfo/tutor
