A system and method may retrieve transaction data for a plurality of electronic payment system transactions. The transaction data may describe a plurality of electronic payment transactions between a payment network system and a plurality of merchants. The transaction data may include a transaction location and a merchant store number. The system and method may parse the transaction data to identify the transaction location and the merchant store number and analyze the retrieved and parsed transaction data to identify one or more centroids for at least a portion of the retrieved and parsed transaction data. The one or more centroids may correspond to a merchant location for each transaction of the retrieved and parsed transaction data. The system and method may then clean the retrieved and parsed transaction data having a transaction location outside a threshold distance from the one or more centroids to include accurate merchant store number data.