How to separate Variables Names from the Data in Two Different table

1 次查看（过去 30 天）
Alikouider
Alikouider 2021-12-11
评论： Star Strider 2021-12-11
Hello,
I have been able to read my excel file and to create my table using this code:
T = readtable('Data.xlsx','TextType','string');
I would like to separate them in 2 differents tables one with variables names and one with the data
because my list of variable name is very long.
like following:
varnames = ["Var1""Var2"..."VarN"]
data =["BOB" "london" "BIM" "Alfred" "Paris" "BOB" "John" "BOB" "CEF"]
Thanks for your understanding
Have a nice day.

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

采纳的回答

Star Strider
Star Strider 2021-12-11
Ran in:
Perhaps something like this —
T1 = array2table(randi(99, 10, 5))
T1 = 10×5 table
Var1 Var2 Var3 Var4 Var5 ____ ____ ____ ____ ____ 66 94 35 1 7 80 65 87 94 7 18 90 14 99 88 23 29 23 14 46 55 58 31 61 57 97 52 61 95 1 55 23 39 27 31 98 5 11 12 88 47 15 55 80 46 83 49 81 31 27
T2 = T1;
T2.Properties.VariableNames = {'Alpha','Beta','Gamma','Delta','Epsilon'}
T2 = 10×5 table
Alpha Beta Gamma Delta Epsilon _____ ____ _____ _____ _______ 66 94 35 1 7 80 65 87 94 7 18 90 14 99 88 23 29 23 14 46 55 58 31 61 57 97 52 61 95 1 55 23 39 27 31 98 5 11 12 88 47 15 55 80 46 83 49 81 31 27
Make appropriate changes to get the desired result.
.
  4 个评论
显示 2更早的评论

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Startup and Shutdown 的更多信息

标签

产品


版本

R2016b

Community Treasure Hunt

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

Start Hunting!

Translated by