Question

What is the difference between inner join and join?

I have two tables, A and B. They are almost identical but in different sorted by rows. I would like to tie them up by rows. ...

2 years ago | 1 answer | 0

Question

How to disable popups

Hi, I am running a large Matlab code in Matlab command window. It reads several .mat files. Every time it reads a file, a s...

2 years ago | 0 answers | 0

Question

How to find the part of a larger table or array that is not in a smaller table or array?

Hi, I have two tables A and B, each have a column dates, A.dates, B.dates. How to find out the part that is in B but not in A...

2 years ago | 1 answer | 0

Question

How to sort a matrix by row based on an index array

Hi, I have an index array ib which is a result of two table joining. I have a matrix M, I would like to sort M by rows accordi...

2 years ago | 1 answer | 0

Answered

How to subtract mean along rows?

I think both answers are correct but I don't know how to choose both.

How to subtract mean along rows?

I think both answers are correct but I don't know how to choose both.

2 years ago | 0

Question

How to subtract mean along rows?

Hi, I have a matrix 100x120 and I can group along the rows by findgroups. Then I use mean_mat = splitapply(@mean, mat, G) t...

2 years ago | 3 answers | 0

Question

How to get simulated values for a polynomial given the coefficients.

Hi, I need to simulation 1000 values out of a polynomial which I have the coefficients and errors. What is the best way to do...

2 years ago | 1 answer | 0

Question

Got error in joining two tables: Left and right key variables 'Date' and 'Date' include cells containing non-string values.

Hi, I have two tables a and b. Both have a column Date as datenum. When I use left join, I got this error: "Left and right k...

2 years ago | 1 answer | 0

Question

How to convert a datenum to a datetime?

Hi, I have table with column of datenum. I need to do a join with another table which has also a column of date but in just a ...

2 years ago | 2 answers | 1

Question

how to count values in an array of a structure C

I have an array of structure C of 5 elements. 'Values' is an array of doubles in each C(i). The numbers vary. How to count th...

2 years ago | 1 answer | 0

Answered

How to subtract Mean from Matrix along columns

Thanks to KL and John! Have a nice day!

How to subtract Mean from Matrix along columns

Thanks to KL and John! Have a nice day!

2 years ago | 0

Answered

How to subtract Mean from Matrix along columns

With the above help, found that bsxfun works for versions before 2017a: bsxfun(@minus, A, mean(A, 2))

How to subtract Mean from Matrix along columns

With the above help, found that bsxfun works for versions before 2017a: bsxfun(@minus, A, mean(A, 2))

2 years ago | 0

| accepted

Question

How to subtract Mean from Matrix along columns

Hi, In subtraction, there is an example of subtract mean from matrix: A - mean(A) and it works well. But I have a matrix A ...

2 years ago | 3 answers | 0

Question

Optmizing areas covered by bricks

Hi, I am facing an optimization problems. It is like, not exactly, to optimize the areas covered by irregular shaped bricks, su...

2 years ago | 2 answers | 0

Question

Question on fmincon in formulating a constrained optimization

Hi, I am facing a complex optimization problem. It is a constrained nonlinear minimization problem. So I use fmincon and it w...

2 years ago | 1 answer | 0

Question

Startup.m works well in 2016a but not in 2017a

My startup.m works well in 2016a but not in 2017a. It issues a variable or function not defined error in 2017a. I did indeed d...

2 years ago | 1 answer | 0

Question

What method/function should be used for large scale optimization

I am working on a large scale optimization (objective function is complex) non-linear optimization problem. What function in ...

2 years ago | 1 answer | 0

Question

How to form objective function with a class instance and a set of variables

Hi, I am trying to minimize an objective function by using fmincon(fun,x0,A,b,Aeq,beq,lb,ub). But I am having some difficult...

2 years ago | 1 answer | 0

Question

How to filter out multiple rows based on another array?

I have two arrays, a, b, one has numbers from 1,2, to 12. The other has 5 numbers 3,4, to 7. I want to filter out the rows i...

2 years ago | 1 answer | 0

Question

How to set up the path for a tree class download from internet?

Hi, I downloaded a tree class from the web and put it under Matlab's main path. It works. But when I tried to make it into a...

2 years ago | 1 answer | 0

Question

Why isn't strtrim working on my string?

Hi, I have a simple string, that has many leading spaces: a = ' abcd' I want to remove the white sp...

2 years ago | 1 answer | 0

Question

Unable to read a huge XML or text file

Hi, I have a XML of 2GB in size. I keep getting java heap memory error when loading it. So I am thinking of reading it in as...

2 years ago | 1 answer | 1

Question

How to fix a get sort row error?

I run a matlab based application with out any problem on my computer. But when I run the same app on a colleague's computer, ...

2 years ago | 1 answer | 0

Answered

Get error "Undefined function or variable 'xml_write'."

Just found out why, I didn't use import. Now it works.

Get error "Undefined function or variable 'xml_write'."

Just found out why, I didn't use import. Now it works.

2 years ago | 0

| accepted

Question

Get error "Undefined function or variable 'xml_write'."

I am trying a simple code to test xml_write but I got this: Undefined function or variable 'xml_write'. Why?

2 years ago | 1 answer | 0

Question

How to extract the first part of an array of strings by pattern?

Hi, I have an array of strings: L_Name. Each string has several "_" in it. I would like to have an array that take the firs...

3 years ago | 1 answer | 0

Question

Two table left join with 4 keys

Hi, I have two tables, A and B, each has 7 columns and 4 keys. I would like to left join by the 4 keys and show the rest 3 c...

3 years ago | 0 answers | 0

Question

How to use mat2cell in splitapply?

Hi, I used findgroup and get a G as the output. I would like to apply G to a numeric matrix (MxN) to split the matrix into s...

3 years ago | 2 answers | 0

Question

Primary key issue in insert a table into SQlServer database

Don't know why but keep getting this error: java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'PK__ANLS_SCO__D...

3 years ago | 1 answer | 0

Question

Keep getting error in splitapply

I keep getting this error but I checked my code again and again and can't find anything. Error using vertcat Dimensions of m...

3 years ago | 1 answer | 0