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

casi 8 años hace | 1

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

casi 8 años hace | 0

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

casi 8 años hace | 0

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

casi 8 años hace | 0

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

casi 8 años hace | 0

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

casi 8 años hace | 0

| aceptada

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

casi 8 años hace | 0

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

casi 8 años hace | 0

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

casi 8 años hace | 0

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

casi 8 años hace | 0

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

casi 8 años hace | 0

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

casi 8 años hace | 0

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

casi 8 años hace | 1

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

casi 8 años hace | 0

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

casi 8 años hace | 0

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

casi 8 años hace | 0

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

casi 8 años hace | 0

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

casi 8 años hace | 1

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

casi 8 años hace | 0

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

casi 8 años hace | 1

| aceptada

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

casi 8 años hace | 1

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

alrededor de 8 años hace | 0

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

alrededor de 8 años hace | 0

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

alrededor de 8 años hace | 1

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

alrededor de 8 años hace | 1

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

alrededor de 8 años hace | 0

| aceptada

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

alrededor de 8 años hace | 0

| aceptada

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

alrededor de 8 años hace | 0

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

alrededor de 8 años hace | 0

| aceptada

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

alrededor de 8 años hace | 0

Cargar más