I want redesing my table – change the rows, order numbers, columns and etc. I have created a sample in excel that what I want to get as well as I showed a screenshot of data that what I have right now.Can you please help me?
R data
Excel data (what I want to get)
I have tried different methods – dcast, transpose and etc. but they didn’t work.
>Solution :
You can likely use some command on import (ie, header = TRUE) but if this is how your data look:
set.seed(123)
df <- data.frame(V1 = c("MFST", runif(5)),
V2 = c("ATVI", runif(5)),
V3 = c("AMOT", runif(5)))
rownames(df) <- c("Years", 2015:2019)
It means (1) your first row is your column names and (2) your row names are your year values. So you can do this in base R:
colnames(df) <- df[1,] # rename columns
df$years <- rownames(df) # create year variable from rownames
df <- df[-1,] # remove unneeded first column
Output:
# MFST ATVI AMOT years
# 2015 0.29 0.05 0.96 2015
# 2016 0.79 0.53 0.45 2016
# 2017 0.41 0.89 0.68 2017
# 2018 0.88 0.55 0.57 2018
# 2019 0.94 0.46 0.10 2019
Again though, I would check the import step. If you provide more info on that I can edit to provide more advice. Good luck!