how to edit csv file ?

70 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
Geoff Hayes
Geoff Hayes on 18 Sep 2019
pruth - do you just have one file? If so, can you do this manually instead of using MATLAB?
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

Categories

Find more on Data Import and Analysis in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!