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

2 vues (au cours des 30 derniers jours)
Kevin Wittkowski
Kevin Wittkowski le 7 Jan 2021
Commenté : Mathieu NOE le 8 Jan 2021
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 :)

Réponse acceptée

Mathieu NOE
Mathieu NOE le 7 Jan 2021
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 commentaires
Kevin Wittkowski
Kevin Wittkowski le 7 Jan 2021
Thank you Mathieu :)
Mathieu NOE
Mathieu NOE le 8 Jan 2021
You're welcome !

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Workspace Variables and MAT Files dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by