将qcut分配为新列 [英] Assignment of qcut as new column
问题描述
在这里的熊猫笔记本上
我看到qcut的结果被分配为DataFrame的新列.数据框有两列,但是以某种方式将qcut输出分配给新列会神奇地找到"var"变量所属的正确级别-不会检查其他变量.熊猫在这里的语义是什么?示例输出如下:
I see the result of qcut being assigned as a new column to a DataFrame. Dataframe has two columns, but somehow assigning qcut output to a new column magically finds the correct level that the "var" variable falls in -- the other variable is not checked. What is the Pandas semantics here? Sample output is below:
In [2]:
from pandas import *
from statsmodels.formula.api import logit
from statsmodels.nonparametric import KDE
from patsy import dmatrix, dmatrices
In [3]:
df = read_csv('wells.dat', sep = ' ', header = 0, index_col = 0)
print df.head()
switch arsenic dist assoc educ
1 1 2.36 16.826000 0 0
2 1 0.71 47.321999 0 0
3 0 2.07 20.966999 0 10
4 1 1.15 21.486000 0 12
5 1 1.10 40.874001 1 14
In [4]:
model_form = ('switch ~ center(I(dist / 100.)) + center(arsenic) + ' +
'center(I(educ / 4.)) + ' +
'center(I(dist / 100.)) : center(arsenic) + ' +
'center(I(dist / 100.)) : center(I(educ / 4.)) + ' +
'center(arsenic) : center(I(educ / 4.))'
)
model4 = logit(model_form, df = df).fit()
In [20]:
resid_df = DataFrame({'var': df['arsenic'], 'resid': model4.resid})
resid_df[:10]
Out [20]:
resid var
1 0.842596 2.36
2 1.281417 0.71
3 -1.613751 2.07
4 0.996195 1.15
5 1.005102 1.10
6 0.592056 3.90
7 0.941372 2.97
8 0.640139 3.24
9 0.886626 3.28
10 1.130149 2.52
In [15]:
qcut(df['arsenic'], 40)
Out [15]:
Categorical: arsenic
array([(2.327, 2.47], (0.68, 0.71], (1.953, 2.07], ..., [0.51, 0.53],
(0.62, 0.64], (0.64, 0.68]], dtype=object)
Levels (40): Index([[0.51, 0.53], (0.53, 0.56], (0.56, 0.59],
(0.59, 0.62], (0.62, 0.64], (0.64, 0.68],
(0.68, 0.71], (0.71, 0.75], (0.75, 0.78],
(0.78, 0.82], (0.82, 0.86], (0.86, 0.9], (0.9, 0.95],
(0.95, 1.0065], (1.0065, 1.0513], (1.0513, 1.1],
(1.1, 1.15], (1.15, 1.2], (1.2, 1.25], (1.25, 1.3],
(1.3, 1.36], (1.36, 1.42], (1.42, 1.49],
(1.49, 1.57], (1.57, 1.66], (1.66, 1.76],
(1.76, 1.858], (1.858, 1.953], (1.953, 2.07],
(2.07, 2.2], (2.2, 2.327], (2.327, 2.47],
(2.47, 2.61], (2.61, 2.81], (2.81, 2.98],
(2.98, 3.21], (3.21, 3.42], (3.42, 3.791],
(3.791, 4.475], (4.475, 9.65]], dtype=object)
In [17]:
resid_df['bins'] = qcut(df['arsenic'], 40)
resid_df[:20]
Out [17]:
resid var bins
1 0.842596 2.36 (2.327, 2.47]
2 1.281417 0.71 (0.68, 0.71]
3 -1.613751 2.07 (1.953, 2.07]
4 0.996195 1.15 (1.1, 1.15]
5 1.005102 1.10 (1.0513, 1.1]
6 0.592056 3.90 (3.791, 4.475]
7 0.941372 2.97 (2.81, 2.98]
8 0.640139 3.24 (3.21, 3.42]
找到正确的bin用于"var",分配没有注意"resid".
The correct bin is found for "var", the assignment did not pay attention to "resid".
推荐答案
我想我明白了.标签会根据该点所在的四分位数为每个点携带一个数字,例如1,2,3.然后,如果将qcut结果分配给DataFrame上的新列,则Pandas会将标签"与DataFrame的索引"进行匹配.
I think I got it.. There is a "labels" attribute on qcut Categorical (its result) object; Labels carries a number such as 1,2,3 for each point based on the quartile the point falls in. Then, if qcut result is assigned into a new column on DataFrame Pandas matches this "labels" with the "index" of the DataFrame.
这篇关于将qcut分配为新列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!