The application can correctly read the first line of the csv file but can not continue till the end and I continuously get this error (even if I try to set all my csv data in one line: Exception in thread 'main' java.io.IOException: Stream closedĪt java.io.BufferedReader.ensureOpen(Unknown Source)Īt java.io.BufferedReader.readLine(Unknown Source)Īt CSVConverter.main(CSVConverter.java:17)

JsonScript=jsonScript.substring(0,jsonScript.length()-2) String jsonScript='constant header of json content' Here is a portion of my code: BufferedReader csvFile= new BufferedReader(new FileReader('DataTextCsv.csv')) īufferedWriter jsonFile=new BufferedWriter(new FileWriter('converted.txt'))

I chose to simplify by using a classic method with BufferedReader and BufferedWriter. Step2: Now if I try to convert the JSON again to CSV, it's not getting converted in the same format as earlier: df = pd.read_csv('C://Users//DAMALI//Desktop/test.csv')ĭf.to_json('C://Users//DAMALI//Desktop/test1.I'm trying to create a Java application to convert Excel/csv file content to JSON format,Īs all my output json files have the same header. Step 1: Converted JSON to CSV using pandas: df = pd.read_json('C://Users//DAMALI//Desktop/test.json')ĭf.to_csv('C://Users//DAMALI//Desktop/test.csv') Now when I am again converting the CSV into JSON using pandas< the data is not getting displayed in the correct format. I created a CSV file by reading a JSON using pandas for reference. I am a tester and want to send some events to Event Hub for that I want to maintain a CSV file and update my records/data using the CSV file. I want to convert a CSV to a JSON format using pandas.

Convert csv to json