The NYC Property Sales data set includes commas in the sale prices, and the best composite key I could find included the sale price. At present, I form a composite key before cleaning the sale_price, which will make it hard to remake the composite key. It would be much better to just apply cleaning before making the composite key.
The NYC Property Sales data set includes commas in the sale prices, and the best composite key I could find included the sale price. At present, I form a composite key before cleaning the
sale_price, which will make it hard to remake the composite key. It would be much better to just apply cleaning before making the composite key.