How to save table with data in columns instead of one long row?

18 次查看(过去 30 天)
I am trying to save a table that contains several doubles and one categorical array (see picture).
When I now script (see below) I get a csv file with just one long row with all the numbers next to one another. How can I save a table with just the three columns seperate into a csv file?
writetable(table,'name.csv')

采纳的回答

Eveline Kallenberg
Eveline Kallenberg 2020-8-24
No more help needed! I basically extracted the data inside the categorical cell array and the double cell arrays with the code below.
[mycellarray{:}]
I thereafter created three different columns (new variables) and then created a new table from the three columns and saved it into a csv file :D
column1 = [table.Var1{:}];
column2 = [table.Var2{:}];
column3 = [table.Var3{:}];
table_final = table(column1, column2, column3);
writetable(table_final,'filename.csv','writevariablenames',0); % writing the table without headers of the variable names

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by