How to convert and save dataframe to json string, json file, json array using pandas and python in a jupyter notebook.
Timestamps
0:00 - Introduction - convert dataframe to json python
1:05 - How to convert dataframe to json string array using pandas
1:41 - Types of orientation for dataframe to json
2:22 - Default orientation is columns for dataframe to json with pandas
3:18 - How to use Different orientations for dataframe to json with pandas
6:26 - 2 decimal place float when converting dataframe to json
7:11 - Convert dataframe to json without index
8:25 - How to add indentation to json data
10:17 - Convert and Save dataframe to json output file on your local computer using pandas
12:32 - Convert json back to pandas dataframe using pandas
15:53 - How to compress the output of dataframe to json into a zipped folder
18:10 - Recap of what we covered today
18:32 - Get the code used in this video and support this channel
Visit me online at
Get access to notebook used in this video along with FREE Software engineering and Data science resources -
Support my work directly -
Follow me on twitter -
Contact me -
Content suggestions -
Documentation link -
Join to get Help with Any Data Science Project and/or Simply say "Thank you" to me: