Community Profile

photo

Paolo


57 total contributions since 2018

Paolo's Badges

  • Knowledgeable Level 3
  • Thankful Level 1
  • Solver
  • First Answer

View details...

Contributions in
View by

Answered
Vector with various IFs, adding up and counting down
X = [ 5 2 -4 -6 -2 1 4 2 -3 -6 -1 8 9 ]; indx = find(X<0); Y = [zeros(1,indx(1)-1) cumsum(X(indx(1):end))]; Y(Y>0) = 0; ...

4 days ago | 0

Answered
How do I Subscript Duration Row times with Date Time values?
opts = detectImportOptions('QuakeTrials.csv'); opts.MissingRule = 'omitvar'; T = readtable('QuakeTrials.csv',opts); T.D...

4 days ago | 0

Answered
Extracting a number from certain line of .txt file
For the values which follow "COLLAPSE MULTIPLIER = ", you can simply use a positive lookbehind which checks for the pattern you ...

4 days ago | 0

| accepted

Answered
Excluding one vector from another vector with repetition
S=[1 3 0 2 0 0]; C=[0 2]; [~,col] = ismember(C,S); S(col) = []; S = 1 3 0 0

5 days ago | 2

| accepted

Answered
Selecting points from a matrix
x = [9,10,3,2,6;3,1,7,8,10]; x = 9 10 3 2 6 3 1 7 8 10 x(x<9 | x>10) = 0; ...

5 days ago | 0

| accepted

Answered
Convert part of a string to number
You can use <https://uk.mathworks.com/help/matlab/ref/regexp.html regexp> to simply match the digits in your input. NA = reg...

6 days ago | 0

| accepted

Solved


Remove any row in which a NaN appears
Given the matrix A, return B in which all the rows that have one or more <http://www.mathworks.com/help/techdoc/ref/nan.html NaN...

6 days ago

Answered
Removing specific characters from string in nested cells
Perhaps this can easily be achieved in two steps. For your input: 1 ****TABLE1**** COLUMN1= 1.12, 2.23, 3.34, 4.45,...

8 days ago | 0

| accepted

Answered
Extracting parts of a string
The following code uses <https://uk.mathworks.com/help/matlab/ref/regexp.html regexp> to extract the data you want. You can play...

8 days ago | 0

| accepted

Answered
How can I get successive difference and later add all the difference?
x = [735954.715277778 735954.716412037 735954.717766204 735954.717824074 735954.717916667 735954.863611111 735955.043206019 735...

9 days ago | 1

| accepted

Answered
If I have file names listed in a readtable how do I get it to extract part of the file name?
You have two options for extracting that data. The first is the simplest one. Since you said that that information always occu...

9 days ago | 0

| accepted

Answered
How to covert a datenum (serial number) back to original date time format
Please note that in your example for time all datenum values are the same. time = [735235]; dates = datetime(time,'Convert...

9 days ago | 0

Answered
Remove rows with NaN from a table
Use <https://uk.mathworks.com/help/matlab/ref/rmmissing.html rmmissing> : T = table([38;43;38;40;49],[71;NaN;64;67;64],[176...

10 days ago | 1

| accepted

Answered
How to read a data from txt file: only a specific part of txt
You can use <https://uk.mathworks.com/help/matlab/ref/regexp.html regexp> to match the sampling value. The expression below assu...

10 days ago | 0

| accepted

Answered
Extracting a file path from a .txt file
You can use <https://uk.mathworks.com/help/matlab/ref/regexp.html regexp> to match the path in your .txt file. corr = filere...

11 days ago | 0

Answered
Reading, finding and storing the lines from comma-separated text file into a matrix
The best way to parse your .txt file is probably <https://uk.mathworks.com/help/matlab/ref/regexp.html regexp>. corr = filer...

11 days ago | 0

Answered
Remove text from a text file without otherwise altering the file
You can use <https://uk.mathworks.com/help/matlab/ref/regexprep.html regexprep> for this purpose. x1 = 'G1 X104.650 Y95.350 ...

12 days ago | 0

| accepted

Answered
Extract specific rows or columns containing letters (xxx) From dat File in Matlab
The code below reads the xlsx file as a table |t| using <https://uk.mathworks.com/help/matlab/ref/readtable.html readtable> and ...

12 days ago | 0

| accepted

Answered
How do i get thindex of the rows where 'NaN' elements are there in a cell array?
Find the rows where NaN occurs, with "a" being your cell array: [row,~]= find(cell2mat((cellfun(@(x) any(isnan(x)),a,'un',0...

12 days ago | 0

| accepted

Answered
how can remove words and split in cellarray in matlab
*For input*: x = {'100614,Peter Beadle,131542'} You can use <https://uk.mathworks.com/help/matlab/ref/regexp.html regexp>...

13 days ago | 1

| accepted

Answered
Getting the minimum distance in a coordinates array
Your input: x = [938;810;147;1162;494;383;203]; y = [845;1012;875;810;1039;897;1010]; Sort x: [tmpx,i] = sort(x); ...

14 days ago | 0

Answered
How do I delete specific elements from a matrix?
Tijdgoed((Tijdgoed > 10 | Tijdgoed <-10)) = []; You can confirm by using: find(Tijdgoed>10) find(Tijdgoed<-10) wh...

14 days ago | 1

| accepted

Answered
How can i Replace missing values from Timetable
Input timetables: tt1: Time Var1 ___________ ____ 13-Apr-2018 30.1 25-Apr-2018 NaN...

14 days ago | 0

| accepted

Answered
Color of plots when there are multiple plots
Since you specified that you do not wish to specify the color manually, you can use: plot(Date,A,'Color',rand([1 3])) To ...

15 days ago | 0

| accepted

Answered
How to keep unique rows
You can determine the common values between the two cell arrays with <https://uk.mathworks.com/help/matlab/ref/intersect.html in...

15 days ago | 1

| accepted

Answered
merging date and time
Nicole, the following example should help you in what you are trying to do. I have added some comments in the code to help you. ...

16 days ago | 0

Answered
Replacing NaN with the average of previous and next cell value
If you are working with a table: %Table. var = {'time';'exp1'}; time = [1;2;3;4;5;6;7;8]; exp1 = [45;67;78;NaN;80;81;8...

16 days ago | 1

Answered
How to Separte table data from html?
You should be using <https://uk.mathworks.com/help/matlab/ref/webread.html webread> rather than <https://uk.mathworks.com/help/m...

17 days ago | 0

| accepted

Answered
picking maximum difference across entries of row vectors
Perhaps a simpler solution which only requires a sort: A = [1 3 6 7 10]; A = sort(A); B = A(end) - A(1); B = ...

17 days ago | 1

| accepted

Answered
Different colors for each item in listbox of an app designer
It is possible to change the color of a uicontrol popup element as explained <https://uk.mathworks.com/matlabcentral/answers/78...

18 days ago | 0

Load more