photo

Mia Dier


Last seen: 1 year ago |  Active since 2021

Followers: 0   Following: 0

Statistics

  • Thankful Level 3

View badges

Feeds

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.

3 years ago | 1 answer | 0

1

answer

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...

3 years ago | 1 answer | 0

1

answer

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...

3 years ago | 1 answer | 0

1

answer

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...

4 years ago | 1 answer | 0

1

answer

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...

4 years ago | 1 answer | 0

1

answer

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 ...

4 years ago | 0 answers | 0

0

answers

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;...

4 years ago | 1 answer | 0

1

answer

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...

4 years ago | 1 answer | 0

1

answer

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...

4 years ago | 1 answer | 0

1

answer

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 ...

4 years ago | 1 answer | 0

1

answer

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...

4 years ago | 2 answers | 0

2

answers

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...

4 years ago | 2 answers | 1

2

answers

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 ...

4 years ago | 1 answer | 0

1

answer