Pivoting a dataframe

Asked May 28 '21 at 13:05

Active May 28 '21 at 13:05

Viewed 18 times

Any suggetions to transform a dataframe from this format to a longer format would be wonderful. Original data has 50 names and hundreds of YearMonths. So it should be a pivot from wide to long (?).

df<-data.frame(name=c("Amber","Thomas","Stefan","Joe"),
                      YM_202006=c(8,2,NA,7),
               YM_202007=c(NA,4,1,7),
               YM_202008=c(1,2,3,4))

Before transformation:

After transformation / Desired Output (df_new):

Desired output is faked with this code:

df_new<- data.frame(YM=c("YM_202006","YM_202007","YM_202008"),
                    Amber=c(8,NA,1),
                    Thomas=c(2,4,2),
                    Stefan=c(NA,1,3),
                    Joe=c(7,7,4))

I tried a lot of approaches without getting the desired output.

Hope somebody can help, thx in advance!

asked May 28 '21 at 13:05

crm_analytics

With `tidyr` library `df %>% pivot_longer(cols = -name, names_to = 'YM') %>% pivot_wider(names_from = name, values_from = value)` – Ronak Shah May 28 '21 at 13:07
Perfect, thank you Ronak! – crm_analytics May 28 '21 at 14:07

Pivoting a dataframe

0 Answers0