**Statistics**

RANK**130,188**

of 247,126

REPUTATION**0**

CONTRIBUTIONS

**39** Questions

**3** Answers

ANSWER ACCEPTANCE **
64.1%
**

VOTES RECEIVED**0**

RANK

of 17,230

REPUTATION**N/A**

AVERAGE RATING**0.00**

CONTRIBUTIONS**0** Files

DOWNLOADS **0**

ALL TIME DOWNLOADS**0**

CONTRIBUTIONS**0 Posts**

CONTRIBUTIONS**0** Public Channels

AVERAGE RATING

CONTRIBUTIONS**0** Highlights

AVERAGE NO. OF LIKES

**Content Feed**

Question

Table Find Duplicate Rows (double, char, datetime)

Hello, in table A with 100,000 rows and 40 columns, is there a way to find duplicate rows? The elements are of the type: double...

1 month ago | 1 answer | 0

### 1

answerQuestion

Extract first non-NaN of each row without loop

Hello, from a matrix where each row contains at least one non-NaN, is there away to extract the FIRST non-nan of each row withou...

1 month ago | 1 answer | 0

### 1

answerQuestion

In table, replace NaN with Text (from NaN to "ABCD")

Hello, In a column of a table, is there a non-loop way to replace the NaN for any fixed text say "ABCD" ? In the column that I ...

2 months ago | 2 answers | 0

### 2

answersQuestion

find ( strcmp ( many_different_elements )

Hello, I want to check if any of the elements of a cell CC with 90 elements are in column2 of a matrix w 10k rows. If so, to ret...

2 months ago | 2 answers | 0

### 2

answersQuestion

Stacking more than 200K files (same #columns)

Hello, I have more than 200,000 csv files I would like to put/stack/append/concatenate over each other. All csv file are in th...

2 months ago | 1 answer | 0

### 1

answerQuestion

stacking or appending tables with NaN and 'ABC' -- cell vs non-cell

Hello, with a loop and using readtable I am stacking a table on top of an existing table where var2 is sometimes NaN or sometime...

2 months ago | 1 answer | 0

### 1

answerQuestion

gunzip subfolders at once

Hello, I have gz files stored in many sub-sub-folders; is there way I can gunzip all files at once into a single folder single_f...

2 months ago | 1 answer | 0

### 1

answerQuestion

Moving mean/std based on number of NaN

Hello, Is there a way to compute movstd but replace with NaN if the window includes 2 or more NaN? A=[4, 8,6,3,NaN,NaN,-1,9,4,...

3 months ago | 2 answers | 0

### 2

answersQuestion

datetime InputFormat error in R2021a but works in R2017b ?

Hello, using datetime in R2021a brings an error while the same task works in R2017b, Is there a way to fix the issue in the newe...

3 months ago | 1 answer | 0

### 1

answerQuestion

find column variable sharing another column variable (table)

I have two variables where name1 shares name2 in some cases. unique(name1) is larger than unique(name2) name1={'ABC';'ABC';...

1 year ago | 1 answer | 0

### 1

answerQuestion

Remove variables not shared by 4 tables

Hello. How can I remove the variables not shared by 4 tables? Tables have the same number of rows but different number of variab...

2 years ago | 1 answer | 0

### 1

answerQuestion

Table Find/Replace based on condition (greater than)

Morning, In a table, how can I find values greater than 1 and replace them with NaN? I know about the ismissing family but it d...

2 years ago | 1 answer | 0

### 1

answerQuestion

"See" max 2nd-to-max values per column (by coloring entry)

Hello, is there a way to "see" the max and second-to-max by columns in a 100x20 array? If, so, where would you see it? I underst...

2 years ago | 1 answer | 0

### 1

answerQuestion

save figure "dynamic"

x=[1, 2, 3, 4]; y=[10, 100, -20, 300]; plot(x,y) Hello, Is there a way generate and save in extension eps or similar a "dynam...

2 years ago | 1 answer | 0

### 1

answerQuestion

Find common elements between two vectors and extract data from matrix (vectorized)

Hello, I understand this is different question than the one answered in https://www.mathworks.com/matlabcentral/answers/44285...

3 years ago | 1 answer | 0

### 1

answerQuestion

Using FIND for common elements WITHOUT a loop (Vectorized?)

Hello, I have an array A 100x1 with different datenum that I need to find in a big array B 5000000x1 (all datenum in B are...

3 years ago | 1 answer | 0

### 1

answerQuestion

Browse, search, click , save?

Hello Is there something similar to VBA: Dim myBrowser As Internet Explorer ... myBrowser.Document.getElementById("na...

3 years ago | 2 answers | 0

### 2

answersQuestion

Table: Reshape based on Cell Column and Sort

Is there a way to reshape or transform a table 7x3 table into a table with as many columns as the unique elements of a cell colu...

3 years ago | 1 answer | 0

### 1

answerQuestion

readtable changing range (not all contents)

Hello, Manually Importing an XLS file (right click import data) the window by default highlights a matrix, say C10:X90 If I m...

3 years ago | 1 answer | 0

### 1

answerQuestion

Input search string then record search result from a website

Hello all, I tried urlfilter, websave, webread, webwrite I have to search in a website by entering a search string in the we...

3 years ago | 0 answers | 0

### 0

answersQuestion

xlswrite from cell and strcat error 0x800A03EC

GreetingsI have a variable A={'H$1';'H$2';'H$3'} %a 4x1 cell % I need to generate an xlsx file with =(YesH$...

3 years ago | 1 answer | 0

### 1

answerQuestion

save to 2nd decimal, then add brackets

I needed to round a matrix of double to the second decimal. And also convert the second row such that each entry is in brackets,...

4 years ago | 1 answer | 0

### 1

answerQuestion

Combine two columns into one by first two rows A two rows B and so on

Hi, I want to combine two columns A and B (both 4x1) into one column C by using first the first two rows of A, then the first tw...

4 years ago | 1 answer | 0

### 1

answerlast daily observation in a month (not lbusdate)

Solved, used accumarray with @max

4 years ago | 0

| accepted

Question

last daily observation in a month (not lbusdate)

is there a way to keep only the last observation in a month from a datenum vector? For example A= 729530 ...

4 years ago | 1 answer | 0

### 1

answerQuestion

plotyy: manually modify secondary axis label position

How can I manually modify the position of the right y-axis label in a plotyy figure? In a plotyy, once I View/PlotBrowser and...

5 years ago | 0 answers | 0

### 0

answersQuestion

Align subplots non-manually

I have a figure with 5 subplots. Aside from doing it manually, is there are a way to set a 2x3 subplot figure in a way that th...

5 years ago | 1 answer | 0

### 1

answerQuestion

Create a folder for each iteration and save workspace and figures

Hello, I need to save the workspace and figures for each iteration. The resulting workspace and figures should be placed in a n...

6 years ago | 2 answers | 0

### 2

answersQuestion

If only one positive elem per row (rest are 0), then fill both sides of positive element

Hi, I have a square matrix of non-negative elements. In each row, at least one element is positive. For rows where there is...

7 years ago | 3 answers | 0

### 3

answersQuestion

Remove sub-matrix if any col are all nan (3D matrix)

Hi, In a 3D matrix, I have 4 sub-matrices of 3x3, like A below A=[1 2 nan; 2 5 nan; 4 2 nan]; A(:,:,2)=[3 4 5; 4 nan na...

7 years ago | 1 answer | 0