Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello community,
I am parsing a free text field from a .xslx file (retrieved from database) using Python regular expressions. Indeed, I need to filter the free text and retrieve very specific data which can only be done using regular expressions, and then store the parsed data in new columns of the file. A sample of the code:
line_pattern = r'(?i)(line item\.*\s*\d+|line\.*\s*\d+|lines\.*\s*\d+|line items\.*\s*\d+)'
df['LINE'] = df['FMEA Assessment'].str.findall(line_pattern)
My company is using Power BI mostly for reporting purposes and implementing my script within the desktop to automatically parse the data would be great.
I have tried Get Data -> Load -> Edit Queries -> Run Python script, but I get the following error message.
Any help using Python scripts including regular expressions, or using only regular expressions to parse text and populate new columns would be greatly appreciated.
Thank you!
Solved! Go to Solution.
The error message mentioned that you haven't installed the site-package "pandas", please install pandas library using pip. For more details, you can refer to steps in blog below:
https://data-flair.training/blogs/install-pandas-on-windows/
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The error message mentioned that you haven't installed the site-package "pandas", please install pandas library using pip. For more details, you can refer to steps in blog below:
https://data-flair.training/blogs/install-pandas-on-windows/
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
There seemed to be an internal issue with my anaconda environment. I uninstalled all packaged then installed them again and it worked!
Thanks again.
Good Morning,
Thank you for your reply @v-yuta-msft. I double checked pandas and they are indeed installed so I am not sure what the problem might be. I installed them again just to be safe but I still get an error message.
Attached is the latest error message I get. Not sure what is ADO.NET?
Thank you again for your help.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
105 | |
79 | |
71 | |
66 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |