Guest User

Untitled

a guest
Jun 25th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. import pandas as pd
  2.  
  3. data = {"A":['a','b','c'], "B":[1,2,3], "C":[2,6,7]}
  4. data2 = {"A":['b','a','c'], "B":[0,1,9], "C":[2,2,27]}
  5.  
  6. df = pd.DataFrame(data)
  7. df2 = pd.DataFrame(data2)
  8.  
  9. # выбираем из df строки, которые есть в df2 (возможно с другим индексом)
  10. lf = {"A":df2["A"], "B":df2["B"], "C":df2["C"]}
  11. f = df[list(lf)].isin(lf).all(axis=1)
  12. df[f]
  13. # Результат:
  14. A B C
  15.  
  16. # должно быть:
  17. A B C
  18. 0 a 1 2
  19.  
  20. >>> data1 = {"A":['a','b','c','b'], "B":[1,2,3,0], "C":[2,6,7,2]}
  21. >>> data2 = {"A":['b','a','c'], "B":[0,1,9], "C":[2,2,27]}
  22. >>> df1 = pd.DataFrame(data1)
  23. >>> df2 = pd.DataFrame(data2)
  24. >>> pd.merge(df1, df2, how='inner')
  25. A B C
  26. 0 a 1 2
  27. 1 b 0 2
Add Comment
Please, Sign In to add comment