dataframe转换成list

import pandas as pd

# 创建一个示例 DataFrame
data = {
    'Name': ['Alice', 'Bob', 'Charlie'],
    'Age': [25, 30, 35],
    'City': ['New York', 'Los Angeles', 'Chicago']
}
df = pd.DataFrame(data)

# 将 DataFrame 转换成 List of Dictionaries
list_of_dicts = df.to_dict(orient='records')
print(list_of_dicts)

[
    {'Name': 'Alice', 'Age': 25, 'City': 'New York'},
    {'Name': 'Bob', 'Age': 30, 'City': 'Los Angeles'},
    {'Name': 'Charlie', 'Age': 35, 'City': 'Chicago'}
]

# 将 'Name' 列转换成 List
names_list = df['Name'].tolist()
print(names_list)

['Alice', 'Bob', 'Charlie']

# 将所有列分别转换成 List
lists_of_columns = df.values.tolist()
print(lists_of_columns)

[
    ['Alice', 25, 'New York'],
    ['Bob', 30, 'Los Angeles'],
    ['Charlie', 35, 'Chicago']
]

# 去除包含 NaN 的行
df_cleaned = df.dropna()
list_of_dicts_cleaned = df_cleaned.to_dict(orient='records')

# 使用不同的 orient 参数进行转换
list_of_records = df.to_dict(orient='records')
list_of_lists = df.values.tolist()
dict_of_columns = df.to_dict(orient='list')