how to edit csv file ?
70 views (last 30 days)
Show older comments
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
on 18 Sep 2019
pruth - do you just have one file? If so, can you do this manually instead of using MATLAB?
Accepted Answer
More Answers (1)
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
0 Comments
See Also
Categories
Find more on Data Import and Analysis in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!