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,600 courses taught by industry experts.

Solution: Describing data

Solution: Describing data

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

Start my 1-month free trial Buy for my team

Solution: Describing data

“

(bright electronic music) - [Instructor] Okay, let's take a look at the solution. Now, we're going to work with a data file that's available with this lesson, and I have downloaded that to my computer, so I'm going to upload from my computer to ChatGPT, the grocery products file associated with this particular chapter, and I'm going to enter a prompt, basically asking for the calculations that I want. I wan to analyze the attached data set, calculate the mean, and the standard deviation of two columns, the cost per unit sales, and the sales price per unit. I also want to calculate the mode of one of the categorical variables product category. So, what we have here is ChatGPT allows us to browse the data, so we can see we have columns like Date Sold, Product Name, Product Category, Cost Per Unit, Sales Price Per Unit, the Units Sold, Total Cost of Units Sold, and Total Revenue of Units Sold. And we can browse and we could look through multiple lines of that. Now, we can also see the…

Contents