Respondida

Multiply and integrate two plots for single output value

Any time the number 365 appears in code, thatr's probably a bug. You might try to use datetimes and durations in your code, inc...

Multiply and integrate two plots for single output value

Any time the number 365 appears in code, thatr's probably a bug. You might try to use datetimes and durations in your code, inc...

más de 1 año hace | 0

Respondida

Extract SST data in a polygon from average monthly netcdf file

Simbarashe, readtable and readmatrix read your file just fine, so I don't think that's the issue: >> sst2 = readmatrix("sst2.tx...

Extract SST data in a polygon from average monthly netcdf file

Simbarashe, readtable and readmatrix read your file just fine, so I don't think that's the issue: >> sst2 = readmatrix("sst2.tx...

más de 1 año hace | 0

| aceptada

Respondida

Model calibration for different dates

I would think that the best way to do this would be to put your data into a timetable, and use the rowfun function with the date...

Model calibration for different dates

I would think that the best way to do this would be to put your data into a timetable, and use the rowfun function with the date...

más de 1 año hace | 0

Respondida

How to get a sum of coloumnn linked to datetime?

Create a timetable from your data, and use retime to aggregate it to monthly. It's one line of code.

How to get a sum of coloumnn linked to datetime?

Create a timetable from your data, and use retime to aggregate it to monthly. It's one line of code.

casi 2 años hace | 1

| aceptada

Respondida

How do I pull data between specific dates like Vlookup formula in Excel?

As Walter says, uses a timetable. >> tt = readtimetable("sampledata_uyyk.csv") [some warnings removed] >> tt = convertvars(tt...

How do I pull data between specific dates like Vlookup formula in Excel?

As Walter says, uses a timetable. >> tt = readtimetable("sampledata_uyyk.csv") [some warnings removed] >> tt = convertvars(tt...

casi 2 años hace | 0

Respondida

date and time string identification

"I have the following information obtained from a text-file date_hne: {'2014' '04' '01' '23' '46' '44.998300'}" I don't s...

date and time string identification

"I have the following information obtained from a text-file date_hne: {'2014' '04' '01' '23' '46' '44.998300'}" I don't s...

casi 2 años hace | 0

Respondida

how to convert hours and minutes from decimals to datetime objects

Converting to string is totally unnecessary. Assuming the first variable in the table is already a datetime: >> t = datetime(20...

how to convert hours and minutes from decimals to datetime objects

Converting to string is totally unnecessary. Assuming the first variable in the table is already a datetime: >> t = datetime(20...

casi 2 años hace | 1

| aceptada

Respondida

Effect of os clock change on timers

cr, this was a bug in earlier releases, and got fixed in R2021a.

Effect of os clock change on timers

cr, this was a bug in earlier releases, and got fixed in R2021a.

casi 2 años hace | 2

| aceptada

Respondida

Live Editor: Brace indexing changes Table to Struct

You can certainly post something like the table you have. In any case, if A is a table, then A.all is a variable in that table....

Live Editor: Brace indexing changes Table to Struct

You can certainly post something like the table you have. In any case, if A is a table, then A.all is a variable in that table....

casi 2 años hace | 0

Respondida

How can I delete some specific rows from a matrix?

Surely you don't just have a list of dates. Presumably you have data at each date. Use a timetable to store all that. At that p...

How can I delete some specific rows from a matrix?

Surely you don't just have a list of dates. Presumably you have data at each date. Use a timetable to store all that. At that p...

casi 2 años hace | 1

Respondida

Select column in timetable based on value in table

Two steps: 1) Find the nearest sensor. This easy using interpolation: >> load("SL.mat") >> load("SensorLoc.mat") >> SensorLo...

Select column in timetable based on value in table

Two steps: 1) Find the nearest sensor. This easy using interpolation: >> load("SL.mat") >> load("SensorLoc.mat") >> SensorLo...

casi 2 años hace | 0

| aceptada

Respondida

Is it possible to use vertcat with dot notation?

Depending on what you are doing, you may find it convenient to turn that struct into a table (which wil automatically vertcat th...

Is it possible to use vertcat with dot notation?

Depending on what you are doing, you may find it convenient to turn that struct into a table (which wil automatically vertcat th...

casi 2 años hace | 1

Respondida

A very fast way to convert numbers into datetime ?

Syntactically, >> time = datetime("202210270954498", 'inputFormat','uuuuMMddHHmmssSSS', 'Format','yyyy-MM-dd HH:mm:ss.SSS') t...

A very fast way to convert numbers into datetime ?

Syntactically, >> time = datetime("202210270954498", 'inputFormat','uuuuMMddHHmmssSSS', 'Format','yyyy-MM-dd HH:mm:ss.SSS') t...

casi 2 años hace | 1

Respondida

How to find specific elements in cell array not followed by another specific element?

If you have time and other data, think timetables (also Walter is right about categorical): action = categorical([1;3;2;4;1;3;2...

How to find specific elements in cell array not followed by another specific element?

If you have time and other data, think timetables (also Walter is right about categorical): action = categorical([1;3;2;4;1;3;2...

casi 2 años hace | 1

Respondida

Getting Data from Cell: Dynamic Structure needed?

Simon, what you should do depends very heavily on what you want to do with these data, i.e. what "take the value of the needed d...

Getting Data from Cell: Dynamic Structure needed?

Simon, what you should do depends very heavily on what you want to do with these data, i.e. what "take the value of the needed d...

casi 2 años hace | 1

Respondida

trying to find highest values in a time segment

It's not clear to me that Image Analyst's solution answers your question, mostly because your question is not very clear. If the...

trying to find highest values in a time segment

It's not clear to me that Image Analyst's solution answers your question, mostly because your question is not very clear. If the...

casi 2 años hace | 0

Respondida

How to fix non-alignment issue when plotting multiple axes

Dinuka, if that's the plot you are looking for, I guess Voss' suggestion gets you there. But I might also add: y1=0.45 + .3*ran...

How to fix non-alignment issue when plotting multiple axes

Dinuka, if that's the plot you are looking for, I guess Voss' suggestion gets you there. But I might also add: y1=0.45 + .3*ran...

casi 2 años hace | 1

Respondida

Storing Variables in a loop to out put in a table

Make a timetable: i = (1:9)'; a = i-1; b = i.^2; c = i + rand(9,1); d = rand(length(i),1); e = rand(length(i),1); f = ran...

Storing Variables in a loop to out put in a table

Make a timetable: i = (1:9)'; a = i-1; b = i.^2; c = i + rand(9,1); d = rand(length(i),1); e = rand(length(i),1); f = ran...

casi 2 años hace | 0

Respondida

Issue Plotting 2 different Values

Cedric, I can't really follow your code or your explanation, but I would think you want something like this: ice = readtimetabl...

Issue Plotting 2 different Values

Cedric, I can't really follow your code or your explanation, but I would think you want something like this: ice = readtimetabl...

casi 2 años hace | 0

Respondida

Coverting Timetable to Column Vector

Sam, it looks like you are ending up with a 7201x6 timetable whose variables are cell arrays, and each cell contains a 500x1 dou...

Coverting Timetable to Column Vector

Sam, it looks like you are ending up with a 7201x6 timetable whose variables are cell arrays, and each cell contains a 500x1 dou...

casi 2 años hace | 1

| aceptada

Respondida

A very fast way to sort datetime (in "ascend" mode)?

It seems like the obvious response to Any way faster than this one ? [~, idx2] = sort(datenum(a), 1, 'ascend'); is to...

A very fast way to sort datetime (in "ascend" mode)?

It seems like the obvious response to Any way faster than this one ? [~, idx2] = sort(datenum(a), 1, 'ascend'); is to...

casi 2 años hace | 1

Respondida

Average of variables in timetable belonging to the same day over several years

Ziad, it seems that "dayofyear" is using "serial day number of year", and as you found, is lumping 29-Feb's with the non-leap 1-...

Average of variables in timetable belonging to the same day over several years

Ziad, it seems that "dayofyear" is using "serial day number of year", and as you found, is lumping 29-Feb's with the non-leap 1-...

alrededor de 2 años hace | 0

| aceptada

Respondida

Compile data from excel sheets into a dataset with multiple tags

Charlie, I'm confused. I haven't followed all of what you code does, but it seems that you are lining up tables of different he...

Compile data from excel sheets into a dataset with multiple tags

Charlie, I'm confused. I haven't followed all of what you code does, but it seems that you are lining up tables of different he...

alrededor de 2 años hace | 0

Respondida

Only required the mean value out rather then every single value in a data

"7" sounds rather suspiciously like "weeks". If this were a timetable, it would be a one-liner with groupsummary. Moral: don't t...

Only required the mean value out rather then every single value in a data

"7" sounds rather suspiciously like "weeks". If this were a timetable, it would be a one-liner with groupsummary. Moral: don't t...

alrededor de 2 años hace | 1

Respondida

Using date and time in MATLAB

I'm having trouble following exactly what needs to be done, but I imagine you want to append variables to your LoadProfile&Tarif...

Using date and time in MATLAB

I'm having trouble following exactly what needs to be done, but I imagine you want to append variables to your LoadProfile&Tarif...

más de 2 años hace | 1

| aceptada

Respondida

Help Merge two tables by the column variables

See join (or maybe innerjoin).

Help Merge two tables by the column variables

See join (or maybe innerjoin).

más de 2 años hace | 1

| aceptada

Respondida

generate an independent seed with a fixed number

Ebru, you are doing parallel simulations and presumably want to combine the results under the assumption that those results are ...

generate an independent seed with a fixed number

Ebru, you are doing parallel simulations and presumably want to combine the results under the assumption that those results are ...

más de 2 años hace | 3

| aceptada

Respondida

Export rows as combined separate CSV files

There are a bunch of ways to do this. I thought I'd see how well rowfun works: > C = {rand(10,1) rand(10,1); rand(10,1) rand(10...

Export rows as combined separate CSV files

There are a bunch of ways to do this. I thought I'd see how well rowfun works: > C = {rand(10,1) rand(10,1); rand(10,1) rand(10...

más de 2 años hace | 0

Respondida

Error: Row index exceeds table dimensions.

SOLARL.Date2 = datenum(SOLARL.Date); DON'T do that. Just use datetime. You can call unique, length, and == a on datetime vector...

Error: Row index exceeds table dimensions.

SOLARL.Date2 = datenum(SOLARL.Date); DON'T do that. Just use datetime. You can call unique, length, and == a on datetime vector...

más de 2 años hace | 0

Respondida

Elementwise calculations when making a new Table column

Will noone think of the joins? "I am trying to find (value1-min)/(max-min) using the appropriate max and min for the protocol ...

Elementwise calculations when making a new Table column

Will noone think of the joins? "I am trying to find (value1-min)/(max-min) using the appropriate max and min for the protocol ...

más de 2 años hace | 0