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

alrededor de 7 años hace | 1

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

alrededor de 7 años hace | 0

| aceptada

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

alrededor de 7 años hace | 0

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

alrededor de 7 años hace | 2

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

alrededor de 7 años hace | 1

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

alrededor de 7 años hace | 1

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

alrededor de 7 años hace | 1

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

alrededor de 7 años hace | 0

| aceptada

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

alrededor de 7 años hace | 0

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

alrededor de 7 años hace | 0

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

alrededor de 7 años hace | 1

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

alrededor de 7 años hace | 0

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

más de 7 años hace | 0

Respondida
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"])...

más de 7 años hace | 0

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

más de 7 años hace | 2

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

más de 7 años hace | 0

Respondida
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 = ...

más de 7 años hace | 0

| aceptada

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

más de 7 años hace | 0

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

más de 7 años hace | 0

| aceptada

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

más de 7 años hace | 1

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

más de 7 años hace | 0

| aceptada

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

más de 7 años hace | 1

| aceptada

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

más de 7 años hace | 0

| aceptada

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

más de 7 años hace | 0

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

más de 7 años hace | 0

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

más de 7 años hace | 1

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

más de 7 años hace | 2

Respondida
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)]

más de 7 años hace | 0

| aceptada

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

más de 7 años hace | 0

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

más de 7 años hace | 0