Answered
readtable and readtimetable can't load timezone properly?
What worked here for R2019b >> opt=detectImportOptions('thing.csv','delimiter',',') opt = DelimitedTextImportOptions with ...

6 years ago | 0

| accepted

Answered
How to find peaks in a for loop where the number of peaks are not the same for every vector in matrix?
That's when cell arrays are useful... for i=1:size(CH1WaveForm_1,2) [pks{i},locs{i}]=findpeaks(CH1WaveForm_1(1:end,i)); en...

6 years ago | 2

| accepted

Answered
Printing the values on the .csv file
In your program you'll have to create a table of the names/categories and the breakpoints that is associated with them and then ...

6 years ago | 0

Answered
Find Time when two conditions are met in two colomns
Really don't need the applied signal at all to answer the Q?... data=load('Data1.txt'); [Imx,iImx]=max(data(:,3)); ...

6 years ago | 0

| accepted

Answered
Use string or character arrays in code?
It's all about what's more convenient for the purpose...char() is most memory efficient, but one has to always drag around and r...

6 years ago | 0

Answered
Count number of values within a range in matrix per column and assign count to new matrix
>> reshape(cell2mat(arrayfun(@(c) histcounts(A(:,c),[0 0.5 1]),1:size(A,2),'UniformOutput',false)),[],size(A,2)) ans = ...

6 years ago | 0

Answered
How can I analyse particular portions of an array to use for plotting? Considering dataset of ~1.5 million rows for each variable and ~150,000 locations with 10 values (for each variable) per location
"I’ve imported the data from a table and converted each variable into their own individual arrays,..." That's exactly the wrong...

6 years ago | 0

Answered
select complex numbers from cell array based on the real part
Well, if you want the max() of the real part, then you'll have to limit to only looking at the real part -- max() for complex re...

6 years ago | 0

| accepted

Answered
Put a cell into a title in plot
Sr=regexp(fileread('data.txt'), '\r?\n', 'split') .'; % reads as a string, not numeric for i=1:size(St); ...

6 years ago | 0

Answered
How to sort a two column vector
s=sortrows(x);

6 years ago | 1

Answered
Avoid +0 when using fprintf %+d
Not w/o some code logic of one form or the other, no. There is no "magic bullet" format descriptor that behaves as desired; as ...

6 years ago | 2

| accepted

Answered
How to convert the output of this coding to txt file formate using Matlab?
ix1 = (Xs1-x2).^2+(Ys1-y2).^2+(Zs1-z2).^2 < R2^2; scatter3(Xs1(~ix1),Ys1(~ix1),Zs1(~ix1),20,'r','h','filled','MarkerFaceColor',...

6 years ago | 1

| accepted

Answered
proportion of gender having health issue
Some other things to explore... hScore=randi(100,100,1)/4; % An artificial dataset... ...

6 years ago | 2

Answered
Is there a way to change the range function of xlsread based on a variable input?
Sure (altho it's probably as fast and less hassle to just read read the whole spreadsheet and then just select the results wante...

6 years ago | 0

Answered
How can one show variable values in legend of a plot?
Just build the desired string array -- num2str works nicely here alto you have to ensure the values are in a column vector to av...

6 years ago | 2

| accepted

Answered
Syntax: var<1d-4
dp=max(max(abs(phi1a-phi1))); if(~(dp>0) & ~(dp<0) ) disp('NaN'); return; end if(dp<1d-4) break; end % THIS LINE could be wr...

6 years ago | 3

| accepted

Answered
How do I make a variable that is equal to the position of a row in a table by using the name of that row?
fieldnames is specically documented for struct or Java or COM objects at least thru R2019b; I wasn't aware it would return the ...

6 years ago | 0

| accepted

Question

Yet Another Excel COM Problem -- SAVEAS
Have a whole bunch of older Excel files that must process -- and for going forward would like to convert them to the current def...

6 years ago | 1 answer | 0

1

answer

Answered
Error for reading function
You certainly do throw the parentheses around... :) sumenergy2= ((delta_H_T_ref)+ ((delta_Cp)*((T_isoth)-(T_ref))); ...

6 years ago | 0

Answered
graph axes and its scaling
If you haven't, turn your time vector into datetime (if it is actual calendar time) or a duration (if it is elapsed time from so...

6 years ago | 0

Answered
How do I detect a "tab" character in a line of text read by fgetl?
l=fgetl(fid); istab=(l==9); % the fast way... % istab=strfind(l,char(9)); % the char() string stri...

6 years ago | 1

| accepted

Answered
Modifying Figure Y-Axis Exponent Parameter After YTickLabels are Modified
Don't use manual labels on ticks, just don't put ticks at the unwanted places. When write labels, the EponentMode is set to 'Ma...

6 years ago | 0

| accepted

Answered
About the usage of for, while and return
With the clarification that operations are the same, then data=xlsread('data.xlsx','B1:B86640'); % preliminaries -- define sto...

6 years ago | 0

| accepted

Answered
Array loop to find highest value
"Now I want the 5 best values, but I'm afraid if I sort them with the sort function the id's wont match anymore ..." If that's ...

6 years ago | 1

| accepted

Question

Indexing to table subset from unique
Have a fairly complex table that contains, amongst other things, a Formula field (altho what the field is is immaterial to the q...

6 years ago | 0 answers | 0

0

answers

Answered
I want to plot!!!
You left out some very key information MATLAB told you about... ... contour(x,y,psi); Warning: Matrix is singular to working ...

6 years ago | 0

Answered
Knowing the value in the first and second column of an array, what is the corresponding value in the third column?
Use the MATrix LABoratory features of MATLAB instead of explicit loops where can... width = 0.5; height = 0.1; nIntervalsX = ...

6 years ago | 0

| accepted

Answered
How to perform mathematical operation in columns on certain elements and make the other elements zero??
Don't try to get too fancy...sometimes just deadahead is the simplest and best (and probably fastest, besides)... a=10; ...

6 years ago | 0

| accepted

Answered
how to convert the cell to matrix
Presuming the input is a cell array, m... >> cellfun(@(s) sprintf('%d',fliplr(s)),m,'UniformOutput',false) ans = 6×1 cell a...

6 years ago | 0

Answered
How to run a Absolute value for formula when there's a variable?
Because >> y=abs('Temperature'); >> char(y) ans = 'Temperature' >> You passed the literal character string 'Temperatur...

6 years ago | 1

| accepted