Simple script to verify airdrop

verify_creeps_airdrop.py

import json
import pandas as pd
from web3 import Web3

AVAX_NODE = "https://api.avax.network/ext/bc/C/rpc"
SMOL_CREEPS_ADDRESS = "0x2cd4dbcbfc005f8096c22579585fb91097d8d259"
provider = Web3(Web3.HTTPProvider(AVAX_NODE))

with open("abi.json", "r") as f:
    abi = json.load(f)

creeps_contract = provider.eth.contract(
    address=Web3.toChecksumAddress(SMOL_CREEPS_ADDRESS), abi=abi
)

balanceOf = creeps_contract.functions.balanceOf

wl = pd.read_excel("smol_creeps_wl.xlsx")

for i, row in wl.iterrows():
    address = Web3.toChecksumAddress(row["Address"])
    expected_amount = row["Amount"]
    actual_amount = balanceOf(address).call()
    if actual_amount != expected_amount:
        print(
            "{} expected {} but received {}".format(
                address, expected_amount, actual_amount
            )
        )