从列表中获取值并从中生成列名

data = [
    {"name": "Alice", "age": 25, "gender": "Female"},
    {"name": "Bob", "age": 30, "gender": "Male"},
    {"name": "Charlie", "age": 35, "gender": "Male"}
]

# 获取列名
column_names = list(data[0].keys())

# 获取值并生成列名
result = []
result.append(column_names)  # 将列名作为第一行数据
for row in data:
    row_values = list(row.values())
    result.append(row_values)

print(result)

[['name', 'age', 'gender'],
 ['Alice', 25, 'Female'],
 ['Bob', 30, 'Male'],
 ['Charlie', 35, 'Male']]