Answered
Condense repeating values in table into one cell
You may have other reasons for reshaping your data, but it's easy to compute those means without doing so: >> monthDates = ...

7 years ago | 0

| accepted

Answered
Reshape table by rows, then merge horizontally and new var names
Unstack: >> t = table([1;1;1;2;2;2;3;3;3;4;4;4],[1;2;3;1;2;3;1;2;3;1;2;3],[1;2;3;4;5;6;7;8;9;10;11;12]) t = 12×3 ta...

7 years ago | 2

| accepted

Answered
Storing and accessing large amounts of time-based data
Consider this: >> x = rand(100,5); >> c1 = mat2cell(x,100,[1 1 1 1 1]) c1 = 1×5 cell array {100×1 double}...

7 years ago | 1

Answered
Filtering timeseries with NaN
You might take a look at isoutlier and filloutliers.

7 years ago | 0

Answered
Locating variables across multiple tables
How's this: >> dogs = categorical(["Spike";"Mr. Dog";"Chow";"Spike";"Chow";"Mr. Dog";"Spike";"Chow";"Mr. Dog";"Charlie"]); ...

7 years ago | 0

| accepted

Answered
Combine multiple tables into one so that it can be write into one excel sheet
You can combine the tables, but if you have different variables in each one you'd have to fill in large chunks with missing data...

7 years ago | 0

Answered
pltoting a variable with dates on horizontial axis
If possible, use datetimes, not datenums. Jonas' answer seems good, except I think it isn't correct when dealing with the non-st...

7 years ago | 1

Answered
Converting dates into numbers
Unless you're using a fairly old version of MATLAB, consider using datetimes instead of datenums. You will be happier. >> x...

7 years ago | 0

Answered
Combine Timetable's
Perhaps tt12 = [tt1; tt2] i.e., just like any other MATLAB array.

7 years ago | 0

Answered
Duration in double between two datenum
If possible, don't use datenum. Use datetimes: >> fmt = 'yyyy-MM-dd HH:mm:ss.SSS'; >> dur = datetime('2018-09-07 18:36:0...

7 years ago | 3

Answered
Combine variables in workspace into one table?
If you created those variables in the workspace, surely you could have created them in a table to begin with? t = table(); ...

7 years ago | 0

Answered
Storing and accessing large amounts of time-based data
Ben, I'm coming to this post a bit late, and I don't think I have a silver bullet for you, but I wonder if I can get you to say ...

7 years ago | 0

Answered
Averaging data with slightly different time values
Stephan's is an interesting and powerful approach. Alex, what you described in your question is a good deal simpler. Tak a look ...

7 years ago | 1

Answered
How to display a Localized Time of a specific city?
Also, the timezones function will pop up a browser window with all your choices for time zones. It's kind of interesting reading...

7 years ago | 0

Answered
How to solve floating point problem with datenum
The real answer is, use datetime if at all possible, because this kind of floating point issue doesn't exist in datetime (at lea...

7 years ago | 1

Answered
how can i convert duration type to datetime type??
As posed, this question is equivalent to, "how do I convert 1 hour to a date?" As SK points out, you also have to answer, "1 hou...

7 years ago | 1

Answered
Initialise a table which contains a structure and a sub-structure
Max, there are perfectly good reasons for wanting to put a struct inside a table, and yours may be one of them. But you might al...

7 years ago | 0

Answered
Look-up table row and assign values to individual variables
If the names are unique, make them row names. JohnsData = allData('John',{'Age', 'Height'}) or perhaps allData{'John',{'...

7 years ago | 0

Answered
struct2table produces different results when I use it on different struct files
I can't really tell what's going on here, but often problems with struct2table are cleared up by this: >> help struct2table...

7 years ago | 0

Answered
How to do matching in table format?
b = (A2.col2 == 2); % or A2{:,2) == 2 c = A(b,:) % leave this as a table d = A2; d.Col2(b) = 200; % or d{b,2}...

7 years ago | 0

| accepted

Answered
Correcting timestamp from netCDF
>> time = [23627 23627.0069444444 23627.0138888889 23627.0208333333]; >> dt = datetime(1950,1,1,'Format','dd-MMM-yyyy HH:mm...

7 years ago | 1

| accepted

Answered
How can I calculate the delta time for each line?
Beginning in R2018a, you can convert directly to durations: >> duration(["15:27:02.563904" "15:27:02.815706" "15:27:03.0670...

7 years ago | 0

Answered
How to calculate mean frequency and amplitude between a period of a particular time interval.
I'm guessing you want to use readtable, convert the result to a timetable using table2timetable, and then either use a timerange...

7 years ago | 0

Answered
I have some big data file and I'm trying to plot them against date and time, I used the code below but it's not working for me at all. All I was is an x axis that has a point every 15 minutes.
I'm not exactly sure what you want, but in recent versions of MATLAB: >> x = datetime(2018,8,3,0,0,86400*sort(rand(10,1)));...

7 years ago | 0

Answered
Error using datevec (line 212) Failed to lookup month of year.
Better still: do what Jan suggests, but create a datetime, not a datenum. Actually, with datetime, you can probably avoid a l...

7 years ago | 0

Answered
How to reverse datenum?
The longer answer is, Don't use datenum and datestr at all if you can avoid it. Use datetime, no conversion back and forth betwe...

7 years ago | 0

Answered
Import date, time together with candlestick data for Candlestick chart
Your file has hundreds of empty lines in it, Ive removed them. Try this: >> t = readtable('EURCADecn15.csv'); >> t.DateT...

7 years ago | 0

| accepted

Answered
How do I read a text file and convert the dates and time?
It's likely that you want to read the file using readtable, and if you are using a recent version of MATLAB, you will get dateti...

7 years ago | 0

Answered
How to use 'setvartype' to get the variable as 'datetime' formatted as: yyyy-MM-dd
Pawel, if I understand your question correctly, this is just a display issue. The datetime in the middle and right images are th...

7 years ago | 0

Answered
How to extract Jan and feb dates from an array of date strings?
If possible, don't do this with text. Convert to datetimes: >> d = datetime(2018,randi(6,10,1),1) d = 10×1 datetim...

7 years ago | 0