Split one csv to multiple csv

조회 수: 10 (최근 30일)
novice modeler
novice modeler 2017년 5월 4일
댓글: novice modeler 2017년 5월 7일
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
per isakson 2017년 5월 5일
  • "a csv file with 100 columns" &nbsp How large is it? Does it fit in memory?
  • Does the file have header lines?
novice modeler
novice modeler 2017년 5월 7일
the file size is 2 GB. it has header lines as well.

댓글을 달려면 로그인하십시오.

답변 (1개)

Image Analyst
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.

카테고리

Help CenterFile Exchange에서 File Operations에 대해 자세히 알아보기

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by