cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Arcadis_PowerBI Frequent Visitor
Frequent Visitor

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Data Cleaning

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

1 REPLY 1
Community Support Team
Community Support Team

Re: Data Cleaning

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