Make Variable Names in a table numbers

26 visualizzazioni (ultimi 30 giorni)
I have a table that needs to have the variable names (columns) as numbers. When I try to assign the variablenames to the table t, i get this error. It is an array of 800 numbers that each have to be assigned a column. How do I make this work? Is there a way I can use array2table and specify the first row of numbers as the header? That is what I am trying to do below but it is not working.
t = array2table(allDataT(2:26,:)) %converting allDataT from rows 2 to 26 to a talbe
t.Properties.VariableNames = (allData(1,:)) % Trying to specify that the first row of numbers should be the header
% ERROR: The VariableNames property is a cell array of character vectors.
% To assign multiple variable names, specify nonempty names in a string arrayor a cell array of character vectors.

Risposta accettata

Jan
Jan il 22 Giu 2022
Header are strings, not numbers. You cannot use numbers to be a header.
allData = reshape(1:64, 8, 8)
allData = 8×8
1 9 17 25 33 41 49 57 2 10 18 26 34 42 50 58 3 11 19 27 35 43 51 59 4 12 20 28 36 44 52 60 5 13 21 29 37 45 53 61 6 14 22 30 38 46 54 62 7 15 23 31 39 47 55 63 8 16 24 32 40 48 56 64
t = array2table(allData);
t.Properties.VariableNames = string(allData(1,:))
t = 8×8 table
1 9 17 25 33 41 49 57 _ __ __ __ __ __ __ __ 1 9 17 25 33 41 49 57 2 10 18 26 34 42 50 58 3 11 19 27 35 43 51 59 4 12 20 28 36 44 52 60 5 13 21 29 37 45 53 61 6 14 22 30 38 46 54 62 7 15 23 31 39 47 55 63 8 16 24 32 40 48 56 64
Instead of 1,9, ... you have the headers "1", "9", ...

Più risposte (0)

Categorie

Scopri di più su Tables in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by