Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. df1 = pd.DataFrame({'lkey': ['foo', 'bar', 'baz', 'foo'],
  2. 'value1': [1, 2, 3, 5],
  3. 'value2': [5, 7, 8, 9]})
  4. dfc = [['lkey','value1'],['lkey','value2']]
  5.  
  6.  
  7. rslt = pd.DataFrame()
  8. for i in range(0,1):
  9. tmp = df1[dfc[i]].rename(columns={ df1[dfc[i]].columns[0]: "test" })
  10. if len(rslt) == 0:
  11. rslt = tmp
  12. else:
  13. rslt = pd.merge(rslt, tmp,how='outer',on="test")
  14.  
  15. test value1
  16. 0 foo 1
  17. 1 bar 2
  18. 2 baz 3
  19. 3 foo 5
  20.  
  21. test value1 value2
  22. 0 foo 1 6
  23. 1 bar 2 7
  24. 2 baz 3 8
  25. 3 foo 5 9
  26.  
  27. print (list(range(0,1)))
  28. [0]
  29.  
  30. print (list(range(0,2)))
  31. #alternative
  32. #print (list(range(2)))
  33. [0, 1]
  34.  
  35. rslt = pd.DataFrame()
  36. for i in range(0,2):
  37. tmp = df1[dfc[i]].rename(columns={ df1[dfc[i]].columns[0]: "test" })
  38. if len(rslt) == 0:
  39. rslt = tmp
  40. else:
  41. rslt = pd.merge(rslt, tmp,how='outer',on="test")
  42.  
  43. print (rslt)
  44. test value1 value2
  45. 0 foo 1 5
  46. 1 foo 1 9
  47. 2 foo 5 5
  48. 3 foo 5 9
  49. 4 bar 2 7
  50. 5 baz 3 8
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement