PandasのDataFrameを使ってCSVファイルから特定の行をルックアップするサンプル

lookup.py

import sys
import pandas as pd

def main(name):
    df = pd.read_csv('./sample.csv', header=0)
    filtered = df[df['token'] == name]
    if len(filtered.index) > 0:
        value = filtered.loc[filtered.index[0]]['normalized']
        print(value)
    else:
        print('Not Found. NAME: ' + name)

if __name__ == '__main__':
    if len(sys.argv) > 1:
        main(sys.argv[1])
    else:
        print('USAGE: python3 lookup.py NAME')

sample.csv