Community Profile

photo

dpb


3.934 total contributions since 2012

Contact

dpb's Badges

  • Thankful Level 2
  • 36 Month Streak
  • Ace
  • Revival Level 1
  • Knowledgeable Level 4
  • First Answer
  • Solver

View details...

Contributions in
View by

Answered
How can I erase Sheet1 Sheet2 and Sheet3 in excel file using writetable function in matlab?
Modifying workbook properties isn't what writetable does--it just writes to a given sheet, creating one of that name if it doesn...

etwa eine Stunde ago | 0

Answered
Function handle not rechecking if statement
tf_f = @(T,Y) isempty(p_f(T,Y)); if tf_f(T,Y) == 1 && bottom_f(Y) > p21top_f(T) elseif tf_f(T,Y) == 1 && top_f(Y) < p21top_f(...

etwa 4 Stunden ago | 0

Answered
limits are too large
K>> format short K>> sum(X(:)>1E100)/numel(X) ans = 0.8499 K>> sum(X(:)>1E200)/numel(X) ans = 0.7848 K>> sum(X(:)...

3 Tage ago | 0

Question


regexrep for the neophyte
How to write expression to find and convert financial strings written with comma separator to be able to parse numerically? Exa...

3 Tage ago | 1 answer | 0

1

answer

Question


Brain freeze re: grouping and recombination
Have two files of correlated data via a categorical variable -- in the first, the name field has been normalized such that can f...

6 Tage ago | 0 answers | 0

0

answers

Answered
while/for loop
"know i have to use a for or while loop..." Not with Matlab, no! Use Logical indexing (link) as illustrated...

6 Tage ago | 0

Answered
Reading a csv file
You started off well w/ the readtable route...but, once you've got the table, then use the variables there, don't create new one...

7 Tage ago | 1

Answered
computing second derivative from txt/csv file based on existing excel algorithm
Here's perfect example why Matlab excels over Excel... :) txyz=importdata('B0264_dollyo_air_P_T01 rtoe.txt',',',8); % read the...

7 Tage ago | 0

| accepted

Answered
How can I save a word e.g. 'apple' in a text file, without matlab separating every letter with a comma?
You undoubtedly use csvwrite or similar to write a character array -- internally a char() array is just that--an array of number...

9 Tage ago | 1

| accepted

Answered
how to add a matrix element in a fzero function
As you wrote it, the function is the literal text including the argument so nothing ever gets substituted for dynamically--one w...

9 Tage ago | 0

| accepted

Answered
How to find intersection point of two curves, when the intersection point is not there in data sets?
Both intersection sections appear to be straight lines; fit them and use fzero to find the point bblue=polyfit(xblue,yblue,1); ...

10 Tage ago | 0

| accepted

Answered
second degree polynomial regression and all the coefficients
Higher order polynomials aren't going to help here...the following code generated the figure: for i=3:9 subplot(4,2,i-2); ...

10 Tage ago | 0

| accepted

Answered
code for computing the pvalue
fnP=@(a,i) (sum(a(i)>a(1:i))+0.5*sum(a(i)==a(1:i)))/i; >> for i=2:numel(Si),fnP(Si,i),end ans = 0.75 ans = ...

13 Tage ago | 1

| accepted

Answered
How to change values of x axis from numbers to dates
x = -10:0.1:10; y = sin(x); hF=figure; % keep handle to figure plot(x,y) hAx(1)=gca; ...

13 Tage ago | 1

| accepted

Answered
Correlating Two Arrays Using Correcoef
There's at least one NaN in the second variable...you don't give any information about which is which. >> spd=5*rand(500,1);tlt...

14 Tage ago | 0

| accepted

Answered
second degree polynomial regression and all the coefficients
Taking a shot that the presumption earlier is the correct one-- xy=xlsread('ML.xlsx','sheet2'); % read the data into array ...

15 Tage ago | 0

Answered
Writing first and last line of each cell
Just have to handle the special case outside the loop... xx=zeros(length(xxMM)+1,6); xx(1,:)=xxMM{1,:}(1,:); for i=1:length(x...

16 Tage ago | 0

| accepted

Answered
Plotting graph of negative values of array in integral2 with 3 variables
The functional is invariant upon the the loop; remove the definition from inside the loop Use meaningful name for the degrees a...

16 Tage ago | 1

Answered
Finding pythagoras triples when only c is known
Somewhat more rudimentary would be UP=fix(sqrt(Csq-1)); % can't be bigger ignoring degenerate case of (sqrt(Csq^2),0) for i=1:...

16 Tage ago | 1

Answered
Plot A Graph With Asymptotic Behavior
ymaxCX = max(max(CX), limCSss); yminCX = min(min(CX), limCSss); Just getting an overall min/max value of the data in vector C...

17 Tage ago | 0

Answered
I need to classify my result in catagories
N=1.5*ones(size(ma)); N(abs(ma)==45 | abs(ma)==135)=-0.5; ... The rest should be self-evident from the above; lett as "exerci...

17 Tage ago | 0

Answered
Getting the correct y-intercept and gradient for a trend line using 'fit'
Looks quite right to me...the intercept is where the fitted line will cross (intercept) the y-axis at x=0...that point is way an...

17 Tage ago | 0

| accepted

Answered
How to add a column to an existing file?
Text sequential files are, well, "sequential" You can't just add in the middle by either column or line/record. data=importdat...

18 Tage ago | 2

Answered
is it possible to copy a file on itself?
That isn't copying a file onto itself; there's nothing to prevent you doing what you want. Your copyfile command isn't referenc...

18 Tage ago | 0

Answered
Ploting every n-th result in a for loop
v=2;L=100; N=10; for t=0:0.01*N/v:L/v clf ... To introduce a 10-fold reduction...

18 Tage ago | 0

Answered
How can I plot hourly data in the same figure?
Use the features of Matlab to your advantage...granted, it takes some "time in grade!" to learn one's way around! :) As a gene...

18 Tage ago | 0

| accepted

Answered
Create a table with Revenue by financial year such as 2017-18
t=readtable('chindamo.xlsx'); % read the input table data t.Code=categorical(t.Code); ...

18 Tage ago | 0

| accepted

Answered
I can't delete plot and line in a figure
... p1 = line([xr xr],[0 f(xr)]); line([xr xr],[0 f(xr)]) ... x = [-10 0.01 10]; y = (x-xr).*df(xr)...

20 Tage ago | 0

| accepted

Answered
marker size difference between 'plot' and 'scatter' function
Per the documentation, scatter marker size property is marker proportional to area while the line marker property is proportiona...

20 Tage ago | 0

| accepted

Answered
How to convert each row of the matrix into a Character array, without using a for command?
Preallocate B may help just tad... Alternatives to loop include B=cellstr(num2str(A)); but what is end purpose for doing the ...

20 Tage ago | 0

| accepted

Load more