Answered
How do you determine the average values in second column of an excel data corresponding to a particular range of values in first column ?
Here's another approach. Because of the size of your dataset I would recommend avoiding loops. the accumarray function applies s...

5 years ago | 0

| accepted

Answered
Readtable function reads the return of CRSP data as cell array
This will convert that column to numbers (assuming all elements in that column can be converted to numbers) (EDIT: sorry I have...

5 years ago | 0

| accepted

Answered
Changing from char variable to another input
Your *.mot files are coming in as one very long character array. You can either try to parse it character-by-character into a c...

5 years ago | 2

| accepted

Answered
Check if all data in a table are numbers
This is how I would approach it... DataTable = readtable(filename,'Sheet','Sheet1'); % load your data TF = cellfun(@isnumeric,...

5 years ago | 1

| accepted

Answered
Using two vectors to get the third one
x = [0,1,2,4,5,7,8,9,10,12,13,14,16,17,18,20,21,23]; % here's your first column y = x*rand()+rand(); % here's a vague represent...

5 years ago | 1

| accepted

Answered
Make an array Arr where element Arr(m,n)=i(m)+j(n)*i(m), and i is changing from -5 to 20 and j is changing from -13 to 9.
Make a nested For Loop with a loop for each dimension. Something like this: for ii = 1:26 i = ii-6; for jj = 1:23 ...

5 years ago | 0

Answered
Plot 4d data
May not be the most efficient, but this is what I came up with: Here's my sample data based on my interpretation of your descri...

5 years ago | 0

Answered
How to skip NaN values in cross correlation between 2 time series datasets.
I encountered this same issue a few weeks ago. My solution was to use fillmissing() to patch up the NaN's. I also used resample...

5 years ago | 0

Answered
Trouble using pchip to interpolate
You'll need to pre-process your data to resolve this. However, the method is up to you and depends on what you're trying to do. ...

5 years ago | 3

| accepted

Answered
How to generate random points and place it within a rectangular/ square boundary?
Check out the intersect function. Here is one approach: % generate a rectangular boundry rectX = [0.1 0.1 0.9 0.9]; rectY = ...

5 years ago | 1

| accepted

Question

Adding secondary r axis to polar plots
I would like to add a secondary r-axis to a polarplot with different limits. The analogous in cartesian would of course be util...

5 years ago | 0 answers | 0

Question

Strategies for reducing calculation time: Finding values in a large array
I have multiple individual large arrays (each are as much as 1 million rows) making up a "complete dataset". Each has two column...

5 years ago | 1 answer | 0