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

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

▶ 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  1.496475 -0.462460  0.239277 -0.150066
2013-01-02  0.522467 -1.208454 -0.249313  0.337069
2013-01-03 -0.058117  0.351514  2.003000 -1.487527
2013-01-04 -2.049386  0.991963 -1.148437 -0.631090
2013-01-05  0.284946  1.314614 -1.701463  1.685527
2013-01-06 -2.020866  0.165436  1.581737  0.480128
"""

print()

value = dataFrame1.at[datetimeIndex[0], "A"]

print(value)

"""
1.4964751609479943
"""

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 1.496475 -0.462460 0.239277 -0.150066

2013-01-02 0.522467 -1.208454 -0.249313 0.337069

2013-01-03 -0.058117 0.351514 2.003000 -1.487527

2013-01-04 -2.049386 0.991963 -1.148437 -0.631090

2013-01-05 0.284946 1.314614 -1.701463 1.685527

2013-01-06 -2.020866 0.165436 1.581737 0.480128

"""

print()

value = dataFrame1.at[datetimeIndex[0], "A"]

print(value)

"""

1.4964751609479943

"""

▶ 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 명령을 실행했다.