jumlah (GroupedData)

Menghitung jumlah untuk setiap kolom numerik untuk setiap grup.

Sintaksis

sum(*cols)

Parameter-parameternya

Parameter	Tipe	Deskripsi
cols	str	Nama kolom. Kolom non-numerik diabaikan.

Pengembalian Barang

DataFrame

Examples

df = spark.createDataFrame([
    (2, "Alice", 80), (3, "Alice", 100),
    (5, "Bob", 120), (10, "Bob", 140)], ["age", "name", "height"])

# Group-by name, and calculate the sum of the age in each group.
df.groupBy("name").sum("age").sort("name").show()
# +-----+--------+
# | name|sum(age)|
# +-----+--------+
# |Alice|       5|
# |  Bob|      15|
# +-----+--------+

# Calculate the sum of the age and height in all data.
df.groupBy().sum("age", "height").show()
# +--------+-----------+
# |sum(age)|sum(height)|
# +--------+-----------+
# |      20|        440|
# +--------+-----------+