답변 있음
Select row from matrix based on month with datenum
Andrei's solution also works out nicely with timetables: >> monthlyAvg = timetable(rand(3,1),'RowTimes',datetime(2017,1:3,1...

거의 9년 전 | 0

답변 있음
Using If Statement on Table2Array
Not sure what the table looks like so this is at best a guess. movstd returns a vector (or maybe a matrix). You're using a re...

거의 9년 전 | 0

답변 있음
How to merge cells within a table
David, this is certainly possible, but you have not said what you want done with the other variables in the table. Guillaume has...

거의 9년 전 | 0

답변 있음
How Do i Sort rows in tables based on unique rows dictionary ?
This sounds a lot like one or more innerjoin operations.

거의 9년 전 | 0

답변 있음
Reformatting a table with (yyyy-mm-dd HH:mm:ss) in one column to a new table with dates in the rows and time in the columns.
James, you're right about retime, what you're looking for is a "seasonal average" (I forget the right term) where all 10:00's ac...

거의 9년 전 | 0

| 수락됨

답변 있음
date computations in a table
Andrei provided the right answer if those data are text, e.g. '19850331' or "19850331". If they are _numeric_, use datetime...

거의 9년 전 | 1

답변 있음
compare date and time
All you need is if theDate > '21-May-2017 12:00:00' That's it. Unless you are using a fairly old version of MATLAB, stay...

거의 9년 전 | 0

답변 있음
How do I access data from a table?
You don't need table2array. Your example data don't seem to match either description, so I'm just guess what they look like. ...

거의 9년 전 | 2

| 수락됨

답변 있음
finding rows which correspond to date
>> Date = datetime({'Jan 2004';'Mar 2004';'Jun 2004';'Jan 2006';'Mar 2007'},'Format','MMM yyyy'); >> Value = [26.3;27.2;35....

거의 9년 전 | 0

| 수락됨

답변 있음
Adding datenum to plots
In MATLAB R2014b or later (and especially in R2016b or later), consider using datetimes, not datenums. startDate = datetime...

거의 9년 전 | 0

답변 있음
How to create a cross table?
I reformatted your data as a CSV, and read it into a table: >> t = readtable('tmp5.csv','Format','%s%C%C%C%C','ReadRowNames...

거의 9년 전 | 1

답변 있음
advice on table storage in a struct or a mat file
First thing is probably to get rid of all those cell arrays: PartID = {'H1';'H2'; 'H3';'H4';'H5';'H6';'H7';'H8';'H9';'H10'}...

거의 9년 전 | 1

답변 있음
Importing data in secs to matlab
Simon, there's not currently a way to use readtable to create a duration array directly from a file. If you are the one creating...

거의 9년 전 | 1

답변 있음
time in seconds to standard time
You don't say what the counter is: where it starts, what it counts, and how long it counts for. Based on the code, it looks l...

거의 9년 전 | 0

답변 있음
Extract rows from matrix based on date
David, even prior to R2016b, you might look at using datetimes rather than datenums: >> d = datetime(2017,10,26,(0:60:420)'...

거의 9년 전 | 0

답변 있음
Sort matrix by datenum
If using MATLAB R2016b or newer, you might consider using a timetable. There are lots of benefits beyond simple sorting by time,...

거의 9년 전 | 0

답변 있음
Time vector using stairs
It's not clear what you have and what you're trying to do, but in R2016b and later: >> strs = {'170101' '170102' '170103' '...

거의 9년 전 | 0

답변 있음
How to use time in form of HH:MM:SS:MliSecon in calculation
Not sure what you have or what you want, but datetime parses text in many formats: >> datetime('1/22/2017 4:4:7:558','Input...

거의 9년 전 | 0

답변 있음
How can i change the years with the dates in a data set?
If you already have these in MATLAB as text, then datetime will gracefully handle your problem: >> datetime('08-01-0003 09:...

거의 9년 전 | 0

답변 있음
is it possible to sort structure arrays along 1 field.
You can do it (as in what Stephen cited), but if you find yourself asking that question, you might want to ask whether you shoul...

거의 9년 전 | 0

답변 있음
Change the x axis in a figure with time
In MATLAB R2014b or newer, try this: >> t = duration(0:.5:23.5,0,0,'Format','hh:mm'); >> x = rand(size(t)); >> plot(t...

거의 9년 전 | 1

답변 있음
How can I count the number of working days between 2 dates?
If you only care about weekdays vs. weekends, try this: >> t = datetime({'10-apr-2017' '17-apr-2017'},'Format','eee dd-MM-y...

거의 9년 전 | 1

답변 있음
Querying rows in a table, specific scenario
You sample code doesn't actually work. Also, storing numeric values in a cell array is not a good idea. Try this: >> ID...

거의 9년 전 | 1

| 수락됨

답변 있음
Return the table column # containing the maximum value in a row
I think you want something like this: [maxVals,maxLocs] = max(T{:,14:27},[],2) In other words, for the contents of the 1...

거의 9년 전 | 1

답변 있음
How can I put a table Column (all the values from variable X) as a single element in another table
If that is literally what you want to do, I recommend that you don't use a table at all. There's not a lot of point in having a ...

거의 9년 전 | 0

답변 있음
How can I create this table?
Use table: >> x = randn(5,5); >> t = array2table(x,'VariableNames',{'x' 'y' 'h' 'H' 'N'},'RowNames',{'P1' 'P2' 'P3' 'P4'...

거의 9년 전 | 0

답변 있음
convert multidimensional array to a table with multi indexing
Another possibility is to flatten out the data. You may have the N-D organization on purpose. but here's one way to flatten the ...

거의 9년 전 | 2

답변 있음
how to read date time column in matlab
Unless you're using a version of MATLAB older than about R2015a, use readtable, not xlsread. In recent versions, you'll get a da...

거의 9년 전 | 0

답변 있음
Tables doesn't display the elements of columns
table's display has a limit of 3 columns within each variable; more than that and you'll see the above. Perhaps you want to spli...

거의 9년 전 | 1

| 수락됨

답변 있음
How to convert table to an array when the first two variables are different?
I don't understand your statement that you "cannot get matlab to read it". Based on the error message you get from table2array, ...

거의 9년 전 | 1

| 수락됨