Converting a pandas DataFrame to a JSON object is straight-forward:
orient parameter controls how the data is formatted.
index worked well for my use cases so far.
The other conversion direction is very similar:
If you receive your JSON as a string in Python (e.g. through a request from an API), you must first convert the string into a JSON object for the above call to work: