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

조회 수: 1 (최근 30일)
Kevin Wittkowski
Kevin Wittkowski 2021년 1월 7일
댓글: Mathieu NOE 2021년 1월 8일
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일
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
  댓글 수: 2
Kevin Wittkowski
Kevin Wittkowski 2021년 1월 7일
Thank you Mathieu :)
Mathieu NOE
Mathieu NOE 2021년 1월 8일
You're welcome !

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

추가 답변 (0개)

카테고리

Help CenterFile 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!

Translated by