擅长:python、mysql、java
<p>修正了代码的工作原理。找到每个游戏者的索引,for循环对第一个条目、两个条目、三个条目求和,以此类推</p>
<pre><code>df = pd.read_csv('D:\RunningBackYards_3.csv',
usecols=['Player', 'Tm', 'Year', 'Yds'])
unique_player = set(df.Player)
unique_year = set(df.Year)
yr = [[]]
plyr = [[]]
yards = [[]]
for ii in unique_player:
idxPt = df.index[(df['Player'] == ii)]
idx = 1
for kk in idxPt:
yards.append(sum(df.Yds[idxPt[0:idx]]))
yr.append(df.Year[kk])
plyr.append(df.Player[kk])
idx = idx + 1
yards = numpy.transpose(yards)
yr = numpy.transpose(yr)
plyr = numpy.transpose(plyr)
yards = pd.Series(yards)
yr = pd.Series(yr)
plyr = pd.Series(plyr)
data = {"Player": plyr,
"Year": yr,
"Yds": yards}
dffNew = pd.concat(data,
axis = 1)
</code></pre>