%global _empty_manifest_terminate_build 0 Name: python-gspread-dataframe Version: 3.3.0 Release: 1 Summary: Read/write gspread worksheets using pandas DataFrames License: MIT URL: https://github.com/robin900/gspread-dataframe Source0: https://mirrors.nju.edu.cn/pypi/web/packages/9e/4b/d6874bfa13c3534e4effc8356a30d8ecda32f6eea989db5883a324ebdebb/gspread-dataframe-3.3.0.tar.gz BuildArch: noarch Requires: python3-gspread Requires: python3-pandas Requires: python3-six %description This package allows easy data flow between a worksheet in a Google spreadsheet and a Pandas DataFrame. Any worksheet you can obtain using the ``gspread`` package can be retrieved as a DataFrame with ``get_as_dataframe``; DataFrame objects can be written to a worksheet using ``set_with_dataframe``: import pandas as pd from gspread_dataframe import get_as_dataframe, set_with_dataframe worksheet = some_worksheet_obtained_from_gspread_client df = pd.DataFrame.from_records([{'a': i, 'b': i * 2} for i in range(100)]) set_with_dataframe(worksheet, df) df2 = get_as_dataframe(worksheet) The ``get_as_dataframe`` function supports the keyword arguments that are supported by your Pandas version's text parsing readers, such as ``pandas.read_csv``. Consult `your Pandas documentation for a full list of options `__. Since the ``'python'`` engine in Pandas is used for parsing, only options supported by that engine are acceptable: import pandas as pd from gspread_dataframe import get_as_dataframe worksheet = some_worksheet_obtained_from_gspread_client df = get_as_dataframe(worksheet, parse_dates=True, usecols=[0,2], skiprows=1, header=None) Formatting Google worksheets for DataFrames ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ If you install the ``gspread-formatting`` package, you can additionally format a Google worksheet to suit the DataFrame data you've just written. See the `package documentation for details `__, but here's a short example using the default formatter: import pandas as pd from gspread_dataframe import get_as_dataframe, set_with_dataframe from gspread_formatting.dataframe import format_with_dataframe worksheet = some_worksheet_obtained_from_gspread_client df = pd.DataFrame.from_records([{'a': i, 'b': i * 2} for i in range(100)]) set_with_dataframe(worksheet, df) format_with_dataframe(worksheet, df, include_column_header=True) %package -n python3-gspread-dataframe Summary: Read/write gspread worksheets using pandas DataFrames Provides: python-gspread-dataframe BuildRequires: python3-devel BuildRequires: python3-setuptools BuildRequires: python3-pip %description -n python3-gspread-dataframe This package allows easy data flow between a worksheet in a Google spreadsheet and a Pandas DataFrame. Any worksheet you can obtain using the ``gspread`` package can be retrieved as a DataFrame with ``get_as_dataframe``; DataFrame objects can be written to a worksheet using ``set_with_dataframe``: import pandas as pd from gspread_dataframe import get_as_dataframe, set_with_dataframe worksheet = some_worksheet_obtained_from_gspread_client df = pd.DataFrame.from_records([{'a': i, 'b': i * 2} for i in range(100)]) set_with_dataframe(worksheet, df) df2 = get_as_dataframe(worksheet) The ``get_as_dataframe`` function supports the keyword arguments that are supported by your Pandas version's text parsing readers, such as ``pandas.read_csv``. Consult `your Pandas documentation for a full list of options `__. Since the ``'python'`` engine in Pandas is used for parsing, only options supported by that engine are acceptable: import pandas as pd from gspread_dataframe import get_as_dataframe worksheet = some_worksheet_obtained_from_gspread_client df = get_as_dataframe(worksheet, parse_dates=True, usecols=[0,2], skiprows=1, header=None) Formatting Google worksheets for DataFrames ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ If you install the ``gspread-formatting`` package, you can additionally format a Google worksheet to suit the DataFrame data you've just written. See the `package documentation for details `__, but here's a short example using the default formatter: import pandas as pd from gspread_dataframe import get_as_dataframe, set_with_dataframe from gspread_formatting.dataframe import format_with_dataframe worksheet = some_worksheet_obtained_from_gspread_client df = pd.DataFrame.from_records([{'a': i, 'b': i * 2} for i in range(100)]) set_with_dataframe(worksheet, df) format_with_dataframe(worksheet, df, include_column_header=True) %package help Summary: Development documents and examples for gspread-dataframe Provides: python3-gspread-dataframe-doc %description help This package allows easy data flow between a worksheet in a Google spreadsheet and a Pandas DataFrame. Any worksheet you can obtain using the ``gspread`` package can be retrieved as a DataFrame with ``get_as_dataframe``; DataFrame objects can be written to a worksheet using ``set_with_dataframe``: import pandas as pd from gspread_dataframe import get_as_dataframe, set_with_dataframe worksheet = some_worksheet_obtained_from_gspread_client df = pd.DataFrame.from_records([{'a': i, 'b': i * 2} for i in range(100)]) set_with_dataframe(worksheet, df) df2 = get_as_dataframe(worksheet) The ``get_as_dataframe`` function supports the keyword arguments that are supported by your Pandas version's text parsing readers, such as ``pandas.read_csv``. Consult `your Pandas documentation for a full list of options `__. Since the ``'python'`` engine in Pandas is used for parsing, only options supported by that engine are acceptable: import pandas as pd from gspread_dataframe import get_as_dataframe worksheet = some_worksheet_obtained_from_gspread_client df = get_as_dataframe(worksheet, parse_dates=True, usecols=[0,2], skiprows=1, header=None) Formatting Google worksheets for DataFrames ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ If you install the ``gspread-formatting`` package, you can additionally format a Google worksheet to suit the DataFrame data you've just written. See the `package documentation for details `__, but here's a short example using the default formatter: import pandas as pd from gspread_dataframe import get_as_dataframe, set_with_dataframe from gspread_formatting.dataframe import format_with_dataframe worksheet = some_worksheet_obtained_from_gspread_client df = pd.DataFrame.from_records([{'a': i, 'b': i * 2} for i in range(100)]) set_with_dataframe(worksheet, df) format_with_dataframe(worksheet, df, include_column_header=True) %prep %autosetup -n gspread-dataframe-3.3.0 %build %py3_build %install %py3_install install -d -m755 %{buildroot}/%{_pkgdocdir} if [ -d doc ]; then cp -arf doc %{buildroot}/%{_pkgdocdir}; fi if [ -d docs ]; then cp -arf docs %{buildroot}/%{_pkgdocdir}; fi if [ -d example ]; then cp -arf example %{buildroot}/%{_pkgdocdir}; fi if [ -d examples ]; then cp -arf examples %{buildroot}/%{_pkgdocdir}; fi pushd %{buildroot} if [ -d usr/lib ]; then find usr/lib -type f -printf "/%h/%f\n" >> filelist.lst fi if [ -d usr/lib64 ]; then find usr/lib64 -type f -printf "/%h/%f\n" >> filelist.lst fi if [ -d usr/bin ]; then find usr/bin -type f -printf "/%h/%f\n" >> filelist.lst fi if [ -d usr/sbin ]; then find usr/sbin -type f -printf "/%h/%f\n" >> filelist.lst fi touch doclist.lst if [ -d usr/share/man ]; then find usr/share/man -type f -printf "/%h/%f.gz\n" >> doclist.lst fi popd mv %{buildroot}/filelist.lst . mv %{buildroot}/doclist.lst . %files -n python3-gspread-dataframe -f filelist.lst %dir %{python3_sitelib}/* %files help -f doclist.lst %{_docdir}/* %changelog * Mon Apr 10 2023 Python_Bot - 3.3.0-1 - Package Spec generated