Google sheets Data Extractor
Project description
gSheetsDataExtractor
Extracts data from google sheets and plots a chart with the values on the sheet. This library also gives the user an option to select the columns for x-axis and y-axis
Installation
Use pip
to install the package
Python Version support
This package runs aunder python 3.6 and above versions
$ pip install gSheetsDataExtractor
Quickstart
Sign into the Google Drive
with the your Google account
Open the spreadsheet you want to access and get the SpreadSheet ID
from the link
Example
https://docs.google.com/spreadsheets/d/`1SrZfvr2ee54r7HR1jGtAE9zHIj_Y-UzK9ok8bdwkpqc`/edit#gid=0 The highlighted part in the above link will be the SpreadSheet ID
import the library and provide the input to the spreadSheetId and spreadSheetName:
- spreadSheetName can be any string without
space
>>> import gSheetsDataExtractor as de
>>> spreadSheetId = input()
>>> spreadSheetName = input()
For extracting the data and for plotting the chart with the values on the sheet, call the function extractData with googleSheetId and spreadSheetName as shown below:
>>> de.extractData(spreadSheetId, spreadSheetName)
This prints the column names of the spreadsheet and gives the user to select the columns for x-axis and y-axis and plots the graph with the column names given by user.
License
This package is distributed under the MIT license
.
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 Distributions
Built Distribution
Hashes for gSheetsDataExtractor-0.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1e83d618499046dc061e68b0b4029d6d1cfe21b80ffcfe61ec82928afcd3fde0 |
|
MD5 | 249e0c66728a2146b864cfb35e8e1416 |
|
BLAKE2b-256 | 909db015e8200491c165c8f80732fc1db36d0015589efdc8b8aff9913750994e |