Separate all data from table by date

6 次查看（过去 30 天）
Debbie Oomen
Debbie Oomen 2018-5-1
评论： Peter Perkins 2018-5-14
Hi everyone!
I need to separate data in a table based on their dates. I cannot seem to figure out the code for this. I have found several options such as datenum and timetable. The datenum option gives me an error because the dates are not a string and datestr does not function either. The dates are displayed in the following format : DD/MM/YYYY. I have also tried converting the table to a structure but this just displays the date as: 1x1 datetime
  2 个评论
Ameer Hamza
Ameer Hamza 2018-5-1
Can you show an example of your table content, or better yet if you could share a sample mat file, which could contain the table data.
Debbie Oomen
Debbie Oomen 2018-5-1
This is the table content. Thanks for the help

请先登录，再进行评论。

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

采纳的回答

Ameer Hamza
Ameer Hamza 2018-5-1
One possible solution is to use splitapply(). It will split your table into several tables based on dates
splitapply(@(x) {x}, myTable{:,:}, findgroups(myTable{:, 1}))
this supposes that dates are present in the first column of the table myTable.
  5 个评论
显示 3更早的评论
Debbie Oomen
Debbie Oomen 2018-5-2
I need to analyse one cell of each date and save this per day. What would be the best/easiest way to do this?
Ameer Hamza
Ameer Hamza 2018-5-2
Does it depend on what you want to analyze? cellfun() might be an option since it can apply a function on every cell in a cell array and save the output in a variable.

请先登录，再进行评论。

更多回答（1 个）

Peter Perkins
Peter Perkins 2018-5-2
Debbie, Ameer's solution answers your question, but you should ask yourself why you want to split your data up. There are lots of things you can do by applying functions to groups of data while they are still within a table. In fact, findgroups/splitapply is one of the ways to do that.
Very often, you are better off leaving the data all in one container.
  2 个评论
Debbie Oomen
Debbie Oomen 2018-5-4
Thank you Peter, but how would I do this? I have a file with an amount of data for 10 days and want to get data from each individual day.
Peter Perkins
Peter Perkins 2018-5-14
I don't know what you mean by "get". If your goal is to split up the data, then you should do that, and Ameer's sol'n works. But I am suggesting that your goal is probably more like "find the mean temperature for each day", and you don't need to split up your data to do that.

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by