df-join-inner.py

dfListingReviewStat = dfListingReview\
    .groupBy(col("listing_id"))\
    .agg(count("*").alias("count_review"))
    
    
dfListingReview = dfListingMeta\
    .select(
        col("id").alias("listing_id"), 
        col("name").alias("listing_name"))\
    .alias("LISTING_META")\
    .join(
        other = dfListingReviewStat.alias("LISTING_REVIEW"), 
        on = col("LISTING_META.listing_id") == col("LISTING_REVIEW.listing_id"), 
        how = "inner"
    )\
    .select(
        col("LISTING_META.listing_id"), 
        col("LISTING_META.listing_name"), 
        coalesce(col("LISTING_REVIEW.count_review"), lit(0)).alias("count_review")
    )