Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- data = {"A":['a','b','c'], "B":[1,2,3], "C":[2,6,7]}
- data2 = {"A":['b','a','c'], "B":[0,1,9], "C":[2,2,27]}
- df = pd.DataFrame(data)
- df2 = pd.DataFrame(data2)
- # выбираем из df строки, которые есть в df2 (возможно с другим индексом)
- lf = {"A":df2["A"], "B":df2["B"], "C":df2["C"]}
- f = df[list(lf)].isin(lf).all(axis=1)
- df[f]
- # Результат:
- A B C
- # должно быть:
- A B C
- 0 a 1 2
- >>> data1 = {"A":['a','b','c','b'], "B":[1,2,3,0], "C":[2,6,7,2]}
- >>> data2 = {"A":['b','a','c'], "B":[0,1,9], "C":[2,2,27]}
- >>> df1 = pd.DataFrame(data1)
- >>> df2 = pd.DataFrame(data2)
- >>> pd.merge(df1, df2, how='inner')
- A B C
- 0 a 1 2
- 1 b 0 2
Add Comment
Please, Sign In to add comment