Community Profile

photo

Danielle Leblance


36 2016 이후 총 참여 횟수

Danielle Leblance's 배지

  • Thankful Level 3

세부 정보 보기...

참여 게시물
보기 기준

질문


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

약 1년 전 | 답변 수: 3 | 0

3

답변

질문


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

약 1년 전 | 답변 수: 1 | 0

1

답변

질문


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?

1년 이상 전 | 답변 수: 2 | 0

2

답변

질문


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

1년 이상 전 | 답변 수: 0 | 0

0

답변

질문


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

1년 이상 전 | 답변 수: 2 | 0

2

답변

질문


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

1년 이상 전 | 답변 수: 2 | 0

2

답변

질문


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

1년 이상 전 | 답변 수: 1 | 0

1

답변

질문


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

1년 이상 전 | 답변 수: 2 | 0

2

답변

질문


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

2년 이하 전 | 답변 수: 1 | 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...

2년 이하 전 | 0

질문


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?

2년 이하 전 | 답변 수: 3 | 0

3

답변

질문


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

2년 이하 전 | 답변 수: 0 | 0

0

답변

질문


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

약 2년 전 | 답변 수: 1 | 0

1

답변

질문


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

약 2년 전 | 답변 수: 3 | 0

3

답변

질문


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

약 2년 전 | 답변 수: 2 | 0

2

답변

질문


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

약 2년 전 | 답변 수: 2 | 0

2

답변

질문


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

2년 이상 전 | 답변 수: 1 | 0

1

답변

질문


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

2년 이상 전 | 답변 수: 2 | 0

2

답변

질문


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

3년 이하 전 | 답변 수: 1 | 0

1

답변

질문


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

3년 이하 전 | 답변 수: 1 | 0

1

답변

질문


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

3년 이하 전 | 답변 수: 2 | 0

2

답변

질문


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

3년 이하 전 | 답변 수: 1 | 0

1

답변

질문


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

3년 이하 전 | 답변 수: 1 | 0

1

답변

질문


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

3년 이하 전 | 답변 수: 1 | 0

1

답변

질문


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

3년 이하 전 | 답변 수: 0 | 0

0

답변

질문


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?

3년 이하 전 | 답변 수: 3 | 0

3

답변

질문


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

3년 이하 전 | 답변 수: 1 | 0

1

답변

질문


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

3년 이하 전 | 답변 수: 1 | 0

1

답변

질문


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

약 3년 전 | 답변 수: 3 | 0

3

답변

질문


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

약 3년 전 | 답변 수: 0 | 0

0

답변

Load more