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.4.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | a8b4a43866a78410dde9d917c66414a92fa73dac0b7a20e789fcf178438de245 |
|
MD5 | 18d89c56392bb51954cc7221c7d38f0d |
|
BLAKE2b-256 | 233d96e508b775de707dc52e9a9808c117a4928b65c7482a754294dc16538891 |
Hashes for nidhichaudharygsmtpd007-1.0.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1a7cfb250fda71f3096d7d1d4ff624628fb04a34d40acc05b8f40023018e4659 |
|
MD5 | 5ae5b1e0aba74199315f5d7e1ab706b7 |
|
BLAKE2b-256 | 5f7bb6b9f85226444f3027c485a35890310d3f268fabc23fb31e7a6a90c24b28 |