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.

Merging data and building basic calculations into a data set

Merging data and building basic calculations into a data set

From the course: The Data Skills Survival Kit

Start my 1-month free trial Buy for my team

Merging data and building basic calculations into a data set

“

- Dealing with data sets that are similar but in different systems is a fact of life. In our example here, we have our customer order data, but we also have some data related to a plant program. It's plant points. It's a third party provider that our customers can sign up for and then actually get plant points to spend on plants and tools and whatever else they want. We have decided that we need to analyze if people are participating in the plant points, and we also want to take a look at it by cohorts. So let's go ahead and get connected to our plants point data. This is a great time to pause, get connected to the points data, and then also update your data source so that you're connected to the order data in the exercise files. And then come back and join me to get started. (upbeat music) Okay, so I'm ready to go and grab that points data. It's an Excel file, I'll go ahead and grab my plants points. Here's the…

Contents