readRDS("/home/pawan/edibleoils/palmoil_import.rds")->palm
readRDS("/home/pawan/edibleoils/soyabean_import.rds")->soyabean
readRDS("/home/pawan/edibleoils/sunflower_import.rds")->sunflower
paste0("Palm Oil")->palm$Edibleoil
paste0("Soyabean Oil")->soyabean$Edibleoil
paste0("Sunflower Oil")->sunflower$Edibleoil
paste0(as.numeric(substr(palm$Year,1,4)),"-",
as.numeric(substr(palm$Year,3,4))+1)->palm$Year
paste0(as.numeric(substr(palm$LagYear,1,4)),"-",
as.numeric(substr(palm$LagYear,8,9)))->palm$LagYear
paste0(as.numeric(substr(soyabean$Year,1,4)),"-",
as.numeric(substr(soyabean$Year,3,4))+1)->soyabean$Year
paste0(as.numeric(substr(soyabean$LagYear,1,4)),"-",
as.numeric(substr(soyabean$LagYear,8,9)))->soyabean$LagYear
paste0(as.numeric(substr(sunflower$Year,1,4)),"-",
as.numeric(substr(sunflower$Year,3,4))+1)->sunflower$Year
paste0(as.numeric(substr(sunflower$LagYear,1,4)),"-",
as.numeric(substr(sunflower$LagYear,8,9)))->sunflower$LagYear
rbind(palm,soyabean,sunflower)->edibleoil
edibleoil[Country=="Total",.(Share=(round(ImportYear*100/sum(ImportYear))),
Edibleoil,ImportYear),.(Year)]->oil