我的数据框号为1
价格物
0 1笔
1 2铅笔
2 6苹果
我有DataFrame 2:
价格物
0 5笔
1 6支铅笔
2 10杯
我想加入两个DataFrame,我想看一下这个DataFrame:
DataFrame 1号DatFRame 2号
价格物
0 6笔
1 8支铅笔
2 6苹果
3 10杯
我怎样才能做到这一点?
这段代码:
import pandas as pd
df = pd.DataFrame({'Things': ['pen', 'pencil'], 'Price': [1, 2]})
series = pd.Series([1,2], index=[0,1])
df["Price"] = series
df.loc[2] = [6, "apple"]
print("DataFrame number 1")
print(df)
df2 = pd.DataFrame({'Things': ['pen', 'pencil'], 'Price': [1, 2]})
series = pd.Series([5,6], index=[0,1])
df2["Price"] = series
df2.loc[2] = [10, "cup"]
print("DataFrame number 2")
print(df2)