how to edit csv file ?

68 次查看（过去 30 天）
pruth
pruth 2019-9-18
回答： pruth 2019-9-19
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 个评论
显示 2更早的评论
Geoff Hayes
Geoff Hayes 2019-9-18
pruth - do you just have one file? If so, can you do this manually instead of using MATLAB?
pruth
pruth 2019-9-19
no sir, i have 100's of files like this . i can not do it manually !

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

pruth
pruth 2019-9-19
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');

更多回答（1 个）

Sebastian Körner
Sebastian Körner 2019-9-18
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

类别

在 Help Center 和 File Exchange 中查找有关 Workspace Variables and MAT-Files 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by