回答済み
filtering excel commands in matlab
tA=readtable('https://www.mathworks.com/matlabcentral/answers/uploaded_files/1121415/animals.xlsx'); tA=convertvars(tA,@iscells...

3年以上前 | 0

回答済み
How can i extract data from data from table using a string of words.
data_table=readtable("Normal and Tumor TPM.xlsx","Sheet","Normal Expression","VariableNamingRule","preserve"); geneslist=strt...

3年以上前 | 1

回答済み
Changing colors for findpeaks function
Sure, but not with the triplet form of plot to use anything except the named colors... hL=plot(x,y,'-', pk,loc,'*'); ...

3年以上前 | 0

回答済み
I want to make, MATLAB can log in by for number of people and use the software (but not simultaneously).
You should contact your site manager or, if you are the site rep, contact Sales at TMW for install support. Your last sentenc...

3年以上前 | 1

回答済み
Plot matrix dependent on x against x
You can/could try surf with X,Y the ordinal vectors 1:9 and Z-->CMR. Use hold on to add for each x to add to the same plot; if ...

3年以上前 | 0

回答済み
How to convert a long txt sequence of single digit numbers (e.g. '100101011101010111...') to number array?
s = '1000011110'; n = sscanf(s,'%1d') Probably fastest. Or you can compare s = '1000011110'; n =str2num(s.') If the string...

3年以上前 | 1

| 採用済み

回答済み
imhist and histogram giving different results
For <imhist>, the n bins of the histogram are each half-open intervals computed for a double as you've passed as (p−1.5)/(n−1) ...

3年以上前 | 0

| 採用済み

回答済み
How to precisely place textarrow?
This has always been a pain in the royal patootie...the annotaton objects are in figure coordinates while the data inside the pl...

3年以上前 | 1

| 採用済み

回答済み
How to save data to existing excel file
OK, had a few more minutes -- as @Cris LaPierre (and I had also) suggests, it would be a somewhat simpler job to build the table...

3年以上前 | 0

| 採用済み

回答済み
Want to correct experimental data using a black box non-linear model of the data
Look into Kalman filters...

3年以上前 | 0

| 採用済み

回答済み
How to save data to existing excel file
You didn't define cellReference before trying to use it in the else clause if the file didn't exist. Must not have executed tha...

3年以上前 | 0

回答済み
Turn all excel sheet background to white
<docs.microsoft.com/...vba/api/excel.worksheet.usedrange>

3年以上前 | 0

回答済み
How to create different Plots for different functions while each function has been plotted using hold on
%enthalpy plot (KJ/mol Vs Bar)- hold on; for t = 1:nt %varying temperature to create isotherms for p = 1:np ...

3年以上前 | 1

| 採用済み

回答済み
change output from row to column and display one cell value instead of multiple
[locAll,typeAll]=find(mVocs==1) will return two vectors of the row,column indices (that you've inexplicably called loc/typeAll...

3年以上前 | 1

| 採用済み

回答済み
How to locate the the difference between the max. and min in matrix rows
M=[ 2 4 7 10 28; 1 3.6 8 11 27; 0.5 5 9.5 13 32].'; D=range(M,2) Almost never need loops in MATLAB for such...

3年以上前 | 0

回答済み
How do I make a vector of fitted values and a vector of residual values from a linear model of y on x
As per the above comment, if you have either of the toolboxes, I'd recommend using one of those routines instead, but to get by ...

3年以上前 | 0

| 採用済み

回答済み
How to use the values of an array as inputs for a function?
Well, it would be easier if the function were written to accept an array instead of the six different variables -- but, you can ...

3年以上前 | 0

| 採用済み

回答済み
How can I extract certain rows from a CSV imported table?
Unless the table is just huge or there really is never to be any need for the other variables, there's no reason to not keep the...

3年以上前 | 0

| 採用済み

回答済み
Producing incorrect results with abs command
You didn't provide the input x array so we can (easily) duplicate, but now this one is easy... :) You're confusing the output d...

3年以上前 | 0

回答済み
fscanf not giving any output
Absolutely no way to debug without the data file, but either The file is empty even if it exists, or The file content is such ...

3年以上前 | 1

| 採用済み

回答済み
How to find mean and errorbars for scatter plot at various x values.
The specific answer is M1=mean(Mat2,'all'); S1=std(Mat2,[],'all'); general answer is to not create multiple sequentially-name...

3年以上前 | 1

回答済み
deleting the last row of csv file
If have R2020b or later, the simplest portable coding solution would be data=readlines('yourfile.csv'); data(end)=""; writema...

3年以上前 | 1

| 採用済み

回答済み
Trying to average values from specific cells in a similarity matrix
Not too bad ... use logical addressing to find the locations and the mean with the 'omitnan' argument over the values returned.....

3年以上前 | 0

回答済み
Find that particular start index at which the atleast 6 points are consecutively increasing
OK, since we have real data, I'll just use it and illustrate the way the previous code works with it... a=readmatrix('https://w...

3年以上前 | 1

| 採用済み

回答済み
matlab plot rendering problem
load https://www.mathworks.com/matlabcentral/answers/uploaded_files/1115780/y2_max.mat I dunno whassup w/ this last couple days...

3年以上前 | 0

| 採用済み

回答済み
Elegant way to batch extract all as single data from Data Pool
The real answer in MATLAB is "Don't Do That!" -- making variables out of array elements generally is not the way to write effic...

3年以上前 | 2

回答済み
There are 500 different sizes of a bolt ranging around 0.5 mm. I want to separate the sizes that are above or below the tolerance. then add those results in a column vector
No loops needed in MATLAB for this kind of logical addressing problem -- ... N=numel(boltMeasurements); %...

3年以上前 | 1

回答済み
Am importing five columns of numeric data from an excel file. Why is MATLAB not detecting the third and fourth columns as numeric data ? how can i change them to numeric data
Because the first entries are NOT numeric -- they're asterisks which can't be interpreted as numbers. Use detectImportOptions a...

3年以上前 | 0

| 採用済み

回答済み
How to fix overlapping tick labels?
Not so bad, just have to remember the trick, Walter... :) Once you've got the ticks labeled as you have where you want them, th...

3年以上前 | 0

回答済み
Extract all data for the June months over the years from a timetable
Piece 'o cake -- granted, it takes a little while to get used to using grouping variables and all, but... load https://www.math...

3年以上前 | 1

| 採用済み