Select data from a spreadsheet

Question

I read data from a spreadsheet using Python 3 libraries (xlrd / xlsxwriter / Pandas and Numpy). This spreadsheet has in the rows questions of the survey and in the columns the areas that answered the survey. Each sentence has a note, that goes from 0 to 100. I need to create a code that I can select only phrases (lines) with notes smaller than 30 for example in all areas (columns).

Could someone give me a hint?

Answer 1

I wonder if this might help you?

output = []

    f = open( 'arquivo.csv', 'rU' ) #abrir o arquivo em read universal mode
    for line in f:
        cells = line.split( "," )
        output.append( ( cells[ 0 ], cells[ 1 ], cells[ 3 ] ) ) #Neste caso pegaria a primeira segunda e terceira coluna

    f.close()

    print output