That wasn't complete code. You'll have to define "id" somewhere, and it should be the record ID of a record in the db.mytable table.
Anthony On Friday, March 21, 2014 3:52:18 AM UTC-4, Gaston wrote: > Thanks Anthony. > > Then, in db.py > db.define_table('mytable',Field('myfile','upload')) > > and in default.py > def stat(): > record=db.mytable(id) > data = pd.read_csv(db.mytable.myfile.retrieve(record.myfile)[1] > > But I got the following error message > <type 'exceptions.AttributeError'>('NoneType' object has no attribute > 'myfile') > > Sorry for my poor understanding of how the database works. Could you > direct me to a manual or tutorial for beginners so I can learn these > issues. > > Thanks > > On Thursday, March 20, 2014 2:35:50 PM UTC+1, Anthony wrote: >> >> Something like: >> >> record = db.mytable(id) >> data = pd.read_csv(db.mytable.myfile.retrieve(record.myfile)[1]) >> >> Anthony >> >> On Wednesday, March 19, 2014 9:50:15 AM UTC-4, Gaston wrote: >> >>> I am statistician and new in web2py. >>> I tried to build an application that allows users to: >>> >>> - upload a csv file in the database (my file) >>> - and click a link where some automated analyses have been attached >>> using the python module pandas with (import pandas as pd) >>> >>> >>> In the db.py, I have >>> db.define_table('mytable',Field('myfile','upload')) >>> >>> >>> In the default.py I have the below lines >>> def stat(): >>> data=pd.read.csv('myfile') >>> >>> >>> I received the following error: >>> >>> <type 'exceptions.AttributeError'>('module' object has no attribute >>> 'read') >>> >>> Great if someone could help. Thanks. Gaston >>> >> -- 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.