User:Zarino/diff scratchpad

Comparing one column

Common key	Wikidata		CSV
Uganda (Q1036)	Yoweri Museveni (Q57274)	→	Ruhakana Rugunda (Q1740843)
Peru (Q419)	Pedro Pablo Kuczynski (Q381027)	→	Fernando Zavala (Q5860422)
North Korea (Q423)		+	Kim Jong-un (Q56226)
South Korea (Q884)	Moon Jae-in (Q21001)	→	Lee Nak-yon (Q12611134)
Isle of Man (Q9676)	Howard Quayle (Q25752048)	−

Only in Wikidata

Only in CSV

In both, but different

The same in both

Comparing two columns

Common key	Wikidata		CSV		Wikidata		CSV
id	start_date		start_date		end_date		end_date
Alex Salmond (Q10652)	2011-05-05	→	2011-05-06		2016-03-24	→	2016-03-23
Chic Brodie (Q1071778)	2011-05-05	→	2011-05-06		2016-03-24	→	2016-03-23
Christina McKelvie (Q1083222)	2011-05-05	→	2011-05-06		2015-10-10	=	2015-10-10

Only in Wikidata

Only in CSV

In both, but different

The same in both