답변 있음
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년 초과 전 | 1

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

| 수락됨

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 1

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 1

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 1

| 수락됨

답변 있음
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년 초과 전 | 1

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 1

답변 있음
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년 초과 전 | 1

답변 있음
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년 초과 전 | 0

| 수락됨

답변 있음
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년 초과 전 | 0

| 수락됨

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

| 수락됨

답변 있음
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년 초과 전 | 0

더 보기