Answered
combine two cell into one string
opt=detectImportOptions('SummaryResult - Copy.xlsx'); opt.VariableTypes(1:2)={'char'}; tG=readtable('SummaryResult - Copy.xlsx...

4 years ago | 1

Answered
How to import multiple variable starting the same from excel?
Guessing from the above code snippet, try something like W1_data= readtable(waffer1); isDrainVar=startsWith(W1_data.Properties...

4 years ago | 1

Answered
Set one common Xaxis for a sublot with rows = 1 and columns = 2
I overlooked the labels in the original Q? body and thought was to have a combination axis itself of some sort based on title --...

4 years ago | 0

| accepted

Answered
regstats The design matrix has more predictor variables than observations.
The problem is NOT that there are NaN or Inf in the data (although that could also be a cause since they're treated as missing v...

4 years ago | 0

Answered
how to plot using surf function?
osmotisk_data = readtable("tester_tabeller.xlsx"); x = osmotisk_data{:,3}; y = osmotisk_data{:,1}; z = osmotisk_data{:,2}...

4 years ago | 0

Answered
How do I change the tick label rotation on my colorbar?
They've hidden some of the ruler properties -- you have to use/access the underlying numeric ruler properties -- cb.Ruler.TickL...

4 years ago | 2

| accepted

Answered
Output argument 'ENA' is not assigned on some execution paths
1, You don't have an else clause so it is possible to select a set of inputs the combination of which will not satisfy any of t...

4 years ago | 0

Answered
How to ensure that MATLAB reads the first column as a column in a table?
rownames are table metadata; they are NOT a variable which is why the column variable heading doesn't show up for them -- the ta...

4 years ago | 0

Answered
dividing a distance double by a duration time to get rate
A datenum is a double; you must mean a datetime -- subtracting them does create a duration type/class, yes. There are some wart...

4 years ago | 0

| accepted

Answered
How to detect and manage occurrencies in a large .csv file?
Start perhaps with something like >> tAst=readtable('table.csv'); tAst.S_C=categorical(tAst.S_C); tAst.Sol_inters=categorical...

4 years ago | 0

| accepted

Answered
How to map one array elements to another array elements?
>> awardCoef=[-10,50]; >> conc=polyval(awardCoef,feederNum) conc = 40 30 30 10 20 40 >> More genericall...

4 years ago | 0

Answered
Append and add lines in text/dat file
"..., and the easiest way to do this would be (if appending itself is impossible) to rewrite the line in its entirety by simply ...

4 years ago | 0

| accepted

Answered
How do I create a beeswarm plot and boxplot together?
The basic starting point isn't difficult; some tedium in setting all the conditional fixups of symbols, colors, etc, etc., ... b...

4 years ago | 0

Answered
Multiply only certain columns in a matrix with a constant
M(:,end-5:end)=c*M(:,end-5:end);

4 years ago | 1

Answered
Extract the Transport names from the list of adapter names
I was going after @chrisw23's mode as I have a terrible time with regexp -- I can find both the start and the end of the string,...

4 years ago | 0

| accepted

Answered
converting .txt file to .csv file with mixed delimiter
Using the import tool manually, just go to the section on 'delimiters' and check the comma as well as the identified blank -- it...

4 years ago | 1

Answered
Problem concatenating two strings
I hate struct, but if I understand the Q?, then try something like -- d=dir(fullfile(pwd,'test-*.txt')); fn=strcat('loc_',extr...

4 years ago | 0

| accepted

Answered
bar graph with 3 axes
p=10*abs(randn(7,6)); % some dummy data -- 7 periods by 6 systems d=[72 142 225 275 975 2475 5975]; % the retur...

4 years ago | 0

Answered
converting .txt file to .csv file with mixed delimiter
filename='/Users/gulfcarbon2/Downloads/Modis Data/7da2190bbf_NSF_Rapid_HPLC_2018_AC.txt'; data=readlines(filename); data=strre...

4 years ago | 0

Answered
Convert vector to matrix
Given the above problems regarding the number of elements in the vector vis a vis the number of channels (and it can't be there'...

4 years ago | 0

| accepted

Answered
Verify if a given argument is a probability distribution
Interesting puzzle...I dunno, but let's see what we can find... The class is the fully-qualified distribution name; in your abo...

4 years ago | 0

Answered
Select positive samples in a matrice
One more time, yet again, it's one of the most fundamental of MATLAB idioms/syntaxes that makes MATALB what it is -- <MatrixInde...

4 years ago | 0

| accepted

Answered
Hide/remove bubbles of size = 0 in polarbubblechart
tbl.countA(tbl.CountA==0)=nan; tbl.countB(tbl.CountB==0)=nan; ... tbl.countG(tbl.CountG==0)=nan; polarbubblechart(tbl,{'a','...

4 years ago | 0

| accepted

Answered
How to create 3D arrray from text file?
OK, had a little time -- XZ=zeros(50,50,50); % preallocate the output array fmt=['%fnm' re...

4 years ago | 1

Answered
Extract annualized returns from daily stock returns timetable
As per retime first syntax and its example, ttAnnRet=retime(MCStest,'yearly',@geomean);

4 years ago | 0

Answered
How to index txt file
datalength = length(data); datalength2 = datalength - 1 ; A = time(1:datalength2,1); % time data excluding last point B = t...

4 years ago | 0

Answered
How to know the slope and intercept of a straight line in a log log plot and how to connect the data in log log scale by a straight line?
If one is not concerned about stastical estimation but simply the coefficients, then just use b=polyfit(log10(x),log10(y),1); ...

4 years ago | 0

Answered
reading data in loop
But they are .. just that cy_sum(Q) is the single element of the array on each pass and the mean of a single number is the numbe...

4 years ago | 0

| accepted

Answered
Create time matrix with serial date number and sample rate
Well, what is "tick rate"? If you have a sample rate and number of points, then the sample times are just t=[0:1/Fs:(N-1)/FS...

4 years ago | 0

| accepted

Answered
Plotting hourly data for every month for 'x' number of years
tData=readtable('test.xlsx'); tData=addvars(tData,year(tData.Date_Time),month(tData.Date_Time),'Before','WaterLevel','NewVariab...

4 years ago | 1

| accepted