java读取csv文本数据_java 读取CSV数据并写入txt文本

最新推荐文章于 2024-09-07 10:04:58 发布

weixin_39634438

最新推荐文章于 2024-09-07 10:04:58 发布

阅读量153

点赞数

文章标签： java读取csv文本数据

本文链接：https://blog.csdn.net/weixin_39634438/article/details/114231103

版权

这个Java程序展示了如何读取CSV文件并将其内容写入TXT文件。它使用了CsvReader库来处理CSV数据，可以按特定条件筛选行进行写入。

摘要由CSDN通过智能技术生成

package com.vfsd;

import java.io.BufferedWriter;

import java.io.File;

import java.io.FileWriter;

import java.io.IOException;

import com.csvreader.CsvReader;

/*******************************************************************************************************

* The whole package including this class is licensed under

* @ClassName:

* @Directory:

* @author: luozhubang

* @version: v1.0.0

* @date:

* @Description:

* 1、

* 2、

* @Others: 暂无说明

* @Modification History:

* 1、

* Date:

* Author:

* Modification:

* 2、

* Date:

* Author:

* Modification:

* @Statement: If you are using the package or parts of it in any commercial way, a commercial license is required.

* Visit http://www.bim-times.com for more information.

*********************************************************************************************************/

public class ReadCSVAndWriteTxt {

public static void main(String[] args) throws IOException {

String csvFilePath="D:\\参考手册\\无名\\LSTM数据\\2019110101\\2019042701.csv";

String xFileName="D:\\参考手册\\无名\\LSTM数据\\2019110101\\X_train.txt";

String yFileName="D:\\参考手册\\无名\\LSTM数据\\2019110101\\y_train.txt";

//readCSVAndWrite(csvFilePAth);

//readCSVAndWriteData(csvFilePath,xFileName,yFileName);

//String h1[] = {"A","B","C","D","E","F"};

String h1[] = {"A","B","C","D","K","P"};

//String h1[] = {"actionid","actionname","1","\'非该动作\'","\'异常\'","\'分水岭\'"};

readCSVAndWrite1("D:\\参考手册\\无名\\190428 安全带动作数据组织1.csv",h1);

}

/**

* 读取CSV文件内容

* @param csvFileName

* @throws IOException

public static void readCSVAndWrite(String csvFileName) throws IOException{

try {

// 创建CSV读对象

CsvReader csvReader = new CsvReader(csvFileName);

// 读表头

csvReader.readHeaders();

while (csvReader.readRecord()){

// 读一整行

//System.out.println(csvReader.getRawRecord());

// 读这行的某一列

System.out.println(csvReader.get("A")+"\t"+csvReader.get("B")+"\t"+csvReader.get("C"));

}

} catch (IOException e) {

e.printStackTrace();

}

public static void readCSVAndWrite1(String csvFileName,String h1[]) throws IOException{

try {

// 创建CSV读对象

CsvReader csvReader = new CsvReader(csvFileName);

// 读表头

csvReader.readHeaders();

while (csvReader.readRecord()){

// 读一整行

//System.out.println(csvReader.getRawRecord());

// 读这行的某一列

if(csvReader.get(h1[0]).contains("actionid")) {

//System.out.println(csvReader.get(h1[0])+"\t"+csvReader.get(h1[1])+"\t"+csvReader.get(h1[2])+"\t"+csvReader.get(h1[3])+"\t"+csvReader.get(h1[4])+"\t"+csvReader.get(h1[5]));

}

if(csvReader.get(h1[1]).endsWith("f") && !csvReader.get(h1[2]).equals("")) {

System.out.println(csvReader.get(h1[0])+"\t"+csvReader.get(h1[1])+"\t"+csvReader.get(h1[2])+"\t"+csvReader.get(h1[3])+"\t"+csvReader.get(h1[4])+"\t"+csvReader.get(h1[5]));

}

} catch (IOException e) {

e.printStackTrace();

}

/**

* 读取CSV文件内容

* @param csvFileName

* @throws IOException

public static void readCSVAndWriteData(String csvFileName,String xFileName,String yFileName) throws IOException{

File xFile = new File(xFileName);

File yFile = new File(yFileName);

xFile.createNewFile();