擅长:python、mysql、java
<p>如果这些是空的,你需要先做N/A</p>
<pre><code>import pandas as pd
df = pd.DataFrame(dict(column1=["shop1","","","shop2",""],column2=["",34,32,"",35]))
df = df.mask(df == '')
df.column1 = df.column1.fillna(method='pad')
df = df.dropna(axis=0,how='any').reset_index(drop=True)
print(df)
</code></pre>
<p>退货:</p>
<pre><code> column1 column2
0 shop1 34
1 shop1 32
2 shop2 35
</code></pre>