0

I would like to create a new dataframe which query data from two dataframe. e.g. df1 has x,y, df2 has y,z, df3 will map y value to z, then create a x,z dataframe.

import pandas as pd

df1 = pd.DataFrame({
    "x": ["A","B","C"],
    "y": [10, 20, 30],
})

df2 = pd.DataFrame({
    "y": [20, 10, 40],
    "z": ["green", "blue", "green"],
})

print(df1)
print(df2)

expected output:

:    x   y
: 0  A  10
: 1  B  20
: 2  C  30
:     y      z
: 0  20  green
: 1  10   blue
: 2  40  green

:    x   z
: 0  A  blue
: 1  B  green
: 2  C  N/A
lucky1928
  • 8,708
  • 10
  • 43
  • 92

0 Answers0