Community Profile

# Peter Perkins

### MathWorks

Last seen: 9 jours il y a Actif depuis 2011

All

#### Content Feed

Afficher par

A répondu
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...

environ 2 mois il y a | 0

| A accepté

A répondu
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...

environ 2 mois il y a | 0

A répondu
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/...

environ 2 mois il y a | 0

A répondu
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 ...

environ 2 mois il y a | 0

A répondu
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...

environ 2 mois il y a | 0

A répondu
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...

environ 2 mois il y a | 1

A répondu
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....

environ 2 mois il y a | 0

A répondu
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...

environ 2 mois il y a | 1

A répondu
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";...

environ 2 mois il y a | 0

A répondu
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...

environ 2 mois il y a | 0

A répondu
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...

environ 2 mois il y a | 0

A répondu
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...

environ 2 mois il y a | 1

A répondu
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...

2 mois il y a | 0

A répondu
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...

2 mois il y a | 0

A répondu
Extract SST data in a polygon from average monthly netcdf file

3 mois il y a | 0

| A accepté

A répondu
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...

3 mois il y a | 0

A répondu
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.

6 mois il y a | 1

| A accepté

A répondu
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...

6 mois il y a | 0

A répondu
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...

6 mois il y a | 0

A répondu
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...

6 mois il y a | 1

| A accepté

A répondu
Effect of os clock change on timers
cr, this was a bug in earlier releases, and got fixed in R2021a.

6 mois il y a | 2

| A accepté

A répondu
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....

6 mois il y a | 0

A répondu
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...

6 mois il y a | 1

A répondu
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...

6 mois il y a | 0

| A accepté

A répondu
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...

6 mois il y a | 1

A répondu
A very fast way to convert numbers into datetime ?
Syntactically, >> time = datetime("202210270954498", 'inputFormat','uuuuMMddHHmmssSSS', 'Format','yyyy-MM-dd HH:mm:ss.SSS') t...

6 mois il y a | 1

A répondu
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...

6 mois il y a | 1

A répondu
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...

6 mois il y a | 1

A répondu
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...

6 mois il y a | 0

A répondu
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...

6 mois il y a | 1