plotursheet 1.0.0

Description:

plotursheet 1.0.0

Plotursheet Package
The package acts as a wrapper on gsheets and retrieves a sheet from google drive.
Further it uses the same to plot a graph(currently scatterplot for continuos values)
How to install the library using pip
pip install plotursheet

Or if you want it in cwd
pip install plotursheet -t .

This would do the work
How to initialize the library and select the desired Google sheet
Now once the package is installed,
import the module and run the plotty() function within it
The required values url, column_name1, column_name2(the axes for plot),sheet number
are all to be present in a config.txt file
python #invoke python interpreter
import plotursheet #imports the package to be used

N
How to use the various methods in the library
The package has a single method plotty()
And can be invoked by running
import plotursheet
plotursheet.plotty()


Once the function is invoked, Google sheet specified at url,sheet_no
is loaded into file "detail.csv" at the working directory
Further pandas is invoked and the sheet is taken in as a pandas dataframe
Then the column names are used to plot with (currently scatterplot for 2 continuous
values is written)
IMPORTANT NOTE

This package uses authentication for google sheets api
The client_secrets.json must be put in root directory (for authenticaation)
And at the first run authentication flow must be completed from the google account
where the sheet is present in drive
Directory to put in client_secrets

"C:/Users/<Usernaame>/"


In order to supply url and column names and sheet number
The file config.txt has to be created and placed in current working directory.
The content has to be

# config.txt
[sheet]
#url for ur sheet
url="https://docs.google.com/spreadsheets/d/1SrZfvr2ee54r7HR1jGtAE9zHIj_Y-UzK9ok8bdwkpqc/edit?usp=sharing"
#sheet number
n=0
#x_axis
x=offer_price
#y-axis
y=average_sales