Hi yall,
I am having trouble creating a box plot because my x variables, in this case, my TFS each have multiple values or in this case the replicates. I want to plot my TF's as my x values and I want to plot each replicate as my y-axis
You need to reshape your data so the TF label is in one column and the values are in another. It seems as if the SN250 column is not needed, so I dropped it in the example below. I invented a small data set for this example
Hi, thank you so much for your response.
I have one quick question which is what happened to our 3 replicate values in our new dfplot table since they became one value.
Wait never mind I figured it out thank you once again. If I did want to Transfer my values from my excel sheet to a new table like this how would I go about it?
Of course, you have to install the openxlsx package first. If the file is not in R's working directory, you will have to use the full file path instead of just the file name.
An alternative that I have never used can be found in the Import Dataset menu of RStudio. This can be found on the Environment tab which is usually in the top right pane of RStudio. Just below the Environment tab itself, there is a row of icons and one of those is Import Dataset. It seems to use the readxl package.
This was exactly the answer I was looking for on my own question I made. If I may also add a small question, instead of boxplot, would it be possible to do a bar graph representing the same type of data shown above and then separate by two groups? Thank you so much!
I would be happy to help you but your question is separate from the question in this thread. Could you please start another thread and include a little bit of your data? Posting the output of
dput(head(DF))
is a good method if you already have your data in a data frame (named DF in my example).