MATLAB Answers

how to edit csv file ?

91 views (last 30 days)
pruth
pruth on 18 Sep 2019
Answered: pruth on 19 Sep 2019
i have this csv file. i want to edit the file and add a number(the value) of total rows in the file at the top without deleting any row .inserting the number !
output should look like
697
98.036,90,72.708,9.9692e+36,9.9692e+36
97.451,90,72.927,9.9692e+36,9.9692e+36
96.9,90,73.135,9.9692e+36,9.9692e+36
.
.
.
97.451,90,72.927,9.9692e+36,9.9692e+36
96.9,90,73.135,9.9692e+36,9.9692e+36
  4 Comments
pruth
pruth on 19 Sep 2019
no sir, i have 100's of files like this . i can not do it manually !

Sign in to comment.

Accepted Answer

pruth
pruth on 19 Sep 2019
this worked for me ! thank you all !
after reading the csv file i converted it into mat file 'a' and used this further code .
M = length(a(:,1))
dlmwrite('test.csv',M,'delimiter',',')
N = a;
dlmwrite('test.csv',N,'delimiter',',','-append');

More Answers (1)

Sebastian Körner
Sebastian Körner on 18 Sep 2019
read your file with
A = readtable(yourfile);
then follow this scheme:
A = [8 8 8 8 8 8 ; 7 7 7 7 7 7]; %% example data for your file
[r,c]=size(A);
A = num2cell(A);
B = cell(1,c);
B{1,1} = r;
C = [B ; A];
C is the output you are looking for

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by