read-excel 0.0.2
Read en excel file throgh google drive and plot it

gsheets
=======

|PyPI version| |License| |Supported Python| |Format|


``gsheets`` is a small wrapper around the [`Google Sheets API`_ (v4)](https://docs.google.com/spreadsheets) to provide
more convenient access to [`Google Sheets`_](https://docs.google.com/spreadsheets) from Python scripts.

go to [google console](console.cloud.google.com) 
1.Create a Project in google cloud
2.through Navigation menu Go ti API'S & Services and go to library
3.search for google sheets api and enable it
4.search for google drive api enable it and on the right side corner click on create credentials
select google drive api in which api you are using column and web server (eg node js tomcat) in  Where will you be calling the API from dropdown and tick on application data. and then no and press button
5.fill any name in account and role select project and then editor and type json and submit. it will download the json file .
6.open json file search client email go to google sheet you want to use and select share and give access to client email and send.


Links
-----

- GitHub: https://github.com/afsarahmad786/Read-Excel
- PyPI: https://pypi.org/project/Read-Excel/0.0.1/


Installation
------------

This package runs under Python 2.7, and 3.6+, use pip_ to install:

.. code:: bash

    $ pip install Read-Excel

This will also install google-api-python-client_ and its dependencies, notably
httplib2_ and oauth2client_, as required dependencies.


Quickstart
----------

Log into the `Google Developers Console`_ with the Google account whose
spreadsheets you want to access. Create (or select) a project and enable the
**Drive API** and **Sheets API** (under **Google Apps APIs**).

Go to the **Credentials** for your project and create **New credentials** >
**OAuth client ID** > of type **Other**. In the list of your **OAuth 2.0 client
IDs** click **Download JSON** for the Client ID you just created. Save the
file as ``client_secrets.json`` in your home directory (user directory).

import the library and load the data by passing the filename and json file downloaded from console it will return a dataframe and print top 5 rows of your data:

.. code:: python

    >>> import Read-Excel as rf

    >>> dataframe = rf.load_data(filename_of_your_sheet,json_path)

For plotting the data you have to pass the dataframe you just loaded and pass the name X axis  columns name and Y axis column name it will plot the data for you:

.. code:: python

    for plotting
    >>> plot_data(dataframe,"x-axis-column","y-axis-column")


    ...

``WorkSheet.to_frame()`` passes its kwargs on to ``pandas.read_csv()`` 


See also
--------

- gsheets.py_ |--| self-containd script to dump all worksheets of a Google
  Spreadsheet to CSV or convert any subsheet to a pandas DataFrame (Python 2
  prototype for this library)
- gspread_ |--| Google Spreadsheets Python API (more mature and featureful
  Python wrapper, currently using the XML-based `legacy v3 API`_)
- `example Jupyter notebook`_ using gspread_ to fetch a sheet into a pandas
  DataFrame
- df2gspread_ |--| Transfer data between Google Spreadsheets and Pandas (build
  upon gspread_, currently Python 2 only, GPL)
- pygsheets_ |--| Google Spreadsheets Python API v4 (v4 port of gspread_
  providing further extensions)
- gspread-pandas_ |--| Interact with Google Spreadsheet through Pandas DataFrames
- pgsheets_ |--| Manipulate Google Sheets Using Pandas DataFrames (independent
  bidirectional transfer library, using the `legacy v3 API`_, Python 3 only)
- PyDrive_ |--| Google Drive API made easy (google-api-python-client_ wrapper
  for the `Google Drive`_ API, currently v2) 


License
-------

This package is distributed under the `MIT license`_.


.. _Google Sheets API: https://developers.google.com/sheets/
.. _Google Sheets: https://sheets.google.com
.. _Google Drive: https://drive.google.com
.. _Turn on the API: https://developers.google.com/sheets/quickstart/python#step_1_turn_on_the_api_name

.. _Google Developers Console: https://console.developers.google.com


.. _MIT license: https://opensource.org/licenses/MIT


.. |--| unicode:: U+2013


.. |PyPI version| image:: https://img.shields.io/pypi/v/gsheets.svg
    :target: https://pypi.org/project/gsheets/
    :alt: Latest PyPI Version
.. |License| image:: https://afsarahmad786.github.io/Read-Excel/
    :target: https://pypi.org/project/gsheets/
    :alt: License
.. |Supported Python| image:: https://img.shields.io/pypi/pyversions/gsheets.svg
    :target: https://pypi.org/project/gsheets/
    :alt: Supported Python Versions