Data Preprocessing in Power BI using Python

Data Preprocessing is one of the key areas in a Data Science project. In this video explains how to perform preprocessing or data manipulation in Microsoft Power BI using Python. Power BI has integrated with Python, the language used for Data Science workloads since August 2018 release. Similar to other methods like GUI or R scripts, now you can use Python to do data manipulation in your Power BI model.

Understand Power BI Desktop Privacy Levels:

LET'S CONNECT WITH

Blog:

Twitter:

LinkedIn:

Instagram:

[ericGTS]

Thanks for sharing!
Great intro to data preprocessing with python in power bi.

[rosycoco]

I like that you use the shortest time and explained the most important thing! 👍

[luckyreview]

very good info..
please use Noise cancelling headphones.

[ritubansal]

Hey Nisal, is it possible to save python script code. so we don't need to write the code again and again for the transformation purpose?

[abhishekpachauri]

Hi Sir, If we run data cleansing steps using python in power BI? Will this process save time as compared to cleaning in power bi using Power bi cleaning steps?

[Nicky]

Nice. I just learned this bit:



finPy = pd.DataFrame(dataset.loc[:, 'TotalCharge'])

finPy = #example to fill dataset (in this case a column) with the mean values of the dataset

[Andynonymous_music]

good info! just a tip, try speaking a little slower and try to enunciate more clearly, you're not the easiest to understand.

[krishnakishorepeddisetti]

i am getting the blow error when i run the python code.

ErrorCode=-2147467259


can you help me with this

Thanks and Regards
Kishore

[amokhtar]

So funny, why you didn't do that without Python, it sounds easier! not a good example you picked