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...
3 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 5 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 5 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...
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
Choose your country to get translated content where available and see local events and offers. Based on your location, we recommend you select United States from the following list:
See all countries