read .csv file, append content to another .csv file
조회 수: 1 (최근 30일)
이전 댓글 표시
Hello,
I have two csv files, file1.csv and file2.csv (see attachments).
I want to append all the data -except the header and the first line- in file2.csv to the data already present in file1.csv .
To be clearer,
if file1.csv is
header1,header2,header3
1,2,3
3,4,5
and file2.csv is
header1,header2,header3
3,4,5
6,7,8
9,10,11
I want to get as file1.csv
header1,header2,header3
1,2,3
3,4,5
6,7,8
9,10,11
Thank you in advance :)
댓글 수: 0
채택된 답변
Mathieu NOE
2021년 1월 7일
hello
this is it :
data1 = readcell('file1.csv');
data2 = readcell('file2.csv');
[m,n] = size(data2);
data_out = [data1;data2(2:m,:)];
writecell(data_out, 'file_out.csv');
I noticed that your first file ends with time iteration = 4 and and the second file starts also at the same time iteration
maybe one line to be removed if duplicates ?
all the best
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Workspace Variables and MAT Files에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!