Guest User

Untitled

a guest
Oct 21st, 2017
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. import pandas as pd
  2. columns = ["A", "B", "C"]
  3. data = [[1, 11, 111],
  4. [2, 22, 222],
  5. [3, 33, 333]]
  6. df = pd.DataFrame(data=data, columns=columns)
  7. df
  8.  
  9. Out[1]:
  10. A B C
  11. 0 1 11 111
  12. 1 2 22 222
  13. 2 3 33 333
  14.  
  15.  
  16. mdict = {}
  17. for c in df.columns:
  18. mdict.update(dict(zip(df[c], df['A'])))
  19. mdict
  20.  
  21. Out[2]:
  22. {1: 1, 2: 2, 3: 3, 11: 1, 22: 2, 33: 3, 111: 1, 222: 2, 333: 3}
  23.  
  24. df2 = pd.DataFrame(data=[1, 11, 111, 2, 22, 222, 3, 33, 333], columns=['D'])
  25. df2['D'] = df2['D'].map(mdict)
  26. df2
  27.  
  28. Out[3]:
  29. D
  30. 0 1
  31. 1 1
  32. 2 1
  33. 3 2
  34. 4 2
  35. 5 2
  36. 6 3
  37. 7 3
  38. 8 3
Add Comment
Please, Sign In to add comment