课程: ETL in Python and SQL

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Solution: Load the data into a database and automate

Solution: Load the data into a database and automate

课程: ETL in Python and SQL

开始一个月试用 购买团队方案

Solution: Load the data into a database and automate

“

(upbeat music) - [Instructor] Hello. Welcome back. Were you able to hack the last challenge? Let's get into it. First, I will walk you through the logic. For some challenges, you need to walk through them with the Jupyter Notebook to test out your logic before moving to an ETL logic file, which is exactly what I did in this challenge. Now, what I've done here in my Jupyter file is to import pandas, create our engine, find our Excel location, and now we can work through our transformation path. For the transformation in our Excel, the prices columns are all in dollars. Let's look at our Excel, here. They're all in dollars, and the challenge said to convert them to euros. For the purpose of this challenge, that would mean dividing by 0.92. We would update the price column in the products data frame with the new price that is being divided by 0.92. Since we are carrying out a mathematical operation where each value in the price column is divided by 0.92, the result of the division can be…

内容