擅长:python、mysql、java
<p>我一直在想任何可能的方法,我注意到在play\u homevisitor专栏中我总是有0,1,0,1的顺序,所以我想到了一个主意:</p>
<ol>
<li>创建两个中间列,移动-1和+1。它将创建列升档和列降档。只分析每一对博弈;在升档时,主队得分上升,而在降档时,客队得分下降</李>
</ol>
<blockquote>
<pre><code>df['downShift'] = df['Runs_scored'].shift(periods= 1).fillna(0)
df['upShift'] = df['Runs_scored'].shift(periods= -1).fillna(0)
</code></pre>
</blockquote>
<ol start=“2”>
<li>如果play\u homevisitor为0,则我将在升档时获取值,否则,如果play\u homevisitor为1,则我将在降档时获取值</li>
</ol>
<blockquote>
<p>df['Runs_allowed'] = df[['play_homevisitor','downShift',
'upShift']].apply(lambda x: x['upShift'] if x['play_homevisitor'] == 0
else x['downShift'], axis=1)</p>
</blockquote>