melted | MLT Video Server | Video Utils library

I have a data frame of the form:

I am processing this dataset (bottom of the page) in R for a project. First I load in the data:

I have this text:

I think the code below is OK but seems to clumsy. Basically, I want to go from here:

to here:

Basically adding column Result if the dummy column is 1. Hope this makes sense?

I have 2 dataframes which I combine and then melt with pandas. I need to multi-plot them (as below) and the code needs to be scalable. They consist of 2 variables which form the 'key' column below ('x' and 'y' here), across multiple 'stations' (just 2 here, but needs to be scalable). I've used relplot() to be able to multi-plot the two variables on each graph, and different stations on separate graphs.

Is there any way to maintain this format but introduce a 2nd y axis to each plot? 'x' and 'y' need to be on different scales in my actual data. I've seen examples where the relplot call is stored with y = 1st variable, and a 2nd lineplot call is added for the 2nd variable with ax.twinx() included in it. So in example below, 'x' and 'y' would each have a y axis on the same graph.

How would I make that work with a melted dataframe (e.g. below) where 'key' = 2 variables and 'station' can be length n? Or is the answer to scrap that df format and start again?

The multi-plot as it stands:

I'm wanting to use stat_difference() from the ggh4x package to add a shaded area between two lines in my plot. I have melted my example dataset below as I thought this was the correct approach to facet_wrap all the variables in my dataset, but I'm unsure how to use stat_difference() with the categorical variable team. I essentially want the line corresponding to Team A or Team B shaded depending on which one has a higher value, similar to the example here. Any suggestions will be great! Thanks.

I tried to fix it but it didn't work for me. I think I am missing something, it works in older version of Flutter but not in recent one.

I am trying to set (onTap) function on an image to go to the next widget screen.

Here is my code:

I'm trying to pivot to a longer format using dplyr::pivot_longer, but can't seem to get it to do what I want. I can manage with reshape::melt, but I'd also like to be able to achieve the same using pivot_longer.

The data I'm trying to reformat is a correlation matrix of the mtcars-dataset:

I have made a plot of my data but want the bars stacked as a percentage (the data already sums to 100%).