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

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

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

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

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

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

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

5 years ago | 2 answers | 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...

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

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

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

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

6 years ago | 2 answers | 0

Answered
De-allocation un-used spalloc
Also would nnz() or numel() provide actual #elements used?

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

6 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

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

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

8 years ago | 2 answers | 0

Answered
regexprep with multiple expression
Yes. Thanks

11 years ago | 0

Question

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

11 years ago | 2 answers | 0