对字典元组键值拆分数据帧/字典

import pandas as pd

# 假设我们有以下字典
data = {
    'A': (1, 'foo'),
    'B': (2, 'bar'),
    'C': (3, 'baz')
}

# 将字典转换为数据帧
df = pd.DataFrame.from_dict(data, orient='index')

# 拆分元组为两列
df[['Value1', 'Value2']] = df.iloc[:, 0].apply(pd.Series)

# 删除原始的元组列
df = df.drop(df.columns[0], axis=1)

print(df)

# 检查元组长度
max_length = max(len(tup) for tup in data.values())

# 填充缺失值
for key, tup in data.items():
    if len(tup) < max_length:
        data[key] += (None,) * (max_length - len(tup))

# 重新创建数据帧
df = pd.DataFrame.from_dict(data, orient='index')

# 拆分元组为多列
for i in range(max_length):
    df[f'Value{i+1}'] = df.iloc[:, 0].apply(lambda x: x[i])

# 删除原始的元组列
df = df.drop(df.columns[0], axis=1)

print(df)

# 使用rename方法重命名列
df.rename(columns={'Value1': 'Key', 'Value2': 'Value'}, inplace=True)

print(df)