R:将多个csv文件的汇总合并成一个数据帧 [英] R: combine summary of multiple csv files into one data frame
本文介绍了R:将多个csv文件的汇总合并成一个数据帧的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
getSummary< -function(df){
摘要(df $ Names)
}
文件名< -list.files(path,pattern =*。csv,full.names = T)
ldf< -lapply(filenames,read.csv,header = T)
结果< -lapply(ldf,getSummary)
返回结果如下:
print(results)
[[1] ] abcd
100 2 3 4
[[2]] abcd
97 4 2 6
我想要的是这样的
filename abcd
1.csv 100 2 3 4
2.csv 97 4 2 6
有人可以帮助吗?
谢谢。
解决方案
我想你可能想要 .call(rbind,results)
。但是,只有每个组件至少有一个字母(即所有列必须存在于每个字母中)时才会起作用。如果不是,您可以使用 plyr 中的 rbind.fill
。
还建议表
是比总结
更为安全的功能。
I have a directory with many csv files. I want to read them into then create a summary of a column into one data frame.
getSummary<-function(df){
summary(df$Names)
}
filenames<-list.files(path, pattern="*.csv", full.names=T)
ldf<-lapply(filenames, read.csv, header=T)
results<-lapply(ldf, getSummary)
It is returning results as follows:
print(results)
[[1]] a b c d
100 2 3 4
[[2]] a b c d
97 4 2 6
What I want is something like this
filename a b c d
1.csv 100 2 3 4
2.csv 97 4 2 6
Can someone help??
Thanks.
解决方案
I think you probably want do.call(rbind,results)
. But that will only work if each component has at least one of each letter (i.e. all the columns must be present in each). If not you could use rbind.fill
from plyr instead.
I'd also suggest that table
is a safer function to be using for this purpose than summary
.
这篇关于R:将多个csv文件的汇总合并成一个数据帧的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文