Answered
Efficiently processing unusual date/time format
Michael, your data example says, "Absolute Time", so datetime may indeed be the right thing to create. But beginning in R2018a, ...

7 years ago | 1

Answered
Monthly average from yearly data missing days with dates in a cell
Don't use a loop. Use a timetable and retime: >> data = array2timetable(rand(366,3),'RowTimes',datetime(2016,1,1:366)); ...

7 years ago | 0

Answered
Hi, I have facing some problems in separating a column of datetime series into separate date and time column. How can I get two columns of date and time from a single datetime column?
Hard to know precisely what you mean by that question. If you have a datetime vector that you've read into MATLAB from a spreads...

7 years ago | 0

Answered
How to plot date and time on x axis and data on y axis using matlab?
As Jonas suggests, if you are using a recent version of MATLAB, use readtable, and you should be able to just plot the resulting...

7 years ago | 0

Answered
I want to compare timestamps from two measurement devices to see that both instrumtents have measured the same minutes, and if they haven't find those locations and manipulate the tables so that they do correspond.
You may find that converting _everything_ to datetims is much easier: >> d1 = datetime(2018,8,3,0,randi(3,5,1),0) d1 = ...

7 years ago | 0

Answered
How to fix when I give value to cell in a blank table, the rest of the un-valued cells in the same row will be set as double format automatically
You are creating a table with 0 rows, but the table has two variables, both of which are doubles. Empty, but doubles. >> ro...

7 years ago | 0

| accepted

Answered
How to save multiple tables in seperate sheets in Excel
Victoria, I really recommend that you not use xlswrite. As Paolo suggests, writetable can definitely write to sheets in an Excel...

7 years ago | 0

Answered
Inconsistent Error - Undefined function 'length' for input arguments of type 'table'. Use the HEIGHT, WIDTH, or SIZE functions instead
The error strongly suggests that something that's expected to be a numeric vector is in fact a table. Set a breakpoint at the li...

7 years ago | 0

Answered
Removing Rows Based on Repeated Values in a Single Column of Matlab Table
Use varfun on the table, with b as the grouping variable. It's one line. >> t = table([1;3;3;4],[2;2;4;2],[3;5;6;6],[4;3;7;...

7 years ago | 0

Answered
how to convert from table to 3D array
Based on your description, it sounds like you want to horzcat the amplitudes, reshape them into 3D, and prepend (copies of?) the...

7 years ago | 0

Answered
Best multi data type export options [table,struct,cell array, etc..] also file types
It's hard to say for sure, but it's likely that you don't want to use cell arrays, because that will make working with the data ...

7 years ago | 0

Answered
Analyzing the rows of a timetable,I want to take the range from door/closed to door/open and study2cases:1.if there are no rows between door/closed and door/open and their time difference is> 20 minutes ;2.if there are rows between them.How can I do?
That's kind of a complicated explanation, and I'm not sure I can follow it completely. It sounds like you want to use categorica...

7 years ago | 0

Answered
table2array error
table2array wants to create a homogeneous array. It can't do that if the table contains a mix of numeric and text. What would yo...

7 years ago | 1

Answered
Cell contents reference from a non-cell array object table2array
In a recent-ish version of MATLAB, try this: >> load('ae1993.mat') >> t = array2table(AE_val,'VariableNames',{'Time' 'X'...

7 years ago | 0

Answered
Time Stamp is a Large Number
If you have _text_, Stephen's advice is good. If you have a number, you can split it into two pieces and use datetime to do at l...

7 years ago | 0

Answered
how to change a time series data from 30 minutes to 5 minutes
You may find that putting your data in timetables, and using synchronize, is the easiest way to go. That function offers a varie...

7 years ago | 0

Answered
How to covert a datenum (serial number) back to original date time format
There's not enough in your description to go on, but a round-trip certainly does work in your example: >> dn = 735235 + (0:...

7 years ago | 0

Answered
datetime with nanosecond precision, but arithmetic with millisecond precision?
As Walter says, datetime and duration* should have no trouble with this. I suspect this is just a format issue: >> d = date...

7 years ago | 1

Answered
How do I Subscript Duration Row times with Date Time values?
I'm coming to this thread late, so I may be repeating what Walter and Paolo already sorted out. It looks like the root cause was...

7 years ago | 0

Answered
convert datenum to date time series
You can do this: >> datetime(1900,1,1,0,0,0) + hours([1008072 1016808]) ans = 1×2 datetime array 01-Jan-2015...

7 years ago | 1

| accepted

Answered
Convert any datetime to english datetime
Here's what was happening (and keep in mind, "sauna" might be the only Finnish word I know): dir uses system utilities. It ap...

7 years ago | 1

Answered
How to output specific rows from tables depending on values within the table?
In more recent versions of MATLAB there are several ways to do this. In R2014a, do a grouped varfun, using @max as the function ...

7 years ago | 0

Answered
How can I select rows based on the value in a specific column and calculate the mean of those rows for all other columns to create a new table containing just the means?
You could also create a timetable using a duration time vector -- elapsed time from the start instead of absolute times. Equival...

7 years ago | 0

Answered
save result of each iteration in a joint table
You are overwriting all of T every time. Do one of two things: 1) inside you2 loop, assign to new rows of T: T(end:en...

7 years ago | 1

Answered
How to read only number from the number and character mixed text file???
You are probably better off reading the whole file into a table using readtable, with TreatAsEmpty set to "No Data". In recent v...

7 years ago | 1

Answered
Extract a table with some range of dates
In R2016b or later, the best way to do this is to use a timetable, and use timerange to create a row subscript.

7 years ago | 0

| accepted

Answered
Add data in a table according to the variable names.
I can't tell if the question is about just the variable names, or the tables themselves. So this may be answering a different qu...

7 years ago | 0

| accepted

Answered
I have a cell array of 37x1 cells. each cell is having around 133x7 table. each cell data is one day data. therefore 37 days means 37 days data. i want to export each day (133x7 table) to a new txt file.
I think you'd want to loop over the cell array, and call readtable on each cell's (table) contents.

7 years ago | 0

Answered
Add a variable to a table
If your table is named T, and your workspace variable is named k, and you want the new variable in the table to be named k, then...

7 years ago | 0

| accepted

Answered
Plotting time series data but data rounding to minute
Jack, what is it that makes you think all the data have been rounded to the nearest minute? Certainly the tick labels are rounde...

7 years ago | 0