Convert the DataFrame to a dictionary.

The type of the key-value pairs can be customized with the parameters (see below).

param orient
str {‘dict’, ‘list’, ‘series’, ‘split’, ‘records’, ‘index’}

Determines the type of the values of the dictionary.

  • ‘dict’ (default) : dict like {column -> {index -> value}}

  • ‘list’ : dict like {column -> [values]}

  • ‘series’ : dict like {column -> Series(values)}

  • ‘split’dict like

    {‘index’ -> [index], ‘columns’ -> [columns], ‘data’ -> [values]}

  • ‘records’list like

    [{column -> value}, … , {column -> value}]

  • ‘index’ : dict like {index -> {column -> value}}

Abbreviations are allowed. s indicates series and sp indicates split.

param into
class, default dict

The subclass used for all Mappings in the return value. Can be the actual class or an empty instance of the mapping type you want. If you want a collections.defaultdict, you must pass it initialized.

New in version 0.21.0.


dict, list or Return a object representing the DataFrame. The resulting transformation depends on the orient parameter.


This feature is currently unsupported by Intel Scalable Dataframe Compiler