graphing column means of two data frames on single line graph

tidyverse
,
1

I'm near positive you can do this with ggplot but I'm not sure exactly how.

I have data that I've exported from another program that I'm not trying to analyze in R. It's set up with 10,000 rows over 200 columns that are headed as "physical state at step 1, physical state at step 2, ... etc." Basically it represents 10,000 "individuals" tracking their physical state over 200 timesteps. Sometimes they die in which case their physical state changes to NaN. I have two data frames representing this setup that happened over two different model conditions.

I want to plot the means of these two data frames on the same line graph, so basically comparing the mean physical state over the entire length of time under these two different conditions. What's the easiest way I can do this?

1 Like
2

Just calculate the means for both data.frames, and plot in basic R.

3

You can use ggplot2 by reshaping your data from wide to long format (with pivot_longer()) and then plotting the mean physical state over time using stat_summary(fun = mean, geom = "line"). Make sure to add a condition label to differentiate the two datasets before combining them. This will give you a clear line graph comparing both conditions over time. :rocket: