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...@hilboll.de> 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 <mark...@gmail.com
> > <mailto:mark...@gmail.com>> 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
> > Matplotlib-users@lists.sourceforge.net
> > 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
Matplotlib-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/matplotlib-users