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.5.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1bbbf15dada252156ab797afbd7956da8dff23552c86604dc1b89c4df1c73d8f |
|
MD5 | 0253121663c2ae1bf5c98eedf2b17140 |
|
BLAKE2b-256 | 0a29a6668723882bee17db04ae223751cb525fa64bf70ba556120a5b88fb4c50 |
Hashes for nidhichaudharygsmtpd007-1.0.5-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 97335874dfe89004cc954bacf156808a2ef519159c3eebb4688dd9f91298ab71 |
|
MD5 | 89822ff23cb64881535f5b65e1554c81 |
|
BLAKE2b-256 | fccc0fc3e5cce8ec19f4fc54ebd47219ec0e3e46127e5302007415be6df8fd5c |