From the course: The Data Skills Survival Kit

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Creating unique identifiers between two data sets

Creating unique identifiers between two data sets

From the course: The Data Skills Survival Kit

Start my 1-month free trial Buy for my team

Creating unique identifiers between two data sets

“

- [Instructor] Leaf & Mortar is a landscape design firm that provides services to their clients for their garden and design needs. They have data sets about their clients, their services, and also the plants and trees they use for all their designs. The data that we have in the spreadsheet is the Leaf & Mortar plant data. This includes a detailed plant ID that uniquely identifies the plant for all the Leaf & Mortar data sets. Note, there are other fields like Plant Name and Scientific Name, as well as the Plant Type. Leaf & Mortar buys their plants from wholesalers like Hansel & Petal and others, like Holly Berry Tree Emporium and Plant Fernishings. However, each vendor has their data set up a little bit differently. Let's take a look. Take a look at the Hansel & Petal products. Notice that it has the Scientific Name and the Plant Type and it has a column for Vendor. Now, let's take a look at the Holly Berry Tree…

Contents