Cannot save a matrix into a csv file correctly

2 次查看（过去 30 天）
Hayao
Hayao 2023-12-7
回答： Chunru 2023-12-7
So I have a matrix with doubles inside like this
0.001　　9.86543...
0.002　　5.26811...
0.003　　4.91702...
and so on.
Using writematrix saves all column into a single column. Changing the delimiter option didn't change the result. It only changed how the numbers are separated, but they are still bunched up into a single column when I open the csv file.
How do I fix this?
  2 个评论
Ramtej
Ramtej 2023-12-7
Hi Hayao,
Can you share how your matrix looks like? "writematrix" should work fine in your case.
Dyuman Joshi
Dyuman Joshi 2023-12-7
Ran in:
The code below works fine on my R2021a, see the attach csv file for reference.
Please share the matrix you have, with the call to writematrix() you are using to save the data in csv file.
y = reshape(magic(6), [], 2);
disp(y)
35 26 3 21 31 22 8 17 30 12 4 13 1 19 32 23 9 27 28 10 5 14 36 18 6 24 7 25 2 20 33 15 34 16 29 11
writematrix(y, 'File.csv')

请先登录，再进行评论。

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

回答（1 个）

Chunru
Chunru 2023-12-7
Ran in:
A = [0.001 9.86543
0.002 5.26811
0.003 4.9170]
A = 3×2
0.0010 9.8654 0.0020 5.2681 0.0030 4.9170
writematrix(A, "matrixA.txt");
type matrixA.txt
0.001,9.86543 0.002,5.26811 0.003,4.917

类别

在 Help Center 和 File Exchange 中查找有关 Text Files 的更多信息

标签

产品


版本

R2023b

Community Treasure Hunt

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

Start Hunting!

Translated by