Java CSVFormat类代码示例

import org.apache.commons.csv.CSVFormat; //导入依赖的package包/类
public static String exportMetaDataToCSV(List<StandaloneArgument> arguments)
        throws IOException
{
    StringWriter sw = new StringWriter();
    CSVPrinter csvPrinter = new CSVPrinter(sw, CSVFormat.DEFAULT.withHeader(
            "id", "author", "annotatedStance", "timestamp", "debateMetaData.title",
            "debateMetaData.description", "debateMetaData.url"
    ));

    for (StandaloneArgument argument : arguments) {
        csvPrinter.printRecord(
                argument.getId(),
                argument.getAuthor(),
                argument.getAnnotatedStance(),
                argument.getTimestamp(),
                argument.getDebateMetaData().getTitle(),
                argument.getDebateMetaData().getDescription(),
                argument.getDebateMetaData().getUrl()
        );
    }

    sw.flush();

    return sw.toString();
}
 

import org.apache.commons.csv.CSVFormat; //导入依赖的package包/类
private HashMap<String, Map<String, String>> parseHintFile(Integer exercise, Integer exercise_order)  {

		final HashMap<String, Map<String, String>> list;
		final CSVParser parser;
		final URL resource;
		final CSVFormat csvFormat;
		final Charset charset;
		list = new HashMap<String, Map<String, String>>  ();
		try {
			resource = ResourceHelper.getResource(BuenOjoFileUtils.GAME_RESOURCES_INPUT_DIR ,this.gamePath,this.setPath,exercise.toString(),exercise_order.toString(),"xy_pista.csv");
			charset= FileEncodingDetectorHelper.guessEncodingAndGetCharset(resource);
			csvFormat = CSVFormatHelper.getDefaultCSVFormat();
			parser = CSVParser.parse(resource, charset, csvFormat);
			for (CSVRecord record : parser )
				list.put(record.get("id").trim() , (Map<String, String>)record.toMap());
		}
		catch (IOException e) {
			log.error("Fail",e);
		}
		return list;
		
	}
 

import org.apache.commons.csv.CSVFormat; //导入依赖的package包/类
@Override
public void write(String outputFilePath) throws Exception{            
   try(Writer out = new BufferedWriter(new FileWriter(outputFilePath));
           CSVPrinter csvPrinter = new CSVPrinter(out, CSVFormat.RFC4180)) {
        
        if(this.getHeaders() != null){
            csvPrinter.printRecord(this.getHeaders());
        }
        
        Iterator<CSVRecord> recordIter = this.getCSVParser().iterator();
        while(recordIter.hasNext()){
            CSVRecord record = recordIter.next();
            csvPrinter.printRecord(record);
        }
        
        csvPrinter.flush();
            
   }catch(Exception e){
        throw e;
   }
}
 

import org.apache.commons.csv.CSVFormat; //导入依赖的package包/类
private ArrayList<Map<String, String>> parse()  {
	final ArrayList<Map<String, String>> list;
	final CSVParser parser;
	final URL resource;
	final CSVFormat csvFormat;
	final Charset charset;
	list = new ArrayList<Map<String, String>> ();
	try {
		resource = ResourceHelper.getResource(isFromGameResourceInput(),fileName);
		charset= FileEncodingDetectorHelper.guessEncodingAndGetCharset(resource);
		csvFormat = CSVFormatHelper.getDefaultCSVFormat();
		parser = CSVParser.parse(resource, charset, csvFormat);
		for (CSVRecord record : parser )
			list.add((Map<String, String>)record.toMap());
	}
	catch (IOException e) {
		log.error("Fail", e);
	}
	return list;
	
}
 

import org.apache.commons.csv.CSVFormat; //导入依赖的package包/类
private void logResults() {
	logger.info("Action frequency distribution:\n" + FrequencyUtils.formatFrequency(actionDistribution));
	logger.info("Action frequency distribution of rollback-reverted revisions:\n" + FrequencyUtils.formatFrequency(rollbackRevertedActionDistribution));
	logger.info("Action frequency distribution of non-rollback-reverted revisions:\n" + FrequencyUtils.formatFrequency(nonRollbackRevertedActionDistribution));
	
	try {
		Writer writer = new PrintWriter(path, "UTF-8");
		CSVPrinter csvWriter = CSVFormat.RFC4180.withQuoteMode(QuoteMode.ALL)
				.withHeader("month", "action", "count").print(writer);
		
		for (Entry<String, HashMap<String, Integer>> entry: getSortedList(monthlyActionDistribution)) {
			String month = entry.getKey();
			
			for (Entry<String, Integer> entry2: getSortedList2(entry.getValue())) {
				String action = entry2.getKey();
				Integer value = entry2.getValue();

				csvWriter.printRecord(month, action, value);
			}
		}
		csvWriter.close();
	} catch (IOException e) {
		logger.error("", e);
	}
}
 

