[python] Tidy Data, 교차분석표, pivot_table

3.2.6 교차분석표 구현하기

code

cross = pd.pivot_table(
    data   = datas,
    values = 'sales',
    aggfunc= 'sum',
    index  = 'store',
    columns= 'color'
)

print(cross)

결과

color  blue  red
store           
asan      3    4
seoul     1    2

full code

github

from pandas import DataFrame
import pandas as pd


datas = pd.DataFrame({'store':['seoul', 'seoul', 'asan', 'asan'],
                      'color': ['blue', 'red', 'blue', 'red'],
                      'sales':[1, 2, 3, 4]})

print(datas.describe())
print(datas.info())

cross = pd.pivot_table(
    data = datas,
    values= 'sales',
    aggfunc= 'sum',
    index = 'store',
    columns= 'color'
)

print(cross)