Answered
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 years ago | 0

Answered
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 years ago | 1

Answered
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 years ago | 2

| accepted

Answered
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 years ago | 3

| accepted

Answered
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 years ago | 1

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

11 years ago | 0

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

11 years ago | 2

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

11 years ago | 3

Answered
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(...

11 years ago | 0

| accepted

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

11 years ago | 1

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

11 years ago | 0

Answered
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 years ago | 0

| accepted

Answered
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 years ago | 0

Answered
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 years ago | 1

Answered
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 years ago | 1

Answered
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 years ago | 0

Answered
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 years ago | 3

Answered
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 years ago | 1

Answered
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 years ago | 0

Answered
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 years ago | 0

Answered
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 years ago | 0

Answered
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 years ago | 1

Answered
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 years ago | 0

Answered
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 years ago | 0

| accepted

Answered
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 years ago | 0

| accepted

Answered
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 years ago | 2

Answered
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 years ago | 0

Answered
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 years ago | 0

Answered
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 years ago | 0

Answered
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 years ago | 1