Respondida

How to use groupsummary to group by hour-of-year

Is this really "hour of year", a value that runs from 0 to 8784? In the same way that day of year is just dt = datetime(2023,7,...

How to use groupsummary to group by hour-of-year

Is this really "hour of year", a value that runs from 0 to 8784? In the same way that day of year is just dt = datetime(2023,7,...

alrededor de 1 año hace | 0

Respondida

mean of all these variables over latitude x longitude x time that is (5 x 5 x 2)

It's very likely that you should be using a timetable. You have "eight variables loaded with data (latitude,longitude,time,mont...

mean of all these variables over latitude x longitude x time that is (5 x 5 x 2)

It's very likely that you should be using a timetable. You have "eight variables loaded with data (latitude,longitude,time,mont...

alrededor de 1 año hace | 0

Respondida

How to calculate the date 0.25 years after the date of January 15, 2020

This is a long thread. I hope the following will clarify a couple things. The years function is not really intended for precise...

How to calculate the date 0.25 years after the date of January 15, 2020

This is a long thread. I hope the following will clarify a couple things. The years function is not really intended for precise...

alrededor de 1 año hace | 0

Respondida

seasonal mean for each year based on the sample code

As in your other post, I can't follow youre code, but my strong recommendation is to read in your data using readtimetable, and ...

seasonal mean for each year based on the sample code

As in your other post, I can't follow youre code, but my strong recommendation is to read in your data using readtimetable, and ...

alrededor de 1 año hace | 0

Respondida

Duplicating categorical array to floating point value for perfcurve function

The short answer is that you can call double on a categorical array to get the category numbers as a numeric array. But that may...

Duplicating categorical array to floating point value for perfcurve function

The short answer is that you can call double on a categorical array to get the category numbers as a numeric array. But that may...

alrededor de 1 año hace | 0

Respondida

years in fourth dimension is not printing properly

I can't follow youre code, but my strong recommendation is to read in your data using readtimetable, and then use groupsummary o...

years in fourth dimension is not printing properly

I can't follow youre code, but my strong recommendation is to read in your data using readtimetable, and then use groupsummary o...

alrededor de 1 año hace | 0

Respondida

How to rename identical variables under one common name?

This just SCREAMS for using categorical. Screams. This might seem like more work, but untimately you will be happier. TextData ...

How to rename identical variables under one common name?

This just SCREAMS for using categorical. Screams. This might seem like more work, but untimately you will be happier. TextData ...

alrededor de 1 año hace | 0

Respondida

How do you access table data to be used with basic operators?

There are suggestions in this thread pointing in different directions. To answer the question as stated in the post's title, thi...

How do you access table data to be used with basic operators?

There are suggestions in this thread pointing in different directions. To answer the question as stated in the post's title, thi...

alrededor de 1 año hace | 0

Respondida

How to reference a cell from a table within a table

Aron, it sounds like you have tables in a cell array in a table. Dirk is assuming you have "nested tables", which is different b...

How to reference a cell from a table within a table

Aron, it sounds like you have tables in a cell array in a table. Dirk is assuming you have "nested tables", which is different b...

alrededor de 1 año hace | 1

Respondida

constructing a table from a particular data set

You almost certainly do not want to do all the calculation "by hand" as Sharad's answer shows. Import into a timetable, then us...

constructing a table from a particular data set

You almost certainly do not want to do all the calculation "by hand" as Sharad's answer shows. Import into a timetable, then us...

alrededor de 1 año hace | 0

Respondida

Simulink Desktop Real-Time & MATLAB App Designer UI (App update lag)

This [SOUNDER_DATA;newSounder] can take some time, it's an expensive operation. If possible, better to save all those one-row ...

Simulink Desktop Real-Time & MATLAB App Designer UI (App update lag)

This [SOUNDER_DATA;newSounder] can take some time, it's an expensive operation. If possible, better to save all those one-row ...

más de 1 año hace | 0

| aceptada

Respondida

Extracting corresponding timestamp in two tables of different sizes.

The times are changed in the new table, so all the suggestions to match times are AFAICT not gonna work. I think you're on the r...

Extracting corresponding timestamp in two tables of different sizes.

The times are changed in the new table, so all the suggestions to match times are AFAICT not gonna work. I think you're on the r...

más de 1 año hace | 0

| aceptada

Respondida

I need data points from Labchart file according to stimulus time points in a other channel , how can i get it?

Avinash, I'm not really sure what you are trying to do, but this should get you started: >> t = readtable("90.txt",HeaderLines=...

I need data points from Labchart file according to stimulus time points in a other channel , how can i get it?

Avinash, I'm not really sure what you are trying to do, but this should get you started: >> t = readtable("90.txt",HeaderLines=...

más de 1 año hace | 1

Respondida

Question on datestr to datetime conversion

It's hard to tell what this code is doing, but while replacing this datestr(now) with this char(datetime) is a literal old t...

Question on datestr to datetime conversion

It's hard to tell what this code is doing, but while replacing this datestr(now) with this char(datetime) is a literal old t...

más de 1 año hace | 0

Respondida

How to remove rows in table?

You don't need loops to do this. Hard to verify that this does what you are asking for with no mat file. pathsToDelete = {'E:\A...

How to remove rows in table?

You don't need loops to do this. Hard to verify that this does what you are asking for with no mat file. pathsToDelete = {'E:\A...

más de 1 año hace | 0

Respondida

Select values based on datetime

The very first thing you should do is put your data and timestamps in a timetable. Once you do that, use retime to create a dai...

Select values based on datetime

The very first thing you should do is put your data and timestamps in a timetable. Once you do that, use retime to create a dai...

más de 1 año hace | 0

| aceptada

Respondida

How can I calculate the overlapping time on a timetable?

This might get you started: >> load('T3.mat') >> T3.Next1 = [(T3.LOS(1:end-1) > T3.AOS(2:end)); false]; >> T3.Next2 = [(T3.LO...

How can I calculate the overlapping time on a timetable?

This might get you started: >> load('T3.mat') >> T3.Next1 = [(T3.LOS(1:end-1) > T3.AOS(2:end)); false]; >> T3.Next2 = [(T3.LO...

más de 1 año hace | 0

Respondida

Grouping times by end to start time

This is a lot like hierarchical clustering, if you happen to have the Statistics Toolbox. https://www.mathworks.com/help/stats/...

Grouping times by end to start time

This is a lot like hierarchical clustering, if you happen to have the Statistics Toolbox. https://www.mathworks.com/help/stats/...

más de 1 año hace | 0

Respondida

How to fill zeros and NaNs with the average of the previous nonzero consecutive values (part 2)

Just for fun: a varfun soln. Would look similar using grouptransform. Step one is to define groups of elements by finding runs ...

How to fill zeros and NaNs with the average of the previous nonzero consecutive values (part 2)

Just for fun: a varfun soln. Would look similar using grouptransform. Step one is to define groups of elements by finding runs ...

más de 1 año hace | 0

Respondida

Weighted Average for a certain depth

At one point you say "weighted soil moisture average to a given depth" and at another you say "soil moisture depth average". You...

Weighted Average for a certain depth

At one point you say "weighted soil moisture average to a given depth" and at another you say "soil moisture depth average". You...

más de 1 año hace | 0

Respondida

How can I list individual year from the datetime table?

I'm gonna go Dave one better: >> load DateList.mat >> t = table(Per); >> t.Year = year(t.Per); >> t2 = varfun(@(x){x},t,Inpu...

How can I list individual year from the datetime table?

I'm gonna go Dave one better: >> load DateList.mat >> t = table(Per); >> t.Year = year(t.Per); >> t2 = varfun(@(x){x},t,Inpu...

más de 1 año hace | 1

Respondida

How to plot a derivative against variable?

For extra credit, create a timetable from displacement, add velocity and accel, then use stackedplot to plot all three together....

How to plot a derivative against variable?

For extra credit, create a timetable from displacement, add velocity and accel, then use stackedplot to plot all three together....

más de 1 año hace | 0

Respondida

use unstack to reshape table with dummy variable (edited: alternative crosstab method)

I'm having trouble understanding the desireed output, but others have created what is essentially a crosstabulation of counts, s...

use unstack to reshape table with dummy variable (edited: alternative crosstab method)

I'm having trouble understanding the desireed output, but others have created what is essentially a crosstabulation of counts, s...

más de 1 año hace | 1

Respondida

Naming Cell Array as Rownames

It's hard to tell what you are asking for. It mighht be this: T = array2table(rand(5,2)) T.Properties.RowNames = ["A";"B";"C";...

Naming Cell Array as Rownames

It's hard to tell what you are asking for. It mighht be this: T = array2table(rand(5,2)) T.Properties.RowNames = ["A";"B";"C";...

más de 1 año hace | 0

Respondida

How do you plot two graphs with multiple curves next to a table?

Mathew, I think you are making your life more difficult than it needs to be with all those strings. I get that you are trying to...

How do you plot two graphs with multiple curves next to a table?

Mathew, I think you are making your life more difficult than it needs to be with all those strings. I get that you are trying to...

más de 1 año hace | 0

Respondida

Indexing different time stamps for same day?

Arun, as Jack implies, timerange (the class) currently can only represent one interval. You can do one of two things: 1) As Jac...

Indexing different time stamps for same day?

Arun, as Jack implies, timerange (the class) currently can only represent one interval. You can do one of two things: 1) As Jac...

más de 1 año hace | 0

Respondida

Processing Timeseries of Cylinder Pressure Data

Your file has four time series in it. I would recommend reading those four ranges using readtimetable to get four timetables. Th...

Processing Timeseries of Cylinder Pressure Data

Your file has four time series in it. I would recommend reading those four ranges using readtimetable to get four timetables. Th...

más de 1 año hace | 1

Respondida

Inserting missing rows to table for interpolation

I'm not sure I follow your question, but it's almost certain that using timetables (maybe with durations as the row times) and s...

Inserting missing rows to table for interpolation

I'm not sure I follow your question, but it's almost certain that using timetables (maybe with durations as the row times) and s...

más de 1 año hace | 0

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