Beantwortet
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, ...

fast 8 Jahre vor | 1

Beantwortet
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)); ...

fast 8 Jahre vor | 0

Beantwortet
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...

fast 8 Jahre vor | 0

Beantwortet
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...

fast 8 Jahre vor | 0

Beantwortet
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 = ...

fast 8 Jahre vor | 0

Beantwortet
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...

fast 8 Jahre vor | 0

| akzeptiert

Beantwortet
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...

fast 8 Jahre vor | 0

Beantwortet
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...

fast 8 Jahre vor | 0

Beantwortet
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;...

fast 8 Jahre vor | 0

Beantwortet
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...

fast 8 Jahre vor | 0

Beantwortet
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 ...

fast 8 Jahre vor | 0

Beantwortet
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...

fast 8 Jahre vor | 0

Beantwortet
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...

fast 8 Jahre vor | 1

Beantwortet
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'...

etwa 8 Jahre vor | 0

Beantwortet
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...

etwa 8 Jahre vor | 0

Beantwortet
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...

etwa 8 Jahre vor | 0

Beantwortet
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:...

etwa 8 Jahre vor | 0

Beantwortet
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...

etwa 8 Jahre vor | 1

Beantwortet
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...

etwa 8 Jahre vor | 0

Beantwortet
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...

etwa 8 Jahre vor | 1

| akzeptiert

Beantwortet
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...

etwa 8 Jahre vor | 1

Beantwortet
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 ...

etwa 8 Jahre vor | 0

Beantwortet
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...

etwa 8 Jahre vor | 0

Beantwortet
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...

etwa 8 Jahre vor | 1

Beantwortet
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...

etwa 8 Jahre vor | 1

Beantwortet
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.

etwa 8 Jahre vor | 0

| akzeptiert

Beantwortet
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...

etwa 8 Jahre vor | 0

| akzeptiert

Beantwortet
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.

etwa 8 Jahre vor | 0

Beantwortet
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...

etwa 8 Jahre vor | 0

| akzeptiert

Beantwortet
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...

etwa 8 Jahre vor | 0

Mehr laden