matthewproctor / australianpostcodes

A community sourced comprehensive database of Australian Post Codes with geolocation data.
255 stars 47 forks source link

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

Open scottdk opened 2 months ago

scottdk commented 2 months ago

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