Python - 在 Pandas 中使用其他 DataFrame 的值替换 DataFrame 的值
要使用其他 DataFrame 的值替换 DataFrame 的值,请在 Pandas 中使用 replace() 方法。
首先,让我们先创建一个 DataFrame -
dataFrame1 = pd.DataFrame({"Car": ["Audi", "Lamborghini"], "Place": ["US", "UK"], "Units": [200, 500]})
让我们创建一个另一个 DataFrame -
dataFrame2 = pd.DataFrame({"Car": ["BMW", "Lexus"], "Place": ["India", "Australia"], "Units": [800, 1000]})
接下来,从 DataFrame2 获取一个值并用 DataFrame1 中的一个值替换 -
# get value from 2nd DataFrame i = dataFrame2['Car'][1] # replacing with a value from the 1st DataFrame j = dataFrame1['Car'][0]
最后,使用 replace() 方法用另一个 DataFrame 的值替换一个 DataFrame 的值 -
dataFrame2 = dataFrame2.replace(i, j)
示例
以下是代码 -
import pandas as pd dataFrame1 = pd.DataFrame({"Car": ["Audi", "Lamborghini"],"Place": ["US", "UK"], "Units": [200, 500]}) print("Dataframe 1...") print(dataFrame1) dataFrame2 = pd.DataFrame({"Car": ["BMW", "Lexus"],"Place": ["India", "Australia"], "Units": [800, 1000]}) print("\nDataframe 2...") print(dataFrame2) ## Get a value from DataFrame2 ## and replace with a value ## from DataFrame1 # getting value from 2nd DataFrame i = dataFrame2['Car'][1] # replacing with a value from the 1st DataFrame j = dataFrame1['Car'][0] # replace values of one DataFrame # with the value of another DataFrame dataFrame2 = dataFrame2.replace(i, j) # Display the updated DataFrame print("\nUpdated Dataframe 2...") print(dataFrame2)
输出
这将产生以下输出 -
Dataframe 1... Car Place Units 0 Audi US 200 1 Lamborghini UK 500 Dataframe 2... Car Place Units 0 BMW India 800 1 Lexus Australia 1000 Updated Dataframe 2... Car Place Units 0 BMW India 800 1 Audi Australia 1000
广告