Community Profile # Mia Dier

Last seen: 7 días ago Active since 2021

#### Statistics

• #### Content Feed

View by

Question

Indexing by using column names
I have a table with column names A, B C. I want to create an array col_index=[1 0 1] by using the column names only.

10 meses ago | 1 answer | 0

### 1

Question

Identifying same values of two arrays
I have two string arrays: array1 and array2. I want to create a variable named change that is equal to 0 if array1 and array2 ar...

12 meses ago | 1 answer | 0

### 1

Question

Naming variables according to the values of another variable
I have a variable A=[1;2;5] and I want to use the values of this variable in the name of the new variables I'm going to creat...

alrededor de 1 año ago | 1 answer | 0

### 1

Question

Rowfun without changing the order
I want to use rowfun but I don't want the resulting outcome to be sorted according to the grouping variables that I specify. I w...

más de 1 año ago | 0 answers | 0

### 0

Question

Conditional average (need help with speed)
I have a table that looks like this: country_id year M T average_T 1 2000 10 76 Na...

más de 1 año ago | 1 answer | 0

### 1

Question

How to count the number of times that the previous observation was repeated
I have a table that looks like this: country_id year M 1 2000 10 1 2001 ...

más de 1 año ago | 0 answers | 0

### 0

Question

How to add a NaN row at the beginning columns of a table?
I have a code that looks like this: A(:,1)=[NaN;B(1:end-1)]; A(T.id(1:end)~=[NaN;T.id(1:end-1)],1)=NaN; A(:,2)=[NaN;NaN;...

más de 1 año ago | 1 answer | 0

### 1

Question

Changing value when first time a value appears
A=[1; 1; 1; 1; 2; 2; 4; 4; 4; 4] B=[4; 2; 7; 9; 5; 0; 2; 6; 1; 0] I want to change the values of B to NaN whenever a value i...

más de 1 año ago | 1 answer | 0

### 1

Question

How to calculate the number of times the values of a column changes
I want to calculate the number of times of column A changes over the last 5 years for each id number not counting the current ye...

más de 1 año ago | 1 answer | 0

### 1

Question

Variance when only one observation is not NaN
I am trying to calculate a moving variance of the max last 5 years of observations. I have a tabke that looks like this: id ...

más de 1 año ago | 1 answer | 0

### 1

Question

EDITED: Variance when only one observation is not NaN
EDITED: I think my problem was not clear from the previous example. So, I added a new one below here: I am trying to calcula...

más de 1 año ago | 2 answers | 0

### 2

Question

How to count the number of times that values changes?
A=[1 1 1 2 1 3 3 1 1]' I want to get: B=[NaN 0 0 1 2 3 3 4 4]' The second and third values of B are 0 because A doesn't cha...

más de 1 año ago | 2 answers | 1