旧ms accessのmdbファイルを pandas_access for pythonで読む

以下の通りです

$ sudo yum install mdbtools-devel

#!/usr/local/bin/python3
# -*- coding: utf-8 -*-

import pandas_access as mdb

def main():
    mdb_file = 'my_access_db.mdb'

    for tbl in mdb.list_tables(mdb_file):
        disp_tbl_rows(mdb_file, tbl)

def disp_tbl_rows(mdb_file, tbl):
    df = mdb.read_table(mdb_file, tbl)
#    df = mdb.read_table(mdb_file, tbl, encoding='cp932')

    print( df )

    for index, row in df.iterrows():
        if "USER_BUSHO" in row:
            print( row["USER_BUSHO"] )
        
if __name__ == '__main__':
    main()