답변 있음
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년 전 | 1

답변 있음
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년 전 | 0

| 수락됨

답변 있음
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년 전 | 0

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

거의 7년 전 | 2

답변 있음
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년 전 | 1

답변 있음
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년 전 | 1

답변 있음
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년 전 | 1

답변 있음
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년 전 | 0

| 수락됨

답변 있음
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년 전 | 0

답변 있음
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년 전 | 0

답변 있음
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년 전 | 1

답변 있음
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년 전 | 0

답변 있음
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년 전 | 0

답변 있음
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년 전 | 0

답변 있음
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년 전 | 2

답변 있음
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년 전 | 0

답변 있음
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년 전 | 0

| 수락됨

답변 있음
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년 전 | 0

답변 있음
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년 전 | 0

| 수락됨

답변 있음
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년 전 | 1

답변 있음
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년 전 | 0

| 수락됨

답변 있음
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년 전 | 1

| 수락됨

답변 있음
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년 전 | 0

| 수락됨

답변 있음
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년 전 | 0

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

거의 7년 전 | 0

답변 있음
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년 전 | 1

답변 있음
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년 전 | 2

답변 있음
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년 전 | 0

| 수락됨

답변 있음
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년 전 | 0

답변 있음
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년 전 | 0