Effacer les filtres
Effacer les filtres

Cannot save a matrix into a csv file correctly

5 vues (au cours des 30 derniers jours)
Hayao
Hayao le 7 Déc 2023
Réponse apportée : Chunru le 7 Déc 2023
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 commentaires
Ramtej
Ramtej le 7 Déc 2023
Hi Hayao,
Can you share how your matrix looks like? "writematrix" should work fine in your case.
Dyuman Joshi
Dyuman Joshi le 7 Déc 2023
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')

Connectez-vous pour commenter.

Réponses (1)

Chunru
Chunru le 7 Déc 2023
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

Produits


Version

R2023b

Community Treasure Hunt

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

Start Hunting!

Translated by