一、excel读写
(1)excel表格读取
install.packages("readxl")
library(readxl)
read_xlsx("E:\\毕业\\数据\\迁移流模板.xlsx")
(2)数据输出到excel
install.packages("writexl")
write_xlsx(resultmipex, "E:\\毕业\\数据\\国家属性加mipex.xlsx")
二、数据连接
library(dplyr)
result=left_join(a, b, by = c("oios3"="iso_o","dios3"="iso_d"))
#a为左表数据,b为右表数据,by=c()括号里为键值(匹配的列所对应的名称)
三、根据列名选择数据
library(dplyr)
data <- select(result,c("oname","