Azzera filtri
Azzera filtri

match same column and row in matlab

4 visualizzazioni (ultimi 30 giorni)
Tanmoyee Bhattacharya
Tanmoyee Bhattacharya il 10 Mar 2024
Modificato: Shlok il 8 Ago 2024
I have one excel file containing rainfall data
85 82 82.5
22 22.5 23
0 2 0
2 0 1
1 0 2
0 1 0
I have another excel file where thre are lat lon values like:
82 22.5
82.5 23
I have to extract rainfall for lat lon of second excel file from first one.
If there is any way to extract it in matlab
  1 Commento
the cyclist
the cyclist il 10 Mar 2024
Yes, of course you can extract data from Excel files using MATLAB.
Can you upload the data, or a small representative sample? Details like whether or not the file has headers matter. You can use the paper clip icon in the INSERT section of the toolbar to upload.
Also, it would be helpful if you told us exactly how you want the output of the algorithm to look like.

Accedi per commentare.

Risposte (1)

Shlok
Shlok il 8 Ago 2024
Modificato: Shlok il 8 Ago 2024
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.
tableData = tableData';
  • 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:

Community Treasure Hunt

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

Start Hunting!

Translated by