Rearranging Data Frame for a Heat Map Plot in R: A Step-by-Step Guide Using ggplot2

Calculating Aggregate Mean in R using dplyr Package: A Tutorial

Collapsing Consecutive Periods in Time Series Data Using RLE

Extracting Variable Names from Modified Columns in R Data Frames with Indexing

Removing Extraneous Characters from Variable Names in R: A Two-Method Approach

Mastering Grouping and Aggregation in Pandas: Tips and Techniques for Efficient Data Manipulation

Stacking a Dataset: Relating Each Observation to All Other Observations But Itself

Passing Arguments into Subset Function in R

Merging Dataframes with Matching Values Using R's dplyr Library

Here is a complete code snippet that combines all the interleaved code you wrote in a nice executable codeblock: