The timestamps in the CSV do not match the time formats required: timestamp,likes datetime,int T, 7/1/14,1117 7/2/14,497 7/3/14,296 7/1/14,41911 7/5/14,1129 7/6/14,301 7/7/14,2493 7/8/14,1137 7/9/14,196 7/10/14,1668
You'll need to update the time strings to match one of the supported time formats like "2014-07-01". --------- Matt Taylor OS Community Flag-Bearer Numenta On Wed, Sep 10, 2014 at 2:52 PM, Mika Schiller <[email protected]> wrote: > Yes, I've attached the raw csv file. > > > > > On Wed, Sep 10, 2014 at 5:10 PM, Matthew Taylor <[email protected]> wrote: >> >> Mika, >> >> Your problem might be how you're getting the CSV file out of Excel. >> Can you show us the raw CSV file? I imagine that Excel is not >> formatting the date outputs correctly when it exports the file to CSV. >> --------- >> Matt Taylor >> OS Community Flag-Bearer >> Numenta >> >> >> On Tue, Sep 9, 2014 at 8:20 PM, Mika Schiller <[email protected]> >> wrote: >> > Hey guys, >> > >> > I'm trying to run a Nupic prediction on some social media data. Though >> > when >> > I try to run the swarm on the data, I get the following error: >> > >> > ValueError: The provided timestamp 7/1/14 is malformed. The supported >> > formats are: [%Y-%m-%d %H:%M:%S.%f, %Y-%m-%d %H:%M:%S:%f, %Y-%m-%d >> > %H:%M:%S, >> > %Y-%m-%d %H:%M, %Y-%m-%d, %m/%d/%Y %H:%M, %m/%d/%y %H:%M, >> > %Y-%m-%dT%H:%M:%S.%fZ, %Y-%m-%dT%H:%M:%SZ, %Y-%m-%dT%H:%M:%S] >> > >> > You can take a look at the attachment to see how I have my csv file >> > formatted. It's no different than the hotgym data. Excel also doesn't >> > seem >> > to support the datetime format that the value error proposes. What could >> > be >> > going on here? >> > >> > >> > thnx >> > >> > >> > Mika >> >
