擅长:python、mysql、java
<p>熊猫解决方案,灵感来自(<a href="https://stackoverflow.com/questions/49876077/pandas-reading-excel-file-starting-from-the-row-below-that-with-a-specific-valu">link</a>)</p>
<p>示例文件:</p>
<p><a href="https://i.stack.imgur.com/2au1x.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2au1x.png" alt="enter image description here"/></a></p>
<pre><code>import pandas as pd
import numpy as np
df = pd.read_excel('tst.xlsx', usecols="C:D")
df = df.fillna('')
for row in range(df.shape[0]):
for col in range(df.shape[1]):
if df.iat[row,col] == 'Abbreviation':
row_start = row
col_required = col
break
df = df.loc[row_start+1:, df.columns[col_required]]
df.replace(['','\s+'], np.nan, inplace=True, regex=True)
df.dropna(inplace=True)
print(df)
</code></pre>
<p>结果:</p>
<pre><code>9 sfsdfd
10 fgfg_ff
12 dfs
13 ddd
15 dd_hh
</code></pre>