Read CSV and Convert to JSON in Python

Today in this article, we will see how to Read CSV and Convert to JSON using Python. Then we will see how to convert a CSV to JSON so that it becomes consumable by API or different other applications.

Today in this article, we will cover below aspects,

Today we shall see how to use Pandas library for performing simple read and write.

Getting started

Please create Python application.

Please install below pandas package,

pip3 install pandas

CSV to JSON array

Lets use simple CSV file example as below,

We shall read below file using Python and convert it to JSON array

 import pandas as pd
 df = pd.read_csv ("Input File path")
 df.to_json ("Out File path')

Thats all , above 3 liners are what you need to convert a CSV to json file.

Lets run the above logic and produce a result,

{
  "FirstName": {
    "0": "TEST1",
    "1": "TEST2",
    "2": "TEST3",
    "3": "TEST4"
  },
  "LastName": {
    "0": "Test2",
    "1": "Test3",
    "2": "Test4",
    "3": "Test5"
  },
  "Address": {
    "0": "USA",
    "1": "USA",
    "2": "USA",
    "3": "USA"
  }
}

You can pretty much control the output format using other overloaded methods using parameters like orient=’records’ as below example.

Sample Example

import pandas as pd
 df = pd.read_csv (r'C:\Users\source\repos\PythonApplication1\Address.csv')
 df.to_json (r'C:\Users\source\repos\PythonApplication1\Address.json', orient='records')

Output JSON for the above example as below,

[
  {
    "FirstName": "TEST1",
    "LastName": "Test2",
    "Address": "USA"
  },
  {
    "FirstName": "TEST2",
    "LastName": "Test3",
    "Address": "USA"
  },
  {
    "FirstName": "TEST3",
    "LastName": "Test4",
    "Address": "USA"
  },
  {
    "FirstName": "TEST4",
    "LastName": "Test5",
    "Address": "USA"
  }
]

References:

• Transform CSV to JSON using Google Data Flow

Do you have any comments or ideas or any better suggestions to share?

Please sound off your comments below.

Happy Coding !!

Please bookmark this page and share it with your friends. Please Subscribe to the blog to receive notifications on freshly published(2024) best practices and guidelines for software design and development.