Community Profile

# Danielle Leblance

36 total contributions since 2016

View details...

Contributions in
View by

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

10 maanden ago | 3 answers | 0

### 3

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

10 maanden ago | 1 answer | 0

### 1

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?

ongeveer een jaar ago | 2 answers | 0

### 2

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

ongeveer een jaar ago | 0 answers | 0

### 0

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

meer dan een jaar ago | 2 answers | 0

### 2

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

meer dan een jaar ago | 2 answers | 0

### 2

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

meer dan een jaar ago | 1 answer | 0

### 1

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

meer dan een jaar ago | 2 answers | 0

### 2

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

meer dan een jaar ago | 1 answer | 0

### 1

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

meer dan een jaar 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?

meer dan een jaar ago | 3 answers | 0

### 3

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

meer dan een jaar ago | 0 answers | 0

### 0

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

meer dan een jaar ago | 1 answer | 0

### 1

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

bijna 2 jaar ago | 3 answers | 0

### 3

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

bijna 2 jaar ago | 2 answers | 0

### 2

Question

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

bijna 2 jaar ago | 2 answers | 0

### 2

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

ongeveer 2 jaar ago | 1 answer | 0

### 1

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

ongeveer 2 jaar ago | 2 answers | 0

### 2

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

meer dan 2 jaar ago | 1 answer | 0

### 1

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

meer dan 2 jaar ago | 1 answer | 0

### 1

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

meer dan 2 jaar ago | 2 answers | 0

### 2

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

meer dan 2 jaar ago | 1 answer | 0

### 1

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

meer dan 2 jaar ago | 1 answer | 0

### 1

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

meer dan 2 jaar ago | 1 answer | 0

### 1

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

meer dan 2 jaar ago | 0 answers | 0

### 0

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?

meer dan 2 jaar ago | 3 answers | 0

### 3

Question

Aggregating while removing the individual data
Hi, Is there a way to aggregate the data of a matrix in Matlab based on ID while removing the individual observations? in oth...

meer dan 2 jaar ago | 1 answer | 0

### 1

Question

Hi, I am writing a matrix to text using the following codes: fid = fopen('Datav1Call_1993.txt','w+'); for idx = 1...

meer dan 2 jaar ago | 1 answer | 0

### 1

Question

write table without nans to txt and csv
writetable(t,'D.csv') and writetable(t,'D.txt') are giving files with nan values. since the files are huge (around 1 milli...

meer dan 2 jaar ago | 3 answers | 0

### 3

Question

saving to stata format
Is there a way to write a matlab table to .dta (stata) format? my tabble is huge (1.1 million rows) and it would help greatlly i...

meer dan 2 jaar ago | 0 answers | 0