read .csv file, append content to another .csv file

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 :)

 채택된 답변

Mathieu NOE
Mathieu NOE 2021년 1월 7일

1 개 추천

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개)

카테고리

도움말 센터File Exchange에서 Workspace Variables and MAT Files에 대해 자세히 알아보기

질문:

2021년 1월 7일

댓글:

2021년 1월 8일

Community Treasure Hunt

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

Start Hunting!

Translated by