Data Science, Python Programming, Snowflake, Data Engineering, Apache Spark.
the date column. Group by repo_id and year, and aggregate by sum of count. Sort by sum(count) in descending order. Total_stars_per_repo_year = stars_df.group_by("repo_id", year("date"))\ .agg(sum("count"))\ .with_column_renamed('"sum(count)"', "sum_of_stars")\ .with_column_renamed('"year(date)"',