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

oltre un anno fa | 0

| accettato

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

oltre un anno fa | 1

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

oltre un anno fa | 1

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

oltre un anno fa | 1

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

oltre un anno fa | 1

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

oltre un anno fa | 0

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

oltre un anno fa | 1

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

oltre un anno fa | 0

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

oltre un anno fa | 0

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

oltre un anno fa | 1

| accettato

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

oltre un anno fa | 1

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

oltre un anno fa | 0

| accettato

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

oltre un anno fa | 0

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

oltre un anno fa | 1

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

quasi 2 anni fa | 1

| accettato

Risposto
Help Merge two tables by the column variables
See join (or maybe innerjoin).

quasi 2 anni fa | 1

| accettato

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

quasi 2 anni fa | 3

| accettato

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

quasi 2 anni fa | 0

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

quasi 2 anni fa | 0

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

quasi 2 anni fa | 0

Risposto
unstack table with pre and post measurements
unstack needs you to tell it three things: 1) which variables to unstack. It looks like you want SystemWeight, JumpHeight, ... ...

quasi 2 anni fa | 0

Risposto
How to grab the first instance of a timestamp based on the second
It's a one-liner using a timetable and retime, with NewTimeStep 'secondly' and Method 'firstValue': >> tt = timetable(rand(10,1...

quasi 2 anni fa | 0

| accettato

Risposto
how can I calculate movmean from 1 periode wave data?
In addition to what Mathieu suggests, there are similar things shown in these examples, especially the first one: https://www.m...

quasi 2 anni fa | 0

Risposto
How to compare 2 columns line by line between two matrix of different size?
ismember will work, but ithis is a join operation. It's a one-liner: >> matrix1 = readtable('datasetPDP.csv'); >> matrix2 = re...

quasi 2 anni fa | 0

| accettato

Risposto
averaging columns in a table based on two other columns
This should be straight-forward using either groupsummary, or varfun with displacement_pixel as the input/data variable and x_pi...

quasi 2 anni fa | 0

Risposto
How do I make an array from select points in a large table (based on dates)?
Alex, you already have a timetable, which is the right thing to use. To help get you started: >> i = isbetween(timeofday(UMR202...

quasi 2 anni fa | 0

| accettato

Risposto
How to reformat this table's information so that a column of data becomes the header's for matching data?
I guess this is a useful format? Voss shows one way, here's another: >> Items = "Item" + (1:8)'; >> Family = "Family" + [1;2;4...

quasi 2 anni fa | 1

Risposto
Import and export excel data having combined number and text in a single cell.
If each cell of your spreadsheet literally contains things like "4-sample1-sample2-(23.56,-13.54)", then you may want to figure ...

quasi 2 anni fa | 0

Risposto
Stacked plots: display two variables on the same x-axis
Farbod, IIUC, you cannot do that with stackedplot. Each subplot can have only one y axis. The whole point of stackedplot is to a...

quasi 2 anni fa | 0

Risposto
retrieve data specific date
In addition to what KSSV shows, since you say "retrieve data", I recommend that you use a timetable, and things like timerange,o...

quasi 2 anni fa | 0

Carica altro