Professional Interests: Econometrics and Finance
Top 5% contributor
Hi, I just had a situation where I did A(~A) which returned an error message "NaN's cannot be converted to logicals." So I gues...
2 years ago
Now I am trying to find the occurance of an element in a vector using
How can accumarray be us...
Asked 3 years ago
I have an excel sheet with different date formats (in excel some are in General format, some in date format tota...
I have data of the structure 3 columns by 1.5 million rows. Each column is a variable namely cocode, date, price. I would like t...
Asked 4 years ago
Yes. Your right. The file has just 3 columns with 2 numeric and 1 string column. I increased the virtual memory and the problem ...
Answered 4 years ago
I have an excel file as large as 20MB with roughly abt 1.5 million rows. I run out of memory while I perform any sort of operati...
A = [1 2 NaN; 4 NaN 6; 7 8 9]
1 2 NaN
4 NaN 6
7 8 9
mn = nan...
Asked 2 years ago
I have time series data as a pivot in an array.
The first row and first column are headers.
A = NaN 100 101 102 103 104
201 2 7 3 2 2
202 NaN 8 4 5 6
203 NaN NaN 2 3 5
Is it possible to find mean and std dev. of every row in a huge matrix with double data and a lot of NaN interspersed without lo...
I have read data from an excel sheet. The data Iam trying to manipulate is in the second column. First line is the header. i wou...
I have a huge file in XLSX format. While xlsread runs without memory issues, the command A = dataset(XLSFile, filename) throws t...
I would like to know if there are functions(specially if cellstruct would work) in MATLAB to solve my problem or do i hav...
I have time series data in a double array.
The first column is datenum and all other columns are corresponding data
I have time series data(daily) for 10 years for 500 firms. I would like to calculate monthly beta. I have the data on an excel s...
Hi, I am trying to extract last 4 characters of a string and trying to check if it contains a '/' in it. There are similar que...
3 years ago
Join the conversation