Getting list of lists into pandas DataFrame

I am reading contents of a spreadsheet into pandas. DataNitro has a method that returns a rectangular selection of cells as a list of lists. So

    table = Cell("A1").table

gives

    table = [['Heading1', 'Heading2'], [1 , 2], [3, 4]]

    headers = table.pop(0) # gives the headers as list and leaves data

I am busy writing code to translate this, but my guess is that it is such a simple use that there must be method to do this. Cant seem to find it in documentation. Any pointers to the method that would simplify this?

The following gives what you want:

    df = DataFrame(table, columns=headers)
    df

outputs

    Out[7]:
       Heading1  Heading2
    0         1         2
    1         3         4

From: stackoverflow.com/q/19112398

Back to homepage or read more recommendations: