Question

*q3: Write a public static method named q3 that takes no parameters and has return type void. In this method, you may assume there is a file named "properties.csv" with lines in the format "name, opposed, pure,glad" where "name" is a String and all other values are well-formed integers. There is no header line in this file. This method will create a new * file named "output.csv" in the format "name, pure" containing only these two columns from "properties.csv" and only for lines with a name of "refuse", "being", "poll", or "essential"

Answer 1

Please find the below implemented public static void q3() method. Also find the ProcessCSVFile class with q3 and main method to test the functionality of the q3 method.

Please find the below input dummy properties.csv and generated output.csv file by q3 method.

Please revert back in case anything else needs to do.

****** q3 method ******

public static void q3() {
Scanner sacnnerReader = null;
BufferedWriter bufferedWriter = null;
FileWriter fileWriter = null;
try {
File file = new File("properties.csv");
if (file.exists()) {
// creating File Writer to write CSV file
fileWriter = new FileWriter("output.csv");
// creating Buffered Writer to write CSV file
bufferedWriter = new BufferedWriter(fileWriter);
// creating sacnner Reader to read CSV file
sacnnerReader = new Scanner(file);
while (sacnnerReader.hasNextLine()) {
String line = sacnnerReader.nextLine();
String lineArray[] = line.split(",");
String name = lineArray[0];
int pure = Integer.parseInt(lineArray[2]);
if (name != null && (name.equals("refuse") || name.equals("being") ||
name.equals("poll") || name.equals("essential"))) {
bufferedWriter.write(name+","+pure);
bufferedWriter.newLine();
}
}
bufferedWriter.flush();
} else {
System.out.println("Input File not found");
}
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (sacnnerReader != null) {
sacnnerReader.close();
}
if (bufferedWriter != null) {
bufferedWriter.close();
}
if (fileWriter != null) {
fileWriter.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
}

****** ProcessCSVFile Class ********

import java.io.BufferedWriter;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileWriter;
import java.io.IOException;
import java.util.Scanner;
public class ProcessCSVFile {
public static void main(String[] args) {
q3();
}
public static void q3() {
Scanner sacnnerReader = null;
BufferedWriter bufferedWriter = null;
FileWriter fileWriter = null;
try {
File file = new File("properties.csv");
if (file.exists()) {
// creating File Writer to write CSV file
fileWriter = new FileWriter("output.csv");
// creating Buffered Writer to write CSV file
bufferedWriter = new BufferedWriter(fileWriter);
// creating sacnner Reader to read CSV file
sacnnerReader = new Scanner(file);
while (sacnnerReader.hasNextLine()) {
String line = sacnnerReader.nextLine();
String lineArray[] = line.split(",");
String name = lineArray[0];
int pure = Integer.parseInt(lineArray[2]);
if (name != null && (name.equals("refuse") || name.equals("being") ||
name.equals("poll") || name.equals("essential"))) {
bufferedWriter.write(name+","+pure);
bufferedWriter.newLine();
}
}
bufferedWriter.flush();
} else {
System.out.println("Input File not found");
}
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (sacnnerReader != null) {
sacnnerReader.close();
}
if (bufferedWriter != null) {
bufferedWriter.close();
}
if (fileWriter != null) {
fileWriter.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
}

****** properties.csv ******

***** output.csv *******