- "a csv file with 100 columns"   How large is it? Does it fit in memory?
- Does the file have header lines?
Split one csv to multiple csv
조회 수: 10 (최근 30일)
이전 댓글 표시
Friends, I have a csv file with 100 columns. I want to split it into 10 csv files, 10 columns each.Please give me your advice.
댓글 수: 2
per isakson
2017년 5월 5일
답변 (1개)
Image Analyst
2017년 5월 5일
Try this:
data = csvread(filename);
csvwrite('part1.csv', data(:, 1:10));
csvwrite('part2.csv', data(:, 11:20));
csvwrite('part3.csv', data(:, 21:30));
csvwrite('part4.csv', data(:, 31:40));
csvwrite('part5.csv', data(:, 41:50));
csvwrite('part6.csv', data(:, 51:60));
csvwrite('part7.csv', data(:, 61:70));
csvwrite('part8.csv', data(:, 71:80));
csvwrite('part9.csv', data(:, 81:90));
csvwrite('part10.csv', data(:, 91:100));
Adapt as needed.
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 File Operations에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!