[PYTHON/PANDAS] Series 클래스 : sum 메소드를 사용해 값 합산하기

■ Series 클래스의 sum 메소드를 사용해 값을 합산하는 방법을 보여준다.

▶ main.py


import pandas as pd
import numpy  as np

dataFrame1 = pd.DataFrame({"key" : ["A", "B", "C", "D"], "value" : np.random.randn(4)})
dataFrame2 = pd.DataFrame({"key" : ["B", "D", "D", "E"], "value" : np.random.randn(4)})

dataFrame3 = dataFrame1.merge(dataFrame2, on = ["key"], how = "outer")

print(dataFrame3)

"""
  key   value_x   value_y
0   A  1.760074       NaN
1   B -0.959353  0.390332
2   C -0.410334       NaN
3   D -0.157667 -0.996457
4   D -0.157667 -0.214345
5   E       NaN  1.238488
"""

print()

totalValue = dataFrame3["value_x"].sum()

print(totalValue) # numpy.float64

"""
0.07505333274381987
"""

import pandas as pd

import numpy as np

dataFrame1 = pd.DataFrame({"key" : ["A", "B", "C", "D"], "value" : np.random.randn(4)})

dataFrame2 = pd.DataFrame({"key" : ["B", "D", "D", "E"], "value" : np.random.randn(4)})

dataFrame3 = dataFrame1.merge(dataFrame2, on = ["key"], how = "outer")

print(dataFrame3)

"""

key value_x value_y

0 A 1.760074 NaN

1 B -0.959353 0.390332

2 C -0.410334 NaN

3 D -0.157667 -0.996457

4 D -0.157667 -0.214345

5 E NaN 1.238488

"""

print()

totalValue = dataFrame3["value_x"].sum()

print(totalValue) # numpy.float64

"""

0.07505333274381987

"""

▶ requirements.txt


numpy==2.1.3
pandas==2.2.3
python-dateutil==2.9.0.post0
pytz==2024.2
six==1.16.0
tzdata==2024.2

numpy==2.1.3

pandas==2.2.3

python-dateutil==2.9.0.post0

pytz==2024.2

six==1.16.0

tzdata==2024.2

※ pip install pandas 명령을 실행했다.