图中的两个表,我不知道该怎么合并,我需要将表二的内容添加到表一中,并把表一中的technical列删除
import pandas as pd
df1 = pd.DataFrame({'Technical efficiency [gCO2/t·nm]': ['EEDI(12)','EVI(1)'],'art':[1,2]})
df1
eff = df1['Technical efficiency [gCO2/t·nm]'].str.split('(',expand=True)
eff.columns = ['Technical Efficiency Index','Technical Efficiency Value']
eff['Technical Efficiency Value'] = eff['Technical Efficiency Value'].str.rstrip(')')
eff