pyspark.sql.DataFrame.limit#

DataFrame.limit(num)[source]#

Limits the result count to the number specified.

Added in version 1.3.0.

Changed in version 3.4.0: Supports Spark Connect.

Parameters:

numint: Number of records to return. Will return this number of records or all records if the DataFrame contains less than this number of records.

Returns:

DataFrame: Subset of the records

Examples

>>> df = spark.createDataFrame(
...     [(14, "Tom"), (23, "Alice"), (16, "Bob")], ["age", "name"])
>>> df.limit(1).show()
+---+----+
|age|name|
+---+----+
| 14| Tom|
+---+----+
>>> df.limit(0).show()
+---+----+
|age|name|
+---+----+
+---+----+