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?
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?
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 👉🏼 th-cam.com/video/nPQE5B51DQ8/w-d-xo.html
@@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
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
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
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
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?
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?
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 👉🏼 th-cam.com/video/nPQE5B51DQ8/w-d-xo.html
@@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
How to upload excel file in python rest api method sir?
can I use this method to refresh an Excel File ?
A bit of a different use case but programming that shouldn’t be very hard
if i want to read file excel in teams microsoft , how to you do it? pls help me
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
@@SATSifaction you can help me?
Sir Please do Some videos on Python Visualisation.
Thanks for the feedback. I’m working on a live stream for python dash. I’ll let you know when that is ready
@@SATSifaction Oh sounds great Sir.
in a real world scenario, shouldnt you have that excel file saved in a cloud anyway?
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
@@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
Not MS Windows friendly
why are you using Excel?! yea Excel will shit the bed with anything over a couple thousand records..
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