回答済み
Create new matrix by date/time
The answer depends on what version of MATLAB you have. In recent versions, if you use readtable, that date column in the spreads...

8年弱前 | 0

回答済み
How can I clear an entire table column without deleting the variable?
The short answer is to just overwrite the entire variable: t.P = NaN(size(T.P)) You could also overwrite every element ...

8年弱前 | 0

| 採用済み

回答済み
How to change table dimensions by ordering by column values?
Not clear how you need to use your result, but this is exactly what unstack does: t = 15×3 table Var1 Var2 ...

8年弱前 | 0

回答済み
How a large timetable (10 million rows by 15 columns) could be modified to a smaller table?
This looks like an application of unstack. Not sure what you'll be doing with that table, so I can't say if that "wide" versi...

8年弱前 | 0

回答済み
How can I fill in cells of a table with cells of another table while the two tables do not share the same number of rows?
This is solvable using timetables and synchronize, if I understand the question correctly: >> tt1 = timetable(rand(10,1),'R...

8年弱前 | 0

回答済み
Get index of table column
I guess you have a table like this: >> t = array2table(rand(10,6),'VariableNames',{'A_X' 'A_Y' 'A_Z' 'B_X' 'B_Y' 'B_Z'}) ...

8年弱前 | 0

回答済み
how to find the data for same period of time ?
It may be that join on timetables is the way to go here. >> load('distro-data.mat') >> load('MRRarranged.mat') >> tt1...

8年弱前 | 1

回答済み
"Locale" issue. Danish created-date extracted from file
Specifying the locale would work: >> datetime('11-maj-2018 15:39:22','Locale','da_DK') ans = datetime 11-May...

8年弱前 | 0

回答済み
How Can I traspose value from a table?
It's not clear what you are starting with. If you have a table, it's not clear what the one variable in it is. But if you are st...

8年弱前 | 0

回答済み
How to use a loop with datetime and store the datetime values?
I'm a bit late to this party, but isn't it just this? >> dt = datetime(2001,1,2:5); >> et = hours(9:12)'; >> t = repm...

8年弱前 | 1

回答済み
converting a date column with yyyymmdd to matlab date number?
Danielle, you may have your reasons for wanting a datenum, but I'd suggest using datetime, for which there's an easy conversion:...

8年弱前 | 0

回答済み
I have 10 .txt files. In each of these files I have a column of datetime and another column for data. I want to generate a sequence of datetime for the next 500 months for eahc file
There's not a lot to go on here. Presumably you will want to read in a file, do somethign in MATLAB, and then write out another ...

8年弱前 | 0

回答済み
How do I take a small array, keyed by a datetime variable which is a subset of a larger array and replace the values in the larger array with the values from the smaller array?
The answer might be join, or maybe outerjoin. It might also be synchronize. It's hard to tell from your question.

8年弱前 | 0

回答済み
Problems with financial timetable
You don't say how you got this table, but likely you read a file that has non-numeric junk in some fields on some rows, and that...

8年弱前 | 0

回答済み
HELP: Find All Rows of a table which meet a specific condition
Convert thos variables to categorical, something like alldata.HOMETOWNS = categorical(alldata.HOMETOWNS); Then i = ...

8年弱前 | 4

回答済み
How do I store values from a for loop into a table?
Or perhaps yourdesiredtable = array2table(zeros(89, 41)); for i = 1:41 %calculate something yourdesiredtable...

8年弱前 | 1

回答済み
Repeating table calculations using pairs of columns
It's likely this can be solved using varfun. That takes a function handle and a table and applies the function to each variable ...

8年弱前 | 0

回答済み
Synchronize two timetables with millisecond precision
As Walter says, the ms thing is just a display format issue. You say you are starting out with ms-resolutiuon data, and you w...

8年弱前 | 0

回答済み
how to have a loop if for a column in a table
Ameer's solution works, but arrayfun is really not needed: words = {'nok', 'ok'}; table.newColumn = words(table.column>n...

8年弱前 | 2

回答済み
Replace 0 with nans in a table
The standardizemissing function should get you started.

8年弱前 | 1

回答済み
Separate all data from table by date
Debbie, Ameer's solution answers your question, but you should ask yourself why you want to split your data up. There are lots o...

8年弱前 | 0

回答済み
So I need to sort a time data out. First I have a column of data e.g 24401 means 244th days and 01 means the first 30 minutes. So in one day I have 48 data and I have a month full of time. How can I convert the time into hours To show on graph easier
I would think that you would just do this: >> .5*(x - 100*(round(x/100))) ans = 0.5 24

8年弱前 | 0

| 採用済み

回答済み
plotting dates over continuous numeric data
If you have this >> x = [0 28 56 91 119] x = 0 28 56 91 119 why not just plot your y values agains...

8年弱前 | 0

回答済み
How do I get matlab to read a string of dates and times
In recent versions of MATLAB, readtable will read dates/times from a spreadsheet automatically, assuming that the aspreadsheet i...

8年弱前 | 0

| 採用済み

回答済み
Sort Timetable from May to April
As Ameer says, you can simply reorder the rows of the table, and if your table only ever has 12 rows, that's probably the way to...

8年弱前 | 0

回答済み
datetime input format from windows settings?
The short answer is no. There may be some way to bang out to the system and get that setting, but you also have the challenge of...

8年弱前 | 0

| 採用済み

回答済み
Is there a way to calculate the mean of multiple data points at one time stamp of a time series?
Depending on what you have, it can be as easy as retime(tt,tt.Time,'mean'); where tt is a timetable.

8年弱前 | 0

| 採用済み

回答済み
How can I concatenating 2 table
You want outerjoin.

8年弱前 | 0

回答済み
How can I use custom date labels for my x-axis in MATLAB plots?
In recent versions of MATLAB, don't use datenum or datetick for plotting vs. time. Use datetimes. Then set the XTick and/or XTic...

8年弱前 | 0

回答済み
How to plot a datetime contained in a cell array
Walter, your code won't create datetime variabels at all. What it may create is a cell array of text timestamps. In recent ve...

8年弱前 | 0