Dear all, I have a CSV file with the first column with timestamps:
0:00:00 01/01/2007, 0.000, 10, 0.000, 10, 0.000, 10: 00:00:00 02/01/2007, 0.000, 10, 0.000, 10, 0.000, 10 00:00:00 03/01/2007, 0.000, 10, 0.000, 10, 0.000, 10 ... 00:00:00 29/12/2009, 0.000, 10, 0.000, 10, 0.000, 10 00:00:00 30/12/2009, 0.000, 10, 0.000, 10, 0.000, 10 00:00:00 31/12/2009, 0.000, 10, 0.000, 10, 0.000, 10 As you can see, the format is hour:minute:second (nor relevant, always 00) day/month/year. When loaded with mlab.csv2rec, it automatically detects them as dates and creates datetime objects, but it is not consistent with the interpretation of the dates. When the day is < 13, it interprets it as month/day/year. It's loaded correctly otherwise (as day/month/year). I could pre-process the files and change the dates format, but imho it's not very elegant. Any suggestion about how to address this issue? Regards, Sergi ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Matplotlib-users mailing list Matplotlib-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/matplotlib-users
