#
# Licensed to the Apache Software Foundation (ASF) under one or more
# contributor license agreements. See the NOTICE file distributed with
# this work for additional information regarding copyright ownership.
# The ASF licenses this file to You under the Apache License, Version 2.0
# (the "License"); you may not use this file except in compliance with
# the License. You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
import functools
import shutil
import tempfile
import warnings
from contextlib import contextmanager
from distutils.version import LooseVersion
import decimal
from typing import Any, Union, TYPE_CHECKING
import pyspark.pandas as ps
from pyspark.pandas.frame import DataFrame
from pyspark.pandas.indexes import Index
from pyspark.pandas.series import Series
from pyspark.pandas.utils import SPARK_CONF_ARROW_ENABLED
from pyspark.testing.sqlutils import ReusedSQLTestCase
from pyspark.errors import PySparkAssertionError
tabulate_requirement_message = None
try:
from tabulate import tabulate
except ImportError as e:
# If tabulate requirement is not satisfied, skip related tests.
tabulate_requirement_message = str(e)
have_tabulate = tabulate_requirement_message is None
matplotlib_requirement_message = None
try:
import matplotlib
except ImportError as e:
# If matplotlib requirement is not satisfied, skip related tests.
matplotlib_requirement_message = str(e)
have_matplotlib = matplotlib_requirement_message is None
plotly_requirement_message = None
try:
import plotly
except ImportError as e:
# If plotly requirement is not satisfied, skip related tests.
plotly_requirement_message = str(e)
have_plotly = plotly_requirement_message is None
try:
from pyspark.sql.pandas.utils import require_minimum_pandas_version
require_minimum_pandas_version()
import pandas as pd
except ImportError:
pass
__all__ = ["assertPandasOnSparkEqual"]
def _assert_pandas_equal(
left: Union[pd.DataFrame, pd.Series, pd.Index],
right: Union[pd.DataFrame, pd.Series, pd.Index],
checkExact: bool,
):
from pandas.core.dtypes.common import is_numeric_dtype
from pandas.testing import assert_frame_equal, assert_index_equal, assert_series_equal
if isinstance(left, pd.DataFrame) and isinstance(right, pd.DataFrame):
try:
if LooseVersion(pd.__version__) >= LooseVersion("1.1"):
kwargs = dict(check_freq=False)
else:
kwargs = dict()
if LooseVersion(pd.__version__) < LooseVersion("1.1.1"):
# Due to https://github.com/pandas-dev/pandas/issues/35446
checkExact = (
checkExact
and all([is_numeric_dtype(dtype) for dtype in left.dtypes])
and all([is_numeric_dtype(dtype) for dtype in right.dtypes])
)
assert_frame_equal(
left,
right,
check_index_type=("equiv" if len(left.index) > 0 else False),
check_column_type=("equiv" if len(left.columns) > 0 else False),
check_exact=checkExact,
**kwargs,
)
except AssertionError:
raise PySparkAssertionError(
error_class="DIFFERENT_PANDAS_DATAFRAME",
message_parameters={
"left": left.to_string(),
"left_dtype": str(left.dtypes),
"right": right.to_string(),
"right_dtype": str(right.dtypes),
},
)
elif isinstance(left, pd.Series) and isinstance(right, pd.Series):
try:
if LooseVersion(pd.__version__) >= LooseVersion("1.1"):
kwargs = dict(check_freq=False)
else:
kwargs = dict()
if LooseVersion(pd.__version__) < LooseVersion("1.1.1"):
# Due to https://github.com/pandas-dev/pandas/issues/35446
checkExact = (
checkExact and is_numeric_dtype(left.dtype) and is_numeric_dtype(right.dtype)
)
assert_series_equal(
left,
right,
check_index_type=("equiv" if len(left.index) > 0 else False),
check_exact=checkExact,
**kwargs,
)
except AssertionError:
raise PySparkAssertionError(
error_class="DIFFERENT_PANDAS_SERIES",
message_parameters={
"left": left.to_string(),
"left_dtype": str(left.dtype),
"right": right.to_string(),
"right_dtype": str(right.dtype),
},
)
elif isinstance(left, pd.Index) and isinstance(right, pd.Index):
try:
if LooseVersion(pd.__version__) < LooseVersion("1.1.1"):
# Due to https://github.com/pandas-dev/pandas/issues/35446
checkExact = (
checkExact and is_numeric_dtype(left.dtype) and is_numeric_dtype(right.dtype)
)
assert_index_equal(left, right, check_exact=checkExact)
except AssertionError:
raise PySparkAssertionError(
error_class="DIFFERENT_PANDAS_INDEX",
message_parameters={
"left": left,
"left_dtype": str(left.dtype),
"right": right,
"right_dtype": str(right.dtype),
},
)
else:
raise ValueError("Unexpected values: (%s, %s)" % (left, right))
def _assert_pandas_almost_equal(
left: Union[pd.DataFrame, pd.Series, pd.Index],
right: Union[pd.DataFrame, pd.Series, pd.Index],
rtol: float = 1e-5,
atol: float = 1e-8,
):
"""
This function checks if given pandas objects approximately same,
which means the conditions below:
- Both objects are nullable
- Compare decimals and floats, where two values a and b are approximately equal
if they satisfy the following formula:
absolute(a - b) <= (atol + rtol * absolute(b))
where rtol=1e-5 and atol=1e-8 by default
"""
def compare_vals_approx(val1, val2):
# compare vals for approximate equality
if isinstance(lval, (float, decimal.Decimal)) or isinstance(rval, (float, decimal.Decimal)):
if abs(float(lval) - float(rval)) > (atol + rtol * abs(float(rval))):
return False
elif val1 != val2:
return False
return True
if isinstance(left, pd.DataFrame) and isinstance(right, pd.DataFrame):
if left.shape != right.shape:
raise PySparkAssertionError(
error_class="DIFFERENT_PANDAS_DATAFRAME",
message_parameters={
"left": left.to_string(),
"left_dtype": str(left.dtypes),
"right": right.to_string(),
"right_dtype": str(right.dtypes),
},
)
for lcol, rcol in zip(left.columns, right.columns):
if lcol != rcol:
raise PySparkAssertionError(
error_class="DIFFERENT_PANDAS_DATAFRAME",
message_parameters={
"left": left.to_string(),
"left_dtype": str(left.dtypes),
"right": right.to_string(),
"right_dtype": str(right.dtypes),
},
)
for lnull, rnull in zip(left[lcol].isnull(), right[rcol].isnull()):
if lnull != rnull:
raise PySparkAssertionError(
error_class="DIFFERENT_PANDAS_DATAFRAME",
message_parameters={
"left": left.to_string(),
"left_dtype": str(left.dtypes),
"right": right.to_string(),
"right_dtype": str(right.dtypes),
},
)
for lval, rval in zip(left[lcol].dropna(), right[rcol].dropna()):
if not compare_vals_approx(lval, rval):
raise PySparkAssertionError(
error_class="DIFFERENT_PANDAS_DATAFRAME",
message_parameters={
"left": left.to_string(),
"left_dtype": str(left.dtypes),
"right": right.to_string(),
"right_dtype": str(right.dtypes),
},
)
if left.columns.names != right.columns.names:
raise PySparkAssertionError(
error_class="DIFFERENT_PANDAS_DATAFRAME",
message_parameters={
"left": left.to_string(),
"left_dtype": str(left.dtypes),
"right": right.to_string(),
"right_dtype": str(right.dtypes),
},
)
elif isinstance(left, pd.Series) and isinstance(right, pd.Series):
if left.name != right.name or len(left) != len(right):
raise PySparkAssertionError(
error_class="DIFFERENT_PANDAS_SERIES",
message_parameters={
"left": left.to_string(),
"left_dtype": str(left.dtype),
"right": right.to_string(),
"right_dtype": str(right.dtype),
},
)
for lnull, rnull in zip(left.isnull(), right.isnull()):
if lnull != rnull:
raise PySparkAssertionError(
error_class="DIFFERENT_PANDAS_SERIES",
message_parameters={
"left": left.to_string(),
"left_dtype": str(left.dtype),
"right": right.to_string(),
"right_dtype": str(right.dtype),
},
)
for lval, rval in zip(left.dropna(), right.dropna()):
if not compare_vals_approx(lval, rval):
raise PySparkAssertionError(
error_class="DIFFERENT_PANDAS_SERIES",
message_parameters={
"left": left.to_string(),
"left_dtype": str(left.dtype),
"right": right.to_string(),
"right_dtype": str(right.dtype),
},
)
elif isinstance(left, pd.MultiIndex) and isinstance(right, pd.MultiIndex):
if len(left) != len(right):
raise PySparkAssertionError(
error_class="DIFFERENT_PANDAS_MULTIINDEX",
message_parameters={
"left": left,
"left_dtype": str(left.dtype),
"right": right,
"right_dtype": str(right.dtype),
},
)
for lval, rval in zip(left, right):
if not compare_vals_approx(lval, rval):
raise PySparkAssertionError(
error_class="DIFFERENT_PANDAS_MULTIINDEX",
message_parameters={
"left": left,
"left_dtype": str(left.dtype),
"right": right,
"right_dtype": str(right.dtype),
},
)
elif isinstance(left, pd.Index) and isinstance(right, pd.Index):
if len(left) != len(right):
raise PySparkAssertionError(
error_class="DIFFERENT_PANDAS_INDEX",
message_parameters={
"left": left,
"left_dtype": str(left.dtype),
"right": right,
"right_dtype": str(right.dtype),
},
)
for lnull, rnull in zip(left.isnull(), right.isnull()):
if lnull != rnull:
raise PySparkAssertionError(
error_class="DIFFERENT_PANDAS_INDEX",
message_parameters={
"left": left,
"left_dtype": str(left.dtype),
"right": right,
"right_dtype": str(right.dtype),
},
)
for lval, rval in zip(left.dropna(), right.dropna()):
if not compare_vals_approx(lval, rval):
raise PySparkAssertionError(
error_class="DIFFERENT_PANDAS_INDEX",
message_parameters={
"left": left,
"left_dtype": str(left.dtype),
"right": right,
"right_dtype": str(right.dtype),
},
)
else:
if not isinstance(left, (pd.DataFrame, pd.Series, pd.Index)):
raise PySparkAssertionError(
error_class="INVALID_TYPE_DF_EQUALITY_ARG",
message_parameters={
"expected_type": f"{pd.DataFrame.__name__}, "
f"{pd.Series.__name__}, "
f"{pd.Index.__name__}, ",
"arg_name": "left",
"actual_type": type(left),
},
)
elif not isinstance(right, (pd.DataFrame, pd.Series, pd.Index)):
raise PySparkAssertionError(
error_class="INVALID_TYPE_DF_EQUALITY_ARG",
message_parameters={
"expected_type": f"{pd.DataFrame.__name__}, "
f"{pd.Series.__name__}, "
f"{pd.Index.__name__}, ",
"arg_name": "right",
"actual_type": type(right),
},
)
[docs]def assertPandasOnSparkEqual(
actual: Union[DataFrame, Series, Index],
expected: Union[DataFrame, pd.DataFrame, Series, pd.Series, Index, pd.Index],
checkExact: bool = True,
almost: bool = False,
rtol: float = 1e-5,
atol: float = 1e-8,
checkRowOrder: bool = True,
):
r"""
A util function to assert equality between actual (pandas-on-Spark object) and expected
(pandas-on-Spark or pandas object).
.. versionadded:: 3.5.0
Parameters
----------
actual: pandas-on-Spark DataFrame, Series, or Index
The object that is being compared or tested.
expected: pandas-on-Spark or pandas DataFrame, Series, or Index
The expected object, for comparison with the actual result.
checkExact: bool, optional
A flag indicating whether to compare exact equality.
If set to 'True' (default), the data is compared exactly.
If set to 'False', the data is compared less precisely, following pandas assert_frame_equal
approximate comparison (see documentation for more details).
almost: bool, optional
A flag indicating whether to use unittest `assertAlmostEqual` or `assertEqual`.
If set to 'True', the comparison is delegated to `unittest`'s `assertAlmostEqual`
(see documentation for more details).
If set to 'False' (default), the data is compared exactly with `unittest`'s
`assertEqual`.
rtol : float, optional
The relative tolerance, used in asserting almost equality for float values in actual
and expected. Set to 1e-5 by default. (See Notes)
atol : float, optional
The absolute tolerance, used in asserting almost equality for float values in actual
and expected. Set to 1e-8 by default. (See Notes)
checkRowOrder : bool, optional
A flag indicating whether the order of rows should be considered in the comparison.
If set to `False`, the row order is not taken into account.
If set to `True` (default), the order of rows will be checked during comparison.
(See Notes)
Notes
-----
For `checkRowOrder`, note that pandas-on-Spark DataFrame ordering is non-deterministic, unless
explicitly sorted.
When `almost` is set to True, approximate equality will be asserted, where two values
a and b are approximately equal if they satisfy the following formula:
``absolute(a - b) <= (atol + rtol * absolute(b))``.
Examples
--------
>>> import pyspark.pandas as ps
>>> psdf1 = ps.DataFrame({'a': [1, 2, 3], 'b': [4, 5, 6], 'c': [7, 8, 9]})
>>> psdf2 = ps.DataFrame({'a': [1, 2, 3], 'b': [4, 5, 6], 'c': [7, 8, 9]})
>>> assertPandasOnSparkEqual(psdf1, psdf2) # pass, ps.DataFrames are equal
>>> s1 = ps.Series([212.32, 100.0001])
>>> s2 = ps.Series([212.32, 100.0])
>>> assertPandasOnSparkEqual(s1, s2, checkExact=False) # pass, ps.Series are approx equal
>>> s1 = ps.Index([212.300001, 100.000])
>>> s2 = ps.Index([212.3, 100.0001])
>>> assertPandasOnSparkEqual(s1, s2, almost=True) # pass, ps.Index obj are almost equal
"""
if actual is None and expected is None:
return True
elif actual is None or expected is None:
return False
if not isinstance(actual, (DataFrame, Series, Index)):
raise PySparkAssertionError(
error_class="INVALID_TYPE_DF_EQUALITY_ARG",
message_parameters={
"expected_type": f"{DataFrame.__name__}, {Series.__name__}, {Index.__name__}",
"arg_name": "actual",
"actual_type": type(actual),
},
)
elif not isinstance(expected, (DataFrame, pd.DataFrame, Series, pd.Series, Index, pd.Index)):
raise PySparkAssertionError(
error_class="INVALID_TYPE_DF_EQUALITY_ARG",
message_parameters={
"expected_type": f"{DataFrame.__name__}, "
f"{pd.DataFrame.__name__}, "
f"{Series.__name__}, "
f"{pd.Series.__name__}, "
f"{Index.__name__}"
f"{pd.Index.__name__}, ",
"arg_name": "expected",
"actual_type": type(expected),
},
)
else:
if not isinstance(actual, (pd.DataFrame, pd.Index, pd.Series)):
actual = actual.to_pandas()
if not isinstance(expected, (pd.DataFrame, pd.Index, pd.Series)):
expected = expected.to_pandas()
if not checkRowOrder:
if isinstance(actual, pd.DataFrame) and len(actual.columns) > 0:
actual = actual.sort_values(by=actual.columns[0], ignore_index=True)
if isinstance(expected, pd.DataFrame) and len(expected.columns) > 0:
expected = expected.sort_values(by=expected.columns[0], ignore_index=True)
if almost:
_assert_pandas_almost_equal(actual, expected, rtol=rtol, atol=atol)
else:
_assert_pandas_equal(actual, expected, checkExact=checkExact)
class PandasOnSparkTestUtils:
def convert_str_to_lambda(self, func: str):
"""
This function converts `func` str to lambda call
"""
return lambda x: getattr(x, func)()
def assertPandasEqual(self, left: Any, right: Any, check_exact: bool = True):
_assert_pandas_equal(left, right, check_exact)
def assertPandasAlmostEqual(
self,
left: Any,
right: Any,
rtol: float = 1e-5,
atol: float = 1e-8,
):
_assert_pandas_almost_equal(left, right, rtol=rtol, atol=atol)
def assert_eq(
self,
left: Any,
right: Any,
check_exact: bool = True,
almost: bool = False,
rtol: float = 1e-5,
atol: float = 1e-8,
check_row_order: bool = True,
):
"""
Asserts if two arbitrary objects are equal or not. If given objects are Koalas DataFrame
or Series, they are converted into pandas' and compared.
:param left: object to compare
:param right: object to compare
:param check_exact: if this is False, the comparison is done less precisely.
:param almost: if this is enabled, the comparison asserts approximate equality
for float and decimal values, where two values a and b are approximately equal
if they satisfy the following formula:
absolute(a - b) <= (atol + rtol * absolute(b))
:param rtol: The relative tolerance, used in asserting approximate equality for
float values. Set to 1e-5 by default.
:param atol: The absolute tolerance, used in asserting approximate equality for
float values in actual and expected. Set to 1e-8 by default.
:param check_row_order: A flag indicating whether the order of rows should be considered
in the comparison. If set to False, row order will be ignored.
"""
import pandas as pd
from pandas.api.types import is_list_like
# for pandas-on-Spark DataFrames, allow choice to ignore row order
if isinstance(left, (ps.DataFrame, ps.Series, ps.Index)):
return assertPandasOnSparkEqual(
left,
right,
checkExact=check_exact,
almost=almost,
rtol=rtol,
atol=atol,
checkRowOrder=check_row_order,
)
lobj = self._to_pandas(left)
robj = self._to_pandas(right)
if isinstance(lobj, (pd.DataFrame, pd.Series, pd.Index)):
if almost:
_assert_pandas_almost_equal(lobj, robj, rtol=rtol, atol=atol)
else:
_assert_pandas_equal(lobj, robj, checkExact=check_exact)
elif is_list_like(lobj) and is_list_like(robj):
self.assertTrue(len(left) == len(right))
for litem, ritem in zip(left, right):
self.assert_eq(litem, ritem, check_exact=check_exact, almost=almost)
elif (lobj is not None and pd.isna(lobj)) and (robj is not None and pd.isna(robj)):
pass
else:
if almost:
self.assertAlmostEqual(lobj, robj)
else:
self.assertEqual(lobj, robj)
@staticmethod
def _to_pandas(obj: Any):
if isinstance(obj, (DataFrame, Series, Index)):
return obj.to_pandas()
else:
return obj
class PandasOnSparkTestCase(ReusedSQLTestCase, PandasOnSparkTestUtils):
@classmethod
def setUpClass(cls):
super(PandasOnSparkTestCase, cls).setUpClass()
cls.spark.conf.set(SPARK_CONF_ARROW_ENABLED, True)
class TestUtils:
@contextmanager
def temp_dir(self):
tmp = tempfile.mkdtemp()
try:
yield tmp
finally:
shutil.rmtree(tmp)
@contextmanager
def temp_file(self):
with self.temp_dir() as tmp:
yield tempfile.mkstemp(dir=tmp)[1]
class ComparisonTestBase(PandasOnSparkTestCase):
@property
def psdf(self):
return ps.from_pandas(self.pdf)
@property
def pdf(self):
return self.psdf.to_pandas()
def compare_both(f=None, almost=True):
if f is None:
return functools.partial(compare_both, almost=almost)
elif isinstance(f, bool):
return functools.partial(compare_both, almost=f)
@functools.wraps(f)
def wrapped(self):
if almost:
compare = self.assertPandasAlmostEqual
else:
compare = self.assertPandasEqual
for result_pandas, result_spark in zip(f(self, self.pdf), f(self, self.psdf)):
compare(result_pandas, result_spark.to_pandas())
return wrapped
@contextmanager
def assert_produces_warning(
expected_warning=Warning,
filter_level="always",
check_stacklevel=True,
raise_on_extra_warnings=True,
):
"""
Context manager for running code expected to either raise a specific
warning, or not raise any warnings. Verifies that the code raises the
expected warning, and that it does not raise any other unexpected
warnings. It is basically a wrapper around ``warnings.catch_warnings``.
Notes
-----
Replicated from pandas/_testing/_warnings.py.
Parameters
----------
expected_warning : {Warning, False, None}, default Warning
The type of Exception raised. ``exception.Warning`` is the base
class for all warnings. To check that no warning is returned,
specify ``False`` or ``None``.
filter_level : str or None, default "always"
Specifies whether warnings are ignored, displayed, or turned
into errors.
Valid values are:
* "error" - turns matching warnings into exceptions
* "ignore" - discard the warning
* "always" - always emit a warning
* "default" - print the warning the first time it is generated
from each location
* "module" - print the warning the first time it is generated
from each module
* "once" - print the warning the first time it is generated
check_stacklevel : bool, default True
If True, displays the line that called the function containing
the warning to show were the function is called. Otherwise, the
line that implements the function is displayed.
raise_on_extra_warnings : bool, default True
Whether extra warnings not of the type `expected_warning` should
cause the test to fail.
Examples
--------
>>> import warnings
>>> with assert_produces_warning():
... warnings.warn(UserWarning())
...
>>> with assert_produces_warning(False): # doctest: +SKIP
... warnings.warn(RuntimeWarning())
...
Traceback (most recent call last):
...
AssertionError: Caused unexpected warning(s): ['RuntimeWarning'].
>>> with assert_produces_warning(UserWarning): # doctest: +SKIP
... warnings.warn(RuntimeWarning())
Traceback (most recent call last):
...
AssertionError: Did not see expected warning of class 'UserWarning'
..warn:: This is *not* thread-safe.
"""
__tracebackhide__ = True
with warnings.catch_warnings(record=True) as w:
saw_warning = False
warnings.simplefilter(filter_level)
yield w
extra_warnings = []
for actual_warning in w:
if expected_warning and issubclass(actual_warning.category, expected_warning):
saw_warning = True
if check_stacklevel and issubclass(
actual_warning.category, (FutureWarning, DeprecationWarning)
):
from inspect import getframeinfo, stack
caller = getframeinfo(stack()[2][0])
msg = (
"Warning not set with correct stacklevel. ",
"File where warning is raised: {} != ".format(actual_warning.filename),
"{}. Warning message: {}".format(caller.filename, actual_warning.message),
)
assert actual_warning.filename == caller.filename, msg
else:
extra_warnings.append(
(
actual_warning.category.__name__,
actual_warning.message,
actual_warning.filename,
actual_warning.lineno,
)
)
if expected_warning:
msg = "Did not see expected warning of class {}".format(repr(expected_warning.__name__))
assert saw_warning, msg
if raise_on_extra_warnings and extra_warnings:
raise AssertionError("Caused unexpected warning(s): {}".format(repr(extra_warnings)))