Hi,
Based on the data and context you provided above; I assume you have the Excel files with the following headers:
File 1: Contains “Latitude”, “Longitude”, “RainDat1”, “RainDat2”, “RainDat3”, “RainDat4” in a row-wise format, where “RainDat(i)” is assumed to be four rain data values for specific coordinates.
File 2: Contains “Latitude”, “Longitude” in a column-wise format.
The goal is to extract the values of “RainDat1”, “RainDat2”, “RainDat3”, and “RainDat4” from File 1 based on the “Latitude” and “Longitude” values provided in File 2.
Follow the following steps to achieve the same:
- Read both the Excel files into tables using “readtable” function. For example:
table = readtable("filename.xlsx");
- Convert them to arrays using "table2array” function for easier manipulation.
tableData = table2array(table);
- Transpose the second matrix to align with the header direction of the first matrix.
- Filter out columns where the first two cells (“Latitude” and “Longitude”) in the first matrix match the first two cells of any column in the second matrix. This can be achieved either by looping through the matrices or by using logical indexing.
This will help you achieve the desired result.
To delve deeper into the terminologies used, you can refer to the following documentation links:
