Community Profile

photo

Danielle Leblance


Last seen: 4 years ago Active since 2016

Followers: 0   Following: 0

Statistics

  • Thankful Level 4

View badges

Feeds

View by

Answered
finding unique phrases and their frequency in a cell array
It appears that the solution is problematic for frequency of observations when you have blanck cells. I received for instance th...

4 years ago | 0

Answered
Formating a table with unequal rows
Thanks. I am receiving an error for line 10: Unrecognized table variable name 'Alg_'.

4 years ago | 0

Question


Formating a table with unequal rows
I generated the number of employees in 4 countries and i was expecting my sample to be distributed in each country across all ca...

4 years ago | 3 answers | 0

3

answers

Question


finding unique phrases and their frequency in a cell array
Hi, I usually deal with numbers but never with text. I have a cell array of phrases(attached the mat file) . I want to know wh...

4 years ago | 2 answers | 0

2

answers

Question


distribution of consecutive numbers
Hi , I have a column of 9 states (attached the file) . How can I know in this column how many times each state is followed by...

5 years ago | 3 answers | 0

3

answers

Question


terciles of a distribution
Hi, A is a 10000 x1 vector of numbers. I want to transform the vector to a vector of only 3 values: 1 , 2 , 3 where 1 refers ...

5 years ago | 1 answer | 0

1

answer

Question


reversing the inverse hyperbolic sine function
Y = asinh(X) to get Y which is the inverse hyperbolic sine value. I have Y , how can I get x?

5 years ago | 2 answers | 0

2

answers

Question


Replacing a column in a table
Hi, I want to replace a column A in table S with a table that has the column title A. In other words t=array2table(A)...

6 years ago | 0 answers | 0

0

answers

Question


Replace 0 with nans in a table
I am attaching a table, for the first row , I would like to replace zeros with nans for columns 8 to 13. This problems is rep...

6 years ago | 2 answers | 0

2

answers

Question


Converting categorical data to prespecified numbers
Hi, I have a categorical array : ['SC' 'SC' 'SC' 'SC' 'SC' 'SC' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' 'GA' ...

6 years ago | 2 answers | 0

2

answers

Question


Error using ismember for two cell arrays
attached two cell arrays that I am using in my analysis. When I use in a loop: ismember(StateName2,StateName1(i)) I rec...

6 years ago | 1 answer | 0

1

answer

Question


converting a date column with yyyymmdd to matlab date number?
Hi , I have a double(not a string)column where each observation is a number with the following format yyyymmdd.How can I conv...

6 years ago | 2 answers | 0

2

answers

Question


match a categorical array in a loop
Hi, isequal(AgeState,StateState(i)); is returning a 0 although I can see visually that AgeState which is a categorica...

6 years ago | 1 answer | 0

1

answer

Answered
Converting date string to number
I put it in excel and convert it to excel number then to matlab number using x2mdate function. So I have managed to find a way t...

6 years ago | 0

Question


Converting date string to number
I have a vector of the following format 01-Jul-1980 00:00:00 how can I convert to a matlab date number?

6 years ago | 3 answers | 0

3

answers

Question


how to get the column names of one matrix and assign nan to them
A=[A1,A2] ; where A, A1,A2 are tables I want to build matrix B such as: B=[B1,A2]; but this time A2 is the same ...

6 years ago | 0 answers | 0

0

answers

Question


Predicting one period ahead using neural networks
Hi, I have prices and i am trying to predict next period's price using neural network. I found a code on Mathworks website and ...

6 years ago | 1 answer | 0

1

answer

Question


Matching based on the first word
Hi, I have two cell arrays A and B where each contains companies names: for example A contains "Biotech Capital Corp" while ...

6 years ago | 3 answers | 0

3

answers

Question


replacing a row of an existing table with nans
if t is a table with a mix of numeric columns and text columns, how can i replace a specific row (let us say row 20 of t) with n...

6 years ago | 2 answers | 0

2

answers

Question


find the closest higher date
A=[1000 716606 1000 716971 1000 717336 1000 717702 1000 718067 1000 718432 1000 718797 1000 719163 100...

6 years ago | 2 answers | 0

2

answers

Question


Appending two tables of different sizes
I am matching two tables LC and Bordo using the year and the quarter columns that are common between the two. LC is a bigger tab...

7 years ago | 1 answer | 0

1

answer

Question


date computations in a table
I have a table LC that has a column of dates called "date". The date format is however 19850331. I want to extract the year and ...

7 years ago | 2 answers | 0

2

answers

Question


average of the past 12 observations without a loop
I have vector A. How can i create vector B with the same size of vector A where starting row 13 in B I compute the average of th...

7 years ago | 1 answer | 0

1

answer

Question


Clearing vectors with a certain size
Is it possible to clear from the workspace all variables that don't meet a certain size? for example, I have vectors with a siz...

7 years ago | 1 answer | 0

1

answer

Question


how to convert a table to vectors where each vector takes the name of the column in the table
if I have a table T where each column has a header, how can i convert the table to vectors where each vector takes the respectiv...

7 years ago | 2 answers | 0

2

answers

Question


Finding the index of dupplicate rows in a matrix
I have matrix M 275935x2 . I want to remove duplicate rows. I tried two methods: Method 1) M2=unique(M,'rows') % and it...

7 years ago | 1 answer | 0

1

answer

Question


Determine excel range in writetable function
I have multiple tables t1 t2...t45 and i want to write them on one sheet in excel using write table. All of them have the same n...

7 years ago | 1 answer | 0

1

answer

Question


Eliminating duplicate columns in a table when appending
Hi, I am importing data using readtable function. but when i append data using: mytable=[mytable mytable2]; I receive...

7 years ago | 1 answer | 0

1

answer

Question


nanmean of a variable that should meet 2 conditions
I have a matrix with time observations that are labelled as 1 till 92 for every firm in the matrix. S, assume time 1 refers to m...

7 years ago | 0 answers | 0

0

answers

Question


replacing NaN with dot in a table
I have table A where many numeric variables contain NAN values. How can i replace the NaN values with a dot?

7 years ago | 3 answers | 0

3

answers

Load more