将 DataFrame 的第一 n 行打印到控制台。
Syntax
show(n: int = 20, truncate: Union[bool, int] = True, vertical: bool = False)
参数
| 参数 | 类型 | 说明 |
|---|---|---|
n |
int,可选,默认值 20 | 要显示的行数。 |
truncate |
bool 或 int、optional、default True | 如果设置为 True,则截断长度超过 20 个字符的字符串。 如果设置为大于一的数字,请将长字符串截断为长度 truncate 并右对齐单元格。 |
vertical |
bool,可选 | 如果设置为 True,则垂直打印输出行(每列值一行)。 |
示例
df = spark.createDataFrame([
(14, "Tom"), (23, "Alice"), (16, "Bob"), (19, "This is a super long name")],
["age", "name"])
df.show()
# +---+--------------------+
# |age| name|
# +---+--------------------+
# | 14| Tom|
# | 23| Alice|
# | 16| Bob|
# | 19|This is a super l...|
# +---+--------------------+
df.show(2)
# +---+-----+
# |age| name|
# +---+-----+
# | 14| Tom|
# | 23|Alice|
# +---+-----+
# only showing top 2 rows
df.show(truncate=False)
# +---+-------------------------+
# |age|name |
# +---+-------------------------+
# |14 |Tom |
# |23 |Alice |
# |16 |Bob |
# |19 |This is a super long name|
# +---+-------------------------+
df.show(truncate=3)
# +---+----+
# |age|name|
# +---+----+
# | 14| Tom|
# | 23| Ali|
# | 16| Bob|
# | 19| Thi|
# +---+----+
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...