Réponse apportée
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...

plus de 2 ans il y a | 1

Réponse apportée
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";...

plus de 2 ans il y a | 1

Réponse apportée
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...

plus de 2 ans il y a | 0

Réponse apportée
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...

plus de 2 ans il y a | 0

Réponse apportée
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...

plus de 2 ans il y a | 1

Réponse apportée
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...

presque 3 ans il y a | 0

Réponse apportée
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...

presque 3 ans il y a | 0

Réponse apportée
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...

presque 3 ans il y a | 0

| A accepté

Réponse apportée
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...

presque 3 ans il y a | 0

Réponse apportée
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.

environ 3 ans il y a | 1

| A accepté

Réponse apportée
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...

environ 3 ans il y a | 0

Réponse apportée
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...

environ 3 ans il y a | 0

Réponse apportée
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...

environ 3 ans il y a | 1

| A accepté

Réponse apportée
Effect of os clock change on timers
cr, this was a bug in earlier releases, and got fixed in R2021a.

environ 3 ans il y a | 2

| A accepté

Réponse apportée
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....

environ 3 ans il y a | 0

Réponse apportée
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...

environ 3 ans il y a | 1

Réponse apportée
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...

environ 3 ans il y a | 0

| A accepté

Réponse apportée
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...

environ 3 ans il y a | 1

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

environ 3 ans il y a | 1

Réponse apportée
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...

environ 3 ans il y a | 1

Réponse apportée
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...

environ 3 ans il y a | 1

Réponse apportée
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...

environ 3 ans il y a | 0

Réponse apportée
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...

environ 3 ans il y a | 1

Réponse apportée
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...

environ 3 ans il y a | 0

Réponse apportée
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...

environ 3 ans il y a | 0

Réponse apportée
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...

environ 3 ans il y a | 1

| A accepté

Réponse apportée
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...

environ 3 ans il y a | 1

Réponse apportée
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-...

plus de 3 ans il y a | 0

| A accepté

Réponse apportée
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...

plus de 3 ans il y a | 0

Réponse apportée
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...

plus de 3 ans il y a | 1

Charger plus