Python in Power Query

and the code is
import pandas as pd
y=dataset.Survived
x_train,x_test,y_train,y_test=train_test_split(x,y,test_size=0.2)
from sklearn import metrics
clf = DecisionTreeClassifier()
dfoutput = pd.DataFrame({'prediction':y_pred})

[akshaymankar]

Thanks a lot for this explanation !
I was really struggling with creating new tables from the existing loaded data.
And after 3 hours of googling you solved it in 12 minutes.
Thank-you very much

[KulturanCov]

Is there no way to enable Run Python in Excel based Power Query editors?

[im]

Hello and thanks for a great video. I am sitting here and thinking ....can i just avoid M Language in power query and use python instead? I know python way better than I know m language and don't really have too much time to learn M.

[krishkari]

@RADACAD Can you also do a video on scheduling this file for auto-refresh. I was able to make it work in desktop but I couldn't auto refresh the file from server.

[naheliegend]

it is called scikit-learn. Anyways, strong tutorial :)

[DanielWeikert]

Unfortunately that does not work for me. I installed python via anaconda and pointed exactly to the location in Power BI. I still face the issue that matplotlib is not availabe (The package is installed!)
Any ideas?
Thanks and best regards