- where ncols is number of columns
- preallocate max value variable: m = zeros(1, ncols);
- loop over all files
- read csv data using csvread into variable data
- m = max(max(data), m);
- end loop
Do anyone know how to merge several (80-90) csv file data into 1 file?
2 ビュー (過去 30 日間)
古いコメントを表示
I have to merge data from several csv files into one csv file and find the maximum value of each column.
How shall I do it?
0 件のコメント
採用された回答
Argon
2012 年 11 月 1 日
編集済み: Argon
2012 年 11 月 1 日
Assuming that all files have the same columns I'd do something like this:
m of course is your result.
5 件のコメント
Argon
2012 年 11 月 1 日
There is not "one" function that does that as far as I know -- you will probably have to iterate over all your files and use csvread and write them to disk again, something like this:
files = {'file1.csv', 'file2.csv'};
cellfun(@(x) dlmwrite('output.csv', csvread(x), '-append'), files);
Though you might have to tweak that a bit, it hasn't been tested.
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!