Answered

How to use movsum with datetime?

@SaaraL I should first mention that the function call in your original question should work if you pass a numeric vector or matr...

How to use movsum with datetime?

@SaaraL I should first mention that the function call in your original question should work if you pass a numeric vector or matr...

9 meses ago | 1

Answered

Problem plotting 1D array versus table column: I want a single curve/series but am instead getting a separate series for every array element.

I'd first recommend converting your table into a timetable so you can see the time step for each row. https://www.mathworks.com...

Problem plotting 1D array versus table column: I want a single curve/series but am instead getting a separate series for every array element.

I'd first recommend converting your table into a timetable so you can see the time step for each row. https://www.mathworks.com...

9 meses ago | 0

Answered

Calling data based on column name

You could do something like mean(t{:,varName}) where t is your UI table data (assuming it is represented as a table type) and ...

Calling data based on column name

You could do something like mean(t{:,varName}) where t is your UI table data (assuming it is represented as a table type) and ...

9 meses ago | 0

| accepted

Answered

loop based on a condition in another column

To add to Walter's answer, you might also consider groupsummary. https://www.mathworks.com/help/matlab/ref/double.groupsummary....

loop based on a condition in another column

To add to Walter's answer, you might also consider groupsummary. https://www.mathworks.com/help/matlab/ref/double.groupsummary....

9 meses ago | 0

| accepted

Answered

How can I remove characters in cvs file?

If you use readtable, you can convert the table to a matrix by using the table2array function. https://www.mathworks.com/help/m...

How can I remove characters in cvs file?

If you use readtable, you can convert the table to a matrix by using the table2array function. https://www.mathworks.com/help/m...

9 meses ago | 0

Answered

Training a Neural Network

To add to Olof's answer, the categorical type allows you to efficiently represent a finite set of discrete categories that you m...

Training a Neural Network

To add to Olof's answer, the categorical type allows you to efficiently represent a finite set of discrete categories that you m...

9 meses ago | 1

Answered

Synchronizing several large timetables

Where are your timetables coming from? Are you reading them from one or more files? If so, it probably makes more sense to creat...

Synchronizing several large timetables

Where are your timetables coming from? Are you reading them from one or more files? If so, it probably makes more sense to creat...

9 meses ago | 0

| accepted

Answered

Create elapsed time vector for loop

1) You can convert timestamp data into elapsed time using datetime subtraction. >> dt = datetime(2020,1,1:5) dt = 1×5 ...

Create elapsed time vector for loop

1) You can convert timestamp data into elapsed time using datetime subtraction. >> dt = datetime(2020,1,1:5) dt = 1×5 ...

9 meses ago | 1

| accepted

Answered

Combine 2 datasets and include the duplicates

Check out innerjoin and outerjoin. https://www.mathworks.com/help/matlab/ref/innerjoin.html https://www.mathworks.com/help/mat...

Combine 2 datasets and include the duplicates

Check out innerjoin and outerjoin. https://www.mathworks.com/help/matlab/ref/innerjoin.html https://www.mathworks.com/help/mat...

9 meses ago | 0

Answered

How can I do the SINR representation of some points?

I'm a little unclear on your workflow, but you might consider one of the geographic plots, such as geobubble. https://www.mathw...

How can I do the SINR representation of some points?

I'm a little unclear on your workflow, but you might consider one of the geographic plots, such as geobubble. https://www.mathw...

9 meses ago | 0

| accepted

Answered

How to sort data (multiple rows into one)

This sounds like a good use for unstack. https://www.mathworks.com/help/matlab/ref/unstack.html For example, suppose we have...

How to sort data (multiple rows into one)

This sounds like a good use for unstack. https://www.mathworks.com/help/matlab/ref/unstack.html For example, suppose we have...

9 meses ago | 1

| accepted

Answered

how to accumulate 10 minute values to daily values

Check out retime. https://www.mathworks.com/help/matlab/ref/timetable.retime.html

how to accumulate 10 minute values to daily values

Check out retime. https://www.mathworks.com/help/matlab/ref/timetable.retime.html

9 meses ago | 0

Answered

How do I range through a set of columns in a table to generate data and store data in new columns?

You might be interested in varfun. https://www.mathworks.com/help/matlab/ref/varfun.html

How do I range through a set of columns in a table to generate data and store data in new columns?

You might be interested in varfun. https://www.mathworks.com/help/matlab/ref/varfun.html

9 meses ago | 0

Answered

Concatenate a string array and a table of different dimensions

writematrix and writetable both take a 'WriteMode' name-value pair that can be set to 'append'. To write a header followed by a ...

Concatenate a string array and a table of different dimensions

writematrix and writetable both take a 'WriteMode' name-value pair that can be set to 'append'. To write a header followed by a ...

9 meses ago | 0

| accepted

Answered

Combining two stacked plots

In cases such as this one, where the tables we want to plot have the same height, we can concatenate them horizontally and call ...

Combining two stacked plots

In cases such as this one, where the tables we want to plot have the same height, we can concatenate them horizontally and call ...

alrededor de 1 año ago | 1

Answered

Read one column only of a large file, line by line?

You might also want to consider using a tall table. https://www.mathworks.com/help/matlab/import_export/tall-arrays.html

