how to create csv file with dlmwrite for diffrent vector sizing?
显示 更早的评论
hello, I have sevral of colums vector with different sizes, and I want to write them all to a csv file,in the following way:
for example, vec1=[11,12,13,14], vec2=[21,22,23]; vec3=[31,32,33,34,35,36] the output should be something like this:
line1: 11, 21,31
line2: 12, 22,31
line3: 13, 23,32
line4: 14, ,34
line5: , ,35
line6: , ,36
but instead the output is like this:
11,21,31
12,22,32
13,23,33
14,34
35
36
the code:
vec1=[11,12,13,14]; vec2=[21,22,23]; vec3=[31,32,33,34,35,36];
vec=[];
for i=1:max([length(vec1),length(vec2),length(vec3)])
if (i<=length(vec1))
vec=[vec,vec1(i)];
else vec=[vec,[]];
end
if (i<=length(vec2))
vec=[vec,vec2(i)];
else vec=[vec,[]];
end
if (i<=length(vec3))
vec=[vec,vec3(i)];
else vec=[vec,[]];
end
dlmwrite('test.csv', vec,'-append');
vec=[];
end
I tried replacing "vec=[vec,[]]" in the else with "vec=[vec,NaN]", and it worked, but I dont want to see "NaN" at all in the csv file. is there any other way to keep it blank? for record, I do not know in advance the length of each vector.
1 个评论
"is there any other way to keep it blank?"
Not they way you are trying. Numeric array must contain numeric values, and [] is not a numeric value (it is an empty array). You could write your own export function using low-level operations (i.e. fprintf).
Or just use NaN.
采纳的回答
Walter Roberson
2018-10-31
0 个投票
This is not possible using csvwrite or dlmwrite. You will need to fopen / fprintf / fclose.
更多回答（1 个）
madhan ravi
2018-10-31
编辑：madhan ravi
2018-10-31
instead of [] you can use 0 , you can omit it later on
else vec=[vec,0];
2 个评论
nirit
2018-10-31
madhan ravi
2018-10-31
编辑：madhan ravi
2018-10-31
dlmwrite('test.csv', vec,'delimiter',',','TreatAsEmpty',1,'-append');
类别
在 帮助中心 和 File Exchange 中查找有关 Standard File Formats 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
