필터 지우기
필터 지우기

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

조회 수: 26 (최근 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