Answered
Create a table with Revenue by financial year such as 2017-18
I'm a little late to the party, but here's a version using rowfun and unstack. It doesn't require "balanced data", but maybe dpb...

7 years ago | 1

Answered
Shifting table entries based on criteria
This is in general a complicated question. You might have noisy data. You might have two different sample rates. It looks like m...

7 years ago | 0

| accepted

Answered
Remove rows from table when number in cell array is above certain value
I suggest you try using a categorical variable: >> test_table.Var1 = categorical(test_table.Var1,{'A-01' 'A-02' 'A-03'},'Ordina...

7 years ago | 0

Answered
convert .xlsx file into a timetable
readtable + table2timetable. If you are very up to date (R2019a), use readtimetable.

7 years ago | 2

Answered
Current system time as a Timestamp
This is an old post the got reopened. I feel compelled to say that in anything like recent versions of MATLAB, datetime('now') i...

7 years ago | 1

Answered
How to input a file and write timestamp of 2ms difference in to csv
It's not clear to me what your question really is, or how far you have gotten. The answer to your specific question about creati...

7 years ago | 1

Answered
WHY DATE CANNOT TRANSFER FROM EXCEL TO MATLAB BY XLSREAD?
As SS says, in recent versions of MATLAB, readtable should give you a table with a datetime and a duration for those columns in ...

7 years ago | 1

Answered
Finding average using two input condition from a table
Several ways to do this, including findgroups/splitapply, groupsummary, and varfun: >> XYZ = [ ... 1 1800 1.5 2 1900 ...

7 years ago | 0

| accepted

Answered
Obtaining contents of a column in a table corresponding to specific contents of another column in the same table
The original question you've asked only vaguely matches your second description of, "I wished to obtain values of col1 correspon...

7 years ago | 0

Answered
Inserting Timestamp into a Matrix
I'm gonna take a wild guess, because there's very little to go on here. I'm gonna guess you have format short, and you have a m...

7 years ago | 0

Answered
Reading in csv data with separate columns of dates and times into MATLAB R2017b.
Timothy, I'm on a newer version of MATLAB and readtable has "moved ahead", but I think this is close enough to what you want to ...

7 years ago | 1

Answered
How to get hourly mean values for each table ?
Matthew, I really can't tell what you are asking for, you need to give a short, clear example. retime on a timetable may be wha...

7 years ago | 0

Answered
how to create a time victor ?
How would you create any vector that long in MATLAB? You'd probably use the colon operator. Do that with time values. Pick your ...

7 years ago | 0

Answered
Comparing two tables and copy elements of table 2 into table 1
This is just an outer join: >> T1 = table(["hello";"new";"world";"hi";"hello";"hi"],[1;2;3;5;8;7],'VariableNames',["Word" "V"])...

7 years ago | 0

Answered
How do I compute 3 minute moving average in timeseries?
If you mean, "means for each 3-minute time window", consider using a timetable and the retime function. If you mean, "means at e...

7 years ago | 2

Answered
Error using table (line 253) All variables must have the same number of rows.
Psi0 = array2table(psi0(:,[1 6 11 16 21 16]) would have been helpful for this. And then addvars to add step at the beginning.

7 years ago | 0

Answered
Tables: Transform Variablenames
It's easy to turn 'x2_28_2019' into a datetime, that's just >> datetime('x2_28_2019','InputFormat','''x''MM_dd_yyyy') ans = ...

7 years ago | 0

| accepted

Answered
time string into seconds
I think StarStrider and Walter have already answered this, but in case things are not clear. Start from some text timestamps, ma...

7 years ago | 0

Answered
Adding start date to timestamps
Oliver, it's not 100% clear what you have, but I think this will do what you want. The main issue is, I guess, that your spreads...

7 years ago | 0

| accepted

Answered
create table that count the composition of two categories.
This is almost an unstack operation. It may be that all you want is a nice summary output, not sure. But often this kind of thin...

7 years ago | 1

Answered
How to assign integers to each element in a table that has repeated elements?
Kevin, you really don't want to make a char array to store those names. Unless you have a pretty old version of MATLAB, use a st...

7 years ago | 0

| accepted

Answered
How to merge two interleaving time series?
Larissa, I strongly suggest that you convert those datenums to datetimes (or durations? not sure, not enough information from yo...

7 years ago | 1

| accepted

Answered
I have data with dates and times in separte columns. How do I put them together into a datetime format?
Timothy, in recent versions of MATLAB (since R2018a, IIRC), readtable should read those two columns as a datetime and a duration...

7 years ago | 0

| accepted

Answered
splitting the date in the same line to three variables
Depe3nding on whether you have numeric (ads in your OP) or text (as in your comment): >> start_date = 20110101; >> d = datetim...

7 years ago | 0

Answered
Error using time date table
>> tt = timetable(rand(5,1),'RowTimes',datetime('now')+sort(hours(rand(5,1)))) tt = 5×1 timetable Time ...

7 years ago | 0

Answered
How to sum over grouped data in a table
It seems more likely that you would want the sum for each group in a table with one row for each group. There are several simple...

7 years ago | 1

Answered
Filter a table by 2 columns
Orongo, do this: T.Gender = categorical(T.Gender); Then this Tsmokermale=(T.Smoker==true| T.Gender=='Male'); works as you ex...

7 years ago | 2

Answered
How to calculate the change between periods using the timetable object
Hard to know what you mean, but maybe you are looking for diff? Perhaps something like TT.Change = [NaN; diff(TT.X)]

7 years ago | 0

| accepted

Answered
How to add a date array in a table?
Your question is not at all clear, but I suggest you take a look at durations (and/or datetimes) and timetables.

7 years ago | 0

Answered
Splitting up large amount of data into smaller tables based on one coloumn
You have not said why you want to do that, but in general, you DON'T want to split one table up into lots of tables. You will us...

7 years ago | 0