Question

How to use regexp to extract data?

Hi I have this cell array, and want to extract character before and after the "__" tdata = {'XX__TG','GB_TH','BN__TH'}'; I wan...

7 months ago | 1 answer | 0

Question

How to parse text to numbers?

Hi I have text cell str looking like this? Is there a way to use regexp to convert this matrix? ttxt = {'No info','1-50.000...

8 months ago | 1 answer | 0

Question

How to do vector calc for cost allocation

The problem seems simple to do it using for loop, but I wonder if there's an efficient way to do below calculation. costPerTota...

8 months ago | 0 answers | 0

Question

JDBC Connection to Oracle DB

Hi I have insalled the new Java driver and got the following error 'JDBC Driver Error: No suitable driver found for jdbc:oracl...

1 year ago | 0 answers | 0

Question

issue with writetable in 2019b

Hi I observed behavior changed in writetable function between 2019a and 2019b. In 2019a, when Matlab write data to excel file...

1 year ago | 2 answers | 0

Answered

How simulate correlated Poisson distributions

Is the List() function a default one? I got this error message gpRV = List(Xs',Ps'); % Note tran Undefined function '...

How simulate correlated Poisson distributions

Is the List() function a default one? I got this error message gpRV = List(Xs',Ps'); % Note tran Undefined function '...

2 years ago | 0

Question

How simulate correlated Poisson distributions

Hi Is there a way to simulate correlated RVs where each RV follows poisson distribution? I have 2 RVs X1 and X2, and both foll...

2 years ago | 3 answers | 0

Question

How to do pivot from table-type variable

Hi, I have this table-type data tdata.yearID=[1950;1950;1950;1951;1951;1951;1951;1952;1952;1952]; tdata.cluster=[1;3;...

2 years ago | 1 answer | 0

Question

How to avoid for-loop here; repmat

Hi Could anyone help suggest a faster way to construct this vector? xval = [1 2 7 9]; numX = [1 4 2 3]; % I want fina...

2 years ago | 1 answer | 0

Question

findpeaks with defined width

Is it possible to use findpeaks to sum values within bands. I am looking for a function that maximize sum values within a speci...

3 years ago | 0 answers | 0

Question

How To Accumulate data by maximizing sum value?

Hi, From data below, is there a fast way to identify a block of continuous data that will give largest sum, second largest sum ...

3 years ago | 0 answers | 0

Answered

How to get Lat/Lon from vec2mtx

I realized this is a bit off track. Similar to the Table join in SQL but applying the concept to spatial data. Simply it's e...

How to get Lat/Lon from vec2mtx

I realized this is a bit off track. Similar to the Table join in SQL but applying the concept to spatial data. Simply it's e...

3 years ago | 0

Question

How to get Lat/Lon from vec2mtx

I am trying to generate grid lat/lon for a given polygon. First I tried to get the grids on the boundary first using vec2mtx. ...

3 years ago | 2 answers | 0

Answered

De-allocation un-used spalloc

Also would nnz() or numel() provide actual #elements used?

De-allocation un-used spalloc

Also would nnz() or numel() provide actual #elements used?

3 years ago | 0

Question

De-allocation un-used spalloc

Hi For the S = spalloc(m,n,nz); function where users can pre-allocate non-zero elements, I wonder if there's a way to de-all...

3 years ago | 2 answers | 0

Answered

How to vectorize this operation

Each locid in the ELT has a unique set of eventid by the way

How to vectorize this operation

Each locid in the ELT has a unique set of eventid by the way

3 years ago | 0

Question

How to vectorize this operation

Hi, Could you help guide how I can vectorize this operation? I have the original fullset matrix which i want to retain and p...

3 years ago | 1 answer | 0

Question

cumsum within a group

Hi, Is there a faster way to do a cumulative sum within a group? data looks like year val cumval data=[1 10 10; 1 10 ...

5 years ago | 2 answers | 0

Question

regexprep with multiple expression

Hi, Is there a way to consolidate these regexprep into one expression? regexprep(ttxt, ' parish',''); regexprep(ttxt, ' bor...

8 years ago | 2 answers | 0