Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.9k views
in Technique[技术] by (71.8m points)

pandas - Python: data argument can't be an iterator

I'm trying to replicate the code that is provided here: https://github.com/IdoZehori/Credit-Score/blob/master/Credit%20score.ipynb

The function given below fails to run and give error. Can someone help me resolving it

def replaceOutlier(data, method = outlierVote, replace='median'):
'''replace: median (auto)
            'minUpper' which is the upper bound of the outlier detection'''
vote = outlierVote(data)
x = pd.DataFrame(zip(data, vote), columns=['annual_income', 'outlier'])
if replace == 'median':
    replace = x.debt.median()
elif replace == 'minUpper':
    replace = min([val for (val, vote) in list(zip(data, vote)) if vote == True])
    if replace < data.mean():
        return 'There are outliers lower than the sample mean'
debtNew = []
for i in range(x.shape[0]):
    if x.iloc[i][1] == True:
        debtNew.append(replace)
    else:
        debtNew.append(x.iloc[i][0])

return debtNew

Function Call:

incomeNew = replaceOutlier(df.annual_income, replace='minUpper')

Error: x = pd.DataFrame(zip(data, vote), columns=['annual_income', 'outlier']) TypeError: data argument can't be an iterator

PS: I understand this has been asked before, but I tried using the techniques however the error still remains

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

zip cannot be used directly, you should give the result as a list i.e.:

x = pd.DataFrame(list(zip(data, vote)), columns=['annual_income', 'outlier'])

Edit (from bayethierno answer) :
Since the release 0.24.0, we don't need to generate the list from the zip anymore, the following statement is valid :

x = pd.DataFrame(zip(data, vote), columns=['annual_income', 'outlier'])

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...