Answered
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 years ago | 0

Answered
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 years ago | 0

| accepted

Answered
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 years ago | 0

Answered
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 years ago | 0

Answered
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 years ago | 0

Answered
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 years ago | 0

Answered
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 years ago | 1

Answered
"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 years ago | 0

Answered
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 years ago | 0

Answered
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 years ago | 1

Answered
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 years ago | 0

Answered
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 years ago | 0

Answered
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 years ago | 0

Answered
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 years ago | 0

Answered
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 years ago | 4

Answered
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 years ago | 1

Answered
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 years ago | 0

Answered
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 years ago | 0

Answered
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 years ago | 2

Answered
Replace 0 with nans in a table
The standardizemissing function should get you started.

8 years ago | 1

Answered
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 years ago | 0

Answered
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 years ago | 0

| accepted

Answered
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 years ago | 0

Answered
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 years ago | 0

| accepted

Answered
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 years ago | 0

Answered
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 years ago | 0

| accepted

Answered
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 years ago | 0

| accepted

Answered
How can I concatenating 2 table
You want outerjoin.

8 years ago | 0

Answered
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 years ago | 0

Answered
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 years ago | 0