Community Profile

photo

Danielle Leblance


36 total contributions since 2016

Danielle Leblance's Badges

  • Thankful Level 3

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

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

10 maanden 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?

ongeveer een jaar 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)...

ongeveer een jaar 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...

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

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

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

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

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

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

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

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

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

bijna 2 jaar 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...

bijna 2 jaar 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...

bijna 2 jaar 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...

ongeveer 2 jaar 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 ...

ongeveer 2 jaar 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...

meer dan 2 jaar 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...

meer dan 2 jaar 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...

meer dan 2 jaar 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...

meer dan 2 jaar 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...

meer dan 2 jaar 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...

meer dan 2 jaar 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...

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

meer dan 2 jaar ago | 3 answers | 0

3

answers

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

answer

Question


adding headers when using fprintf to write to text
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

answer

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

answers

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

0

answers

Load more