1、分析报告
根据需求取数,清洗,确定分析逻辑;
2、编制
编制分析报告,报表格式,excel格式,rmarkdown格式
报表格式 可用tableHTML 对格式进行调整;
excel格式,excel中固定公式及图表,定时插入数据即可;
rmarkdown在处理数据的同时编写分析报告;
3、R语言自动发送报表
library(mailR)
library(mailR)
send.mail(
from = “aa@qq.com”, #发送者
to = “ss@qq.com”, #接收者(可多位c(‘1’,‘2’))
subject = “test for mail”,
encoding = ‘utf-8’,#包含iso-8859-1, utf-8, us-ascii, and koi8-r
body = “this is a new shit!”,
html = TRUE,
smtp = list(
host.name = “smtp.qq.com”, #qq,企业邮箱"smtp.exmail.qq.com"
port = 465,
user.name = “aa@qq.com”,
passwd = “qq邮箱密码”, #自己的密码
ssl = TRUE,
tls =TRUE
),
authenticate = TRUE,
attach.files=xxx, #附件
send = TRUE
)
body可用table格式print(xtable(iris),type=“html”,include.rownames=T,include.colnames = TRUE,booktabs = T)
or tableHTML(可设置多种table格式)
4、R语言自动发送分析报告
libraary(rmarkdown)
markdown::render(“example.Rmd”)
send.mail(from = “aa@qq.com”,
to = c(“aa@qq.com”),
subject = “test”,
body = “example.html”,
html = TRUE,
inline = T,
smtp = list(host.name = “smtp.exmail.qq.com”, port = 25,
user.name = “aa@qq.com”, passwd = “xxx”, ssl = TRUE),
authenticate = TRUE,
send = TRUE
)
5、在服务器上设置crontab定时任务实现分析报告的自动更新