Question


multiply each column of a cell matrix that contains NaN by 8
Dear all, I have A={ 'NaN' 'NaN' '2' '2' '8' 'NaN' '10' '10' ...

meer dan 12 jaar ago | 1 answer | 0

1

answer

Question


replicating the elements of a cell matrix
Dear all, here is a cell matrix k={ 12 'kol' 23 'Sew' 45 'awe' 44 'wow' } I would lik...

meer dan 12 jaar ago | 2 answers | 0

2

answers

Question


Erase all the rows that contain NaN
Dear all I have [N,T,R]=xlsread(name) I want to erase all the rows in R that contain only NaN thanks [EDITED,...

meer dan 12 jaar ago | 3 answers | 0

3

answers

Question


xlswrite and more efficient coding
Dear all, I have the following command xlswrite('data_Aus_Di_out'1.xlsx', yy ,'Sheet1', 'A2') I would like to have s...

meer dan 12 jaar ago | 1 answer | 0

1

answer

Question


:cell matrix: transfering the second element of a row to the second element of the next row
Dear all, I have the following problem I have a cell matrix A where the first 2 columns are [1x28 char] ...

meer dan 12 jaar ago | 1 answer | 0

1

answer

Question


Detecting a particular word in a cell vector
Dear all, I have a matrix whose first column is : 'MAR' ' POPSIZE' 'OTHTOTAL' ' CONIZE' ' ...

meer dan 12 jaar ago | 3 answers | 0

3

answers

Question


erasing all the rows that begin with NaN
I have a cell matric. The first two columns of this matrix are [1x28 char] [ NaN] [ ...

meer dan 12 jaar ago | 3 answers | 0

3

answers

Question


constructing a particular "if statement"
Hi, I have [N,T,R]=xlsread(name); R is a cell matrix N is a double array R(:,2) contains string variables and zer...

meer dan 12 jaar ago | 1 answer | 0

1

answer

Question


equivalence of the codes that can be used for erasing the first row of R if cell R(1,3) is occupied by NaN?
Dear all, Could you please verify the equivalence of the codes that can be used for erasing the first row of R if cell R(1,...

meer dan 12 jaar ago | 1 answer | 0

1

answer

Question


erase a column that contains at least one zero
Hi all, I have [N,T,R]=xlsread(name); R(:,2) contains NaNs and string variables. But sometimes R(:,2) contains and z...

meer dan 12 jaar ago | 1 answer | 0

1

answer

Question


cross checking across excel files
Dear all, I have 2 excel files say A and B. A contains 3 sheets but in B all these sheets are merged. I want to compare A...

meer dan 12 jaar ago | 0 answers | 0

0

answers

Question


problem with xlsread:Bizarre results
Dear all, I have an excel file that contains 3 sheets when I look at each of these sheets inside the excel file they a...

meer dan 12 jaar ago | 2 answers | 0

2

answers

Question


using a "for loop" for writing a code more compactly
Dear all, My analysis is repeated every block of 3 sheets of an excel file as follows clear all xlfilename = 'xa....

meer dan 12 jaar ago | 1 answer | 0

1

answer

Question


"permat" and more efficient coding
Dear all, I have this list of countries listl={'ATl' 'BEl' 'ESTl' 'FRl' 'DEl' 'GRl' 'IEl' 'ITl' 'NETHl' 'PTl' 'SLOVA...

meer dan 12 jaar ago | 1 answer | 0

1

answer

Question


A challenging question:merging excel files under a specific pattern
A challenging question: merging excel files under a specific pattern Dear all, I have an excel file that contains 6 sheets...

meer dan 12 jaar ago | 1 answer | 0

1

answer

Question


eliminating, whenever is necessary the first column in nun where [num,txt,raw]=xlsread('data.xlsx');
Dear all, I am struggling to find a solution to the following problem. I load many excel files Say for instance that I load t...

meer dan 12 jaar ago | 1 answer | 0

1

answer

Question


Replacing a row with another one
Dear all, I have a cell matrix A and I want to replace the 6th row with another one that I have created Is there a wa...

meer dan 12 jaar ago | 1 answer | 1

1

answer

Question


Detecting and eliminating numbers from a cell matrix that contains NaNs and string characters
Dear all, I have a cell matrix An example is the following total(1:20,1:2) ans = [ NaN] [ ...

meer dan 12 jaar ago | 1 answer | 0

1

answer

Question


How do I use a single or double pipe (vertical line) in an "or" statement?
I have the following code if k==39 or K==90 do that else do that end My question is how to replace the |or...

meer dan 12 jaar ago | 2 answers | 0

2

answers

Question


if statement to check if the first column of a cell matrix is empty or nor
Dear all, I load an excel file into Matlab. For example: [num,txt,raw]=xlsread('koi.xlsx'); data=num; % contai...

meer dan 12 jaar ago | 1 answer | 0

1

answer

Question


creating a repeated matrix 2
Hi all, I have k1x=repmat(h(19,1), [3,1]) ; k2x=repmat(h(37,1), [3,1]) ; k3x=repmat(h(55,1), [3,1]) ...

meer dan 12 jaar ago | 1 answer | 0

1

answer

Question


creating a repeated matrix
HI all, I have the following code k1=repmat({'S1'}, [3,1]) ; k2=repmat({'S2'}, [3,1]) ; k3=repmat({'S3'}, [3...

meer dan 12 jaar ago | 1 answer | 0

1

answer