Splitting columns of a table

Question

Sonali 2024-5-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2117741-splitting-columns-of-a-table

评论： Sonali 2024-5-12

Hi I have a datafile : https://drive.google.com/file/d/1pYtIqvwfjOYDzvfjeudBE5XzmXmlJFiV/view?usp=drive_link

I am trying to store it in a table using following program. It is not letting me split certain columns that have arrays as values, into different columns. Each column should have just one value. I have tried replaing the delimiter, regexp and splitvars, but they didnt work at all.

.....................................................................................................................

files = dir('mvn_lpw_l2_lpnt_20150301_v03_r02.csv'); 
tab = readtable(files.name)

...........................................................................

Would appreciate some help here. Thanks

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Stephen23 2024-5-12

在 MATLAB Online 中打开

What do you expect DIR of one signle finename to achieve? Why not simply replace this:

files = dir('mvn_lpw_l2_lpnt_20150301_v03_r02.csv'); 
tab = readtable(files.name)

with simpler:

fnm = 'mvn_lpw_l2_lpnt_20150301_v03_r02.csv'; 
tab = readtable(fnm)

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2024-5-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2117741-splitting-columns-of-a-table#answer_1456041

在 MATLAB Online 中打开

files = dir('mvn_lpw_l2_lpnt_20150301_v03_r02.csv'); 
tab = readtable(files.name, 'Delimiter', ',', 'VariableNamingRule', 'preserve');
temp1 = regexp(regexprep(tab.(1), '[[]]', ''), '\s+', 'split');
temp4 = regexp(regexprep(tab.(4), '[[]]', ''), '\s+', 'split');
temp5 = regexp(regexprep(tab.(5), '[[]]', ''), '\s+', 'split');
c1 = cell2mat(cellfun(@str2double, temp1, 'uniform', 0));
c2 = datetime(tab.(2), 'inputformat',"uuuu-MM-dd'T'HH:mm:ss.SSS'Z'");
c3 = datetime(tab.(3), 'convertfrom', 'posixtime');
c4 = cell2mat(cellfun(@str2double, temp4, 'uniform', 0));
c5 = cell2mat(cellfun(@str2double, temp5, 'uniform', 0));
c6 = tab.(6);