Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

13 Records contain right single quote (’, ascii 146) instead of apostrophe (', ascii 39) #46

Open
scottdk opened this issue Jul 1, 2024 · 0 comments

Comments

@scottdk
Copy link

scottdk commented Jul 1, 2024

I found right single quotes instead of apostrophes in 13 records in australian_postcodes.csv, australian_postcodes.json, australian_postcodes.xlsx, and australian_postcodes.xls. Each of the localities also has corresponding entries with a normal apostrophe, causing some inconsistencies.

Easily dealt with during data cleansing, but I thought you might like to know. Thanks for the great dataset!

id	postcode locality
23998	2602	O’CONNOR
24001	2606	O’MALLEY
23996	2795	O’CONNELL
24002	4275	O’REILLY
23926	4514	D’AGUILAR
23994	4626	O’BIL BIL
23997	4680	O’CONNELL
23995	4860	O’BRIENS HILL
24000	5158	O’HALLORAN HILL
24003	5166	O’SULLIVAN BEACH
23927	5223	D’ESTREES BAY
24026	5223	STUN’SAIL BOOM
23999	6163	O’CONNOR

Thankfully it was obvious because I was broswing the CSV version which Excel didn't like.

csv locality
O’CONNOR
O’MALLEY
O’CONNELL
O’REILLY
D’AGUILAR
O’BIL BIL
O’CONNELL
O’BRIENS HILL
O’HALLORAN HILL
O’SULLIVAN BEACH
D’ESTREES BAY
STUN’SAIL BOOM
O’CONNOR
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant