Reading Data Example

library(magrittr)
library(tidyverse)
data1 <- read_csv(file="http://m408.inqs.info/files/data/data_3_4.csv")

Wide to Long Example

df3 <- data1 %>% 
  pivot_longer(`v1/mean`:`v4/median`, 
               names_to = "measurement", 
               values_to = "value") %>% 
  separate(measurement,c("time","stat"),sep="/") %>% 
  pivot_wider(names_from = stat,values_from = value)
head(df3)
LS0tDQp0aXRsZTogIkNsYXNzIDEwIg0KYXV0aG9yOiAiSXNhYWMgUXVpbnRhbmlsbGEgU2FsaW5hcyINCmRhdGU6ICJgciBmb3JtYXQoU3lzLnRpbWUoKSwnJW0tJWQtJVknKWAiDQpvdXRwdXQ6IA0KICBodG1sX25vdGVib29rOg0KICAgIHRvYzogdHJ1ZQ0KICAgIHRvY19mbG9hdDogdHJ1ZQ0KICAgIGNvZGVfZm9sZGluZzogaGlkZQ0KLS0tDQoNCiMjIFJlYWRpbmcgRGF0YSBFeGFtcGxlDQoNCmBgYHtyLCBtZXNzYWdlPUZBTFNFfQ0KbGlicmFyeShtYWdyaXR0cikNCmxpYnJhcnkodGlkeXZlcnNlKQ0KZGF0YTEgPC0gcmVhZF9jc3YoZmlsZT0iaHR0cDovL200MDguaW5xcy5pbmZvL2ZpbGVzL2RhdGEvZGF0YV8zXzQuY3N2IikNCmBgYA0KDQojIyBXaWRlIHRvIExvbmcgRXhhbXBsZQ0KDQpgYGB7cn0NCmRmMyA8LSBkYXRhMSAlPiUgDQogIHBpdm90X2xvbmdlcihgdjEvbWVhbmA6YHY0L21lZGlhbmAsIA0KICAgICAgICAgICAgICAgbmFtZXNfdG8gPSAibWVhc3VyZW1lbnQiLCANCiAgICAgICAgICAgICAgIHZhbHVlc190byA9ICJ2YWx1ZSIpICU+JSANCiAgc2VwYXJhdGUobWVhc3VyZW1lbnQsYygidGltZSIsInN0YXQiKSxzZXA9Ii8iKSAlPiUgDQogIHBpdm90X3dpZGVyKG5hbWVzX2Zyb20gPSBzdGF0LHZhbHVlc19mcm9tID0gdmFsdWUpDQpoZWFkKGRmMykNCmBgYA0K