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

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

▶ 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.453182 -0.861583 -0.254588 -0.361769
2013-01-02  1.215367  0.103539  0.098492  0.149869
2013-01-03  0.821661 -1.125507 -0.242997  0.911715
2013-01-04  0.642376  0.346627 -0.750569 -1.202167
2013-01-05 -1.837095 -0.145270  0.976675  0.339294
2013-01-06 -1.088314  0.103322  0.846974 -1.413636
"""

print()

dataFrame2 = dataFrame1.loc["20130102":"20130104", ["A", "B"]]

print(dataFrame2)

"""
                   A         B
2013-01-02  1.215367  0.103539
2013-01-03  0.821661 -1.125507
2013-01-04  0.642376  0.346627
"""

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.453182 -0.861583 -0.254588 -0.361769

2013-01-02 1.215367 0.103539 0.098492 0.149869

2013-01-03 0.821661 -1.125507 -0.242997 0.911715

2013-01-04 0.642376 0.346627 -0.750569 -1.202167

2013-01-05 -1.837095 -0.145270 0.976675 0.339294

2013-01-06 -1.088314 0.103322 0.846974 -1.413636

"""

print()

dataFrame2 = dataFrame1.loc["20130102":"20130104", ["A", "B"]]

print(dataFrame2)

"""

A B

2013-01-02 1.215367 0.103539

2013-01-03 0.821661 -1.125507

2013-01-04 0.642376 0.346627

"""

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