擅长:python、mysql、java
<pre><code>'''
name,date,description
bundy,12-12-2017,good dog
,,smells kind of weird
,,needs to be washed
'''
df = pd.read_clipboad()
</code></pre>
<p><a href="https://i.stack.imgur.com/oBpU9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oBpU9.png" alt="start"/></a></p>
<pre><code>df.fillna(method = 'ffill').groupby([
'name',
'date'
]).description.apply(lambda x : ', '.join(x)).to_frame(name = 'description')
</code></pre>
<p><a href="https://i.stack.imgur.com/WKtAS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WKtAS.png" alt="finish"/></a></p>