import org.apache.commons.csv.CSVFormat; //导入依赖的package包/类
private ArrayList<Map<String,String>> parse()  {

		ArrayList<Map<String,String>> list;
		CSVParser parser;
		URL resource;
		CSVFormat csvFormat;
		Charset charset;
		list = new ArrayList<Map<String,String>> ();
		try {
			resource = ResourceHelper.getResource(isFromGameResourceInput(),fileName);
			charset= FileEncodingDetectorHelper.guessEncodingAndGetCharset(resource);
			csvFormat = CSVFormatHelper.getDefaultCSVFormat();
			parser = CSVParser.parse(resource, charset, csvFormat);
			for (CSVRecord record : parser )
				list.add(record.toMap());
		}
		catch (IOException e) {
			log.error("Fail", e);
		}
		return list;
		
	}
 

import org.apache.commons.csv.CSVFormat; //导入依赖的package包/类
private  Map<String,String> parseDelimitedAreaFile(Integer exercise, Integer exercise_order)  {

		Map<String,String> list;
		CSVParser parser;
		URL resource;
		CSVFormat csvFormat;
		Charset charset;
		list = new HashMap<String,String>();
		try {
			
			resource =ResourceHelper.getResource(isFromGameResourceInput(),this.gamePath,this.setPath,exercise.toString(), exercise_order.toString(),"areaDelimitada.csv");
			charset= FileEncodingDetectorHelper.guessEncodingAndGetCharset(resource);
								
			csvFormat = CSVFormatHelper.getDefaultCSVFormat();
			parser = CSVParser.parse(resource, charset, csvFormat);
			for (CSVRecord record : parser )
				list = record.toMap();
		}
		catch (IOException e) {
			log.error("Fail",e);
		}
		return list;
		
	}
 

import org.apache.commons.csv.CSVFormat; //导入依赖的package包/类
public List<Map<String,String>> parse() throws BuenOjoCSVParserException {
	List<Map<String,String>> list = new ArrayList<>();
	CSVParser parser = null;
	try {
		parser = CSVFormat.RFC4180.withHeader()
								.withDelimiter(',')
								.withAllowMissingColumnNames(true)
								.parse(new InputStreamReader(this.inputStreamSource.getInputStream()));
	} catch (IOException e) {
		throw new BuenOjoCSVParserException(e.getMessage());
	}
	
	for (CSVRecord record :parser) {
		Map<String,String> map = record.toMap();
		list.add(map);
	}
	
	return list;
	
}
 

import org.apache.commons.csv.CSVFormat; //导入依赖的package包/类
public List<PhotoLocationSightPair> parse () throws IOException, BuenOjoCSVParserException {
	CSVParser parser =  CSVFormat.RFC4180.withHeader().withDelimiter(',').withAllowMissingColumnNames(true).parse(new InputStreamReader(this.inputStreamSource.getInputStream()));
	
	
	List<CSVRecord> records = parser.getRecords();
	if (records.size() == 0 ) {
		throw new BuenOjoCSVParserException("El archivos de miras no contiene registros");
	}
	ArrayList<PhotoLocationSightPair> sightPairs = new ArrayList<>(records.size());
	for (CSVRecord record : records) {
		
		PhotoLocationSightPair sight = new PhotoLocationSightPair();
		sight.setNumber(new Integer(record.get(PhotoLocationSightPairCSVColumn.id)));
		sight.setSatelliteX(new Integer(record.get(PhotoLocationSightPairCSVColumn.satCol)));
		sight.setSatelliteY(new Integer(record.get(PhotoLocationSightPairCSVColumn.satRow)));
		sight.setSatelliteTolerance(new Integer(record.get(PhotoLocationSightPairCSVColumn.satTolerancia)));
		sight.setTerrainX(new Integer(record.get(PhotoLocationSightPairCSVColumn.terCol)));
		sight.setTerrainY(new Integer(record.get(PhotoLocationSightPairCSVColumn.terRow)));
		sight.setTerrainTolerance(new Integer(record.get(PhotoLocationSightPairCSVColumn.terTolerancia)));
		
		sightPairs.add(sight);
		
	}
	return sightPairs;
}
 

import org.apache.commons.csv.CSVFormat; //导入依赖的package包/类
public List<TagPair> parse() throws IOException {
	
	CSVParser parser = CSVFormat.RFC4180.withHeader().withDelimiter(',').withAllowMissingColumnNames(true).parse(new InputStreamReader(this.inputStreamSource.getInputStream()));
	
	
	ArrayList<TagPair> tagPairs = new ArrayList<>(AVG_ITEMS);
	for (CSVRecord record : parser ){
		
		TagPair pair = new TagPair();
		Integer tagSlotId = new Integer(record.get("id"));
		Integer tagNumber = new Integer(record.get("etiqueta"));
		
		pair.setTagSlotId(tagSlotId);
		Optional<Tag> optionalTag = tagList.stream().filter(isEqualToTagNumber(tagNumber)).findFirst();
		if (optionalTag.isPresent()){
			Tag tag = optionalTag.get(); 
			pair.setTag(tag);
			tagPairs.add(pair);			
		}else {
			log.debug("Attempt to get invalid tag with number: "+tagNumber);
		}
	}
	
	return tagPairs;
}
 

