擅长:python、mysql、java
<pre><code>df = pd.read_excel('your/path/filename')
</code></pre>
<p><a href="https://stackoverflow.com/questions/42386629/pandas-find-index-of-value-anywhere-in-dataframe">This</a>应答有助于找到df中“start”的位置</p>
<pre><code> for row in range(df.shape[0]):
for col in range(df.shape[1]):
if df.iat[row,col] == 'start':
row_start = row
break
</code></pre>
<p>开始划船后,你可以使用熊猫的子帧</p>
<pre><code>df_required = df.loc[row_start:]
</code></pre>
<p>如果不需要包含“start”的行,只需将行从1开始</p>
<pre><code>df_required = df.loc[row_start+1:]
</code></pre>