From the course: Complete Guide to Advanced SQL Server

Unlock the full course today

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

Challenge: Import and process data

Challenge: Import and process data - SQL Server Tutorial

From the course: Complete Guide to Advanced SQL Server

Start my 1-month free trial Buy for my team

Challenge: Import and process data

“

In this chapter, we've taken a look at several techniques for importing, slicing, and working with tabular data. Let's apply that knowledge to another challenge. In the Warehouse.ColdRoomTemperatures table, you'll find a column called Temperature. It only contains four values and their measurements in degrees Celsius. I'd like you to import these into Python, then output a DataFrame with two columns, one with the original Celsius values and one with Fahrenheit equivalents. To do this, you'll need to know the conversion formula between the two temperature scales. Fahrenheit is equal to Celsius times 1.8 plus 32. This challenge should take 10 minutes or less to complete. Good luck.

Contents