06_판다스_데이터_선택

import pandas as pd
df = pd.read_Excel('score.xlsx', index_col='지원번호')

• Column 선택(label)

df['이름']

df['키']

df[['이름','키']]

• Column 선택(정수 index)

df.columns

df.columns[0]

df.columns[2]

df[df.columns[0]]

df[df.columns[-1]]

• 슬라이싱

df['영어'][0:5]

df[['이름', '키']][:3]

df[3:]

• loc

df.loc['1번']

df.loc['1번','국어']

df.loc[['1번','2번'],'영어']

df.loc['1번':'5번', '국어':'사회']

• iloc

df.iloc[1]

df.iloc[1,1]

df.iloc[[1,2],4]

df.iloc[1:4,3:]