SQLFROM.factory csv file upload and manipulation

[Yebach]

Hello

I am trying different approaches to upload and manipulate csv file before insert it into DB

I do not need to save the file but If I can open it with csv DictReader that would be awesome.

Any suggestions on how to  achieve it. 

I am trying with SQLFORM.factory

uploadCanonForm=SQLFORM.factory(Field('fileCanon', 'upload',uploadfolder=os.path.join(request.folder,'uploads')),
                                table_name='canonUpload')

I know how to get the file content but it is stored in a list. Any better way to manipulate it since I also have to skip some lines of the file 

Any suggestions?

Thank you