Split table column into multiple columns within the same table based on a specific delimiter

15 次查看（过去 30 天）
Thomas Webber
Thomas Webber 2020-6-26
回答： Cris LaPierre 2020-6-26
Hi all,
I have been hunting for a solution for a few days now and currently nothing is quite working out. I have a table pulled from an sql database with around 16,000 rows. One column is a series of values from 0 to 1 (1024 total) seperated by a ',' . I want to be able to split this single column into 1024 seperate columns,each contianing one value for each row and keep them within the same table, idealy just like the text to columns function in excel.
Any help is much appreciated!
Thomas
Edit: Detections.mat is a head of the table in question. I would like to idealy split column 8 (avrg_spectrum) into a column for each value.
  2 个评论
Cris LaPierre
Cris LaPierre 2020-6-26
It is helpful if you can share an actual example of an entry you want to split. How is it stored in your table? Is it a cell, string, char?
Thomas Webber
Thomas Webber 2020-6-26
I have attached a head of the table in question. Column 8, 'avrg_spectrum' is the only column I would like to split open based on numbers seperated by a ','. The column itself is a cell array of charcater vectors, which would ideally be numeric values in the finished table.

请先登录，再进行评论。

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

采纳的回答

Ameer Hamza
Ameer Hamza 2020-6-26
Try this
load('Detections.mat');
val = cell2mat(cellfun(@(str) {sscanf(str, '%f,').'}, Click.avrg_spectrum));
new_table = [Click(:,1:7) array2table(val) Click(:,9:end)];

更多回答（1 个）

Cris LaPierre
Cris LaPierre 2020-6-26
Another approach
Click.avrg_spectrum = str2double(split(string(Click.avrg_spectrum),","));
newClick = splitvars(Click,"avrg_spectrum");
This does add an extra empty column since the field being split ends in a comma. You could remove that as part of the process if you want.
Click.avrg_spectrum = str2double(split(string(Click.avrg_spectrum),","));
Click.avrg_spectrum(:,end)=[];
newClick = splitvars(Click,"avrg_spectrum");
This is a little slower, so if you have lots of data, Ameer's approach is better.

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by