Answered
How to create a matrix, table or a cell where in odd columns variables from matrix A and in even columns variabls from matrix B will be stored?
This should work for numeric, cell and table, although Adam's is likely more efficient for numeric: >> x1 = array2table(ran...

8 years ago | 0

| accepted

Answered
How to effectively assign values to different location in a TABLE?
This question is really unclear. The best I can guess is that you want to assign S into specified rows of one variable in a tabl...

8 years ago | 2

| accepted

Answered
Is there any function that similar like CELLFUN, for a TABLE Dataype
It's not clear what you code is doing, or what you're using the output for. It appears that your code is finding rows of an Nx3 ...

8 years ago | 0

Answered
How can I write a table from a matrix?
Perhaps the most straight-forward thing to use to get a table with 30891(=30888+3) variables in it would be t = [table(year...

8 years ago | 0

Answered
Subscripted assignment dimension mismatch for table variable
t2 is a cable all of whose variables are cell arrays. That's almost certainly not what you want. Assigning one row at a time ...

8 years ago | 1

Answered
How to subtract time in million second precision?
It might also be worth noting that since you already have the time as a separate thing, you can also do this: >> t1 = durat...

8 years ago | 1

Answered
Identify and fill missing time gaps with NaN
There's a lot going on here, much of it due, as Walter says, to the way that datenums represent time: counting _days_ since a lo...

8 years ago | 1

Answered
how to add datetime variable to a bar graph
Starting from R2016b, plotting supports datetimes much more widely, and natively. So >> d = datetime(2017,1:10,1); >> x...

8 years ago | 0

Answered
How to add values to a column based on time column and its own column?
If your screen shot example is really all you want to do, then it's this: i = find(tt.Interval > 0); tt.Interval(i:end) ...

8 years ago | 0

| accepted

Answered
plotting epoch time with nanoseconds
You say, "with nanoseconds", but in fact what you show is not out to nanosecond precision, only to microsecond. Which is good, ...

8 years ago | 1

Answered
how to add increments to time
You are showing text. A timetable's row times are not text, they would be (in your case) datetimes. retime is the way to sync...

8 years ago | 0

Answered
How do I take a large table, split it into smaller chunks, and add them to a new table?
Another possibility: use repelem to create a variable in the table that indicates the group number. Then call varfun, using that...

8 years ago | 0

Answered
financial time series time with milliseconds
Unless you're using a pretty old version of MATLAB, you should consider using readtable. For example, using R2017a, >> t = ...

8 years ago | 0

Answered
Comparing datetime value from two tables
One of your data files contains daily data with holes, the other contains irregular data of much higher frequency. The only two ...

8 years ago | 1

Answered
Using timetable column values in loop control?
Your description is not entirely clear to me, especially your gola, but this should get you started. It sounds like you need to ...

8 years ago | 0

Answered
Change table variable data type
readtable also accepts a Format parameter that would allow you to override the automatic type detection.

8 years ago | 0

Answered
How do I import a timestamp from Excel/csv?
The best way to do this in a recent version of MATLAB is to use readtable, and create datetimes. This will free you from all the...

8 years ago | 1

Answered
Group data in one table to analyze data by set intervals in another table
The fact that you have discontiguous length bins makes this more complicated than it otherwise would be. There are several ways ...

8 years ago | 1

| accepted

Answered
Matlab Table / Dataset type optimization
Victor, you are stating your problem as if you must always use either one or the other. As already discussed on a couple of othe...

8 years ago | 1

Answered
Mersenne Twister RNG init_by_array
The "array" you are talking about is typically a state vector, right? You can set the generator state: >> r = RandStream.ge...

8 years ago | 0

Answered
Convert minute date (stock data) to matlab from .csv
Try this: >> d = datetime(2017,06,12,13,31,60*sort(rand(10000,1)),'Format','dd-MM-yyyy HH:mm:ss.SSS'); >> x = randn(size...

8 years ago | 0

Answered
Convert minute date (stock data) to matlab from .csv
If you are using a recent version of MATLAB, R2014b or later, it's likely you will be much happier using datetimes, rather than ...

8 years ago | 0

| accepted

Answered
I would like to know how to attribute variable names in a Table
Walter's answer is correct, but if you are able to create all those vectors as columns, not rows, then T = table(media, des...

8 years ago | 0

Answered
Temperature vs time plot
You are likely to be much happier using readtable than textscan. Given that you've used '%D %s' as the format, your temperatures...

8 years ago | 0

Answered
How to calculate and represent the mean values of many distincts time series?
As dpb says, hard to guess. If you do mean, "the 30 series all have the same sample times, and I want to compute the mean of the...

8 years ago | 0

Answered
How do I manipulate data from a csv datafile containing date, time and number data?
Your file has date and time in two separate fields. Depending on what version of MATLAB you're using, the table that readtable r...

8 years ago | 1

Answered
How to insert missing dates for forenoon(F) and afternoon(A)?
If you are using R2016b or later, this is easily done by reading the spreadsheet into a table using readtable, converting to a t...

8 years ago | 0

Answered
Convert vector of datenum values to datetime values
There's actually a direct conversion, once you lose the cell array: vec = cell2mat(b(:,1)); datetime(vec,'ConvertFrom','...

8 years ago | 1

Answered
Why are the ticks of the datetick function unevenly spaced
You say "unevenly spaced", by which I think you mean, "the ticks are labelled at sometimes two and sometimes three year interval...

8 years ago | 0

Answered
How can I create a time series with this data?
Javier, if you have R2016b or later, you might take a look at timetables, as an alternative to timeseries.

9 years ago | 1