import org.apache.commons.csv.CSVFormat; //导入依赖的package包/类
public PhotoLocationBeacon parse() throws IOException, BuenOjoCSVParserException {
	
	CSVParser parser =  CSVFormat.RFC4180.withHeader().withDelimiter(',').withAllowMissingColumnNames(true).parse(new InputStreamReader(this.inputStreamSource.getInputStream()));
	List<CSVRecord> records = parser.getRecords();
	if (records.size() > 1) {
		throw new BuenOjoCSVParserException("El archivo contiene más de un indicador");
	}
	if (records.size() == 0) {
		throw new BuenOjoCSVParserException("El archivo de indicador es inválido");
	}
	
	CSVRecord record = records.get(0);
	PhotoLocationBeacon beacon = new PhotoLocationBeacon();
	beacon.setX(new Integer(record.get(PhotoLocationBeaconCSVColumns.col.ordinal())));
	beacon.setY(new Integer(record.get(PhotoLocationBeaconCSVColumns.row.ordinal())));
	beacon.setTolerance(new Integer(record.get(PhotoLocationBeaconCSVColumns.tolerance.ordinal())));
	
	return beacon;
}
 

import org.apache.commons.csv.CSVFormat; //导入依赖的package包/类
public List<TagCircle> parse() throws IOException, BuenOjoCSVParserException {

		ArrayList<TagCircle> list = new ArrayList<>(MAX_CIRCLES);

		CSVParser parser = CSVFormat.RFC4180.withHeader().withDelimiter(',').withAllowMissingColumnNames(false).parse(new InputStreamReader(this.inputStream));
		
		for (CSVRecord record : parser ){
			TagCircle circle = new TagCircle();
			circle.setNumber(new Integer(record.get("id")));
			circle.setX(new Integer(record.get("col")));
			circle.setY(new Integer(record.get("row")));
			circle.setRadioPx(new Float(record.get("radioPx")));
			list.add(circle);

		}
		if (list.size()>MAX_CIRCLES){
			throw new BuenOjoCSVParserException("el archivo contiene mas de "+MAX_CIRCLES+ "áreas circulares");
		}
		return list;

	}
 

import org.apache.commons.csv.CSVFormat; //导入依赖的package包/类
/**
 * Creates a new dataset with column labels and data read from the given Reader, using a specified input format.
 *
 * @param reader       the Reader to read column labels and data from
 * @param input_format the format
 */
@SuppressWarnings("WeakerAccess")
public DataSet(final Reader reader, final CSVFormat input_format) {

    this();

    try (CSVParser parser = new CSVParser(reader, input_format.withHeader())) {

        labels.addAll(getColumnLabels(parser));

        for (final CSVRecord record : parser) {

            final List<String> items = csvRecordToList(record);
            final int size = items.size();

            // Don't add row if the line was empty.
            if (size > 1 || (size == 1 && items.get(0).length() > 0)) {
                records.add(items);
            }
        }

        reader.close();
    } catch (final IOException e) {
        throw new RuntimeException(e);
    }
}
 

import org.apache.commons.csv.CSVFormat; //导入依赖的package包/类
/**
 * This method reads the file from @see {@link ReadFolder} and put into an array list the data we need.
 * We use here the API commons-csv.
 * Attention : tu run with the API you need to import him into the project @see README.
 * @param folderName.
 * @exception IOException | NumberFormatException : print error reading file.
 */
public void read(String folderName) {
	try {
		Reader in = new FileReader(folderName + "/" + file.getName());
		BufferedReader br = new BufferedReader(in);
		String firstLine = br.readLine();
		if (checkTheFile(firstLine)) {
			Iterable<CSVRecord> records = CSVFormat.RFC4180.withFirstRecordAsHeader().parse(br);	
			for (CSVRecord record : records) 
				if (record.get("Type").equals("WIFI") && !record.get("FirstSeen").contains("1970")) 
					inputWifi(record, firstLine);
			in.close();
			br.close();
		}
	}
	catch(IOException | NumberFormatException ex) { // If there is an error.
		System.out.println("Error reading file : " + ex);
		System.exit(0);
	}
}
 

import org.apache.commons.csv.CSVFormat; //导入依赖的package包/类
public T csvToObject(InputStream is) throws IOException, IllegalArgumentException, IllegalAccessException, InstantiationException {
    WrapperReturner<T> list = new WrapperReturner();
       try (InputStreamReader br = new InputStreamReader(is)) {
        CSVParser parser = new CSVParser(br, CSVFormat.DEFAULT);
        for (int i = 0, j = 0; i < parser.getRecordNumber(); i++) {
            j = 0;
            for (Field field : classFields) {
                setFieldValue(field, list.t, parser.getRecords().get(i).get(j));
                list.tl.add(list.t);
                j++;
            }
        }

    }
    return list.t;
}