GoogleSheetPlot is a python package allow the user to select a google sheet from their Google drive and plots a chart with the values on the sheet.
Project description
GoogleSheetPlot
This library helps a user to select a google sheet from their Google drive and plots a chart with the values on the sheet. The user only needs to select the column for the x-axis and the y-axis.
Install
pip install GoogleSheetPlot
How to initialize
Add the desired google sheet to the google drive then, get the last section the google drive link as Spreadsheet-ID.
Example - if google drive link is "https://docs.google.com/spreadsheets/d/1SrZfvr2ee54r7HR1jGtAE9zHIj_Y-UzK9ok8bdwkpqc/edit?usp=sharing", then google SPREADSHEET_ID = "1SrZfvr2ee54r7HR1jGtAE9zHIj_Y-UzK9ok8bdwkpqc".
Then the user needs to assign the range of the google sheet.
Example - RANGE_NAME = 'A1:C80'
from GoogleSheetPlot import GoogleSheetPlot
SAMPLE_SPREADSHEET_ID = '1SrZfvr2ee54r7HR1jGtAE9zHIj_Y-UzK9ok8bdwkpqc'
SAMPLE_RANGE_NAME = 'A1:C80'
gsp = GoogleSheetPlot()
df = gsp.getDataFrame(SAMPLE_SPREADSHEET_ID, SAMPLE_RANGE_NAME)
here "df" represents the accessed google sheet in dataframe format.
Please download the "credentials.json" file in your working repository by clicking the "Enable Google Sheets API" button
by visiting the page Turn on the Google Sheets API.
If a tab arises saying "This app isn't verified". Click on "Advanced" option on left-hand corner, and select "Go to Quickstart (unsafe)". Now click on "Allow" and approve the application.
Plot the graph
Just give the valid column names(X and Y axis)with the type of plot you want to get. Your plot gets saved with the format "col1_col2_category.png".
gsp.getPlot("average_sales", "offer_price","line")
Example
Please go through the Example.ipynb file in the Example folder.
Links
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.