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...