contents
python
pandas
>>> import pandas
>>> data = pandas.read_csv('sample.csv')
>>> data
name work age race s5k
0 A gov 41 white 1
1 B xxx 35 black 0
2 C xxx 26 asian 0
3 D yyy 26 white 0
4 E xxx 38 black 1
5 F yyy 52 white 0
>>> crosstab = data.pivot_table(rows='work')
>>> crosstab
age s5k
work
gov 41 1.000000
xxx 33 0.333333
yyy 39 0.000000
>>> crosstab['s5k']['xxx']
0.33333333333333331
>>> data.pivot_table(rows='race')['s5k']
race
asian 0.000000
black 0.500000
white 0.333333
Name: s5k, dtype: float64
Last modified: 2015-12-26 by hiroshi.ohtsuka@u...
