And a thorough description of the problem / question:
In S6735 False positive when evaluating pandas.merge having right_on and left_on as parameters it was reported that rule S6735 “Specify the “validate” parameter of this merge” was raising a false positive when left_on or right_on was used, there was a reply stating that it had been fixed however I am getting the same issue today (screenshot provided so you can see the sonarqube message):
In the particular code example you shared, the rule seems to be working as expected. The validate parameter is missing from your pd.merge() call. The S6735 rule encourages adding this parameter to ensure the uniqueness of your merge keys and prevent unexpected results. Adding the validate parameter to your merge should resolve the warning.
As to SonarLint vs SonarQube for IDE, SonarLint was renamed into SonarQube for IDE. If you’re curious, you can find more information here.
Hope this helps clarify things!
By the way, our Product Manager would love to speak to you about the Python analysis and any other feedback you have for us. Would you have 30 minutes to spare? We’d really appreciate it. If so, you can find a time that works for you on this calendar.