I see alot of people are using Jupyter, but what is the optimal way to show dataframe results in IDE other then using println()

If you want to open it from a script, you can always create a temporary HTML file and open it in browser. We do that in Plotly.

thanks @Pavel Gorgulov, @altavir