Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python > #86760
| From | Mark Lawrence <breamoreboy@yahoo.co.uk> |
|---|---|
| Subject | Re: date |
| Date | 2015-03-02 16:41 +0000 |
| References | <slrnmf8hqo.6hg.maus@gmaus.info> <md1ks9$epb$1@speranza.aioe.org> <mailman.40.1425306406.13471.python-list@python.org> <md20cs$er0$1@speranza.aioe.org> |
| Newsgroups | comp.lang.python |
| Message-ID | <mailman.53.1425314529.13471.python-list@python.org> (permalink) |
On 02/03/2015 15:42, Fabien wrote:
> On 02.03.2015 15:26, Mark Lawrence wrote:
>>>
>>> Have you tried Pandas? http://pandas.pydata.org/
>>>
>>> If your csv file has no other problems, the following should do the
>>> trick:
>>>
>>> import pandas as pd
>>> df = pd.read_csv('file.csv', index_col=0, parse_dates= {"time" : [0]})
>>>
>>> Cheers,
>>>
>>> Fabien
>>>
>>
>> IMHO complete overkill. Give me the Steven D'Aprano solution any day of
>> the week.
>
> Without knowing anything about the OP background, I still hope my
> suggestion is a good one. Pandas is one of the best thing that happened
> to me in my python life, I'm happy to at least suggest it. But yeah, if
> you just want to read the csv and do no data crunching on it, pandas is
> "overkill".
>
> Fabien
I've used pandas myself and I'll admit to being very impressed. However
the OP originally said 'I have a csv file, the first item on a line is
the date in the format 2015-03-02 I try to get that as a date by
date(row[0]), but it barfs, replying "Expecting an integer".' Without
finding out exactly what the OP is trying to achieve, telling them to
download a package such as pandas just to convert a string to a date is
overkill when there's a solution in the stdlib.
--
My fellow Pythonistas, ask not what our language can do for you, ask
what you can do for our language.
Mark Lawrence
Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
date greymausg <maus@mail.com> - 2015-03-02 11:55 +0000
Re: date Fabien <fabien.maussion@gmail.com> - 2015-03-02 13:25 +0100
Re: date Mark Lawrence <breamoreboy@yahoo.co.uk> - 2015-03-02 14:26 +0000
Re: date Steven D'Aprano <steve+comp.lang.python@pearwood.info> - 2015-03-03 01:44 +1100
Re: date Tim Golden <mail@timgolden.me.uk> - 2015-03-02 14:50 +0000
Re: date Mark Lawrence <breamoreboy@yahoo.co.uk> - 2015-03-02 15:24 +0000
Re: date Chris Angelico <rosuav@gmail.com> - 2015-03-03 02:51 +1100
Re: date alister <alister.nospam.ware@ntlworld.com> - 2015-03-02 16:09 +0000
Re: date Chris Angelico <rosuav@gmail.com> - 2015-03-03 03:25 +1100
Re: date Dave Angel <davea@davea.name> - 2015-03-02 13:32 -0500
Re: date Mark Lawrence <breamoreboy@yahoo.co.uk> - 2015-03-02 16:44 +0000
Re: date Fabien <fabien.maussion@gmail.com> - 2015-03-02 16:42 +0100
Re: date Mark Lawrence <breamoreboy@yahoo.co.uk> - 2015-03-02 16:41 +0000
Re: date greymausg <maus@mail.com> - 2015-03-02 14:49 +0000
Re: date Steven D'Aprano <steve+comp.lang.python@pearwood.info> - 2015-03-02 23:45 +1100
Re: date greymausg <maus@mail.com> - 2015-03-02 14:49 +0000
Re: date greymausg <maus@mail.com> - 2015-03-02 17:55 +0000
csiph-web