PySpark
keyboard_arrow_down 147 guides
chevron_leftPySpark DataFrame
Method aliasMethod coalesceMethod collectMethod colRegexMethod corrMethod countMethod covMethod describeMethod distinctMethod dropMethod dropDuplicatesMethod dropnaMethod exceptAllMethod fillnaMethod filterMethod foreachMethod groupByMethod headMethod intersectMethod intersectAllMethod joinMethod limitMethod orderByMethod printSchemaMethod randomSplitMethod repartitionMethod replaceMethod sampleMethod sampleByMethod selectMethod selectExprMethod showMethod sortMethod summaryMethod tailMethod takeMethod toDFMethod toJSONMethod toPandasMethod transformMethod unionMethod unionByNameMethod whereMethod withColumnMethod withColumnRenamedProperty columnsProperty dtypesProperty rdd
check_circle
Mark as learned thumb_up
0
thumb_down
3
chat_bubble_outline
0
Comment auto_stories Bi-column layout
settings
PySpark DataFrame | intersect method
schedule Aug 12, 2023
Last updated local_offer
Tags PySpark
tocTable of Contents
expand_more Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!
Start your free 7-days trial now!
PySpark DataFrame's intersect(~) method returns a new PySpark DataFrame with rows that exist in another PySpark DataFrame. Note that unlike intersectAll(~), intersect(~) only includes duplicate rows once.
NOTE
The intersect(~) method is equivalent to the INTERSECT statement in SQL.
Parameters
1. other | PySpark DataFrame
The other PySpark DataFrame with which to perform intersection.
Return Value
A new PySpark DataFrame.
Examples
Consider the following PySpark DataFrame:
+-----+---+| name|age|+-----+---+| Alex| 20|| Bob| 30||Cathy| 40|+-----+---+
Consider the other PySpark DataFrame:
+----+---+|name|age|+----+---+|Alex| 20||Doge| 30||eric| 40|+----+---+
Getting rows of PySpark DataFrame that exist in another PySpark DataFrame
To get rows of a PySpark DataFrame that exist in another PySpark DataFrame, use the intersect(~) method like so:
df_intersect = df.intersect(df_other)
+----+---+|name|age|+----+---+|Alex| 20|+----+---+
Here, we get this row because both PySpark DataFrames contained this row.
Published by Isshin Inada
Edited by 0 others
Did you find this page useful?
thumb_up
thumb_down
Comment
Citation
Ask a question or leave a feedback...
Official PySpark Documentation
https://spark.apache.org/docs/3.2.0/api/python/reference/api/pyspark.sql.DataFrame.intersect.html
thumb_up
0
thumb_down
3
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!
