From the course: Complete Guide to Generative AI for Data Analysis and Data Science

Unlock the full course today

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

Capstone project solution

Capstone project solution

- [Instructor] Let's develop our solution to the Capstone project assignment. Now, the first thing we want to do is we want to work with the data that we have been provided. Now associated with this lesson is a file which I have downloaded to my computer called B2B order data. So I'm going to open that and I'm going to ask ChatGPT to describe the attached dataset. This should gimme some basic information and allow me to see some of the rows. So we have something that looks like supplier ID, an order date, a shipping date, expected delivery. I assume that's expected delivery date. Yep. And that's good to know because the expected delivery date and the order date are two things. We need to calculate the lead time for how long it takes to get an order in from a supplier. Then we have product code, product names. So those are categorical variables. Then we have some numeric quantities, per unit cost and quantity and total cost. Okay, so that gives us our basic description. And we can see…

Contents