擅长:python、mysql、java
<p>像这样的怎么样</p>
<pre><code>import pandas as pd
from collections import defaultdict
df = pd.DataFrame( {"Client" : ["Alice", "Nan", "Nan", "Mallory", "Nan" , "Bob"] ,
"Product" : ["A", "B", "C", "B", "C", "B"] } )
last_client = None
data = defaultdict(list)
for _, row in df.iterrows():
# id hazard a guess you want np.nan not the string compare here
if row.Client != last_client and row.Client != "Nan":
last_client = row.Client
data[last_client].append(row.Product)
print(data)
</code></pre>
<blockquote>
<p>defaultdict(, {'Alice': ['A', 'B', 'C'], 'Mallory': ['B', 'C'], 'Bob': ['B']})</p>
</blockquote>