Convert CSV Data to JSON Using the pandas Python Package

30 minutes
  • 3 Learning Objectives

About this Hands-on Lab

In this lab, we will load a CSV file into a pandas DataFrame. After confirming the data was successfully loaded, we will write the data to a JSON-formatted file.

Basic Python programming skills will be required for this lab. If you need a refresher, check out the following course:
– [Certified Associate in Python Programming Certification](

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Load the CSV File

Load the provided CSV file (data.csv) into a pandas DataFrame object.

Confirm the Data

Confirm the data was loaded by viewing general information about the data and checking the first 10 rows.

Write a JSON File

Finally, write the data to a JSON-formatted file.

Additional Resources

The Scenario

You are working as a database admin when one of the web developers emails you about converting a CSV file to JSON. "Why are you asking me and not whoever sent you the CSV file?" you ask. "Your title has data in it?" is the reply. Sigh.

Thankfully, you've been watching this awesome ACG course on data preparation with Python — so you agree to help him out! To do this, you will need to complete the following 3 steps:

  • Load the CSV file.
  • Confirm the data.
  • Write a JSON file.

Log in to the server over SSH using the credentials provided.

The data.csv file will already be available in the lab instance, but if you'd like to follow along on your own machine, you can download it from here.

The data was sourced from the Center for Machine Learning and Intelligent Systems. Learn more here.

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?