Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-08-2023 11:16 PM
Hi @Suteja Kanuri,
In this case I am using pyspark dataframe, but I am trying to get alle values from a column in that dataframe and create a list. I am using this list to filter columns in another dataframe. (see example below):
value_list = pysparkDF.select(<column_name>).distinct().rdd.flatMap(lambda x: x).collect()
filtered_table = DF2.filter(DF2.<column_name>.isin(value_list))
But I will try to search for ways to avoid lists and keep it in dataframe format.