-  
-   Notifications  You must be signed in to change notification settings 
- Fork 19.2k
Closed
Labels
IO JSONread_json, to_json, json_normalizeread_json, to_json, json_normalizePerformanceMemory or execution speed performanceMemory or execution speed performance
Milestone
Description
xref #9027
So to_json first converts all the a DataFrame by using .values. This converts everything to object dtype (if its a mixed frame) and is pretty expensive perf wise.
If you do this column by column you get excellent perf (and tiny bit more complexity in the code).
Metadata
Metadata
Assignees
Labels
IO JSONread_json, to_json, json_normalizeread_json, to_json, json_normalizePerformanceMemory or execution speed performanceMemory or execution speed performance