automatic import of python-gspread-dataframe

3 files changed, 161 insertions, 0 deletions

diff --git a/.gitignore b/.gitignore
index e69de29..0df58de 100644
--- a/.gitignore
+++ b/.gitignore
@@ -0,0 +1 @@
+/gspread-dataframe-3.3.0.tar.gz
diff --git a/python-gspread-dataframe.spec b/python-gspread-dataframe.spec
new file mode 100644
index 0000000..6a26fe0
--- /dev/null
+++ b/python-gspread-dataframe.spec
@@ -0,0 +1,159 @@
+%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 <https://pandas.pydata.org/docs/reference/api/pandas.read_csv.html>`__. 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 <https://github.com/robin900/gspread-formatting#formatting-a-worksheet-using-a-pandas-dataframe>`__, 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 <https://pandas.pydata.org/docs/reference/api/pandas.read_csv.html>`__. 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 <https://github.com/robin900/gspread-formatting#formatting-a-worksheet-using-a-pandas-dataframe>`__, 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 <https://pandas.pydata.org/docs/reference/api/pandas.read_csv.html>`__. 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 <https://github.com/robin900/gspread-formatting#formatting-a-worksheet-using-a-pandas-dataframe>`__, 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 <Python_Bot@openeuler.org> - 3.3.0-1
+- Package Spec generated
diff --git a/sources b/sources
new file mode 100644
index 0000000..3f0366a
--- /dev/null
+++ b/sources
@@ -0,0 +1 @@
+73d08ebb121744afdad5431f44f2a68f  gspread-dataframe-3.3.0.tar.gz