Document creation of a Pandas DataFrame from gspread

[sudar]

Would be a nice feature to have.

[sudar]

After I posted it, I found the following snippets which allows you to create Pandas DataFrame

import gspread
import pandas
gc = gspread.login('my@email.com', 'supersecretekey')
book = gc.open('My Spreadsheet')
sheet = book.sheet1 #in this case
dataframe = pandas.DataFrame(sheet.get_all_records())

Source: https://github.com/burnash/gspread/wiki/Cookbook

[JamesHaskell]

I'm very happy to see Pandas support being brought into the mix!

James

On Jun 7, 2014, at 5:19 AM, Sudar notifications@github.com wrote:

After I posted it, I found the following snippets which allows you to create Pandas DataFrame

import gspread
import pandas
gc = gspread.login('my@email.com', 'supersecretekey')
book = gc.open('My Spreadsheet')
sheet = book.sheet1 #in this case
dataframe = pandas.DataFrame(sheet.get_all_records())
Source: https://github.com/burnash/gspread/wiki/Cookbook

—
Reply to this email directly or view it on GitHub.

[westurner]

What about pandas -> gspread?

[jimrockey]

That would be an awesome feature.

[msuozzo]

So it appears this is a very easy operation every without a dedicated call. I don't think it warrants a change to the code but it might be useful to add this to the documentation in case anyone else has this use-case.

[lavigne958]

Gspread -> Pandans is covered in the documentation: Examples
Pandas -> Gspread is not intended to be covered here but it is using the following libraries: gspread-pandas && gspread-dataframe

Closing this issue.