Re:Doing a database join with CSV files
by nkozyra on Wednesday January 01, 2020 @07:52AM
(#21927838)
I never got deep into R as we had python or R as options in school for data projects so forgive me but where is the database join in this scenario?
[ Parent
| on HN ]
Original article doesn't say anything about "database join". It's about joining two datasets by some common ID.
R in this case fits the bill and even allows for some relational algebra here (e.g. INNER JOIN would be merge(X, Y, all=FALSE), LEFT OUTER JOIN: merge(X, Y, all.x=TRUE), etc...)
Re:Doing a database join with CSV files
by stilisstuk on Wednesday January 01, 2020 @08:53AM
(#21927999)
Merge joins the two dataset on identical columns. All=True is an outer join.