VBA vs Python

Sub SumData()
    Dim total As Double
    Dim lastRow As Long
    Dim i As Long

    lastRow = Cells(Rows.Count, 1).End(xlUp).Row
    total = 0

    For i = 2 To lastRow
        total = total + Cells(i, 2).Value
    Next i

    Cells(lastRow + 1, 2).Value = total
End Sub

import pandas as pd

df = pd.read_excel("data.xlsx")
total = df["売上"].sum()
print(f"合計: {total}")

Sub ProcessFiles()
    Dim folder As String, filename As String
    Dim wb As Workbook

    folder = "C:\data\"
    filename = Dir(folder & "*.xlsx")

    Do While filename <> ""
        Set wb = Workbooks.Open(folder & filename)
        ' 処理
        wb.Close False
        filename = Dir()
    Loop
End Sub

import os
import pandas as pd

folder = "data/"
for filename in os.listdir(folder):
    if filename.endswith(".xlsx"):
        df = pd.read_excel(os.path.join(folder, filename))
        # 処理