how to edit csv file ?

2019 9 18
2 个回答
回答已采纳
更新时间：2019 9 19
27 次查看（30 天）

0 个投票

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更早的评论 隐藏 2更早的评论

pruth
pruth 2019-9-18
编辑：pruth 2019-9-18
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
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

0 个投票

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

1 个投票

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

类别

在 帮助中心 和 File Exchange 中查找有关 File Operations 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by