Question

How to use fwrite with a format subject to change

Hi, I have a basic question: I am doing multiple SQL queries and exporting the result to text files. I want to use fwrite to ex...

3 months ago | 1 answer | 0

Question

How to attribute a letter to unique combinaisons

Hi, I have a very simple question that is a bit tricky to explain: I have a table like this var_a = {'T1','T1','T1','T1','T1',...

6 months ago | 1 answer | 0

Question

How to remove outliers based on datetime

Hi, I am wondering how to remove outliers based on datetime values in Matlab. For example, in the table below, I am looking for...

12 months ago | 1 answer | 0

Question

How to subset data based on time range

Hi, I am wondering how to subset data based on time range ? For example I would like to subset the maximum number of rows that ...

12 months ago | 2 answers | 0

Question

How to assign point to multiple circles

Hi, I have small script to assign points to circles. However, when a point falls into overlapping circles, then I want it to be...

1 year ago | 1 answer | 0

Question

How to combine rows with some identical values in a table

Hi, I am using the short script below to assign points to boxes. The script works fine but I am struggling to combine duplicate...

1 year ago | 1 answer | 0

Question

How to do multiple replacements in a cell array

Hi, I am wondering what is the most efficient way in Matlab to do multiple replacements in a cell array based on the content of...

1 year ago | 1 answer | 0

Answered

How to assign points to one or several boxes

In reality there is a about 50 boxes. Altought few of them overlap, I still need to take into account the case where a point fal...

How to assign points to one or several boxes

In reality there is a about 50 boxes. Altought few of them overlap, I still need to take into account the case where a point fal...

1 year ago | 0

Question

How to assign points to one or several boxes

Hi, I have a small function that assign points to boxes based on latitude and longitude. This code mostly works: point A falls ...

1 year ago | 2 answers | 0

Question

How to conditionally change values in a table

Hi, I am wondering to conditionally change values in a table. In the table below, everytime that t.val2 is 3 or 4, I want t.val...

1 year ago | 2 answers | 1

Question

How to combine two variables in a table

Hi, I simply want to combine two variables (mean and sd) into a single variable with the symbol ± in between numbers. mean = {...

1 year ago | 1 answer | 0

Question

How to subset a table in a function based on input arguments

Hello, I am trying to write a function that subset a table based on the arguments used by the user. If the user doesnt select a...

1 year ago | 1 answer | 0

Question

How to use fillmissing with table variables of type cell

Hello, I simply want to replace all empty cells ([]) by '99' in the table attached but only for the variables that begin with Q...

1 year ago | 1 answer | 0

Question

How to replace a string with another string in specific table columns

Hello, Im trying to replace all [] with '-99' only in the columns that begin with Q_ in the table t below. How would I do that...

1 year ago | 2 answers | 0

Question

How to order variables in a table

Hello, I find myself with a curious problem: I need to order the variables of a table without knowing in advance if all the var...

1 year ago | 1 answer | 0

Question

How to replace strings in a cell array

Hello, I an wondering how to replace strings in a cell array based on the content of the previous cell. Every time that a cell ...

1 year ago | 1 answer | 0

Question

How to find files with a given pattern in multiple folders

Hello, I have slightly modified code shared by ImageAnalyst (I think) to built the small function below. The function below doe...

1 year ago | 2 answers | 0

Question

How to make faster sql queries

Hello, I am struggling to make SQL queries faster in Matlab. For example, the SQL query below contains not quite 500 000 rows a...

1 year ago | 0 answers | 0

Question

How to find unique combinations between two columns in a cell array

Hi, I am trying to find all the unique combinations between two columns in a cell array so I can identify if a given sensor has...

1 year ago | 1 answer | 0

Question

How to extract data from a multi layered structure

Hi, I have a multi-layered structure A that include 3 structures (a, b and c) and and all of them contain 10 fieldnames with 10...

1 year ago | 1 answer | 0

Question

How to replace outliers with NaN

Hello, I am trying to replace values above the 99th percentile (outliers) by NaN for each group (for both group A and group B) ...

1 year ago | 1 answer | 0

Question

Exporting multiple Excel Files

Hello all, I have a folder with several text files. I am opening them and modifying them in a loop. My question is: how can I...

3 years ago | 1 answer | 0

Question

Exporting mixed cell array as textfile

Hello all, Let's say I had a mixed cell array containing numbers, characters and empty cells. Like so: A 9 [empty] [empty]...

3 years ago | 1 answer | 0

Question

Combining hours and minutes

I have a 600 x 1 double array where the hour is on the 8th row and the minutes are on the 9th row. I want to combine them into a...

3 years ago | 2 answers | 0

Question

Editing large number of dat files

Hello all, I want to add the same comment to the second line of a large number of dat files and then place them in a new fold...

3 years ago | 0 answers | 0

Question

Reshape multiple dat files

Hello all, I have a large number of dat files in which multiple variables are arranged in a single column one after the other...

3 years ago | 2 answers | 0

Question

Basic comparison between columns

Hello all, Let's say I have a 10 x 10 matrix filled with numbers (10 x 10 double). When the value 999 is found (anywhere) the...

4 years ago | 1 answer | 0

Question

Finding columns by name in a cell array

Hello all, Let's say I have a large cell array with similar variable names in the first row (A_F1 , B_F2 , A_F2 , G_F5 ...) f...

4 years ago | 1 answer | 0

Question

Finding a needle in a matrix

Hello, Let's say I have a 10 x 10 matrix filled with numbers (10 X 10 double) which can only be 1, 2 or 3. I need a code that...

4 years ago | 1 answer | 0

Question

Basic if statement with a cell array

Hello all, Let's say I have a basic cell array : x = {1 2 3 4 5 8}. Now, I want to verify that this array only contains those...

4 years ago | 1 answer | 0