Forum Discussion
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:
Task - 000010 RCRA Report
4/19/2017
8/2/2018
9/5/2015
Task - 50002 Groundwater Report
12/6/2017
1/11/2018
Task - 50003 Ecological Report
8/8/2017
and so on...
Essentially, the task information should be in one column and the dates should be in another column. I thought about duplicating the column and using find/replace for both. However, I have too many different tasks and dates to use find and replace easily. Is there a way to separate the two different types of data into two columns: one column with dates and the other with tasks? Thank you for the help!
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
2 Replies
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)