Data Cleaning

[Arcadis_PowerBI]

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!

[jameshart1]

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)

[v-yuta-msft · Accepted solution]

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