pyspark.sql.DataFrame.show#
- DataFrame.show(n=20, truncate=True, vertical=False)[source]#
- Prints the first - nrows of the DataFrame to the console.- New in version 1.3.0. - Changed in version 3.4.0: Supports Spark Connect. - Parameters
- nint, optional, default 20
- Number of rows to show. 
- truncatebool or int, optional, default True
- If set to - True, truncate strings longer than 20 chars. If set to a number greater than one, truncates long strings to length- truncateand align cells right.
- verticalbool, optional
- If set to - True, print output rows vertically (one line per column value).
 
 - Examples - >>> df = spark.createDataFrame([ ... (14, "Tom"), (23, "Alice"), (16, "Bob"), (19, "This is a super long name")], ... ["age", "name"]) - Show - DataFrame- >>> df.show() +---+--------------------+ |age| name| +---+--------------------+ | 14| Tom| | 23| Alice| | 16| Bob| | 19|This is a super l...| +---+--------------------+ - Show only top 2 rows. - >>> df.show(2) +---+-----+ |age| name| +---+-----+ | 14| Tom| | 23|Alice| +---+-----+ only showing top 2 rows - Show full column content without truncation. - >>> df.show(truncate=False) +---+-------------------------+ |age|name | +---+-------------------------+ |14 |Tom | |23 |Alice | |16 |Bob | |19 |This is a super long name| +---+-------------------------+ - Show - DataFramewhere the maximum number of characters is 3.- >>> df.show(truncate=3) +---+----+ |age|name| +---+----+ | 14| Tom| | 23| Ali| | 16| Bob| | 19| Thi| +---+----+ - Show - DataFramevertically.- >>> df.show(vertical=True) -RECORD 0-------------------- age | 14 name | Tom -RECORD 1-------------------- age | 23 name | Alice -RECORD 2-------------------- age | 16 name | Bob -RECORD 3-------------------- age | 19 name | This is a super l...