背景關系:我想創建一個帶有“變數:值”對的字典。該變數具有如下多重索引:
Sexo
Masculino Feminino
0 4245.0 4620.0
1 4274.0 4655.0
2 4304.5 4689.5
3 4322.0 4708.5
4 4318.0 4717.5
5 4288.0 4710.5
6 4247.5 4683.5
7 4224.5 4650.5
8 4223.5 4613.5
9 4191.0 4567.0
10 4133.7 4546.9
11 4093.6 4550.1
12 4079.0 4551.5
13 4070.5 4562.6
我正在使用字典理解創建字典:
dict_boxplot = {col:val for (col,val) in zip(subcolumns,df_var.iloc[:,1])}
哪里subcolumns只是“Masculino”和“Feminino”的名字。我用這種格式制作字典有多冷: {'Masculino': [value1,value2,value3...], 'Feminino': [value1,value2,value3...]} 其中value1,等是每列的值?
先感謝您!
uj5u.com熱心網友回復:
僅迭代列名,然后收集列并轉換為串列
x = {col: df[col].to_list() for col in ['Masculino', 'Feminino']}
或者DataFrame.to_dict用來幫助你
x = {k: list(column.values()) for k, column in df.to_dict().items()}
助手代碼
import pandas as pd
values = {'Masculino': [4245.0, 4274.0, 4304.5, 4322.0, 4318.0, 4288.0, 4247.5,
4224.5, 4223.5, 4191.0, 4133.7, 4093.6, 4079.0, 4070.5],
'Feminino': [4620.0, 4655.0, 4689.5, 4708.5, 4717.5, 4710.5, 4683.5,
4650.5, 4613.5, 4567.0, 4546.9, 4550.1, 4551.5, 4562.6]}
df = pd.DataFrame(values)
x = {col: df[col].to_list() for col in ['Masculino', 'Feminino']}
print(x) # {'Masculino': [4245.0, ..., 4070.5], 'Feminino': [4620.0, ..., 4562.6]}
x = {k: list(column.values()) for k, column in df.to_dict().items()}
print(x) # {'Masculino': [4245.0, ..., 4070.5], 'Feminino': [4620.0, ..., 4562.6]}
uj5u.com熱心網友回復:
只需使用: to_dict('list')
df.to_dict('list')
輸出:
{'Masculino': [4245.0, 4274.0, 4304.5, 4322.0, 4318.0, 4288.0, 4247.5, 4224.5, 4223.5, 4191.0, 4133.7, 4093.6, 4079.0, 4070.5],
'Feminino': [4620.0, 4655.0, 4689.5, 4708.5, 4717.5, 4710.5, 4683.5, 4650.5, 4613.5, 4567.0, 4546.9, 4550.1, 4551.5, 4562.6]
}
轉載請註明出處,本文鏈接:https://www.uj5u.com/houduan/402288.html
標籤:
上一篇:如何從相關串列中獲取列名?
下一篇:嘗試從熊貓資料框中洗掉重復項
