如何为 SAP 应用选择合适的 EC2

import pandas as pd
saps_table = pd.read_html(‘https://aws.amazon.com/cn/sap/instance-types/’)
import pandas as pd
saps_table = pd.read_html('https://aws.amazon.com/cn/sap/instance-types/')

new_table = saps_table[0]
old_table = saps_table[1]
new = new_table[['Instance Type', 'vCPU', 'Mem (GiB)', 'SAPS']]
old = old_table[['Instance Type', 'vCPU', 'Mem (GiB)', 'SAPS']]
ec2_saps = pd.concat([new, old])
ec2_saps.replace({'\*': ''}, regex=True, inplace=True)
ec2_saps['vCPU'] = pd.to_numeric(
    ec2_saps['vCPU'], downcast='integer', errors='coerce')
ec2_saps['Mem (GiB)'] = pd.to_numeric(
    ec2_saps['Mem (GiB)'], downcast='float', errors='coerce')
ec2_saps['SAPS'] = pd.to_numeric(
    ec2_saps['SAPS'], downcast='float', errors='coerce')

ec2_saps.to_excel('ec2_saps.xlsx', index=False) 

import pandas as pd
source = "blog3_output.xlsx"
sheet = 0
target = pd.ExcelWriter('result.xlsx')
for i in range(1, 6):
    sheet = i
    ex1 = pd.read_excel(source)
    ex2 = pd.read_excel("ec2_saps.xlsx")
    merge = ex1.merge(ex2, left_on="type",
                      right_on="Instance Type", how='left')
    merge.drop(['Instance Type', 'vCPU', 'Mem (GiB)'], axis=1, inplace=True)
    merge.rename(columns={'SAPS': 'source_saps'}, inplace=True)
    merge = merge.merge(ex2, left_on="target_type",
                        right_on="Instance Type", how='left')
    merge.drop(['Instance Type', 'vCPU', 'Mem (GiB)'], axis=1, inplace=True)
    merge.rename(columns={'SAPS': 'target_saps'}, inplace=True)

    merge.to_excel(target, sheet_name=str(sheet), index=False)
target.save()