How can I trim a dataset with missing values

1 次查看（过去 30 天）

Sebastian 2016-11-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/310483-how-can-i-trim-a-dataset-with-missing-values

评论： abduall hassn 2016-11-3

I have a dataset I'm working on as part of a project. I need to trim it down for some specific information, but I can't figure out how to go about it, as it's too much data to manually manipulate.

Essentially I have 2 columns with information. The first column holds a date and time in various formats. I need each cell to be the time only.

example:

05/07 2008 13:40 --> 13:40 --> 13.40
11.01.2009 15.12 --> 15.12

Is there a way to do this in matlab? (I was thinking regex but I'm not very experienced in that)

The second column simply holds either a 1 or a 0. The problem here is that I need both columns for each row, or I have to discard the data. Is there a way to automatically delete rows, for which there's less than 2 columns of data?

Thanks in advance.

2 个评论
显示无隐藏无

Guillaume 2016-11-3

Yes, you could use a regular expression to extract your time, but for us to tell you which expression to use we would need to know what are all the possible formats we have to deal with.

As for your second question, the answer again is yes, but to answer it properly we need to know what form your data is in at the moment. How can there be less than two columns of data for some rows if everything is stored in a cell array?