Python字典到pandas的DataFrame转换

import pandas as pd

# 定义一个字典
data = {
    'Name': ['Alice', 'Bob', 'Charlie'],
    'Age': [24, 27, 22],
    'City': ['New York', 'Los Angeles', 'Chicago']
}

# 将字典转换为DataFrame
df = pd.DataFrame(data)

print(df)

      Name  Age         City
0    Alice   24     New York
1      Bob   27  Los Angeles
2  Charlie   22      Chicago

# 示例：长度不一致的字典
data_inconsistent = {
    'Name': ['Alice', 'Bob'],
    'Age': [24, 27, 22],
    'City': ['New York', 'Los Angeles']
}

# 解决方法：使用from_dict并设置orient='index'
df_inconsistent = pd.DataFrame.from_dict(data_inconsistent, orient='index').T
print(df_inconsistent)

# 示例：包含缺失值的字典
data_with_nan = {
    'Name': ['Alice', None, 'Charlie'],
    'Age': [24, 27, None],
    'City': ['New York', 'Los Angeles', 'Chicago']
}

df_with_nan = pd.DataFrame(data_with_nan)
df_with_nan_filled = df_with_nan.fillna('Unknown')
print(df_with_nan_filled)