Skip to main content

A Python module for writing pandas DataFrame objects directly to Google Spreadsheets

Project description

dfgsheet

A Python module for writing pandas DataFrame objects directly to Google Spreadsheets

Install dfgsheet

$ pip install dfgsheet

Setup

  1. Enable the Google Sheets API for the Google account you'd like to use.

Simple Usage

import pandas as pd
import dfgsheet

data_frame = pd.DataFrame()
dfgsheet.write_to_sheet(data_frame, spreadsheet_id, sheet_name)

Parameters

There are three mandatory parameters for the above function:

  • data_frame is any pandas DataFrame object.
  • spreadsheet_id is the part of the Google Spreadsheet URL that is between /d/ and /edit.
  • sheet_name is the name of the sheet within the Google spreadsheet. E.g. Sheet1.

What's new

  • Update README.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

dftogsheet-0.0.4.tar.gz (3.8 kB view hashes)

Uploaded Source

Built Distribution

dftogsheet-0.0.4-py3-none-any.whl (5.6 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page