Effacer les filtres
Effacer les filtres

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

26 vues (au cours des 30 derniers jours)
Eveline Kallenberg
Eveline Kallenberg le 24 Août 2020
Commenté : Bogdan -Ervin le 21 Mai 2023
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')

Réponse acceptée

Eveline Kallenberg
Eveline Kallenberg le 24 Août 2020
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
  1 commentaire
Bogdan -Ervin
Bogdan -Ervin le 21 Mai 2023
What to do if you want a column to contain strings?

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Tables dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by