how to edit csv file ?

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

[madhan ravi]

Isn't this the same quesion as https://in.mathworks.com/matlabcentral/answers/480943-how-to-insert-a-single-value-in-the-matrix ?

[pruth]

yes but i feel i dint ask the question correctly. and can not delete the old question too ! however i couldnt solve the prblem yet ! i would really apriciate if you could help ! thank you !

[Geoff Hayes]

pruth - do you just have one file? If so, can you do this manually instead of using MATLAB?

[pruth]

no sir, i have 100's of files like this . i can not do it manually !

Answer 1

[pruth]

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');

Answer 2

[Sebastian Körner]

read your file with

 A = readtable(yourfile);

https://de.mathworks.com/help/matlab/ref/readtable.html

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