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.
Hi - I am trying to use power query to create the most optimal matches in a dataset. Think of it as the college dorm assigment problem. I have survey responses from a group of people and I want to match individuals with the most opposite responses. The issue is rather than create a unique score for each person, the individual's responses are compared to every other person to create a score for every possible pairing. I have been able to create a matrix with the participants on the X and Y axis and their pairing score. Now I need to select the pairings with the highest scores, without any of the participants being selected more than once.
After some digging, it appears to be a perfect use case for the hungarian aglorithm, does anyone know how to do this in Power Query, or maybe have the Python code to do it?
Thanks in advance
Solved! Go to Solution.
Hi @Anonymous ,
About Hungarian Algorithm in python, I think you could refer these two simliar articles which introduce it in details:
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
About Hungarian Algorithm in python, I think you could refer these two simliar articles which introduce it in details:
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.