Metadata-Version: 2.1
Name: gsheet-plots
Version: 0.0.0
Summary: gsheet will help to create your connection between google sheet and python through API and help to plot graph by you choice
Home-page: https://github.com/abhii1/gsheetplot
Author: abhishek pratap singh
Author-email: abhisheklumiamicro@gmail.com
License: UNKNOWN
Description: # gsheetplots_
        
        >gheetplot is small wrapper around  [Google Sheet API](https://developers.google.com/sheets/) ,[Pandas](https://pandas.pydata.org/) and [Matplotlib](https://matplotlib.org/) provide **access** to [Google Sheet](https://docs.google.com/spreadsheets/u/0/) and help to plot graph with desired axis by user .
        
        
        To access [Google Sheet](https://developers.google.com/sheets/) one need to [Turn_on_the_API ](#Quickstart)  , download service credinatial JSON file and use ``read_spreadsheet()`` to read spreadsheet and underneath it takes the help of [gspread](https://gspread.readthedocs.io/en/latest/) ,[ServiceAccountCredentials](https://oauth2client.readthedocs.io/en/latest/source/oauth2client.service_account.html) to create connection with [Google Sheet API](https://developers.google.com/sheets/api)  and function convert it into a dataframe which can be used data analysis .
        
        
        ## Table of contents
        
        
        * [Link](#Link)
        * [Installation](#screenshots)
        * [Quickstart](#Quickstart)
        * [Languages_and_API](#Languages_and_API)
        * [See_Also](#See_Also)
        * [Contact](#contact)
        * [License](#License)
        
        
        ## Link
        
        
        
        - [X] GitHub : https://github.com/abhii1/Sheetplot
        - [x] PyPi :
        - [x] Documention : https://github.com/abhii1/Sheetplot
        - [x] Download : https://github.com/abhii1/Sheetplot
        
        
        ## Installation
        
        
        This package runs under ``Python 3.5+ `` ,use [pip](https://pip.pypa.io/en/stable/)  to install
        
        
             pip install gsheetplot
        
         This will install gsheetplot module you need to install [gspread](https://gspread.readthedocs.io/en/latest/)
        
         Requirements: ``Python 2.7+ or Python 3+``
         ```sh
        pip install gspread
        
        ```
        you  need install oauth2client to use  [ServiceAccountCredentials](https://oauth2client.readthedocs.io/en/latest/source/oauth2client.service_account.html)
        
         ```sh
        pip install oauth2client
        
        ```
        
        ## Quickstart
        
        
        Log into the [Google Developers console](https://console.developers.google.com/) with the google account whose spreadsheets you want to access . Create(or select) a project and enable the **Drive APP** and **Sheet API** under (**Google Apps APIs**).
        
        Steps for turn on API
        
        1__ [Go to google API console](https://console.developers.google.com/)
        
        2__  create new project
        
        3__ Click Enable API. Search for and enable the Google Drive API.
        
        4__ Create credentials for a Web Server to access Application Data.
        
        5__ Name the service account and grant it a Project Role of Editor.
        
        6__ Download the JSON file
         7__ Copy the JSON file to your code directory and rename it to client_secret.json
        
                                      this some how its looklike
        
        
                                      {
        
                                      "type": "service_account",
        
                                      "project_id": "spreadsheet-291117",
        
                                      "private_key_id":_________________,
        
                                      "private_key":  _______ here will be some key,
        
                                      "client_email": "________________,
        
                                      "client_id": __________________________,
        
                                      [auth_uri]("https://accounts.google.com/o/oauth2/auth"),
        
                                      [token_uri]("https://oauth2.googleapis.com/token"),
        
                                      [auth_provider_x509_cert_url]("https://www.googleapis.com/oauth2/v1/certs"),
        
                                      [client_x509_cert_url](https://www.googleapis.com/robot/v1/metadata/x509/spreadsheet%40spreadsheet-291117.iam.gserviceaccount.com"),
        
                                      }
        
         8__ if you spread sheet is private then you have give drop client_email of JSON file to share with client file
        
        
         Create a object to acces member function and convert into dataframe
        
         ```Python
        
         #import libary
        from plotgraph import GET
        
         #url of the spreadsheet
        connection_url='https://docs.google.com/spreadsheets/d/1077QfadB_V_Nl8-jomsb62RYyrs0_Is-IGlVRl8QF2I/edit?usp=sharing'
        
        #servicecrendiatl JSON file
        driveouth_json='spreadsheetouth.json'
        
        #creating a object to access member function
        >>> dataframeObj=GET.read_sheet_to_dataframe(connection_url,driveouth_json)
        
        #converting to dataframe
        dataframe=dataframeobj.read_spreadsheet()
        
        
        ```
        
        Option for user input
        
        ```python
        
        #tuple for X axis and y axis
        X,Y=dataframe.select_axis()
        
        ```
        
        plot graph with user input
        
        ```python
        #input from user
        >>> X,Y=dataframe.select_axis()
        
        #calling plot function
        
        plot=r.plot_chart(g,X,Y,'line',imagename='test')
        
        
        ```
        
        you can provide range of data example from (200,500)
        
        ```python
        
        plot=r.plot_chart(g,X,Y,'line',range=(200,500),imagename='test')
        
        ```
        imagename is name of image that will saved in system you can make empty also
        
        ```python
        
        plot=r.plot_chart(g,X,Y,'line')
        
        ```
        
        diffrent kind of plot
        
        ```python
        
        #plot kde
        plot=r.plot_chart(g,X,Y,'kde')
        
        ```
        
        
        ## Languages_and_API
        
        
        [<img src="https://pluralsight.imgix.net/paths/python-7be70baaac.png?w=70" width="150" height="140">](https://www.python.org/)
        
        [<img src="https://encrypted-tbn0.gstatic.com/images?q=tbn%3AANd9GcSsIK2jA5rNj9I7ttMIgAReruBAkUKOPVRr6g&usqp=CAU" width="150" height="140">](https://developers.google.com/drive)
        
        [<img src="https://api.framer.com/store/assets/aroagb/google-sheet-component/artwork.png?ZDg0MzF" width="150" height="140">](https://developers.google.com/sheets/api)
        
        
        
        ## See_also
        
        
        * [Google Sheets API]( https://developers.google.com/sheets/) : Read, write, and format data in Sheets. The latest version of the Sheets API lets developers programmatically
        
        * [Pandas](https://pandas.pydata.org/) : pandas is a software library written for the Python programming language for data manipulation and analysis
        
        * [gspread](https://gspread.readthedocs.io/en/latest/) : Python wrapper, currently using the XML-based ``legacy v3 API`` example ``Jupyter notebook`` using gspread_ to fetch a sheet into a pandas DataFrame
        
        * [matplotlib](https://matplotlib.org/) : Matplotlib is a plotting library for the Python programming language and its numerical mathematics extension NumPy
        
        
        
        
        ## Contact
        
        
        Created by Abhishek pratap singh
        
        [<img src="https://cdns.iconmonstr.com/wp-content/assets/preview/2012/240/iconmonstr-linkedin-3.png" width="42" height="42">](https://www.linkedin.com/in/abhishek-pratap-singh-44a96816b/)
        
        [<img src="https://9to5google.com/wp-content/uploads/sites/4/2016/08/gmail-logo.png?w=1280" width="42" height="42">](abhisheklumiamicro@gmail.com)
        
        
        ## License
        
        This package is distributed under the `MIT license`_.# gsheetplot
        
        >gheetplot is small wrapper around  [Google Sheet API](https://developers.google.com/sheets/) ,[Pandas](https://pandas.pydata.org/) and [Matplotlib](https://matplotlib.org/) provide **access** to [Google Sheet](https://docs.google.com/spreadsheets/u/0/) and help to plot graph with desired axis by user .
        
        
        To access [Google Sheet](https://developers.google.com/sheets/) one need to [Turn_on_the_API ](#Quickstart)  , download service credinatial JSON file and use ``read_spreadsheet()`` to read spreadsheet and underneath it takes the help of [gspread](https://gspread.readthedocs.io/en/latest/) ,[ServiceAccountCredentials](https://oauth2client.readthedocs.io/en/latest/source/oauth2client.service_account.html) to create connection with [Google Sheet API](https://developers.google.com/sheets/api)  and function convert it into a dataframe which can be used data analysis .
        
        
        ## Table of contents
        
        
        * [Link](#Link)        
        * [Installation](#screenshots)
        * [Quickstart](#Quickstart)
        * [Languages_and_API](#Languages_and_API)
        * [See_Also](#See_Also)
        * [Contact](#contact)
        * [License](#License)
        
        
        ## Link
        
        
        
        - [X] GitHub :
        - [x] PyPi:
        - [x] Documention:
        - [x] Download
        
        
        ## Installation
        
        
        This package runs under ``Python 3.5+ `` ,use [pip](https://pip.pypa.io/en/stable/)  to install
        
        
             pip install gsheetplot
        
         This will install gsheetplot module you need to install [gspread](https://gspread.readthedocs.io/en/latest/)
        
         Requirements: ``Python 2.7+ or Python 3+``
         ```sh
        pip install gspread
        
        ```
        you  need install oauth2client to use  [ServiceAccountCredentials](https://oauth2client.readthedocs.io/en/latest/source/oauth2client.service_account.html)
        
         ```sh
        pip install oauth2client
        
        ```
        
        ## Quickstart
        
        
        Log into the [Google Developers console](https://console.developers.google.com/) with the google account whose spreadsheets you want to access . Create(or select) a project and enable the **Drive APP** and **Sheet API** under (**Google Apps APIs**).
        
        Steps for turn on API
        
        1__ [Go to google API console](https://console.developers.google.com/)
        
        2__  create new project
        
        3__ Click Enable API. Search for and enable the Google Drive API.
        
        4__ Create credentials for a Web Server to access Application Data.
        
        5__ Name the service account and grant it a Project Role of Editor.
        
        6__ Download the JSON file
         7__ Copy the JSON file to your code directory and rename it to client_secret.json
        
                                      this some how its looklike
        
        
                                      {
        
                                      "type": "service_account",
        
                                      "project_id": "spreadsheet-291117",
        
                                      "private_key_id":_________________,
        
                                      "private_key":  _______ here will be some key,
        
                                      "client_email": "________________,
        
                                      "client_id": __________________________,
        
                                      [auth_uri]("https://accounts.google.com/o/oauth2/auth"),
        
                                      [token_uri]("https://oauth2.googleapis.com/token"),
        
                                      [auth_provider_x509_cert_url]("https://www.googleapis.com/oauth2/v1/certs"),
        
                                      [client_x509_cert_url](https://www.googleapis.com/robot/v1/metadata/x509/spreadsheet%40spreadsheet-291117.iam.gserviceaccount.com"),
        
                                      }
        
         8__ if you spread sheet is private then you have give drop client_email of JSON file to share with client file
        
        
         Create a object to acces member function and convert into dataframe
        
         ```Python
        
         #import libary
         >>> from gsheetplot import GET
        
         #url of the spreadsheet
        connection_url='https://docs.google.com/spreadsheets/d/1077QfadB_V_Nl8-jomsb62RYyrs0_Is-IGlVRl8QF2I/edit?usp=sharing'
        
        #servicecrendiatl JSON file
        driveouth_json='spreadsheetouth.json'
        
        #creating a object to access member function
        >>> dataframeObj=GET.read_sheet_to_dataframe(connection_url,driveouth_json)
        
        #converting to dataframe
        dataframe=dataframeobj.read_spreadsheet()
        
        
        ```
        
        Option for user input
        
        ```python
        
        #tuple for X axis and y axis
        X,Y=dataframe.select_axis()
        
        ```
        
        plot graph with user input
        
        ```python
        #input from user
        >>> X,Y=dataframe.select_axis()
        
        #calling plot function
        
        plot=r.plot_chart(g,X,Y,'line',imagename='test')
        
        
        ```
        
        you can provide range of data example from (200,500)
        
        ```python
        
        plot=r.plot_chart(g,X,Y,'line',range=(200,500),imagename='test')
        
        ```
        imagename is name of image that will saved in system you can make empty also
        
        ```python
        
        plot=r.plot_chart(g,X,Y,'line')
        
        ```
        
        diffrent kind of plot
        
        ```python
        
        #plot kde
        plot=r.plot_chart(g,X,Y,'kde')
        
        ```
        
        
        ## Languages_and_API
        
        
        [<img src="https://pluralsight.imgix.net/paths/python-7be70baaac.png?w=70" width="150" height="140">](https://www.python.org/)
        
        [<img src="https://encrypted-tbn0.gstatic.com/images?q=tbn%3AANd9GcSsIK2jA5rNj9I7ttMIgAReruBAkUKOPVRr6g&usqp=CAU" width="150" height="140">](https://developers.google.com/drive)
        
        [<img src="https://api.framer.com/store/assets/aroagb/google-sheet-component/artwork.png?ZDg0MzF" width="150" height="140">](https://developers.google.com/sheets/api)
        
        
        
        ## See_also
        
        
        *[Google Sheets API]( https://developers.google.com/sheets/) help you to under stand how enable API
        
        *[Pandas](https://pandas.pydata.org/) for more information in data manupulations and other feature
        
        *[gspread](https://gspread.readthedocs.io/en/latest/)Python wrapper, currently using the XML-based ``legacy v3 API`` example ``Jupyter notebook`` using gspread_ to fetch a sheet into a pandas DataFrame
        
        *[matplotlib](https://matplotlib.org/) it will provide helpfull feature to change title,label ,color etc of graph
        
        *[ServiceAccountCredentials](https://oauth2client.readthedocs.io/en/latest/source/oauth2client.service_account.html) it will help to understand about connection of API in python
        
        
        
        ## Contact
        
        
        Created by Abhishek pratap singh
        
        [<img src="https://cdns.iconmonstr.com/wp-content/assets/preview/2012/240/iconmonstr-linkedin-3.png" width="42" height="42">](https://www.linkedin.com/in/abhishek-pratap-singh-44a96816b/)
        
        [<img src="https://9to5google.com/wp-content/uploads/sites/4/2016/08/gmail-logo.png?w=1280" width="42" height="42">](abhisheklumiamicro@gmail.com)
        
        
        ## License
        
        This package is distributed under the `MIT license`_.
        
Platform: UNKNOWN
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.6
Classifier: Operating System :: OS Independent
Requires-Python: >=3.6
Description-Content-Type: text/markdown
