Answered

Convert Number to Time / Duration Format of Data Column

This is much simpler than you think. You can't currently parse things like "000002" directly into duration, but you can get ther...

Convert Number to Time / Duration Format of Data Column

This is much simpler than you think. You can't currently parse things like "000002" directly into duration, but you can get ther...

4 mois ago | 0

Answered

Perform a calculation using data from multiple tables

Mark, have you tried using join? t = readtable("flight data.xlsx","TextType","string") t = join(t,T_Distance,"LeftKey","Destin...

Perform a calculation using data from multiple tables

Mark, have you tried using join? t = readtable("flight data.xlsx","TextType","string") t = join(t,T_Distance,"LeftKey","Destin...

4 mois ago | 0

| accepted

Answered

How to simply the code

"I'm working with cell arrays": Riccardo, you don't want to be doing that, especially not with 100000 rows. Or using a loop for ...

How to simply the code

"I'm working with cell arrays": Riccardo, you don't want to be doing that, especially not with 100000 rows. Or using a loop for ...

4 mois ago | 0

Answered

How to stackplot a table?

That seems overly complicated. stack to the rescue? >> t = table(datetime(2021,7,26,0:2:22,0,0)',datetime(2021,7,26,1:2:23,0,...

How to stackplot a table?

That seems overly complicated. stack to the rescue? >> t = table(datetime(2021,7,26,0:2:22,0,0)',datetime(2021,7,26,1:2:23,0,...

4 mois ago | 0

Answered

How to manage NaN values and calculate mean under conditions

Another possibility that uses and preserves a timetable: >> tt = readtimetable("Daily data.xlsx"); >> head(tt) ans = 8×1 t...

How to manage NaN values and calculate mean under conditions

Another possibility that uses and preserves a timetable: >> tt = readtimetable("Daily data.xlsx"); >> head(tt) ans = 8×1 t...

4 mois ago | 0

Answered

Insert two plots and a precreated table in the same figure

Camilo, in general you don't need all those table2array calls. Just do this: plot(Tablecalc.NameOfYour6thVar,Tablecalc.NameOfYo...

Insert two plots and a precreated table in the same figure

Camilo, in general you don't need all those table2array calls. Just do this: plot(Tablecalc.NameOfYour6thVar,Tablecalc.NameOfYo...

4 mois ago | 1

Answered

Subscripting into a table using three or more subscripts (as in t(i,j,k)) is not supported. Always specify a row subscript and a variable subscript, as in t(rows,vars).

Lihi, hard to say for sure, but you may want to make a table that contains those four tables. For example: >> baseline = table(...

Subscripting into a table using three or more subscripts (as in t(i,j,k)) is not supported. Always specify a row subscript and a variable subscript, as in t(rows,vars).

Lihi, hard to say for sure, but you may want to make a table that contains those four tables. For example: >> baseline = table(...

4 mois ago | 0

Answered

find elapse time with date rollover

Get away from using datenum. Can't say this strongly enough. >> tstr=["11:58:00"; "11:59:00"; "00:00:02"; "00:02:04"]; >> tod ...

find elapse time with date rollover

Get away from using datenum. Can't say this strongly enough. >> tstr=["11:58:00"; "11:59:00"; "00:00:02"; "00:02:04"]; >> tod ...

4 mois ago | 1

Answered

How can I create a mat file which changes the values of a column in excel table into the mat file's column headers?

I thnk you'd want to use readtimetable or readtable to bring the first xlsx into matlab. But I'm confused: the second xlsx only ...

How can I create a mat file which changes the values of a column in excel table into the mat file's column headers?

I thnk you'd want to use readtimetable or readtable to bring the first xlsx into matlab. But I'm confused: the second xlsx only ...

4 mois ago | 0

Answered

Problem using ranova for analysis of variance

Scott, haven't you explicitly not included DietaryGroup with that minus sign? I think you are using it for predictors in a way t...

Problem using ranova for analysis of variance

Scott, haven't you explicitly not included DietaryGroup with that minus sign? I think you are using it for predictors in a way t...

4 mois ago | 0

| accepted

Answered

EDF reading: edfread gives timetable; possible to get struct?

Andrew, FEX issues aside, it's possible that the DataRecordOutputType parameter to edfread may help. But it's also possible that...

EDF reading: edfread gives timetable; possible to get struct?

Andrew, FEX issues aside, it's possible that the DataRecordOutputType parameter to edfread may help. But it's also possible that...

4 mois ago | 1

Answered

how to use setvartype on a table that is already existing

setvartype is an import feature. let's come back to that. cell creates a cell array containing nothing but 0x0 doubles: >> c =...

how to use setvartype on a table that is already existing

setvartype is an import feature. let's come back to that. cell creates a cell array containing nothing but 0x0 doubles: >> c =...

4 mois ago | 0

Answered

cant put char array in a table of char!

Don't use raw char arrays other than a char row vector. You will eventually be unhappy. Unless you are using a very old version ...

cant put char array in a table of char!

Don't use raw char arrays other than a char row vector. You will eventually be unhappy. Unless you are using a very old version ...

4 mois ago | 0

Answered

How to filter first fixation times for participants

Like SS, I tried to make sense of this code. And I found the same thing: in a recent version of MATLAB, these few lines would ha...

How to filter first fixation times for participants

Like SS, I tried to make sense of this code. And I found the same thing: in a recent version of MATLAB, these few lines would ha...

4 mois ago | 0

Answered

Conversion and Merger of date and time using datetime

You are correct to use datatime to parse those times of day with : as the decimal separator; duration can't currently do that. A...

Conversion and Merger of date and time using datetime

You are correct to use datatime to parse those times of day with : as the decimal separator; duration can't currently do that. A...

4 mois ago | 1

| accepted

Answered

Normality test of the Matlab function 'randn'

With all due respect (and I mean that), nonsense. MadhiH, I don't know what you mean when you say that, "the p-value is too hig...

Normality test of the Matlab function 'randn'

With all due respect (and I mean that), nonsense. MadhiH, I don't know what you mean when you say that, "the p-value is too hig...

5 mois ago | 3

| accepted

Answered

Convert julian date SAC to specific format date

I'm gonna suggest another solution that might be simpler to follow. First thing is that this isn't a Julian Date in the strict...

Convert julian date SAC to specific format date

I'm gonna suggest another solution that might be simpler to follow. First thing is that this isn't a Julian Date in the strict...

8 mois ago | 0

Answered

How to easily propagate the error of a column ?

Aaron, I think that depends on what you mean by "propagate the uncertainties". There is a simple formula for the variance of the...

How to easily propagate the error of a column ?

Aaron, I think that depends on what you mean by "propagate the uncertainties". There is a simple formula for the variance of the...

8 mois ago | 0

| accepted

Answered

Time series data events

Ben, I'm not sure where you are starting from. I'm gonna show how to do this with timetables. Imagine you have a timetable conta...

Time series data events

Ben, I'm not sure where you are starting from. I'm gonna show how to do this with timetables. Imagine you have a timetable conta...

9 mois ago | 1

| accepted

Answered

get GPS time to calulate time since referencje epoch

Marta, that depends on what you mean by "GPS time". MATLAB doesn't yet have direct support for GPS time, but if all you want is...

get GPS time to calulate time since referencje epoch

Marta, that depends on what you mean by "GPS time". MATLAB doesn't yet have direct support for GPS time, but if all you want is...

environ un an ago | 0

| accepted

Answered

Find the certain amount of values between NaNs and make another variable from these values

There's no need to loop over the 750K elements. Do this on each row x of your data, i.e. loop from 1:50. Try stepping through t...

Find the certain amount of values between NaNs and make another variable from these values

There's no need to loop over the 750K elements. Do this on each row x of your data, i.e. loop from 1:50. Try stepping through t...

environ un an ago | 0

Answered

Finding row number of a variable existing in a table

I have no idea what you mean by "In this case the second column and third row of the table.", but this sounds like what you want...

Finding row number of a variable existing in a table

I have no idea what you mean by "In this case the second column and third row of the table.", but this sounds like what you want...

environ un an ago | 0

| accepted

Answered

Correlating values from a table using a for loop

Not sure why you think a "loop is better". Try this: >> t = table([1;1;1;1;2;2;2;2;2;2],rand(10,1),rand(10,1),'VariableNames',[...

Correlating values from a table using a for loop

Not sure why you think a "loop is better". Try this: >> t = table([1;1;1;1;2;2;2;2;2;2],rand(10,1),rand(10,1),'VariableNames',[...

environ un an ago | 0

Answered

Comparing matrices and filling in the gaps

There are just so many things you can do with joins: >> a = table(["A";"B";"C";"D";"E";"F"]); >> b = table(["B";"D";"F"], [5;1...

Comparing matrices and filling in the gaps

There are just so many things you can do with joins: >> a = table(["A";"B";"C";"D";"E";"F"]); >> b = table(["B";"D";"F"], [5;1...

environ un an ago | 0

Answered

Time weighted average after every 60mins

Or put the data in a timetable and use retime(tt,'hourly','mean'). If you need weights, you can write your own aggregation funct...

Time weighted average after every 60mins

Or put the data in a timetable and use retime(tt,'hourly','mean'). If you need weights, you can write your own aggregation funct...

environ un an ago | 0

Answered

How can I construct a struct handle from a string?

A scalar struct with a field for each variable that you would have put in the workspace is often useful. It's like a private wor...

How can I construct a struct handle from a string?

A scalar struct with a field for each variable that you would have put in the workspace is often useful. It's like a private wor...

environ un an ago | 1

| accepted

Answered

Keeping columns names but replacing value for iteration

You are horzcat'ing tables, and table variable names must be unique. But your two tables both have variables named dist1, dist2,...

Keeping columns names but replacing value for iteration

You are horzcat'ing tables, and table variable names must be unique. But your two tables both have variables named dist1, dist2,...

environ un an ago | 1

| accepted

Answered

Preallocation of a vector of structure

Audric, it seems like dpb understand what you are doing better than I do, but "in which each cell will be a structure of 42 fiel...

Preallocation of a vector of structure

Audric, it seems like dpb understand what you are doing better than I do, but "in which each cell will be a structure of 42 fiel...

environ un an ago | 0

Answered

convert hourly data to daily sum

Turn your table into a timetable, and use retime: >> hourmelt = table2timetable(hourmelt); >> head(hourmelt) ans = 8×1 tim...

convert hourly data to daily sum

Turn your table into a timetable, and use retime: >> hourmelt = table2timetable(hourmelt); >> head(hourmelt) ans = 8×1 tim...

environ un an ago | 0

Answered

missing/incorrect use of math operators?

Jocelyn, modulo Geoff's concerns, I think your whole loop can be done as x = 200*3*(0:5)'; Vx = (sqrt(Vx_o) - ((k3/2).*x))^2; ...

missing/incorrect use of math operators?

Jocelyn, modulo Geoff's concerns, I think your whole loop can be done as x = 200*3*(0:5)'; Vx = (sqrt(Vx_o) - ((k3/2).*x))^2; ...

environ un an ago | 0