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

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

4 years ago | 0

| accepted

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

4 years ago | 2

| accepted

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Extract specific rows or columns containing letters (xxx) From dat File in Matlab

4 years ago | 0

| accepted

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

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

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

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

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