Become A Data Scientist

I have tried a million ways over years to by-pass all the certs/securities but never had a one right way to do this, xgboost is a very popular ml algorithm but been hard to install. This time finally I made it happen. I downloaded the wheel file directly and installed it to make this happen right. I also have a video for this but this article shows step by step process on how to do it right. Here is how: Open command window from start menu in windows: Fig1: Open Command Window Go to the website to find unofficial binaries 👉 here , find the desired .whl file, in this case, we are looking for xgboost, and download the compatible version with your machine and python: Fig2: The Unofficial Binaries Locate the downloaded file on your machine: Fig3: Locate the Files Install from cmd using pip: Fig4: Install the file  And you are done, you can also follow these steps from my video here: 

If coding/automation is not about us fooling the machine to get our work done, we haven't yet exploited our powers enough. I, in my daily life, do all sorts of problem-solving involves complex coding, cloud computing, etc. but I get my real kick when I solve the smallest problem like hacking excel, or automation of workflow using power query. Here is my latest gig, I tried to connect to an excel in SharePoint and ensure that every time the database is updated my query picks the latest file. This is the first time I am using power query and it sounds so powerful. So without further delay, let's see what I did: 1.  Connect Excel to DataBase:  Open an excel file, Select  Data  from the green ribbon, go to  Get  Data , select the drop-down on  From File , and connect to share point select  From SharePoint Folder.  Fig1: Select DataBase Once you select the database which is SharePoint in our case, you will get a window like this popping up to connect to it. Put in site url (not the