Menu
▾
▴
matplotlib-users
|
From: Mark B. <ma...@gm...> - 2014-04-25 08:46:39
|
Hello List, datestr2num works great when dates are stored as month/day/year (as American like). Europeans store them as day/month/year. Any quick function to convert a day/month/year string do a date? Is there an eu version: datestr2numeu? Thanks, Mark |
|
From: Mark B. <ma...@gm...> - 2014-04-25 09:02:57
|
OK, I figured out I can use:
converters={0:strpdate2num('%d-%m-%y')}
What now if part of my dates are given as 'day-month-year' and part as
'day/month/year' in the same file (I know, who does that, an I could do a
replace first and then read it in). Can I specify both formats for the
converter? I guess not....
Thanks,
Mark
On Fri, Apr 25, 2014 at 10:46 AM, Mark Bakker <ma...@gm...> wrote:
> Hello List,
>
> datestr2num works great when dates are stored as month/day/year (as
> American like).
>
> Europeans store them as day/month/year.
>
> Any quick function to convert a day/month/year string do a date? Is there
> an eu version: datestr2numeu?
>
> Thanks,
>
> Mark
>
|
|
From: Andreas H. <li...@hi...> - 2014-04-25 09:35:10
|
On 25.04.2014 11:02, Mark Bakker wrote:
> OK, I figured out I can use:
> converters={0:strpdate2num('%d-%m-%y')}
>
> What now if part of my dates are given as 'day-month-year' and part as
> 'day/month/year' in the same file (I know, who does that, an I could do
> a replace first and then read it in). Can I specify both formats for the
> converter? I guess not....
Try this:
def _conv_date(s):
try:
return strpdate2num('%d-%m-%y')
except Exception: # figure out which exception class to use
return strpdate2num('%d/%m/%y')
converters={0:_conv_date}
Cheers, Andreas.
>
> Thanks,
>
> Mark
>
>
>
> On Fri, Apr 25, 2014 at 10:46 AM, Mark Bakker <ma...@gm...
> <mailto:ma...@gm...>> wrote:
>
> Hello List,
>
> datestr2num works great when dates are stored as month/day/year (as
> American like).
>
> Europeans store them as day/month/year.
>
> Any quick function to convert a day/month/year string do a date? Is
> there an eu version: datestr2numeu?
>
> Thanks,
>
> Mark
>
>
>
>
> ------------------------------------------------------------------------------
> Start Your Social Network Today - Download eXo Platform
> Build your Enterprise Intranet with eXo Platform Software
> Java Based Open Source Intranet - Social, Extensible, Cloud Ready
> Get Started Now And Turn Your Intranet Into A Collaboration Platform
> http://p.sf.net/sfu/ExoPlatform
>
>
>
> _______________________________________________
> Matplotlib-users mailing list
> Mat...@li...
> https://lists.sourceforge.net/lists/listinfo/matplotlib-users
>
--
-- Andreas.
|
|
From: Mark B. <ma...@gm...> - 2014-04-25 09:37:53
|
Thanks, Andreas, but it doesn't quite work.
This works for me (I manually changed all dates to 'day-month-year' for
testing):
a = loadtxt('test.csv',converters={2:strpdate2num('%d-%m-%Y')})
But when I define the same function in a separate function, as you
suggested:
def conv_date(s):
return strpdate2num('%d-%m-%Y')
and do
a = loadtxt('test.csv',converters={2:conv_date})
I get the non-descript error:
loadtxt(fname, dtype, comments, delimiter, converters, skiprows, usecols,
unpack, ndmin)
847 fh.close()
848
--> 849 X = np.array(X, dtype)
850 # Multicolumn data are returned with shape (1, N, M), i.e.
851 # (1, 1, M) for a single row - remove the singleton dimension
there
SystemError: error return without exception set
Any suggestions?
Thanks, Mark
On Fri, Apr 25, 2014 at 11:17 AM, Andreas Hilboll <li...@hi...> wrote:
> On 25.04.2014 11:02, Mark Bakker wrote:
> > OK, I figured out I can use:
> > converters={0:strpdate2num('%d-%m-%y')}
> >
> > What now if part of my dates are given as 'day-month-year' and part as
> > 'day/month/year' in the same file (I know, who does that, an I could do
> > a replace first and then read it in). Can I specify both formats for the
> > converter? I guess not....
>
> Try this:
>
> def _conv_date(s):
> try:
> return strpdate2num('%d-%m-%y')
> except Exception: # figure out which exception class to use
> return strpdate2num('%d/%m/%y')
>
> converters={0:_conv_date}
>
> Cheers, Andreas.
>
>
> >
> > Thanks,
> >
> > Mark
> >
> >
> >
> > On Fri, Apr 25, 2014 at 10:46 AM, Mark Bakker <ma...@gm...
> > <mailto:ma...@gm...>> wrote:
> >
> > Hello List,
> >
> > datestr2num works great when dates are stored as month/day/year (as
> > American like).
> >
> > Europeans store them as day/month/year.
> >
> > Any quick function to convert a day/month/year string do a date? Is
> > there an eu version: datestr2numeu?
> >
> > Thanks,
> >
> > Mark
> >
> >
> >
> >
> >
> ------------------------------------------------------------------------------
> > Start Your Social Network Today - Download eXo Platform
> > Build your Enterprise Intranet with eXo Platform Software
> > Java Based Open Source Intranet - Social, Extensible, Cloud Ready
> > Get Started Now And Turn Your Intranet Into A Collaboration Platform
> > http://p.sf.net/sfu/ExoPlatform
> >
> >
> >
> > _______________________________________________
> > Matplotlib-users mailing list
> > Mat...@li...
> > https://lists.sourceforge.net/lists/listinfo/matplotlib-users
> >
>
>
> --
> -- Andreas.
>
|
|
From: Paul H. <pmh...@gm...> - 2014-04-25 14:49:37
|
You might have more luck reading in that data (dates with mixed format)
with pandas than numpy.
On Fri, Apr 25, 2014 at 2:37 AM, Mark Bakker <ma...@gm...> wrote:
> Thanks, Andreas, but it doesn't quite work.
>
> This works for me (I manually changed all dates to 'day-month-year' for
> testing):
>
> a = loadtxt('test.csv',converters={2:strpdate2num('%d-%m-%Y')})
>
> But when I define the same function in a separate function, as you
> suggested:
>
> def conv_date(s):
> return strpdate2num('%d-%m-%Y')
>
> and do
>
> a = loadtxt('test.csv',converters={2:conv_date})
>
> I get the non-descript error:
>
> loadtxt(fname, dtype, comments, delimiter, converters, skiprows, usecols,
> unpack, ndmin)
> 847 fh.close()
> 848
> --> 849 X = np.array(X, dtype)
> 850 # Multicolumn data are returned with shape (1, N, M), i.e.
> 851 # (1, 1, M) for a single row - remove the singleton dimension
> there
>
> SystemError: error return without exception set
>
> Any suggestions?
>
> Thanks, Mark
>
>
>
>
> On Fri, Apr 25, 2014 at 11:17 AM, Andreas Hilboll <li...@hi...>wrote:
>
>> On 25.04.2014 11:02, Mark Bakker wrote:
>> > OK, I figured out I can use:
>> > converters={0:strpdate2num('%d-%m-%y')}
>> >
>> > What now if part of my dates are given as 'day-month-year' and part as
>> > 'day/month/year' in the same file (I know, who does that, an I could do
>> > a replace first and then read it in). Can I specify both formats for the
>> > converter? I guess not....
>>
>> Try this:
>>
>> def _conv_date(s):
>> try:
>> return strpdate2num('%d-%m-%y')
>> except Exception: # figure out which exception class to use
>> return strpdate2num('%d/%m/%y')
>>
>> converters={0:_conv_date}
>>
>> Cheers, Andreas.
>>
>>
>> >
>> > Thanks,
>> >
>> > Mark
>> >
>> >
>> >
>> > On Fri, Apr 25, 2014 at 10:46 AM, Mark Bakker <ma...@gm...
>> > <mailto:ma...@gm...>> wrote:
>> >
>> > Hello List,
>> >
>> > datestr2num works great when dates are stored as month/day/year (as
>> > American like).
>> >
>> > Europeans store them as day/month/year.
>> >
>> > Any quick function to convert a day/month/year string do a date? Is
>> > there an eu version: datestr2numeu?
>> >
>> > Thanks,
>> >
>> > Mark
>> >
>> >
>> >
>> >
>> >
>> ------------------------------------------------------------------------------
>> > Start Your Social Network Today - Download eXo Platform
>> > Build your Enterprise Intranet with eXo Platform Software
>> > Java Based Open Source Intranet - Social, Extensible, Cloud Ready
>> > Get Started Now And Turn Your Intranet Into A Collaboration Platform
>> > http://p.sf.net/sfu/ExoPlatform
>> >
>> >
>> >
>> > _______________________________________________
>> > Matplotlib-users mailing list
>> > Mat...@li...
>> > https://lists.sourceforge.net/lists/listinfo/matplotlib-users
>> >
>>
>>
>> --
>> -- Andreas.
>>
>
>
>
> ------------------------------------------------------------------------------
> Start Your Social Network Today - Download eXo Platform
> Build your Enterprise Intranet with eXo Platform Software
> Java Based Open Source Intranet - Social, Extensible, Cloud Ready
> Get Started Now And Turn Your Intranet Into A Collaboration Platform
> http://p.sf.net/sfu/ExoPlatform
> _______________________________________________
> Matplotlib-users mailing list
> Mat...@li...
> https://lists.sourceforge.net/lists/listinfo/matplotlib-users
>
>
|
