原始数据帧:
fruit Drink week
banana milk Mon
apple coke Tue
pear tea Wed
第二步使用此代码:df['COMBINE'] = df['fruit']+ '+' +df['Drink']
fruit Drink COMBINE week
banana milk banana+milk Mon
apple coke apple+coke Tue
pear tea pear+tea Wed
第三步:
让它随机选择组合列中的1行和周列中的一行,然后将它们组合为一个字符串。
预期结果:
banana+milk Wed
我想知道如何将所有代码组合在一起?
numpy.random.choice
df.apply(np.random.choice)
Food milk
week Tue
dtype: object
根据@piRSquared的答案,并在编辑后的问题中说明您的新需求:
import pandas as pd
import numpy as np
df = pd.DataFrame({'fruit': ['banana','apple','pear'], 'Drink': ['milk','coke','tea'], 'week': ['Mon','Tue','Wed']})
df['COMBINE'] = df['fruit'] + '+' + df['Drink']
' '.join(df[['COMBINE','week']].apply(np.random.choice).values)
收益率:
apple+coke Mon