Read one column only of a large file, line by line?

You might also want to consider using a tall table. https://www.mathworks.com/help/matlab/import_export/tall-arrays.html

alrededor de 1 año ago | 0

Answered

timer with a startat datetime variable in a different time zone

Thank you for reporting this issue. Unfortunately, the startat function currently ignores timezone information when a zoned date...

timer with a startat datetime variable in a different time zone

Thank you for reporting this issue. Unfortunately, the startat function currently ignores timezone information when a zoned date...

alrededor de 1 año ago | 0

Answered

Change the format of an output figure of 'findchangepts'-function into datetime format.

This same figure can be created with the relevant x data by using the plot, title, and xline commands. https://www.mathworks.co...

Change the format of an output figure of 'findchangepts'-function into datetime format.

This same figure can be created with the relevant x data by using the plot, title, and xline commands. https://www.mathworks.co...

alrededor de 1 año ago | 0

Answered

change datatip for segments of stacked bar charts

Take a look at the documentation for creating custom data tips. https://www.mathworks.com/help/matlab/creating_plots/create-cus...

change datatip for segments of stacked bar charts

Take a look at the documentation for creating custom data tips. https://www.mathworks.com/help/matlab/creating_plots/create-cus...

alrededor de 1 año ago | 0

| accepted

Answered

Number of occurrences per category per month using table data

Check out the groupsummary function. https://www.mathworks.com/help/matlab/ref/double.groupsummary.html >> rng default >> Wea...

Number of occurrences per category per month using table data

Check out the groupsummary function. https://www.mathworks.com/help/matlab/ref/double.groupsummary.html >> rng default >> Wea...

alrededor de 1 año ago | 0

Answered

Plot serial date of excel into MATLAB

Do also prefer using readtable and readtimetable as opposed to xlsread.

Plot serial date of excel into MATLAB

Do also prefer using readtable and readtimetable as opposed to xlsread.

alrededor de 1 año ago | 0

Answered

Merge two columns in timetable?

One simple way to combine these variables is to add them together in a new timetable variable and delete the old variables. htt...

Merge two columns in timetable?

One simple way to combine these variables is to add them together in a new timetable variable and delete the old variables. htt...

alrededor de 1 año ago | 0

| accepted

Answered

Dates beside the axis when plotting datetime

1) The date information can be hidden by setting the TickLabelsMode to 'manual' on the DatetimeRuler. ax = gca; ax.XAxis.TickL...

Dates beside the axis when plotting datetime

1) The date information can be hidden by setting the TickLabelsMode to 'manual' on the DatetimeRuler. ax = gca; ax.XAxis.TickL...

alrededor de 1 año ago | 1

Answered

Plot from 2 matrixes as x value and 1 matrix as y

1) It is simpler and more efficient to store durations and datetimes in a duration or datetime array respectively instead of a c...

Plot from 2 matrixes as x value and 1 matrix as y

1) It is simpler and more efficient to store durations and datetimes in a duration or datetime array respectively instead of a c...

alrededor de 1 año ago | 0

Answered

Using clusterdata() to plot clusters using plot(). "Vectors must be the same length"

You'll need to decide what you want the x-values to be when y((clusters == c),:)' does not have 4095 elements. I suspect you wa...

Using clusterdata() to plot clusters using plot(). "Vectors must be the same length"

You'll need to decide what you want the x-values to be when y((clusters == c),:)' does not have 4095 elements. I suspect you wa...

alrededor de 1 año ago | 0

Answered

How do I use the group summary/unstack function in this script?

Take a look at the following documentation example for unstack, which closely resembles your problem. https://www.mathworks.com...

How do I use the group summary/unstack function in this script?

Take a look at the following documentation example for unstack, which closely resembles your problem. https://www.mathworks.com...

alrededor de 1 año ago | 1

Answered

Adding 3 Frequency curves into an existing plot.

I'm a little unclear on the question. It sounds like the question is: "Can I plot vectors of different lengths on the same axes?...

Adding 3 Frequency curves into an existing plot.

I'm a little unclear on the question. It sounds like the question is: "Can I plot vectors of different lengths on the same axes?...

alrededor de 1 año ago | 0

| accepted

Answered

Plotting frequency curves in one figure

The error we see is happening in the split function because not every string in string(FEC_fb2(1:end-1)) has the same number of ...

Plotting frequency curves in one figure

The error we see is happening in the split function because not every string in string(FEC_fb2(1:end-1)) has the same number of ...

alrededor de 1 año ago | 0

| accepted

Answered

Filename to categorical in table

Assuming we know which rows contain data from each file, we can create a categorical variable and add it directly to the table. ...

Filename to categorical in table

Assuming we know which rows contain data from each file, we can create a categorical variable and add it directly to the table. ...

alrededor de 1 año ago | 1

Answered

Streamline for loops and indexing of large files

1) Consider using innerjoin or outerjoin to find the rows with matching row times between two tables. https://www.mathworks.com...

Streamline for loops and indexing of large files

1) Consider using innerjoin or outerjoin to find the rows with matching row times between two tables. https://www.mathworks.com...

alrededor de 1 año ago | 0

| accepted