[PYTHON/PANDAS] DataFrame 클래스 : iat 속성을 사용해 특정 셀 데이터 구하기

■ DataFrame 클래스의 iat 속성을 사용해 특정 셀의 데이터를 구하는 방법을 보여준다.

▶ main.py


import pandas as pd
import numpy  as np

datetimeIndex = pd.date_range("20130101", periods = 6)

dataFrame1 = pd.DataFrame(np.random.randn(6, 4), index = datetimeIndex, columns = list("ABCD"))

print(dataFrame1)

"""
                   A         B         C         D
2013-01-01  0.248786 -0.657086  0.370225 -0.780453
2013-01-02  0.312765 -0.492724  0.654803  1.203754
2013-01-03  0.523139 -2.126527  0.553737  0.041873
2013-01-04  1.316598  0.422930  0.354900 -0.610110
2013-01-05  1.354282 -0.052645  0.497243 -0.943024
2013-01-06 -0.590947  0.494301 -0.692021 -0.128895
"""

print()

cellValue = dataFrame1.iat[1, 1] # numpy.float64

print(cellValue)

"""
-0.49272407509029337
"""

import pandas as pd

import numpy as np

datetimeIndex = pd.date_range("20130101", periods = 6)

dataFrame1 = pd.DataFrame(np.random.randn(6, 4), index = datetimeIndex, columns = list("ABCD"))

print(dataFrame1)

"""

A B C D

2013-01-01 0.248786 -0.657086 0.370225 -0.780453

2013-01-02 0.312765 -0.492724 0.654803 1.203754

2013-01-03 0.523139 -2.126527 0.553737 0.041873

2013-01-04 1.316598 0.422930 0.354900 -0.610110

2013-01-05 1.354282 -0.052645 0.497243 -0.943024

2013-01-06 -0.590947 0.494301 -0.692021 -0.128895

"""

print()

cellValue = dataFrame1.iat[1, 1] # numpy.float64

print(cellValue)

"""

-0.49272407509029337

"""

▶ requirements.txt


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

numpy==2.1.2

pandas==2.2.3

python-dateutil==2.9.0.post0

pytz==2024.2

six==1.16.0

tzdata==2024.2

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