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

etwa 8 Jahre vor | 0

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

etwa 8 Jahre vor | 0

| akzeptiert

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

etwa 8 Jahre vor | 0

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

etwa 8 Jahre vor | 0

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

etwa 8 Jahre vor | 0

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

etwa 8 Jahre vor | 0

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

etwa 8 Jahre vor | 1

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

etwa 8 Jahre vor | 0

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

etwa 8 Jahre vor | 0

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

etwa 8 Jahre vor | 1

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

etwa 8 Jahre vor | 0

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

etwa 8 Jahre vor | 0

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

etwa 8 Jahre vor | 0

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

etwa 8 Jahre vor | 0

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

etwa 8 Jahre vor | 4

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

etwa 8 Jahre vor | 1

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

etwa 8 Jahre vor | 0

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

etwa 8 Jahre vor | 0

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

etwa 8 Jahre vor | 2

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

etwa 8 Jahre vor | 1

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

etwa 8 Jahre vor | 0

Beantwortet
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

etwa 8 Jahre vor | 0

| akzeptiert

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

etwa 8 Jahre vor | 0

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

etwa 8 Jahre vor | 0

| akzeptiert

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

etwa 8 Jahre vor | 0

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

etwa 8 Jahre vor | 0

| akzeptiert

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

etwa 8 Jahre vor | 0

| akzeptiert

Beantwortet
How can I concatenating 2 table
You want outerjoin.

etwa 8 Jahre vor | 0

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

etwa 8 Jahre vor | 0

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

etwa 8 Jahre vor | 0

Mehr laden