Clear Filters
Clear Filters

Hi everyone, I have to use monte carlo time series method to generate synthetic smart meter data for about a million houses. Any heads up on this will be really helpful. Thanks

4 views (last 30 days)
Monte Carlo Time Series Synthetic Data generation

Accepted Answer

Image Analyst
Image Analyst on 30 Oct 2017
Edited: Image Analyst on 30 Oct 2017
Search for Monte Carlo for lots of posts, many of which have code.
I've attached some demos that use Monte Carlo.
  1 Comment
Ragini Gupta
Ragini Gupta on 4 Nov 2017
Edited: Walter Roberson on 4 Nov 2017
Thank you so much. Turns out I have to model the data using Monte Carlo Markov Chain. I created the Transition probability matrix from the consumption values after the binning stage. However, I am not sure how to proceed to simulate the matrix and generate new consumption values.
Here is the code, if you can have a look at it? Please. Thanks in advance
filename = 'newTestingExcel.xlsx';
Furnace=xlsread(filename,'B:B'); %H1D1
edges = linspace(min(Furnace),max(Furnace),8);
[counts,bins] = histc(Furnace, edges);
[counts,bins] = histc(Furnace, edges);
%# transition matrix
m = max(bins);
n = numel(bins);
y = zeros(m,1);
p = zeros(m,m);
for k=1:n-1
y(bins(k)) = y(bins(k)) + 1;
p(bins(k),bins(k+1)) = p(bins(k),bins(k+1)) + 1;
p = bsxfun(@rdivide,p,y); p(isnan(p)) = 0;

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!