I have 2 csv files with around 22 columns in each. I want to compare the 2 csv files based on either all the columns or a number of specified columns and show which rows are different and which rows are new is that possible simply in R ? cheers

Hi @ply , You may want to try using the {waldo} package and the compare() function. You can compared two data frames after reading the CSVs into R. library(waldo) x <- read.csv(...) y <- read.csv(...) compare(x, y) If you only want to compare a subset of columns, you can subset those columns and…

Thanks.. I did try waldo but i did not find the output results very clear ?

If you would like to share the output I could help clarify the meaning.

This is also a good place to start understanding waldo better: https://waldo.r-lib.org/

Thanks I widened my console and it made it more readable but is there a way of putting the results in a table/df It says at the end .. and 27 more differences.... but I dont know how to see them cheers

You could do something like this to wrap it into a tibble: tibble::enframe(compare(x, y), NULL, 'diff') But I'm not sure it improves the readability much.

This seems like the previous issue we discussed, you didnt comment on my final solution ... [image] Check additions/updates between dataframes library(tidyverse) dplyr::setdiff(a2,a1) %>% mutate(key_in_first = key %in% pull(a1,key)) in this case you can show the differen…

Comparing 2 csv files

General

nirgrahamuk April 4, 2022, 5:16pm 8

This seems like the previous issue we discussed, you didnt comment on my final solution ...