snowflake.snowpark.DataFrame.except_¶

DataFrame.except_(other: DataFrame) → DataFrame[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.25.0/snowpark-python/src/snowflake/snowpark/dataframe.py#L2098-L2130)¶

Returns a new DataFrame that contains all the rows from the current DataFrame except for the rows that also appear in the other DataFrame. Duplicate rows are eliminated.

Example:

CopyExpand

>>> df1 = session.create_dataframe([[1, 2], [3, 4]], schema=["a", "b"])
>>> df2 = session.create_dataframe([[1, 2], [5, 6]], schema=["c", "d"])
>>> df1.subtract(df2).show()
-------------
|"A"  |"B"  |
-------------
|3    |4    |
-------------

Show lessSee more

Scroll to top

minus() and subtract() are aliases of except_().

Parameters:

other – The DataFrame that contains the rows to exclude.