Hi What is the simplest way please to select a column of figures (floats and int) into a list, so I can manipulate the list e.g randomise the order
nums3 = db(db.Measures).select( db.Measures.measure_value, orderby=db.Measures.measure_date_time) meannums= sum(nums3)/float(len(nums3)) This calculation of the mean keeps giving me an error File "/home/sydstewart/web2py/applications/SydOwn/controllers/test.py" <https://sydstewart.pythonanywhere.com/admin/default/edit/SydOwn/controllers/test.py>, line 92, in cusum qnum[i][k] = (nums3[k]) - (meannums) TypeError: unsupported operand type(s) for -: 'Row' and 'int' Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.