清空筛选条件
清空筛选条件

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

2 次查看（过去 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 中查找有关 Logical 的更多信息

标签

产品


版本

R2016b

Community Treasure Hunt

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

Start Hunting!

Translated by