gslides is a Python package that helps analysts turn pandas dataframes into Google slides & sheets charts by configuring and executing Google API calls.
The package provides a set of classes that enable the user full control over the creation of new visualizations through configurable parameters while eliminating the complexity of working directly with the Google API.
.. code-block:: bash
pip install gslides
Below is an example that only showcases a simple workflow. Full discussion around features can be found in the docs.
1. Initialize package and connection
.. code-block:: python
import gslides from gslides import ( Frame, Presentation, Spreadsheet, Table, Series, Chart ) from sklearn import datasets gslides.initialize_credentials(creds) #BringYourOwnCredentials
2. Create a presentation
.. code-block:: python
prs = Presentation.create(name = 'demo pres')
3. Create a spreadsheet
.. code-block:: python
spr = Spreadsheet.create( title = 'demo spreadsheet', sheet_names = ['demo sheet'] )
4. Load the data to the spreadsheet
.. code-block:: python
plt_df = #Iris data frame = Frame.create(df = plt_df, spreadsheet_id = spr.spreadsheet_id, sheet_id = spr.sheet_names['demo sheet'], sheet_name = 'demo sheet', overwrite_data = True )
5. Create a scatterplot
.. code-block:: python
sc = Series.scatter(series_columns = target_names) ch = Chart( data = frame.data, x_axis_column = 'sepal length (cm)', series = [sc], title = f'Demo Chart', x_axis_label = 'Sepal Length', y_axis_label = 'Petal Width', legend_position = 'RIGHT_LEGEND', )
6. Create a table
.. code-block:: python
tbl = Table( data = plt_df.head() )
7. Create a slide with the scatterplot
.. code-block:: python
prs.add_slide( objects = [ch, tbl], layout = (1,2), title = "Investigation into Fischer's Iris dataset", notes = "Data from 1936" )
8. Preview the slide you have just created in your notebook
.. code-block:: python
prs.show_slide(prs.slide_ids[-1])
.. image:: img/usage.png
gslides also supports basic templating functionality. See this notebook <https://github.com/michael-gracie/gslides/blob/main/notebooks/usage.ipynb>_ for an example.
Find this Jupyter notebook <https://github.com/michael-gracie/gslides/blob/main/notebooks/advanced_usage.ipynb>_ detailing advanced usage of gslides.
To install the package with development dependencies run the command
.. code-block:: bash
pip install -e .[dev]
This will enable the following
pytest <https://docs.pytest.org/en/latest/>_
pytest in root package directoryblack <https://github.com/ambv/black> and isort <https://github.com/pre-commit/mirrors-isort>make html in package docs folderpython -m http.server