« first day (192 days earlier)      last day (2209 days later) » 

Ivo Flipse
Ivo Flipse
10:32 AM
@Sathya I'm trying my SELECT statement, to see if I can rebuilt my array
from the non-zero data
 
Sathya
Sathya
OK
 
Ivo Flipse
Ivo Flipse
cur.execute("""SELECT * FROM data WHERE meas_id = 1""")
 
Sathya
Sathya
ok
 
Ivo Flipse
Ivo Flipse
in Heidi, this returns all the rows
so when I do data = cur.fetchall() I get : >>> data[0]
(1L, 1L, 49L, 0L, 20L, 0L)
awfully familiar from my early mistake :P
there's only 5 columns, so shouldn't I be expected that many out as well? and why on earth are they longs again :P
ah wait, it might be that I should assign cur.execute to something
on no, that was what went wrong before too :\
 
Sathya
Sathya
LOL :)
 
Ivo Flipse
Ivo Flipse
10:38 AM
lol data2 = cur.fetchall() gives me a tuple, with tuples for each row
and the rows are id, meas_id, frame, row, col, value
but whyyyyy are they Longs :S
 
Sathya
Sathya
presumably they're stored as long objects?
how about just cast'ing them?
 
Ivo Flipse
Ivo Flipse
the datatype says INT
though I can convert them to ints
I just noticed, I was storing my values as INTs too hellow lot's of zeros!
converting them works, but I feel like I'm doing something wrong again :P
y = np.array(data2,float)
that mass converts the whole damn thing to floats :P
 
Ivo Flipse
Ivo Flipse
11:08 AM
Now let's pray those 'swypes' are: not in all measurements and simply some offset problem
well at least this proves that I can retrieve it
 
Sathya
Sathya
11:21 AM
@IvoFlipse yay :)
 
Ivo Flipse
Ivo Flipse
strange, when rebuilding the array, those swypes are gone :S
and my glumpy library was freaking out on me :(
I still need to get that part working
the rest is mostly boilerplate code :P
4
Q: How can I speed up an animation?

Ivo FlipseI'm trying to create a Matplotlib animation of my paw data, where you can see the pressure distribution on the entire pressure plate over time (256x64 sensors for 250 frames). I found a working example on Matplotlib's own site and managed to get it working on my own data. However the 'animation'...

python animation
This part I still need to solve
 

« first day (192 days earlier)      last day (2209 days later) »