I've scraped some data on London's Underground system from various sources on the web, and am trying to combine it into one dataset.
Schematically, this is what I am trying to do:
ds1 = Dataset[{<| "A" -> 1, "B" -> 2 |>, <| "A" -> 3, "B" -> 4 |>, <| "A" -> 5, "B" -> 6 |>}];
ds2 = Dataset[{<| "A" -> 1, "C" -> 20 |>, <| "A" -> 3, "C" -> 40 |>}];
JoinAcross[ds1, ds2, {"A", "A"}]
And this is the Mathematica output from the above, which is as I would expect it to be:
However, when I attempt what is effectively the same thing with my real data, it doesn't work. For example, my two data sets are...
But when I try to combine them, thus...
JoinAcross[csvStations, htmlStations, {"Station", "Station"}]
I get the following result:
Is this a bug, or am I doing something wrong?