Community Profile

photo

Dave


Last seen: 7 days ago Active since 2014

Statistics

  • Thankful Level 3

View badges

Content Feed

View by

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

answer

Question


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

answer

Question


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

answers

Question


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

answers

Question


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

answer

Question


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

answer

Question


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

answer

Question


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

answers

Question


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

answer

Question


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

answer

Question


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

answer

Question


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

answer

Question


"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

answer

Question


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

answer

Question


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

answer

Question


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

answer

Question


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

answers

Question


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

answer

Question


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

answer

Question


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

answers

Question


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

answer

Question


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

answer

Question


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

answer

Answered
last 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

answer

Question


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

answers

Question


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

answer

Question


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

answers

Question


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

answers

Question


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

1

answer

Load more