csv合并某几列
csv合并某几列
package com.vfsd; import java.io.IOException; import java.nio.charset.Charset; import java.util.ArrayList; import java.util.HashMap; import java.util.Iterator; import java.util.List; import java.util.Map; import java.util.Set; import com.csvreader.CsvReader; import com.csvreader.CsvWriter; public class MergeCSVColsAndOut { public static void main(String[] args) throws IOException { String inputCsvFileName1 = "F:\\PythonProject\\DoWhy_Project\\dowhy_202204\\data\\week_1.csv"; //String inputCsvFileName2 = "F:\\PythonProject\\DoWhy_Project\\dowhy_202204\\data\\week_75_6.csv"; String outputCsvFileName = "F:\\PythonProject\\DoWhy_Project\\dowhy_202204\\data\\week1\\week1_90.csv"; //String outputCsvFileName = "F:\\PythonProject\\DoWhy_Project\\dowhy_202204\\data\\week_1_13.csv"; readCSVAndWrite(inputCsvFileName1,outputCsvFileName); } /** * 读取CSV文件内容 * @param csvFileName * @throws IOException */ public static void readCSVAndWrite( String inputCsvFileName1, String outputCsvFileName) throws IOException{ try { // 创建CSV读对象 CsvReader csvReader1 = new CsvReader(inputCsvFileName1); //CsvReader csvReader2 = new CsvReader(inputCsvFileName2); // 读表头 csvReader1.readHeaders(); //csvReader2.readHeaders(); CsvWriter csvWriter1 = new CsvWriter(outputCsvFileName,',', Charset.forName("UTF-8")); String[] headers1 = {"id","XW1","XW2","XW3","XW4","XW5","XW6","XW7","XW8","GXW1"}; String[] headers2 = {"GXW1","GXW2","GXW3","GXW4","GXW5","GXW6","GXW7","GXW8","GXW9","GXW10","GXW11","GXW12","GXW13"}; csvWriter1.writeRecord(headers1); //csvReader1.readRecord(); int n=1; while (csvReader1.readRecord()){ //System.out.println(csvReader1.getRawRecord()); //System.out.println(csvReader1.getRawRecord()); //for(int k=0;k<list_headers.size();k++) { // String indexHeader = list_headers.get(k); // String cell_value_str = csvReader.get(indexHeader); // cell_value = cell_value+Double.parseDouble(cell_value_str); //} String[] content2 = new String[headers1.length]; content2[0] = n+""; for(int k=1;k<headers1.length-1;k++) { String indexHeader = headers1[k]; String cell1_value_str = csvReader1.get(indexHeader); content2[k] = cell1_value_str; } double col1_13 = 0.0; for(int k=0;k<headers2.length;k++) { String indexHeader = headers2[k]; String cell1_value_str = csvReader1.get(indexHeader); col1_13 = col1_13+Double.parseDouble(cell1_value_str); } double avg9_13 = col1_13/13; content2[headers1.length-1] = avg9_13+""; csvWriter1.writeRecord(content2); // 读一整行 //System.out.println(csvReader.getRawRecord()); // 读这行的某一列 //System.out.println(csvReader.get("A")+"\t"+csvReader.get("B")+"\t"+csvReader.get("C")); n++; } csvWriter1.flush(); csvWriter1.close(); csvReader1.close(); } catch (IOException e) { e.printStackTrace(); }finally { System.out.println("finish..."); } } }
########################
QQ 3087438119