Jodie Qiu

I found that the order SQL processes commands is crucial to understanding SQL, especially for beginners.

When reading a SQL script from top to bottom, it’s not easy. What’s more, there are certain rules that are not intuitively understandable. Such as why we cannot put aggregation commands in where, but…

--

--

I’ve tried many ways to pip install but kept running into the following error:

XGBoostLibraryNotFound: Cannot find XGBoost Library in the candidate path, did you install compilers and run build.sh in root path?

Eventually I gave up pip and this worked for me:

In terminal run:

$ git clone — recursive https://github.com/dmlc/xgboost.git

This should downloads a folder called “xgboost”.

Go to /xgboost/python-package

In terminal run:

$ python setup.py install

This should start installing xgboost.

If you run into the following error here again:

XGBoostLibraryNotFound: Cannot find XGBoost Library in the candidate path, did you install compilers and run build.sh in root path?

You need to download xgboost.dll file and put it into /xgboost/python-package/xgboost

Then run the following command again:

$ python setup.py install

This time it should work.

--

--

Jodie Qiu

Jodie Qiu

My memos of machine learning algorithms, data pre-prcocessing and statistics. Git: https://github.com/qhqqiu