matching elements between two arrays
Show older comments
I have two arrays, just one column each. In the first array i have hourly electricity prices and in the other one natural gas prices. I want to match electricity prices with NG. For example:
Electricity an array with 22848 rows, containing elec prices in the form of 24h blocks.
NG an array with 904 rows.
I want next to electricity (another column, column 2 in elec array) prices to have the NG price given that in the same 24h block we have one daily NG price.
3 Comments
Azzi Abdelmalek
on 28 Aug 2013
Give a short numeric example , (10 rows for example) with the expected resullt
Walter Roberson
on 28 Aug 2013
If NG is 904 daily rows, then how do those rows correspond to the 22848 hourly electrical figures, considering that 22848 hourly would be 952 days ?
George
on 29 Aug 2013
Accepted Answer
More Answers (1)
Walter Roberson
on 28 Aug 2013
[Electricity, reshape( NG(:,ones(1,24)), [], 1)]
2 Comments
George
on 28 Aug 2013
Walter Roberson
on 28 Aug 2013
As I asked above,
If NG is 904 daily rows, then how do those rows correspond to the 22848 hourly electrical figures, considering that 22848 hourly would be 952 days ?
Categories
Find more on Sources in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!