Answered
How to find the frequency of unique rows in 3 columns of a table?
Var1 = {'Car';'Dog';'Car';'TV';'TV';'TV';'Car'} Var2 = {'red';'blue';'red';'green';'yellow';'green';'red'}; Var3 = {'X';'Y'...

4 years ago | 0

| accepted

Answered
Delete zero rows from a table
For a table named t: t(~t.speed,:) = []

4 years ago | 0

| accepted

Answered
Extracing the part of the string from cell array
regexp(a,'(?<=__)(.*)','match')

4 years ago | 2

| accepted

Answered
Find string in excel file
text = {'T_DCT_PK_WDT_W01B1_RANGE'; 'T_DCT_PK_WDT_W01B2_RANGE'; 'T_DCT_PK_WDT_W02B1_RANGE'; 'T_DCT_PK_WDT_W02B2_RANGE'} ...

4 years ago | 0

Answered
Populate cell array dynamically
ssnname = {'D1S02';'D3S11';'D3S12'} ssnend = [10 20 24] ssnend = num2cell([ssnend(1) diff(ssnend)]) output = cellfun...

4 years ago | 0

| accepted

Answered
I'm not sure why what I wrote isn't working in terms of extracting the string I want.
filename = 'Synch_ab001.mat'; subjectname = regexp(filename,'(?<=_)(.*)(?=\.\w*)','match')

4 years ago | 0

| accepted

Answered
Hey guys, i need help with vector maniuplation
v = -3:1:3 w = v w(w<0) = w(w<0)*2

4 years ago | 1

| accepted

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

4 years 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; ...

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

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

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

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

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

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

4 years ago | 0

| accepted

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

4 years ago | 3

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

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

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

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

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

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

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

4 years 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); ...

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

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

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

4 years ago | 0

| accepted

Load more