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.

Reply via email to