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

mehr als 7 Jahre vor | 1

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

mehr als 7 Jahre vor | 0

| akzeptiert

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

mehr als 7 Jahre vor | 0

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

mehr als 7 Jahre vor | 2

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

mehr als 7 Jahre vor | 1

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

mehr als 7 Jahre vor | 1

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

mehr als 7 Jahre vor | 1

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

mehr als 7 Jahre vor | 0

| akzeptiert

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

mehr als 7 Jahre vor | 0

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

mehr als 7 Jahre vor | 0

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

mehr als 7 Jahre vor | 1

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

mehr als 7 Jahre vor | 0

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

mehr als 7 Jahre vor | 0

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

mehr als 7 Jahre vor | 0

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

mehr als 7 Jahre vor | 2

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

mehr als 7 Jahre vor | 0

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

mehr als 7 Jahre vor | 0

| akzeptiert

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

mehr als 7 Jahre vor | 0

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

mehr als 7 Jahre vor | 0

| akzeptiert

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

mehr als 7 Jahre vor | 1

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

mehr als 7 Jahre vor | 0

| akzeptiert

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

mehr als 7 Jahre vor | 1

| akzeptiert

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

mehr als 7 Jahre vor | 0

| akzeptiert

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

mehr als 7 Jahre vor | 0

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

mehr als 7 Jahre vor | 0

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

mehr als 7 Jahre vor | 1

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

mehr als 7 Jahre vor | 2

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

mehr als 7 Jahre vor | 0

| akzeptiert

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

mehr als 7 Jahre vor | 0

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

mehr als 7 Jahre vor | 0