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

alrededor de 8 años hace | 0

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

alrededor de 8 años hace | 0

| aceptada

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

alrededor de 8 años hace | 0

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

alrededor de 8 años hace | 0

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

alrededor de 8 años hace | 0

Respondida
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'}) ...

alrededor de 8 años hace | 0

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

alrededor de 8 años hace | 1

Respondida
"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...

alrededor de 8 años hace | 0

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

alrededor de 8 años hace | 0

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

alrededor de 8 años hace | 1

Respondida
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:...

alrededor de 8 años hace | 0

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

alrededor de 8 años hace | 0

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

alrededor de 8 años hace | 0

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

alrededor de 8 años hace | 0

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

alrededor de 8 años hace | 4

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

alrededor de 8 años hace | 1

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

alrededor de 8 años hace | 0

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

alrededor de 8 años hace | 0

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

alrededor de 8 años hace | 2

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

alrededor de 8 años hace | 1

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

alrededor de 8 años hace | 0

Respondida
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

alrededor de 8 años hace | 0

| aceptada

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

alrededor de 8 años hace | 0

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

alrededor de 8 años hace | 0

| aceptada

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

alrededor de 8 años hace | 0

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

alrededor de 8 años hace | 0

| aceptada

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

alrededor de 8 años hace | 0

| aceptada

Respondida
How can I concatenating 2 table
You want outerjoin.

alrededor de 8 años hace | 0

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

alrededor de 8 años hace | 0

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

alrededor de 8 años hace | 0

Cargar más