Add show method to DataFrame and LazyFrame

[djouallah]

Description

pretty much all Python calculation engines support show method , see pyspark documentation https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.DataFrame.show.html

it is just for convenience especially when used with SQL

[stinodego]

We want to support this. Implementation will look like:

• show method on DataFrame and LazyFrame
• It will print to the console and not return anything
• The method will have some parameters to directly configure some Config printing parameters
• In notebooks we want to use the _html_repr, otherwise we want to use the regular repr

[mnurpeiissov]

HI, is this being already worked on? I can be assigned if needed, I am new to the codebase and want to start contributing, will need some time and guidance to implement.

[mnurpeiissov]

I will proceed with implementation as @stinodego outlined, is that ok?