Elements of table equal to elements of another table (2024)

Thank you for your answer!

What I need to do in the end, is end up with one .csv (or whatever) for every station that contains the respective data for that station only. In Stations Coordinates.txt you can see that I have 16 stations, therefore I must end up with 16 files which will have hourly data (temperature or whatever) plus everything else, for each station.

I tried merged as you suggested but I get

Error using tabular/innerjoin (line 98)

Left and right key variables 'Station' and 'Station' are not comparable because one is a non-cell.

Error in WRF_Simulations (line 17)

merged = innerjoin(WRF_Data, stations, 'Keys', 'Station')

I have no idea how you imported your data, the following works fine (R2019b) for me with your input files

Again, the function you want is innerjoin, not ismember in a loop which just complicates things (and is most likely slower)

Note that your demo files have only one station in common 'Airport'

To then split and save merged per station:

I am running on 2019a, I don't know if the problem lies there....

Doesn't the above work exactly as written?

I suspect you're getting your innerjoin error because in one table Station is a string array and in the other a cell array of char vectors. Converting one to the other would fix the problem.

I used

WRF_Data.Station = cellstr(WRF_Data.Station);

and indeed it fixed the compatibility problem.

It works like a doll, million thanks!

The only thing remaing now, is that the split files must go to respective folders so I can detect them easier. With the code I have so far, they are saved to the current dir...

I recommend you use the import code I wrote.

You can modify the anonymous function in the splitapply code to do whatever you want, eg. to save into individual directories named after the station:

Or if it's too complex, use a loop:

Great, thank you!

If you have time, could you please explain to me what each of line

splitapply(@(rows, statidx) writetable(merged(rows, :), sprintf('%s.csv', stations{statidx(1)})), (1:height(merged))', group, group);

does?

splitapply split the input arrays into groups and apply the same function to each group, that is it takes the rows of each input array corresponding to a group and pass that to the function, then it passes the rows corresponding to the next group, etc.

The groups are defined by the last input to splitapply, in this case group. The two arrays that I've decided would be split are (1:height(merged))' which is basically the row indices of the table and group as I actually need the group index to be passed to the processing function. The processing function is the anonymous function: @(rows, statidx) writetable(merged(rows, :), sprintf('%s.csv', stations{statidx(1)})). This is a function with two inputs rows and statidx. rows receives in turn the elements of the first input of splitapply: (1:height(merged))', that is it receives the row indices of the table corresponding to a group (a station), statidx receives in turn the elements of the 2nd input, group corresponding to a group, so it's a vector of identical numbers, hence why I use statidx(1) in the function body.

The function body writes the sekect rows of the table to a file whose name is the station. If we were to rewrite the anonymous function, it would be more or less

And if you were to write what splitapply does as a loop, it would be (in this case):