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

ongeveer een jaar ago | 3 answers | 0

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

ongeveer een jaar ago | 1 answer | 0

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?

meer dan een jaar ago | 2 answers | 0

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

meer dan een jaar ago | 0 answers | 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

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

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

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

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

bijna 2 jaar ago | 1 answer | 0

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

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

bijna 2 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?

bijna 2 jaar ago | 3 answers | 0

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

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

ongeveer 2 jaar ago | 1 answer | 0

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

ongeveer 2 jaar ago | 3 answers | 0

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

ongeveer 2 jaar ago | 2 answers | 0

Question

find the closest higher date

A=[1000 716606 1000 716971 1000 717336 1000 717702 1000 718067 1000 718432 1000 718797 1000 719163 100...

ongeveer 2 jaar ago | 2 answers | 0

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

meer dan 2 jaar ago | 1 answer | 0

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

meer dan 2 jaar ago | 2 answers | 0

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

bijna 3 jaar ago | 1 answer | 0

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

bijna 3 jaar ago | 1 answer | 0

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

bijna 3 jaar ago | 2 answers | 0

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

bijna 3 jaar ago | 1 answer | 0

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

bijna 3 jaar ago | 1 answer | 0

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

bijna 3 jaar ago | 1 answer | 0

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

bijna 3 jaar ago | 0 answers | 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?

bijna 3 jaar ago | 3 answers | 0

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

bijna 3 jaar ago | 1 answer | 0

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

bijna 3 jaar ago | 1 answer | 0

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

ongeveer 3 jaar ago | 3 answers | 0

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

ongeveer 3 jaar ago | 0 answers | 0