A visualisation library written in Python to plot your Google Sheets.
Project description
GSheet Plotter
An interface to plot graphs using data from your Google Spreadsheets.
Features:
- Fetch spreadsheet from ID
- Plot 2D graphs using any two columns
- Export graphs in .png
Quick Links to get up and running
Installation:
Install GSheet Plotter
pip install gsheet_plotter
Create a credentials file(.json) to allow access to GSheet Plotter to access your spreadsheets.
-
Go to Google-Developer-Console and login with your Google account.
-
In the left pane click on
Credentials
- Click on
Create Credentials
- In the dropdown, choose
Service Account
- Fill in the details, and click on
Create
-
Click on
Done
-
Go back to your dashboard and you'll see new credentials added with the information you entered.
-
Click on the Edit icon
-
Goto Keys on
Add Key
. -
Download the JSON file and move to the working directory.
Usage:
- Instantiate the class by passing Google Service Account json file,Sheet Id found in the Google Sheet URL and the work sheet name
- Fetch data from the sheet to a pandas dataframe. The dataframe is saved in the
data
attribute.
- Plot the graph by using two column names
- Additional method- Fetch the data and plot the graph in one go by passing the column list
Available methods
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
gsheet_plotter-0.0.1.tar.gz
(3.6 kB
view hashes)
Built Distribution
Close
Hashes for gsheet_plotter-0.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9c7b0a14feb9a993faa8a996397db417b4933c6c0af088a0fe03c19a3d93f0b5 |
|
MD5 | 44297e969b9f7ac134b9e895200c586a |
|
BLAKE2b-256 | 687839845d8f5f3a88b8db4a921bcde21b1e46ff05c2efba684cab6ac73e7766 |