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