我从SQL查询中获得以下DataFrame:
(Pdb) pp total_rows ColumnID RespondentCount 0 -1 2 1 3030096843 1 2 3030096845 1
我想像这样旋转它:
total_data = total_rows.pivot_table(cols=['ColumnID']) (Pdb) pp total_data ColumnID -1 3030096843 3030096845 RespondentCount 2 1 1 [1 rows x 3 columns] total_rows.pivot_table(cols=['ColumnID']).to_dict('records')[0] {3030096843: 1, 3030096845: 1, -1: 2}
但是我想确保303列被强制转换为字符串而不是整数,以便得到:
{'3030096843': 1, '3030096845': 1, -1: 2}