AttributeError:（“'Series'对象没有属性'iterrows'”，u'occurrent at index Identifier 1'）等问题

Question

当我试图将数据帧传递给我创建的函数时，会遇到AttributeError。在

我创建了一个函数，它应该对我传递的数据帧中的行执行一些基本操作，但前提是其中一个单元格包含某个值。第一个帖子很长，很抱歉。这里是相关的代码和错误。在

nitrogen.head()

    Identifier 1       Amount   Area 28  Percent Nitrogen d 15N/14N   d15N
0   sediment standard  1.568    23.478   0                -4.046      0
1   sediment standard  1.801    11.230   0                3.660       0
2   sediment standard  1.554    9.591    0                3.391       0
3   1c-50cm            12.322   36.075   0                4.349       0
4   1c-10cm            11.786   35.296   0                5.622       0

def correctNitrogen(data):
    for index, row in data.iterrows():
        if data.loc[index, 'Identifier 1'] == 'sediment standard':
            standardsP += (data['Amount']/data['Area 28'])*0.62
            standardsD += data['d 15N/14N']
            x += 1

    averageP = standardsP/x
    averageD = standardsD/x
    correcter = 4.42-averageD

    for index, row in data.iterrows():
        if data.loc[index, 'Identifier 1'] != 'sediment standard':
             data['Percent Nitrogen'] = averageP*(data['Area 28']/data['Amount'])
             data['d15N'] = data['d 15N/14N']+correcter

nitrogen.apply(correctNitrogen)

AttributeError                            Traceback (most recent call last)
<ipython-input-175-98f6b563e9b6> in <module>()
----> 1 nitrogen.apply(correctNitrogen)
      2 nitrogen.head()

C:\ProgramData\Anaconda2\lib\site-packages\pandas\core\frame.py in apply(self, func, axis, broadcast, raw, reduce, args, **kwds)
   4260                         f, axis,
   4261                         reduce=reduce,
-> 4262                         ignore_failures=ignore_failures)
   4263             else:
   4264                 return self._apply_broadcast(f, axis)

C:\ProgramData\Anaconda2\lib\site-packages\pandas\core\frame.py in _apply_standard(self, func, axis, ignore_failures, reduce)
   4356             try:
   4357                 for i, v in enumerate(series_gen):
-> 4358                     results[i] = func(v)
   4359                     keys.append(v.name)
   4360             except Exception as e:

<ipython-input-157-ff5a7f145cc2> in correctNitrogen(data)
      2 # corrects it to the standard that is being used
      3 def correctNitrogen(data):
----> 4     for index, row in data.iterrows():
      5         if data.loc[index, 'Identifier 1'] == 'sediment standard':
      6             standardsP += (data['Amount']/data['Area 28'])*nit

C:\ProgramData\Anaconda2\lib\site-packages\pandas\core\generic.py in __getattr__(self, name)
   3079             if name in self._info_axis:
   3080                 return self[name]
-> 3081             return object.__getattribute__(self, name)
   3082 
   3083     def __setattr__(self, name, value):

AttributeError: ("'Series' object has no attribute 'iterrows'", u'occurred at index Identifier 1')

现在我意识到这个函数可能还有其他问题，但这是迄今为止我遇到的第一个问题。我觉得这和我如何将数据帧传递给函数有关，但我不知道如何修复它。。在

Answer 1

简短回答-函数apply是对列/行调用的，这是一个pandas.Series，因此出现错误。在

要在不修改函数的情况下进行修复，请调用：

nitrogen = correctNitrogen(nitrogen)

但也请注意，您需要从函数返回数据帧：

^{pr2}$