How to combine specific columns from one array into another array

5 次查看（过去 30 天）
Brandon burns
Brandon burns 2021-2-23
评论： dpb 2021-2-24
I have imported an excel spreadsheet as a string array and I need to pull out specific columns from this array that represent data obtained under certain conditions, to be used for further data processing
janimpedance is my 106x41 string array the relevant values are from rows 8 to 106. The first 7 rows contain charcters describing the conditions that were used in obtaining the data. I wanted to combine the values from every 6th column into a single array. I have been using newvariable=str2array((janimpedance(rowstart:rowstop,column)) to create the new variable and I was hoping to streamline the process so I don't have to manually enter the information for each variable.
Thanks
  5 个评论
显示 3更早的评论
Brandon burns
Brandon burns 2021-2-24
Is it possible to repeat the VariableNames. As the table I'm looking at have 40 to 50 variables. I would rather not have to name them all I was hoping to name the first 6 variables and have it repeat over the remaining columns.
dpb
dpb 2021-2-24
You can't have duplicated variable names, no, that would not lead to a way to unambiguously name a column by name.
Default names are Var1, Var2, ... VarN
If variables are related, here might be a place to use an array for the data instead and then refer to the desired column by indexing into the array.
Again, attaching a section of the actual file would help us help you...instead of guessing about stuff.

请先登录，再进行评论。

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

回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by