A library to convert the google sheets into pandas df and plot the graphs accordingly
Project description
Library: nidhichaudharygsmtpd007
This library helps in taking the google sheets and can even convert the sheets into the pandas dataframe and then it can use this dataframe to plot it into 3 different forms of graphs:
- Bar plot
- Line Plot with markers and dotted line
- Scatter Plot with the mean line and the color.
** Details of each functions are described below
-
To call the google spreadsheet:
-
Use createcredentials() for this purpose:
createcredentials('your api json filename', 'spreadsheet to be called')
Put the full path for the api json filename
-
It returns the list of the dictionary from the called spreadsheet.
-
-
To convert the list of dictionary returned from the createcredentials() to dataframe:
-
Use createDF() for this purpose:
createDF(d) - d: the returned list of dictionary
-
Returns the dataframe that can be used for plotting.
-
-
To plot the graphs of your choice:
-
Currently the library provides you to plot 3 graphs: Bar Plot, Line Plot, Scatter Plot.
-
For Barlplot you need to call:
plotBar(dataframe, 'column name for the x axis', 'column name for the y axis')
- The function automatically plots the graph for you.
-
For Lineplot you need to call:
plotLine(dataframe, 'column name for the x axis', 'column name for the y axis')
- The function plots the graph which is represented by the dotted line and the points are marked by the '>' symbol.
-
For Scatterplot you need to call:
plotScatter(dataframe, 'column name for the x axis', 'column name for the y axis', colors) colors: Array for designing the colorbar.
- The function returns the Scatterplot which is represented by the green color and along with it there shall be a color bar which describes the variation of color throughout the plotting of graph. Along with that mean is also plotted with that.
Note: All figures can be easily saved.
Pre-Requisites:
- Google API for spreadsheets
For creating this library I have used gspread for calling the google spreadsheet api.
-
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for nidhichaudharygsmtpd007-1.0.6.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | f2a7786f21bac3917381a618598487240d428a77145572026ffaec33fab4657a |
|
MD5 | b1a0d596cd1a2581a9f6a49b0138c0d4 |
|
BLAKE2b-256 | aadba3ad6889089bf4006170f2ac6e6fb6cd43eb4af294fdf2dd38866408e565 |
Hashes for nidhichaudharygsmtpd007-1.0.6-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 41ceafbae8557f139150d07e2a1c284148353624f79887c14f67717834d35418 |
|
MD5 | 9c55ef4736ffb136627efdc28bf58bde |
|
BLAKE2b-256 | 7b5771df9f11a922e57e1b07be176b99b03913cf386a3c8bb10bc4c463c8550c |