Forum Discussion
Solved
Data Cleaning
Hi Community, My source excel file has data merged into once column. I want to do the data cleaning within Power BI. The data looks like this in one column after importing into Power BI: ...
Hi Arcadis_PowerBI,
It's a little bit complex to implement data clean using power query, so I would recommend you to use extract your data into python pandas framework and do the data transform and clean in python. About how to implement python script in power query, please refer to this announcement: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2018-feature-summary/#python.
Regards,
Jimmy Tao
Hi all
I'm trying to tidy a data set to only show model type: Samsung S10, iPhone XR, iPhone XS Max, etc and remove anything that might be a colour or storage size. Is this possible? (See screenshot)