![photo](/responsive_image/150/150/0/0/0/cache/matlabcentral/profiles/2727238_1522090930822_DEF.jpg)
Ms. Mat
Followers: 0 Following: 0
Professional Interests: Econometrics and Finance
Statistics
RANK
95 348
of 293 483
REPUTATION
0
CONTRIBUTIONS
14 Questions
1 Answer
ANSWER ACCEPTANCE
71.43%
VOTES RECEIVED
0
RANK
of 20 033
REPUTATION
N/A
AVERAGE RATING
0.00
CONTRIBUTIONS
0 Files
DOWNLOADS
0
ALL TIME DOWNLOADS
0
RANK
of 148 733
CONTRIBUTIONS
0 Problems
0 Solutions
SCORE
0
NUMBER OF BADGES
0
CONTRIBUTIONS
0 Posts
CONTRIBUTIONS
0 Public Channels
AVERAGE RATING
CONTRIBUTIONS
0 Highlights
AVERAGE NO. OF LIKES
Feeds
Question
subtract from each element its mean / find absolute deviation across rows
A = [1 2 NaN; 4 NaN 6; 7 8 9] A = 1 2 NaN 4 NaN 6 7 8 9 mn = nan...
mer än 11 år ago | 1 answer | 0
1
answerQuestion
Eliminate nested FOR loop
I have time series data in a double array. The first column is datenum and all other columns are corresponding data d...
mer än 11 år ago | 2 answers | 0
2
answersQuestion
Conversion of arrays to cell array
I have time series data as a pivot in an array. The first row and first column are headers. x = NaN 10...
mer än 11 år ago | 1 answer | 0
1
answerQuestion
How do I find the number of occurrences of NaN and the corresponding subscripts in an array
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 205...
mer än 11 år ago | 1 answer | 0
1
answerQuestion
Mean of every row in a double matrix without looping
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...
mer än 11 år ago | 1 answer | 0
1
answerQuestion
Count the number of occurances of an element using accumarray
Now I am trying to find the occurance of an element in a vector using sum(dta(:,size(dta,2))==3); How can accumarray be us...
mer än 11 år ago | 2 answers | 0
2
answersQuestion
Aligning Time Series data and calculating CAPM beta.
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...
mer än 11 år ago | 1 answer | 0
1
answerQuestion
Consolidate Substring Code using Cellfun
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...
mer än 11 år ago | 1 answer | 0
1
answerQuestion
Datenum - different date formats
*Background* I have an excel sheet with different date formats (in excel some are in General format, some in date format tota...
mer än 11 år ago | 2 answers | 0
2
answersQuestion
Datenum Mystery - different date formats - but results are the same
*Background* I have an excel sheet with different date formats (in excel some are in General format, some in date format tota...
mer än 11 år ago | 1 answer | 0
1
answerQuestion
Choice of data structure - cellarray or dataset
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...
mer än 13 år ago | 2 answers | 0
2
answersHandling memory issues by connecting to database and retrieving only required data
Yes. Your right. The file has just 3 columns with 2 numeric and 1 string column. I increased the virtual memory and the problem ...
mer än 13 år ago | 0
Question
Handling memory issues by connecting to database and retrieving only required data
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...
mer än 13 år ago | 2 answers | 0
2
answersQuestion
Memory issues in using xlsread and dataset('XLSFile'...)
I have a huge file in XLSX format. While xlsread runs without memory issues, the command A = dataset(XLSFile, filename) throws t...
mer än 13 år ago | 3 answers | 0
3
answersQuestion
CellStruct
Hi, I would like to know if there are functions(specially if cellstruct would work) in MATLAB to solve my problem or do i hav...
mer än 13 år ago | 1 answer | 0