将数据从R导出到Excel [英] Export data from R into Excel
本文介绍了将数据从R导出到Excel的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我试图将一些从R获得的结果导出到Excel中。我尝试了以下代码:
I'm trying to export some results obtained from R into Excel unsuccesfully. I have tried the following codes:
write.table(ALBERTA1, "D:/ALBERTA1.txt", sep="\t")
write.csv(ALBERTA1,":\ALBERTA1.csv")
your_filename_in_R = read.csv("ALBERTA1.csv")
your_filename_in_R = read.csv("ALBERTA1.csv")
write.csv(df, file = "ALBERTA1.csv")
your_filename_in_R = read.csv("ALBERTA1.csv")
write.csv(ALBERTA1, "ALBERTA1.csv")
write.table(ALBERTA1, 'clipboard', sep='\t')
write.table(ALBERTA1,"ALBERTA1.txt")
write.table(as.matrix(ALBERTA2),"ALBERTA2.txt")
write.table(as.matrix(vecm.pred$fcst$Alberta_Females[,1]),"vecm.pred$fcst$Alberta_Females[,1].txt")
write.table(as.matrix(foo),"foo.txt")
write.xlsx(ALBERTA2, "/ALBERTA2.xlsx")
write.table(ALBERTA1, "D:/ALBERTA1.txt", sep="\t").
但是,我的excel文件中的数据仍然被打乱,因此我无法运行任何计算。两个数据都在同一列中。请你建议我一些其他功能?
But my data from excel file is still messed up togheter and consequently i can't operate any computations. the two data are inside the same colums. the Please can you suggest me some other functions?
推荐答案
我在Excel中管理CSV数据所做的工作:
What I did to manage the CSV data in Excel:
- 在顶部菜单中找到数据
- 在菜单的中间区域选择文本到列...。
- 按照指令,然后您获取数据列
这篇关于将数据从R导出到Excel的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文