From the course: SQL Server Machine Learning Services: Python

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Solution: Import and process data

Solution: Import and process data

From the course: SQL Server Machine Learning Services: Python

Start my 1-month free trial

Solution: Import and process data

“

(upbeat pop music) - [Instructor] I hope you are able to output a data frame with two columns that show the Celsius and the equivalent Fahrenheit measurements from the warehouse's cold room. Let's take a look at how I would go about solving the problem. First I would go into the database and take a look at the tables folder, and we'll just take a quick look at the table that we're concerned with, this one here, warehouse.cold room temperatures, and the column that we need is this one here called temperature. Let's go ahead and start up a new query, and I'm going to fill in my standard Python template here, so execute the stored procedure, then we have our language parameter, set that to Python, then we have the script parameter, and I'll leave that blank for now, and then we have our input data one parameter, and that's going to be equal to N and open parenthesis. And now I can type in the select statement that's going to pull out of the data, the temperature data, from the warehouse…

Contents