R读取excel，json

目前读execl使用两个包

install.packages("readxl")
library("readxl", lib.loc="C:/Program Files/R/R-3.3.2/library")
x <- read_excel("C:/Users/Administrator/Desktop/work/njupt_plays.xls")

install.packages("openxlsx")
library("openxlsx", lib.loc="C:/Program Files/R/R-3.3.2/library")
Claimdata <- read.xlsx("C:/Users/Administrator/Desktop/work/njupt_plays.xls", sheet = 1)

第二个包只能用xlsx，推荐第一个包。

读json使用

install.packages("rjson")
library("rjson")
result <- fromJSON(file= "C:/Users/Administrator/Desktop/day.json")
json_data_frame <- as.data.frame(result)