Community Profile

photo

dpb


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

ongeveer 7 uur ago | 0

Answered
Difference between readmatrix() and readtable()
It appears readmatrix is limited to returning one type of data in the output array as the 'OutputType' named parameter is limite...

ongeveer 10 uur ago | 0

Answered
am trying to find the first and second derivates of a set of data points I've imported
That's essentially trivial file that data=csvread('data_10.csv'); data(:,2)=[nan;diff(data(:,1))]; % first difference...

ongeveer 12 uur 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(...

1 dag 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(:)...

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

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

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

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

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

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

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

11 dagen 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); ...

11 dagen 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); ...

11 dagen 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 = ...

15 dagen 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; ...

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

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

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

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

18 dagen 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:...

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

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

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

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

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

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

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

19 dagen 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); ...

20 dagen 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)...

21 dagen ago | 0

| accepted

Load more