Community Profile

# Bob Nbob

362 2016 年以降の合計貢献数

#### Bob Nbob's バッジ

How can remove Excel column by MATLAB
The simplest way is to load the excel file with xlsread, then write the data back with only the desired columns using xlswrite. ...

1日 前 | 0

| 採用済み

Plotting a matrix in a for loop.
With MATLAB you don't really want to perform the plot inside the loop in this case. Just save your results in a matrix and plot ...

9日 前 | 0

How to save more than the last matrix in a for cycle
You need to index Sigma_elem. Sigma_elem(:,:,i,N)=EPSM(N,1:6).*e_mat/0.6; % Or something similar

14日 前 | 0

Plotting a 3-D Matrix, but only for some points
I would suggest using scatter3 to make the actual plot. I would suggest using something like find to identify the locations of t...

14日 前 | 0

how to calculate how many rows are having numeric values in a particular cell of an excel sheet data.
Read the file with xlsread, filter the NaN values, then determine the number of the remaining values. numnumerics = sum(~isnan(...

15日 前 | 0

| 採用済み

Extract and code gender string as number using if loop
Just to clarify, you have 'gender' as two separate variables, once as a variable called 'gender' which will have a numeric assig...

16日 前 | 0

overly convoluted elseif condition
You can replace all of them with a single statement and indexing. if x>=1 & x<=4 y = p(x); else y = 1; end

21日 前 | 0

| 採用済み

How to increment matrix row only inside a nested for loop?
The solution is indexing. You can do math in your index if you need to. x((i-1)*5+j) = i*j;

29日 前 | 0

filtering data with a for loop and plot only filtered data
This can be done much more simply with logic indexing. quer = meas.ay.data; quer = quer(quer > 1.5 | quer < -1.5); plot(quer)...

| 採用済み

Replace values in collumns
You can just index your matrix to reorder it, assuming all of the columns are the same type of data (i.e. all of column 6 is z2,...

2 variable for-loop
The issue is with your definition of test. Nested for loops are totally fine. test(:,ss)=TKE_dave(:,ss); On your last loop te...

| 採用済み

Error Unable to perform assignment because dot indexing is not supported for variables of this type.
You are receiving the error because you have already defined the class of the first level as a character. In order to add a seco...

| 採用済み

Changing Variable in matrix
Why are you originally defining A as A = [a b c]? This isn't very common or efficient matlab usage. I would suggest starting wit...

Could someone please optimize this code?
I don't know about 'optimized,' but I'm pretty sure you can remove the entire for loop by vectorizing. Also, suppressing your va...

How can I assign a variable to all the columns and all the rows of a matrix?
You don't need to actually create a new variable for this, you can just use the results from size. A = randi(100,20,10); [r,c]...

A for loop with matrix as step
I'm confused what you're trying to do. From the psuedo code you wrote it looks like you're trying to loop through each of the a...

Choose a cell array that satisfy better some criteria
Ok, here is what I have come up with. It will probably still need some tweaking, but you should be most interested in the calcul...

| 採用済み

Is the find function a robust method to determine the number of specific values in a Matrix?
That method will certainly work, and I would generally use the same concept. I would just use the sum command though to avoid th...

| 採用済み

can any one explain this line of the code.
Per matrix math rules, when you add a single value to a matrix, that operation is applied to all values of the matrix individual...

| 採用済み

Find all the words contained in a file and make an index
You are on the right track, but you aren't calling the word index correctly. Also, I would suggest using strfind instead of the ...

2ヶ月 前 | 0

| 採用済み

Describing a sum with a while loop
I'm pretty sure that adding a big number to 0 will bump you over pi on the first iteration, but maybe that's just me. I would do...

2ヶ月 前 | 0

Select value from the list by defining criteria
I would use readtable to import the data, the logic indexing to narrow down the results. data = readtable('mydata.xlsx'); redu...

2ヶ月 前 | 0

| 採用済み

How to make matlab variables named as excel header
It sounds like readtable might be what you're looking for. I don't think it's exactly what you're asking, but it should recogniz...

2ヶ月 前 | 0

Matrix from an array
Not sure how to do it without a loop or just defining the indices, but here's something simple. A = 1:15; for i = 1:length(A)/...

2ヶ月 前 | 0

I want to circular shift rows of ' ww ' this circular shift depend on the numbers of 'r' array in the order , when the r numbers is change the circular shift is change for the ww array rows .
If I am understanding r correctly, you want to move the respective rows from their current positions to that position plus r(i)....

3ヶ月 前 | 1

| 採用済み

Extract Variable/column with variable name from table
I believe you can get this as a return. T.Properties.VariableNames % T is the table variable Additionally, because you're putt...

3ヶ月 前 | 0

My code is generating this error " Index exceeds matrix dimensions" . Apparently it looks fine. Still can not figure out the problem.
dfdc1(i,j) = (L/M) - M*(log(1 - c1(i,j) - c2(i,j)) - log(c1(i,j)))/M; c1 and c2 are defined as single values (0.1 and 0.0001), ...

3ヶ月 前 | 0

| 採用済み

Extracting data from ascii file using regexp
I have an ascii file which produces the following text. 1 \$FLAG1 NP1=8.,NP2=1.,P2=2.36,P3=3000000., 2 P1=0.,4....

3ヶ月 前 | 0 件の回答 | 0

### 0

Create variable from an excel entry
Hmm, I normally wouldn't recommend anybody do this, and others might still disagree, but I think eval will do what you're lookin...

3ヶ月 前 | 0

Removing nested for loops for quicker time
I'm shooting in the dark a bit on this one, but I think you can get rid of both loops. The only thing I'm not entirely sure abou...

3ヶ月 前 | 0