导出数据 - df. to_dict() - dict{}

数据

import numpy as np
import pandas as pd
df = pd.DataFrame(data=[{"A":"1", "B":"3", "C":"4"}, {"A":"1", "B":"2", "C":"5"}, {"A":"2", "B":"1", "C":"6"}])
df = pd.DataFrame(data=[{"A":1, "B":3, "C":4}, {"A":1, "B":2, "C":5}, {"A":2, "B":1, "C":6}])

使用方法df.to_dict()

参数：'dict' (默认) ，'list'，'series'，'split'，'records'，'index'

1、不传入参数，默认是’dict’ {‘a’:{},’b’:{},’c’:{}}

data = df.to_dict()  # 列标题作为外层dict键值，索引作为内层dict键值

{'A': {0: 1, 1: 1, 2: 2}, 'B': {0: 3, 1: 2, 2: 1}, 'C': {0: 4, 1: 5, 2: 6}}

2、’list’ {‘a’:[],’b’:[],’c’:[]}

data = df.to_dict('list')  # 列标题是外层键值，内层是list

{'A': [1, 1, 2], 'B': [3, 2, 1], 'C': [4, 5, 6]}

3、’split’

data = df.to_dict('split')  # 将列标题，索引，数据分开

{'index': [0, 1, 2], 'columns': ['A', 'B', 'C'], 'data': [[1, 3, 4], [1, 2, 5], [2, 1, 6]]}

4、’records’ [{}{}{}{}]

data = df.to_dict('records')  # 外层列表，内层是列标题为键值的列表

[{'A': 1, 'B': 3, 'C': 4}, {'A': 1, 'B': 2, 'C': 5}, {'A': 2, 'B': 1, 'C': 6}]

5、’index’ {0:{},1:{},2:{},3:{},}

data = df.to_dict('index')  # 与参数1相反：索引作为外层dict键值，列标题作为内层dict键值

{0: {'A': 1, 'B': 3, 'C': 4}, 1: {'A': 1, 'B': 2, 'C': 5}, 2: {'A': 2, 'B': 1, 'C': 6}}