Access Excel Data with a Rest API using Python | Quick Python Scripts with 10 Lines of Code

In this video learn how to access excel data with a rest API using Python. Access the data locally or remotely from any machine across the world without downloading the excel file on your own computer.
Watch Machine Learning Functions in Excel using XLWings 👉 • Machine Learning Algor...
👉 Patreon: patreon.com/SATSifaction
👉 Facebook Group: / theaiwarriors
👉 Instagram: @theaiwarriors
👉 Corporate Training and Up skilling: levers.ai
Netfirms (Affiliate) - bit.ly/2KdJ4Dp
Bluehost (Affiliate) - bit.ly/2GxxBh1
PythonAnywhere (Affiliate) - bit.ly/2kWORVe
Heroku - www.heroku.co
NordVPN (Affiliate) - bit.ly/2W87je0
✅ Here is a link to my python for beginners, master python course: bit.ly/2HIZS42
What Does a Data Science Executive Carry Around in 2019?
Bag - ebay.to/2lKEDXT
Laptop - 2018 MacBook Pro with Touch Bar
Tablet - 2017 9.7” iPad or
Tablet - Amazon Fire HD 10 - amzn.to/2HjeLec
Folding Keyboard - ebay.to/2k6F4vr
Power Bank - ebay.to/2lKFJ5X
Bose QC35 - ebay.to/2kpfthz
Home Setup for more intense analysis and editing:
AMD MSI Vega 56 Graphics Card - amzn.to/2HkiJU1
Razor X Core egpu with thunderbolt 3 - amzn.to/2Hix579
Two LG 29” Ultrawide Monitors - amzn.to/2YtZfSi
Other options to run Python on a budget
Raspberry Pi Starters kit - ebay.to/2kbvOpW
Any inexpensive Android Tablet (all Fire tablets with playstore side loaded)
Minimalist Keyboard and Mouse - ebay.to/2k6F4vr
Favourite Mobile Apps to Run Python and Code
iOS - Pythonista (paid) - apple.co/2HjRVTJ
Android - Dcoder (free) - bit.ly/2Vrjb6N

[@jigneshmore4312]

In the Real World scenario, the user asked me for a file with the last 3 months of product sold report data. He wants it in such a way whenever he opens the File and refreshes the data. He gets the report excluding the current month. Once I provide him the file, I want him to use the same file next time so that he refresh the data and get data for the last 3 months again. Is it possible to build such a report using Python + API, or do we only have to use the traditional way of getting it done from Ms/Power Query?

[@balajicmb1132]

How to upload excel file in python rest api method sir?

[@amatya.rakshasa]

Hey Satisfaction, thanks for an excellent video. I have a quick question: Can I add filters to the endpoints? yknow how APIs typically have a particular call structure. Lets say I have time series data on stocks. I don't want to load the entire data set into a df because that'll slow it down. let's say I give user a dropdown menu to choose a sector, time interval, country or countries, etc etc. Then can we write an API that only pulls up that limited data from the excel file for some use. My goal is to be able to draw interactive plots but I don't want to load the entire data because its too huge and I wanna make API calls to tiny slices of the data that the user has chosen using dropdowns and other interactive elements. So for instance, in your example, maybe I only wanna pull up the data from say June 2019 and only on four players, say Westmoreland, Champ. Ban, and Finau via the API. How would I do that?

[@SATSifaction]

Hi thanks. Yes you can do this. Your best best is to add filters to your endpoint and do the filtering through the data frame before you pull the data from excel.
You should also take a look at my graphql api tutorial which has filtering built into the front end 👉🏼 ruclips.net/video/nPQE5B51DQ8/видео.html

[@amatya.rakshasa]

@@SATSifaction Hey man, thanks for the link to your fantastic video. I went through it and implemented it using my data and its working perfectly. I am going to google and also go through your videos but I wanted to ask you also. How can I use request or something to query the GraphQL backend using the lovely GraphQL query to get data in the form of a json that I can feed into a dataframe to do whatever else I want to do. I don't need the beautiful frontend view that you deployed in your video. For my needs I wanna use the graphQL query to filter, get the jason, and feed the jason to a dataframe to build interactive plots where when the user changes something else in the plot, I send a fresh graphQL query and start the loop again. Thanks

[@suneelreddy4396]

Sir Please do Some videos on Python Visualisation.

[@SATSifaction]

Thanks for the feedback. I’m working on a live stream for python dash. I’ll let you know when that is ready

[@suneelreddy4396]

@@SATSifaction Oh sounds great Sir.

[@TheRehan110592]

can I use this method to refresh an Excel File ?

[@SATSifaction]

A bit of a different use case but programming that shouldn’t be very hard

[@Huynh-Tan-Quoc]

if i want to read file excel in teams microsoft , how to you do it? pls help me

[@SATSifaction]

You would have to store the file locally before reading the file. The alternative is you would need some kind of API access which is difficult and beyond the scope of this video

[@Huynh-Tan-Quoc]

@@SATSifaction you can help me?

[@H0LDENSUX]

Not MS Windows friendly

[@MrDrewluna]

in a real world scenario, shouldnt you have that excel file saved in a cloud anyway?

[@SATSifaction]

Not everyone has access to the cloud network. What i mean is some companies/people are reluctant to have it in the cloud. The alternative is to host is on an on prem network and use a solution like this however if you’re into the cloud, your likely using far more sophisticated technologies than excel

[@MrDrewluna]

@@SATSifaction we actually uses excel as a database, so this is why im watching your videos in excel, python, and sql, which actually gives me ideas

[@MattCamp]

why are you using Excel?! yea Excel will shit the bed with anything over a couple thousand records..

[@SATSifaction]

You would be surprised with how many people are still using excel. This is a way for them to transfer data. Of course my preferred method is db and or cloud based however several orgs aren’t there just yet