import numpy
import pandas
data = pandas.read_csv(
'D:\\PDA\\5.4\\data.csv'
)
bins = [
min(data.年齡)-1, 20, 30, 40, max(data.年齡)+1
]
labels = [
'20歲以及以下', '21歲到30歲', '31歲到40歲', '41歲以上'
]
data['年齡分層'] = pandas.cut(
data.年齡,
bins,
labels=labels
)
ptResult = data.pivot_table(
values=['年齡'],
index=['年齡分層'],
columns=['性別'],
aggfunc=[numpy.size]
)
