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

• GitHub: https://github.com/victor369basu/GoogleSheetPlot
• PyPI: https://pypi.org/project/GoogleSheetPlot/
• Documentation: https://github.com/victor369basu/GoogleSheetPlot/blob/master/README.md