How To Convert Table Data Into Json Format In Python

Today, we will discuss how to convert table data into JSON format using Python. JSON is a popular format for transmitting data between the client and server in web applications.

Converting table data into JSON format can make it easier to work with data and to share it with other applications. In this tutorial, we will use Python to convert table data into JSON format.

Step 1: Setup

Before we begin, make sure that Python is installed on your computer. You can download it from the official website. Once you have installed Python, open your text editor or IDE.

Step 2: Install the Required Packages

We will be using the pandas library to read data from a table file and convert it into JSON format. You can install it using pip by running the following command in your terminal:

1
pip install pandas

Step 3: Read Input Data

We will first read the data from a table file using the pandas library. In this example, we will use a CSV file as the input data.

1
2
3
4
import pandas as pd
 
data = pd.read_csv("input.csv")
print(data.head())

Step 4: Convert Data to JSON Format

Now that we have read the input data, we can use the pandas library to convert it to JSON format. We will use the to_json() method to convert the data to JSON format.

1
2
3
4
5
import pandas as pd
 
data = pd.read_csv("input.csv")
data_json = data.to_json(orient='records')
print(data_json)

Step 5: Write Output Data

Finally, we can write the output data to a JSON file. In this example, we will write the output data to a file called “output.json”.

1
2
3
4
5
6
import pandas as pd
 
data = pd.read_csv("input.csv")
data_json = data.to_json(orient='records')
with open("output.json", "w") as outfile:
    outfile.write(data_json)

Conclusion

That’s it! We have successfully converted table data into JSON format using Python. You can now use the output JSON file in your web applications or share it with other applications.

Here is the full code:

1
2
3
4
5
6
import pandas as pd
 
data = pd.read_csv("input.csv")
data_json = data.to_json(orient='records')
with open("output.json", "w") as outfile:
    outfile.write(data_json)

And here is the output data:

[{"Name":"John","Age":28,"City":"New York"},{"Name":"Mary","Age":25,"City":"Los Angeles"},{"Name":"Peter","Age":32,"City":"Chicago"},{"Name":"Jane","Age":45,"City":"Houston"}]