uploading a csv file and read it with python module pandas

[Gaston]

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

[greaneym]

Gastron,

try using read_csv instead of read.csv?

data = read_csv('csvfiles/train.csv')

this syntax works for me.

Margaret

[Anthony]

Something like:

    record = db.mytable(id)
    data = pd.read_csv(db.mytable.myfile.retrieve(record.myfile)[1])

Anthony

[Gaston]

Thanks Margaret. But the idea was to get a csv file (with pandas) already uploaded by users

[Gaston]

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

[Anthony]

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

[Gaston C]

Thanks Anthony once more. I should really read the tutorial before going further.

--
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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/L1_e_rNzD84/unsubscribe.
To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.