# lil brain

Last seen: ungefär 2 månader ago Active since 2022

Followers: 0   Following: 0

#### Feeds

View by

Question

How to average the columns within this cell array?
Hi, I have a deeply nested cell array of cells which contains a lot of doubles (C_512_eye_numeric). I am aiming to average the c...

### 1

Question

How to loop through cell array and apply script to each double?
Hi, I have a cell array of cell arrays of doubles called "C_512_numeric". I have the script called edit and I want to loop thro...

### 1

Question

How to convert tables into numeric arrays?
Hi I have the data set C_512 (see attached) and I want to make the tables within the cells of the cell array into numeric arrays...

### 1

Question

Importing files in bulk chnages table columns to NaNs
I have the following code in which I want to replace the column 37 in a table. I want to swap the column of categorical values f...

### 1

Question

How do I calculate the duration between two times?
Hi, I have two different data sets that each contain times in the format 'HH:mm:ss'. results_start_array (see attached) contai...

### 1

Question

ERROR: Error using {} Variable index exceeds table dimensions. How to apply function to all cells/tables?
Hi, I have a fucntion called "edit" which I want to apply to all columns of all tables in all cells in "results_velocity_diff" (...

### 2

Question

I want to calculate velocity. How do I apply my code to all tables in all cells?
Hi, I have a data set of distances (see "results_distances" attached) and want to calculate the velocity for each row in each t...

### 1

Question

I want to calculate distances in 3D space. How do I apply my code to all tables in all cells?
Hi, I want to use the formula d = sqrt((x2 - x1)^2 + (y2 - y1)^2 + (z2 - z1)^2) to calculate two distances. Each distance is be...

### 1

Question

How to split/segment csv file into multiple sections?
I have a file (called test_file.csv on my PC) that I want to split into several sections (I attached it as a .mat file here). F...

### 1

Question

Error: Index in position 2 exceeds array bounds.
Hi, I have a loop that loops over the cells in "balls_xyz". If the loop encounters a cell that is empty it is supposed to skip ...

mer än ett år ago | 1 answer | 0

### 1

Question

Error when calculating the distance between two three-dimensional points
Hi, I have a cell array that contains cells in which there are numerical arrays with 9 columns. In that numerical array the col...

mer än ett år ago | 1 answer | 0

### 1

Question

How do I loop over all columns in a cell array?
The following code caluclates the outliers above 3 standard deviations for a single column in balls_data{2,1}(:,1). data = ball...

mer än ett år ago | 3 answers | 0

### 3

Question

How can I do data cleaning/ data smoothing?
I have a cell array called "pre_data" with 1 column and 27 rows. Each element in the column contains a cell with 21 columns and ...

mer än ett år ago | 1 answer | 0

### 1

Question

Imputing missing values for a RM-ANOVA
I have 4 experimental groups/conditions and 5 measurement times for each group/condition. Each participant only took part in one...

mer än ett år ago | 0 answers | 0

### 0

Question

Why do I get: Error using sum Invalid data type. First argument must be numeric or logical?
Hi, I have a cell array called "pre_data" with 1 column and 27 rows. Each element in the column contains a cell with 21 colums ...

mer än ett år ago | 1 answer | 0

### 1

Question

How do I cut the columns in a cell of a cell array according to values in a numerical array?
Hi, I have the following problem at hand: I have a cell array called alldata with 24 cells. The first column in each cell of a...

nästan 2 år ago | 1 answer | 0

### 1

Question

Why does Matlab turn values of 100 into 1 when importing from csv files?
Hi, I use the following code to import data from csv files. [file_list,path_n] = uigetfile('*.csv', 'Grab csv', 'Multiselect'...

nästan 2 år ago | 0 answers | 0

### 0

Question

Error using discretize: Bin edges must be a vector that is real, numeric or logical, and monotonically increasing.
Hi, I have the following code: N = numel(newdata); split_newdata = cell(1,N); split_newdata_mean = cell(1,N); for ii = 1:N...

nästan 2 år ago | 1 answer | 0

### 1

Question

Why are some csv files imported incorrectly into my cell array?
Hi, I have a cell array called alldata whcih contains the contents of 24 csv files. However, when importing these files I can s...

nästan 2 år ago | 1 answer | 0

### 1

Question

How do I remove "nested/deeper" layers of a cell?
Hi, I have a cell called new_mat that has 2 levels (if I double click on a cell then another cell with the same value opens). I...

nästan 2 år ago | 1 answer | 0

### 1

Question

How do I average columns in cell array if some cells are empty?
Hi, I have a cell array called new_mat. I would like to compute the mean of all the values in each column and save the result i...

nästan 2 år ago | 2 answers | 0

### 2

Question

How do I average all the values for each column in a cell array?
Hi, I have a cell array called new_mat. I would like to compute the mean of all the values in each column and save the result i...

nästan 2 år ago | 2 answers | 0

### 2

Question

How do I convert a cell array with multiple values per cell into a numerical array with multiple rows?
Hi, I have a cell array called split_newdata_mean which contains multiple cells. Each of these cells contains five values in fi...

nästan 2 år ago | 2 answers | 0

### 2

Question

How do I compare the order of rows in cell array with a matrix?
Hi, I have a numerical array called split_points_rounded and a cell array called valid_high_IDs. The first column of split_poin...

nästan 2 år ago | 1 answer | 0

### 1

Question

How do I compare values in a cell array with values in another array and split the columns accordingly?
Hi, I have a cell array called newdata. Each cell contains two columns. The first contains seconds and the first column contain...

nästan 2 år ago | 1 answer | 0

### 1

Question

Error: Left and right key variables are not comparable because one is a non-cell
Hi, I have two tables which I want to join using the join() function. However, when I try to join them together like so: load ...

ungefär 2 år ago | 1 answer | 0

### 1

Question

How do I sort an array according to the first column?
Hi, I have a cell array which I would like to sort according to the first column. But when I try using high_emp_sort = sort(h...

ungefär 2 år ago | 1 answer | 0

### 1

Question

How do I concatenate cell arrays and line up the rows according to matching items in a column?
Hi, I have a few arrays (results from different tests) that all have the same first column (list of the participant IDs that pe...

ungefär 2 år ago | 1 answer | 0

### 1

Question

How do I index individual columns in an array?
Hi, I have a fairly basic question that I cant seem to solve. I have an array "high_perspective_taking" which has values from ...

ungefär 2 år ago | 1 answer | 0