英文:
Add pre-defined value to DataFrame on each instance of matching index
问题
我正在尝试在df1中的每次名称和周匹配的情况下，将df中的相应值添加到df1中。
期望的结果是：
df1Name Week Total0 Frank Week 1 161 Frank Week 1 32 Frank Week 3 **36**3 Frank Week 3 **9**4 Frank Week 4 3...310 Daniel Week 2 50311 Daniel Week 3 **58**312 Daniel Week 4 78313 Kevin Week 4 162314 Kevin Week 4 46
英文:
I am trying to add the corresponding value from df to df1 for each time the name and week match in df1
dfName Week Value0 Frank Week 3 8.01 Bob Week 3 8.02 Bob Week 4 8.03 Elizabeth Week 3 4.04 Mario Week 2 1.55 Mario Week 3 2.56 Michelle Week 3 8.07 Michelle Week 4 1.08 Darwin Week 1 1.09 Darwin Week 2 0.510 Darwin Week 3 11.011 Collins Week 1 8.012 Collins Week 2 6.013 Collins Week 3 17.014 Collins Week 4 7.015 Alexis Week 1 1.516 Daniel Week 3 2.0df1Name Week Total0 Frank Week 1 161 Frank Week 1 32 Frank Week 3 283 Frank Week 3 14 Frank Week 4 3.. ... ... ...310 Daniel Week 2 50311 Daniel Week 3 56312 Daniel Week 4 78313 Kevin Week 4 162314 Kevin Week 4 46
Expected:
df1Name Week Total0 Frank Week 1 161 Frank Week 1 32 Frank Week 3 **36**3 Frank Week 3 **9**4 Frank Week 4 3.. ... ... ...310 Daniel Week 2 50311 Daniel Week 3 **58**312 Daniel Week 4 78313 Kevin Week 4 162314 Kevin Week 4 46
答案1
得分: 0
out = (df1.merge(df, how='left').assign(Total=lambda d: d['Total'].add(d.pop('Value'), fill_value=0)))
输出：
Name Week Total0 Frank Week 1 16.01 Frank Week 1 3.02 Frank Week 3 36.03 Frank Week 3 9.04 Frank Week 4 3.0...5 Daniel Week 2 50.06 Daniel Week 3 58.07 Daniel Week 4 78.08 Kevin Week 4 162.09 Kevin Week 4 46.0
英文:
out = (df1.merge(df, how='left').assign(Total=lambda d: d['Total'].add(d.pop('Value'), fill_value=0)))
Output:
Name Week Total0 Frank Week 1 16.01 Frank Week 1 3.02 Frank Week 3 36.03 Frank Week 3 9.04 Frank Week 4 3.0...5 Daniel Week 2 50.06 Daniel Week 3 58.07 Daniel Week 4 78.08 Kevin Week 4 162.09 Kevin Week 4 46.0
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论