Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Poll: Do you use csv.Sniffer?

12 views
Skip to first unread message

sk...@pobox.com

unread,
Sep 24, 2009, 10:26:04 PM9/24/09
to pytho...@python.org
If you are a csv module user, I have a question for you: Do you use the
csv.Sniffer class?

o Yes, frequently
o Yes, on occasion
o I tried it a few times but don't use it now
o No, I don't need it
o No, never heard of it
o No (some other reason)

If you don't use it, how do you figure out the structure of your csv files?

o I just know
o I stumble around in the dark trying different parameters until the csv
reader starts to spit out useful data

If csv.Sniff was to be removed from a future version of Python, how
difficult would it be to adapt?

o No problem
o No problem as long as you make it available via PyPI
o It would be a problem

If it would be a problem for you (which would not easily be solved by adding
it to PyPI), feel free to describe why it would be a challenge for you. In
fact, please feel free to add any other comments you like to your response.

Private replies please.

Thanks,

--
Skip Montanaro - sk...@pobox.com - http://www.smontanaro.net/
Getting old sucks, but it beats dying young

Sean DiZazzo

unread,
Sep 24, 2009, 11:05:33 PM9/24/09
to
> Skip Montanaro - s...@pobox.com -http://www.smontanaro.net/

>     Getting old sucks, but it beats dying young

How do I mark the boxes??

~Sean

Mensanator

unread,
Sep 24, 2009, 11:50:27 PM9/24/09
to
On Sep 24, 9:26�pm, s...@pobox.com wrote:
> If you are a csv module user, I have a question for you: �Do you use the
> csv.Sniffer class?
>
> � � o Yes, frequently
> � � o Yes, on occasion
> � � o I tried it a few times but don't use it now
> � � X No, I don't need it

> � � o No, never heard of it
> � � o No (some other reason)
>
> If you don't use it, how do you figure out the structure of your csv files?
>
> � � X I just know

> � � o I stumble around in the dark trying different parameters until the csv
> � � � reader starts to spit out useful data
>
> If csv.Sniff was to be removed from a future version of Python, how
> difficult would it be to adapt?
>
> � � X No problem

> � � o No problem as long as you make it available via PyPI
> � � o It would be a problem
>
> If it would be a problem for you (which would not easily be solved by adding
> it to PyPI), feel free to describe why it would be a challenge for you. �In
> fact, please feel free to add any other comments you like to your response.
>
> Private replies please.
>
> Thanks,
>
> --
> Skip Montanaro - s...@pobox.com -http://www.smontanaro.net/

Alex_Gaynor

unread,
Sep 25, 2009, 12:00:25 AM9/25/09
to
> Skip Montanaro - s...@pobox.com -http://www.smontanaro.net/

>     Getting old sucks, but it beats dying young

I just used it yesterday :) Not having it would mean I'd need to add
another dependency to my project so that I can import data from my
client (it's easier to reexport his Excel spreadsheets as CSV and
import that), that's not the end of the world, but what's the argument
against leaving it in the stdlib?

Alex

John Machin

unread,
Sep 25, 2009, 2:49:28 AM9/25/09
to
On Sep 25, 2:00 pm, Alex_Gaynor <alex.gay...@gmail.com> wrote:
> On Sep 24, 10:26 pm, s...@pobox.com wrote:
> > If you are a csv module user, I have a question for you:  Do you use the
> > csv.Sniffer class?
>
> I just used it yesterday :)  Not having it would mean I'd need to add
> another dependency to my project so that I can import data from my
> client (it's easier to reexport his Excel spreadsheets as CSV and
> import that), that's not the end of the world, but what's the argument
> against leaving it in the stdlib?

Why do you need the sniffer? If your client can't do "save as" the
same way twice, just read the spreadsheets directly!

Tim Chase

unread,
Sep 25, 2009, 5:04:24 AM9/25/09
to John Machin, pytho...@python.org
> Why do you need the sniffer? If your client can't do "save as" the
> same way twice, just read the spreadsheets directly!

If I only had one contact and one client, it would be this
easy...If you can get multiple points of contact at multiple
client sites to reliably & competently agree on a format, what
are you doing here on c.l.py instead of making your billions as a
business-integration consultant? ;-)

-tkc

John Machin

unread,
Sep 25, 2009, 5:30:04 AM9/25/09
to pytho...@python.org
On 25/09/2009 7:04 PM, Tim Chase wrote:
>> Why do you need the sniffer? If your client can't do "save as" the
>> same way twice, just read the spreadsheets directly!
>
> If I only had one contact and one client, it would be this easy...If you
> can get multiple points of contact at multiple client sites to reliably
> & competently agree on a format, what are you doing here on c.l.py
> instead of making your billions as a business-integration consultant? ;-)

Because like everyone else, I can't get the same contact at the same
site to do the same thing twice in a row :-(

My point is that "save as CSV" is (a) a potentially lossy process and
(b) an unnecessary step when you can read straight from the XLS file.

nn

unread,
Sep 25, 2009, 9:45:42 AM9/25/09
to
On Sep 24, 10:26 pm, s...@pobox.com wrote:
> Skip Montanaro - s...@pobox.com -http://www.smontanaro.net/

>     Getting old sucks, but it beats dying young

Do you use the csv.Sniffer class? No. Don't use it right now.

how do you figure out the structure of your csv files? "head -2
filename" + visual inspection + guesswork

If csv.Sniff was to be removed from a future version of Python, how

difficult would it be to adapt? No problem.

It would still be nice if the code was available somewhere on the net.

r

unread,
Sep 25, 2009, 1:37:19 PM9/25/09
to
On Sep 24, 9:26 pm, s...@pobox.com wrote:
> If csv.Sniff was to be removed from a future version of Python, how
> difficult would it be to adapt?

A good response would be...

What are you adding to the stdlib that requires making space by
removing csv.Sniff? Oh and, i never use the Sniffer ;-)

0 new messages