Answered
How do I: Create a table using a Query on a Larger Table
A couple things: * I think the short answer is that you just want a | (vertical bar) rather than a &, right? You could also u...

8 years ago | 0

Answered
How to extract specific rows from big data table.(87000x35)
In addition to what othjers have suggested, it's almost certain that you want to convert the machine status to a categorical var...

8 years ago | 0

Answered
How to add column values of different tables based on dates column
I think 'sum', as in "the input to retime or synchronize", is a red herring here. That parameter sums across time. Assuming you'...

8 years ago | 0

Answered
How to extract table data using function variable?
Daniel, I'm not exactly sure what you are asking, but i think the following might help. All of these kinds of "dot subscripting"...

8 years ago | 0

Answered
Plot financial data continuously in time
dpb is correct that you can't do this with a datetime ruler. But you can get what you want, at least in a static version. It won...

8 years ago | 1

| accepted

Answered
Format table with frequency of unique combination
This is the classic application of unstack, with the subtlety that you aren't actually unstacking the data, you're counting inst...

8 years ago | 1

| accepted

Answered
How to create a column (in a table) of percent best for multiple ARMA-GARCH specifications
Certainly you can find the lowest error for each asset using varfun with asset as the grouping variable. I'm not really understa...

8 years ago | 0

Answered
how can I convert EST time to GMt time?
Unless you are using a version of MATLAB prior to R2014b, you probably should not be using datevecs. Convert them to datetimes. ...

8 years ago | 0

Answered
How can i split time series by hour
If you are using R2016b or later, this is straight-forward with timetables. If your goal is really just to read an Excel file an...

8 years ago | 0

Answered
Count occurrences of an event by date
If you have R2016b or later, this is one line, using a timetable. Given this timetable ... >> d = datetime({'1/1/2001';'1/1...

8 years ago | 1

Answered
determine index of a value (monthly) from excel table
If you are using R2016b or later, use a timetable, and call retime to compute a monthly mean. Even prior to 16b, you should use ...

8 years ago | 0

| accepted

Answered
I have a nc file with 145 long, 129 lat and 10227 time values, I want to change this daily data (10,227) to monthly values. What could be easy way?
This seems like it could be easily solved using retime on a timetable, but there's not enough information in you post to go on.

8 years ago | 0

Answered
How to replace NaN in tables?
You should look at ismissing, fillmissing, rmmissing, and at the various options in readtable and detectimportoptions.

8 years ago | 0

Answered
How to delete certain rows of a table based on time
Another similar way: >> eightTwentyFive = duration(8,25,0) eightTwentyFive = duration 08:25:00 >> nineOCl...

8 years ago | 0

Answered
Finding category/string in table and converting values
Don't do that. Assume T is your data stored in a table containing a categtorical variable named SomeVarName whose categories are...

8 years ago | 0

| accepted

Answered
Determine distance between point from a data table
It sounds like maybe you used readtable. For the kind of calculation you're doing, I imagine you'll need a numeric array. Simple...

8 years ago | 0

Answered
How to separate a data set into multiple tables sorted by a specific variable
If you are using R2016b or later, you probably want to be using timetables instead of cell arrays. Especially if your data are a...

8 years ago | 1

| accepted

Answered
Last Sunday in a month?
Unless you are using a version of MATLAB prior to R2014b, use datetimes for dates, not numbers: >> d = dateshift(datetime(2...

8 years ago | 1

Answered
Define Variable Names in a double
Tiago, again, I really recommend that you look at the documentation for table subscripting. You will likely find that dot subscr...

8 years ago | 1

Answered
How can i align a column in a table?
Ioannis, it sounds like you are looking for output that's suitable for, say, putting in a report. The table command window displ...

8 years ago | 0

Answered
I want to read in an Excel table with heterogeneous data types
Julian, Brandon's suggestions fo detectImportOptions and the Import Tool are good ones, but if all your spreadsheet has in it is...

8 years ago | 0

Answered
Use retime() to resample to fractional seconds?
If you are working in sub-second resolutions, probably best to use the milliseconds function, rather than seconds, for anything ...

8 years ago | 0

Answered
segregate table in mat lab
Simple solution posted in reply to your identical double post.

8 years ago | 0

| accepted

Answered
How can I expand a table row variable array into multiple table rows
Time to go old school: >> s(1).id = "a"; s(1).datatype = "this"; s(1).val = (1:34)'; >> s(2).id = "b"; s(2).datatype = "...

8 years ago | 1

Answered
split table in mat lab with respect to row values
It's hard to know what you are trying to do, but I'm guessing you want to split up a table, by rows, based on one of the variabl...

8 years ago | 2

Answered
Add newer data to older data without repetition
If you are using R2016b or later, you may find that using timetables is convenient. For example, union works the same way as wha...

8 years ago | 0

Answered
comparing datetime from two different files
It's very likely that what you describe can be done in one line of code, using timetables and the synchronize function. For exam...

8 years ago | 1

Answered
Maximum value of a vector during specified intervals of time
If you are using R2016b or later, use timetables: >> Date = datetime(1929,1,1:32142)'; >> Discharge = cumsum(randn(size(...

8 years ago | 0

Answered
How Can i get MATLAB to plot date on x-axis?
Since R2014b: d = datetime(2015,9,1,0:6:17544,0,0); x = cumsum(randn(size(d))); plot(d,x) <</matlabcentral/answers...

8 years ago | 0

Answered
How to specify a date string format when using xlsread from Excel?
Katherine, consider using readtable instead of xlsread. In recent versions, importing dates is much simpler than using xlsread.

8 years ago | 0