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


    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)


       Heading1  Heading2
    0         1         2
    1         3         4


Back to homepage or read more recommendations: