需求：将两列转换为字典形式

image.png

import pandas as pd
import json
from pathlib import Path


def excel_to_dict():
    #BASE_DIR = Path(__file__).resolve(strict=True).parent.parent

    print('path=', __file__)
    print('path=', Path(__file__).resolve(strict=True).parent)
    file_dir = Path(__file__).resolve(strict=True).parent
    # 
    df = pd.read_excel(file_dir / '航线映射表.xlsx', engine='openpyxl')
    
    data_dict =  {key:values for key, values in zip(df['键'], df['值'])}

    print(len(data_dict))

    with open(file_dir / 'test.json', 'w') as f:
        json.dump(data_dict, f)

结果：

image.png

更多学习笔记整理于微信公号【Python野路子】