답변 있음
Converting fractional doy (eg. 208.572917) to a date with mm/dd/yyyy HH:MM
In R2014b or later, you can use datetime and duration: >> d = datetime(2013,1,1) + days(208.5729167) d = 28-Jul-2...

10년 초과 전 | 0

답변 있음
what is the precision of a MATLAB datenum?
As Ian says, the precision of datenums for contemporary dates is about 10 microseconds: >> eps(now)*86400 ans = 1....

10년 초과 전 | 1

답변 있음
Replace NaN's in table with zero
There's a function called standardizeMissing that would replace a non-NaN value with NaN, but normally, replacing NaN with a con...

10년 초과 전 | 2

| 수락됨

답변 있음
How to find the day number of any year from a date?
If you are using R2014b or later, the datetime data type allows you to compute the day of year using the day function: >> x...

10년 초과 전 | 3

| 수락됨

답변 있음
Trying to sort a table by entry in specific column
If this is a table in the sense of the table data type, it's even easier: >> A=array2table([1 2 3;0 4 5;1 8 7;1 14 10;0 1 2...

10년 초과 전 | 1

답변 있음
How to remove a signal from a timeseries (the signal is known and the same length as timeseries)
Oliver, how are your data stored? If B is a noise component of A that you want to remove, can you not just compute C = A - B? Yo...

10년 초과 전 | 0

답변 있음
How to break a large table into a set of smaller tables?
Jennifer, it's hard to answer this question without knowing whether "table" means "the MATLAB table data type" or something else...

10년 초과 전 | 2

답변 있음
Find the Monday preceding the third Friday of the month
In R2014b or later, using datetime, this is simple: % Generate some random dates >> d = sort(datetime('now','Format','ee...

10년 초과 전 | 3

답변 있음
formulating elapsed time in hours for input data...
In MATLAB R2014b or later, use datetime. With your date_str variable converted to a cell array of strings: >> d = datetime(...

10년 초과 전 | 0

| 수락됨

답변 있음
spliting date and time strings in a table
If all you want is strings, Azzi's answer works. But you may find the following more useful. Given this file: timestamp,x ...

10년 초과 전 | 1

답변 있음
Create a table from symbolic vectors
Farid, tables are meant to store "column-oriented heterogeneous data". That's not what you have, or at least not in your example...

10년 초과 전 | 0

답변 있음
Cell Dates to Timestamp conversion
In MATLAB R2014b or later, using datetime: >> c = {'6/24/2015' '8:33:49'; '6/24/2015' '8:33:48'} c = '6/24/2015'...

거의 11년 전 | 0

| 수락됨

답변 있음
How to extract the timestamp value and an integer value from an excel file?
If you're using R2014b or later, you can read dates and numbers into a table: >> readtable('ACTUAL_testing1.csv','Format','...

거의 11년 전 | 0

답변 있음
How to shift date-time variable to a common start-date/time
Just for the record, this >> common_date = datetime(14,1,1,0,0,0) common_date = 01-Jan-0014 00:00:00 >> actual...

거의 11년 전 | 1

답변 있음
datenum - Parse ISO 8601 timestamp without applying UTC offset
Randall, this is indeed a bug, albeit for inputs that were never documented to work. Prior to R2013b, this generated an error. A...

거의 11년 전 | 1

답변 있음
Select specific data from all fields in structure
Michiel, this doesn't answer your question directly, but may be of some help if you have a version of MATLAB from R2013b on. ...

거의 11년 전 | 0

답변 있음
how to create table and export it to Excel?
Alternatively, >> v1 = [1 2 3 4 5]'; v2 = [6 7 8 9 10]'; v3 = [11 12 13 14 15]'; >> t = table(v1,v2,v3) t = v...

거의 11년 전 | 3

답변 있음
Find elements in table without looping (Matlab)
First convert those highly repetitive strings to a categorical variable: table1.Var1 = categorical(table1.Var1); Type wh...

거의 11년 전 | 1

답변 있음
How do I use indexing to create discrete column vectors for a large data set?
Christopher, your sample data is different than your original example. I'm gonna go with the first (mostly because I don't reall...

거의 11년 전 | 0

답변 있음
how to count values within a time range?
If you have R2014b or later, here's another possibility using datetime: % set up some random data >> y = 2015; mo = 1; d...

거의 11년 전 | 0

답변 있음
Why slow conversion from date in Matlab time to day of year?
In R2014b or later, use datetime. On a not particularly fast Win7 machine: >> timeGmt = '1-Jan-1996':hours(1):datetime('now...

거의 11년 전 | 0

답변 있음
Conversion serial date back to calender dates in string format.
In R2014b or later, using table and datetime, this becomes: data = readtable('1201b.txt','Format','%{yyyy-MM-dd HH:mm:ss}D%...

거의 11년 전 | 1

답변 있음
setting default date and time format in R2015a ?
As Walter says, date is from the set of older functions that include datenum, datestr, and datevec. datetime was introduced in R...

거의 11년 전 | 0

답변 있음
Problem reading from a table using MATLAB v14
I suspect that rather than [RowID(ix,2) RowID(ix,3)] you want RowID{ix,2:3} As it is, it looks like you're using...

거의 11년 전 | 0

| 수락됨

답변 있음
This seems like a bug in the 'categorical' class
Michael, thanks for reporting this. Not sure what version of MATLAB you're using, but this was fixed in R2014b: >> categori...

거의 11년 전 | 0

| 수락됨

답변 있음
Plotting dates on x-axis
An alternative to Star Strider's suggestion, if you are using MATLAB R2014b or later, would be plot(datetime(datecell),y) ...

거의 11년 전 | 2

답변 있음
How to display more than 3 elements per column using the Matlab "table" command?
bayleaf, there's not currently any way to do that, other than splitting the four (or more) columns into separate variables in th...

거의 11년 전 | 0

답변 있음
array splits into more variables when reading from table
This is documented behavior of writetable. Can you not simply combine them back after reading? For example: data.Positions ...

거의 11년 전 | 0

답변 있음
how to filter a table by the dataset of another table
You probably need to give a concrete example of your data and your desired result, but in general terms, you can use the interse...

거의 11년 전 | 0

답변 있음
how do I plot time data (recorded in secods) in hh:mm:ss format?
If you're using MATLAB R2014b or later, one of these is what you're looking for: 1) plot the actual elapsed times as hh:mm:ss...

거의 11년 전 | 1