TypeError: Object of type ‘DataFrame’ is not JSON serializable

Your df is still a data frame because you haven’t assigned it as json.

   df = df.to_json()

This should work. Let me know if not.