Dave

Last seen: 5ヶ月前 | 2014 以来アクティブ

Statistics

Content Feed

質問

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

7ヶ月前 | 1 件の回答 | 0

1

回答

質問

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

7ヶ月前 | 1 件の回答 | 0

1

回答

質問

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

7ヶ月前 | 2 件の回答 | 0

2

回答

質問

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

7ヶ月前 | 2 件の回答 | 0

2

回答

質問

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

7ヶ月前 | 1 件の回答 | 0

1

回答

質問

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

7ヶ月前 | 1 件の回答 | 0

1

回答

質問

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

7ヶ月前 | 1 件の回答 | 0

1

回答

質問

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

9ヶ月前 | 2 件の回答 | 0

2

回答

質問

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

9ヶ月前 | 1 件の回答 | 0

1

回答

質問

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

約2年前 | 1 件の回答 | 0

1

回答

質問

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年以上前 | 1 件の回答 | 0

1

回答

質問

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年以上前 | 1 件の回答 | 0

1

回答

質問

"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年以上前 | 1 件の回答 | 0

1

回答

質問

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

3年弱前 | 1 件の回答 | 0

1

回答

質問

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年以上前 | 1 件の回答 | 0

1

回答

質問

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年以上前 | 1 件の回答 | 0

1

回答

質問

Browse, search, click , save?
Hello Is there something similar to VBA: Dim myBrowser As Internet Explorer ... myBrowser.Document.getElementById("na...

3年以上前 | 2 件の回答 | 0

2

回答

質問

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年以上前 | 1 件の回答 | 0

1

回答

質問

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年以上前 | 1 件の回答 | 0

1

回答

質問

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年以上前 | 0 件の回答 | 0

0

回答

質問

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

約4年前 | 1 件の回答 | 0

1

回答

質問

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年以上前 | 1 件の回答 | 0

1

回答

質問

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年以上前 | 1 件の回答 | 0

1

回答

回答済み
last daily observation in a month (not lbusdate)
Solved, used accumarray with @max

4年以上前 | 0

| 採用済み

質問

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年以上前 | 1 件の回答 | 0

1

回答

質問

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

6年弱前 | 0 件の回答 | 0

0

回答

質問

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

6年弱前 | 1 件の回答 | 0

1

回答

質問

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

約7年前 | 2 件の回答 | 0

2

回答

質問

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年前 | 3 件の回答 | 0

3

回答

質問

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年以上前 | 1 件の回答 | 0

1

回答

もっと読み込む

Dave

Statistics

Thankful Level 4

MATLAB Answers

Content Feed

1

1

2

2

1

1

1

2

1

1

1

1

1

1

1

1

2

1

1

0

1

1

1

1

0

1

2

3

1