Grokking the Forward Deployed Engineer Interview
0% completed
Cleaning and Joining Messy Data
order_id,account,amount
O-1,A-104,"1,250.00"
O-2,a-0104,980
O-5,A-221,
These rows come from a parts distributor's warehouse export. The first two orders belong to one account, written two ways, and the third has no amount. Matching by the id as written loses the second order.
Turning values like these into one consistent form is called cleaning. Matching rows from two sources on a value they share is called joining. Together they are the most common practical task in customer work.
.....
.....
.....
Like the course? Get enrolled and start learning!
Reading Progress
0%