Converting Table with matrices to CSV
7 views (last 30 days)
Show older comments
Hi,
I have been trying to convert a .mat file to .csv, but the table I've been working with has {nxm double} matrices in it.
I tried the 'writetable()' function, but it "one-hot encodes" the whole thing.
For example when I run it I get:
title data
_____________ ___________________
"A" {2×4 double }
"B" {5×4 double }
"C" {2×4 double }
"D" {[000 001 002 003]}
"E" {[004 005 006 007]}
but, the .csv file splits the matrix into "data_1", "data_2" ... "data_n".
I also tried using:
writetable(X,'X_test.csv','Delimiter',',','QuoteStrings',true)
type 'X_test.csv'
to write the matrix as a string, but it didn't make a difference.
I want the output of the matrices to be like python lists, for example, for a {2x4 double} matrix:
[[734, 234, 987, 174], [193, 297, 379, 222]]
or any other way where it is not split into different columns.
Thanks in advance!
3 Comments
Accepted Answer
More Answers (0)
See Also
Categories
Find more on Data Type Conversion in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!