how to create one row table

Question

MAHMOUD ALZIOUD 2017-10-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/362221-how-to-create-one-row-table

评论： MAHMOUD ALZIOUD 2017-10-19

Hello guys, I am trying to create a one row table, I have 19 variables (called them z) and their values (called them y), I wrote this code to display the results in an excel sheet. but the values in the table didn't come under the variable names, they all came in one line which is not a table !!! how can i fix this please? the code is :

z={'Month' 'Card_Name' 'Total_Volume' 'Truck_Volume' 'Sum_Class_1 ' 'Sum_Class_2' 'Sum_Class_3' 'Sum_Class4_' 'Sum_Class_5' 'Sum_Class_6' 'Sum_Class_7' 'Sum_Class_8' 'Sum_Class_9' 'Sum_Class_10' 'Sum_Class_11' 'Sum_Class_12' 'Sum_Class_13' 'Sum_Class_14' 'Sum_Class_15'};
y=[unique(str2num(Month_of_Data)), unique(str2num(Station_ID)), TotalV, TruckV, Sum_Class_1, Sum_Class_2, Sum_Class_3, Sum_Class_4, Sum_Class_5, Sum_Class_6, Sum_Class_7, Sum_Class_8, Sum_Class_9, Sum_Class_10, Sum_Class_11, Sum_Class_12, Sum_Class_13, Sum_Class_14, Sum_Class_15];
T=table(z,y)
filename = 'ourData2.xlsx';
writetable(T,filename,'Sheet',1,'Range','D1')

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Cam Salzberger 2017-10-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/362221-how-to-create-one-row-table#answer_286709

在 MATLAB Online 中打开

Hello Mahmoud,

There are two issues going on here. One is that to specify the column names for a table, you want to provide them as part of a name-value pair argument to table:

T = table(..., 'VariableNames', varNames);

The other is that MATLAB doesn't automatically know that you want each column of your array in a separate variable. Having a full matrix in one column of a table is a viable storage of data. "table" requires that the different columns are provided as separate variables.

To separate it out easily, you can convert it to a cell array, and then use {:} to provide the different cells as individual variables. It's a common trick in other instances.

z = {'a' 'b'};
y = rand(1,2);
yc = num2cell(y, 1);
T = table(yc{:}, 'VariableNames', z)

-Cam

6 个评论
显示 4更早的评论隐藏 4更早的评论

Cam Salzberger 2017-10-19

编辑：Cam Salzberger 2017-10-19

Thanks Walter, I had forgotten about array2table.

Mahmoud, there are several issues with your code:

You can't "writetable" before you define it. That should go at the end.
My use of T = table(... was not meant to be taken literally. By "..." I meant "put something here that makes sense, and then put VariableNames etc. after all that". As I did in my example below that.
When you define "y" initially, you're doing it with num2cell, but giving it a bunch of input arguments. I assumed you had already defined "y" as an array, and then you would convert it to a cell array with num2cell. Or don't bother, and just create your table with each of the different elements of y individually.

What I find to be the easiest way to learn to code in MATLAB is to start with a simple example. Run it, look at the output of each step, and understand it. Then start modifying it a little bit at a time, checking the output of each step to make sure it makes sense. Modify it piece by piece until it's close to what you want. That way if something goes wrong, you know which step it occurred at, and you have actually come to fully understand the code.

MAHMOUD ALZIOUD 2017-10-19