Question

deleting nan rows in a matrix

Hi, is there a simple method to delete the rows in which there is a nan in a matrix? I wrote the codes this way: [x1,y1]=fin...

8 years ago | 2 answers | 0

Question

converting date to matlab date

Hi, I have a date 20100815 that I want to convert to a matlab serial date. I tried datenum(20100815,'yyyymmdd') but i recei...

8 years ago | 1 answer | 0

Question

sorting a matrix according to another matrix

Hi, I have a 2x200000 matrix A where the 2nd column is an ID column.Then I have another 6x200000 matrix B in which also the f...

8 years ago | 1 answer | 0

Question

Last non nan observation

Hi, I have a matrix and I want to find in each column the last non nan observation. Is there a neat way of doing it quickly? ...

8 years ago | 3 answers | 0

Question

extracting a number from a cell

Hi, I have a vector where each cell has the following format: OHN HANCOCK LF.IN. 2004 5.32% 15/04/14 INDXLK. A...

8 years ago | 1 answer | 0

Question

finding a change in a matrix

Hi, I have a matrix in which each column is usually constant but sometimes the value changes. Is there a way to figure out wh...

8 years ago | 1 answer | 0

Question

Matching two numbers using only 2 decimal points

Hi, I have 2 numbers that I want to match in my program and if these don't match I want to receive an error message. The two ...

8 years ago | 2 answers | 0

Question

find structure

I have 2 structure vectors A and B. I want to find the files in A that are not in B I used x=find(~ismember(A,B)); I received...

9 years ago | 1 answer | 0

Answered

A time killing loop

I changed the names of the variables so that they can appear in a readable format and I cut my huge data to a very small sample ...

A time killing loop

I changed the names of the variables so that they can appear in a readable format and I cut my huge data to a very small sample ...

9 years ago | 0

Question

A time killing loop

Hi, I have a loop which is taking ages. I am wondering if someone can make it more efficient. %% x1 is a vector of date rows...

9 years ago | 3 answers | 0

Question

renaming mat and subdirectories

Thousands of files and subdirectories contain as part of their names a wrong name "Naic" that I want to change to "Trace". Is it...

9 years ago | 2 answers | 0

Question

filling nans between two values

Hi, I have matrices in which I want to fill the nans with the last available number. for example: A=[ 1 nan;nan 3;nan 2;4 na...

9 years ago | 2 answers | 0

Question

Counting the non nan observations in a matrix by row

Hi, I have a matrix for which I want to compute the number of non-nan observations for each row without running a loop. is th...

9 years ago | 2 answers | 1

Question

last transaction time

Hi, I have vector A of prices and cell array B of time of the transaction that has the following format 12:00:53 ; 13:07:52 e...

9 years ago | 1 answer | 0

Question

ismember error

Hi, x0=find(ismember(A,B)==1) is giving me error ??? Error using ==> cell.ismember at 28 Input must be cell arrays of strin...

9 years ago | 2 answers | 0

Question

extracting digits from a number

Hi, I have a column of numbers with the following format: 12345678 I want to extract digits 56 and digits 78 . in a way si...

9 years ago | 1 answer | 1

Answered

Modifying a string

that sounds good but how can i figure out how many zeros to add. c in your example consists of 4 characters but in my case it co...

Modifying a string

that sounds good but how can i figure out how many zeros to add. c in your example consists of 4 characters but in my case it co...

9 years ago | 0

Question

Modifying a string

Hi, I have a cell array where in each cell I have an alpha numeric number of IDs. I want to adjust this array in a way that if ...

9 years ago | 3 answers | 0

Question

finding files in a directory

Hi, I have text files that start with a1 , a2,a3b,a4b .. I was using the following loop to find the files in the directory t...

9 years ago | 2 answers | 0

Question

Matlab report generator-Page break

Hi, I am using report table generator to print a report. One of my tables has a a row on the next page. I am wondering how to...

9 years ago | 1 answer | 0

Question

Loop that I am trying to get rid off

To follow up on my previous thread regarding a very time consuming routine, the main source of slowness I believe is the followi...

9 years ago | 3 answers | 0

Question

Time to run a program

Hi, I have a program running since yesterday. I am wondering if there is a way to test and approximate how much time a progra...

9 years ago | 1 answer | 0

Question

number of non nan observations

Hi, I have a matrix for which i need for each row to compute the number of non nan observations . such routine is occurring fre...

9 years ago | 2 answers | 2

Question

out of memory error

I am facing a continuous out of memory error and I am wondering if these codes can be modified to avoid it:where RG,PC,and Acr a...

9 years ago | 1 answer | 0

Question

converting yyyymmdd date to matlab date number

I have a column of dates that have the following format: 19940127 how can i get a matlab number that corresponds to 01/27/1994...

9 years ago | 3 answers | 1

Question

replacing part of a string

Hi, I have a column with cells that have the following format: US313384RJ03(GP) I want to replace "US" by 1032 and delete...

9 years ago | 1 answer | 0

Question

Splitting an excel file using matlab

Hi, I have a 900,000 row excel file that I want to split to 900 files. I am wondering if i can do this with matlab. the conte...

9 years ago | 2 answers | 0

Question

changing the name of a variable

Hi, I know that what I am asking for is not recommended but I need it. I have a loop and i want to change the name of the var...

9 years ago | 2 answers | 0

Question

Regression Diagnostics

is anyone aware of a toolbox that deals with regression diagnostics? i want to test for every single problem that I might face i...

9 years ago | 1 answer | 0

Question

sprintf inputs

Hi, I am writing a function to determine the shape of a table I want to obtain where one of the inputs in the function is n,...

9 years ago | 1 answer | 0