답변 있음
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...

7년 초과 전 | 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 ...

7년 초과 전 | 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 ...

7년 초과 전 | 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...

7년 초과 전 | 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...

7년 초과 전 | 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'}) ...

7년 초과 전 | 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