Question: # Part 4 Ok so we have our database data now. Let's go ahead and grab the data from Chad's Excel abomination so that
# Part 4 """ Ok so we have our database data now. Let's go ahead and grab the data from Chad's Excel abomination so that we can merge it together with what we grabbed from the database. In order to do this, we can use the read_excel function from Pandas, which will again hand us back a DataFrame. Please replace the placeholder below with the filename of the spreadsheet that you placed in your project folder. """ chad_sheet = pd.read_excel('/content/SupplierWebsites-1.xlsx') """ It turns out there's another useful simple way a DataFrame can tell you something about what it contains. This is through the head ()function which displays the first five rows of whatever you have in your variable. Have a look at the code in this cell to see what the variable that holds the data from the spreadsheet is named, and then use dot notation to call the head() function on your variable in the line below.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
