问题

读取CSV文件并计算CSV文件中每列的填充率。我正在读取一个类似以下结构的CSV文件：

    学号    , 姓名     ,  专业
    1      , 人员1   ,  计算机科学
    2      , 人员2   ,  计算机科学
    3      , 人员3   ,  计算机科学
           , 人员4   ,  计算机科学
    null   ,         ,  null

如我们所见，列**学号**在第3行后面没有数据，因此其填充率为80%；
对于列**姓名**，填充率为90%，因为第5行没有数据，其他列也是如此。

我希望输出类似于以下内容：

    {
      "fillRate": [
        {
          "columnName": "学号",
          "fillRate": "80%"
        },
        {
          "columnName": "姓名",
          "fillRate": "90%"
        },
        {
          "columnName": "专业",
          "fillRate": "90%"
        }
      ]
    }

以下是我目前的代码：

```java
readFile(String fileName) {
    String fullPath = fileDir + "/" + fileName;
    int totalNumOfRows = 0;
    int totalNumOfRowsExcludeHeader = 0;
    String[] headers = null;
    String[] columnsValue;
    Map<String, Integer> headerAndValidRecord = new LinkedHashMap<String, Integer>();
    Map<String, Integer> headerAndPercentageOfValidRecord = new LinkedHashMap<String, Integer>();
    List<Map<String, String>> responseList = new ArrayList<Map<String, String>>();
    try {
        InputStream in = sftpConnection.get(fullPath); // 从服务器获取文件
        BufferedReader br = new BufferedReader(new InputStreamReader(in, "UTF-8"));

        String line = null;

        while ((line = br.readLine()) != null) {
            totalNumOfRows++;

            if (totalNumOfRows == 1) {
                headers = line.split(",");
                for (int h = 0; h < headers.length; h++) {
                    headerAndValidRecord.put(headers[h], 0);
                }
            } else {
                columnsValue = line.split(",");

                for (int cV = 0; cV < columnsValue.length; cV++) {
                    if ((columnsValue[cV] != null) && (!((columnsValue[cV].trim()).isEmpty()))) {
                        int countOfValidRecord = 0;
                        countOfValidRecord = headerAndValidRecord.get(headers[cV]);
                        countOfValidRecord = countOfValidRecord + 1;
                        headerAndValidRecord.put(headers[cV], countOfValidRecord);
                    }
                } // --For loop close.
            }
        }
        totalNumOfRowsExcludeHeader = totalNumOfRows - 1;
        headerAndPercentageOfValidRecord = calculatePercentage(headerAndValidRecord, totalNumOfRowsExcludeHeader);

    } catch (Exception e) {
        e.printStackTrace();
    }
    return responseList;
}

Roll No, Name,  Department
1      , Person1,  CS
2      , Person2,  CS
3      , Person3,  CS
, Person4,  CS
null   ,        ,  null

{
"fillRate": [
{
"columnName": "Roll No",
"fillRate": "80%"
},
{
"columnName": "Name",
"fillRate": "90%"
},
{
"columnName": "Department",
"fillRate": "90%"
}
]
}

readFile(String fileName){
String fullPath= fileDir + "/" + fileName;
int totalNumOfRows=0;
int totalNumOfRowsExcludeHeader=0;
String[] headers = null;
String[] columnsValue;
Map<String,Integer> headerAndValidRecord = new LinkedHashMap<String,Integer>();
Map<String,Integer> headerAndPercentageOfValidRecord = new LinkedHashMap<String,Integer>();
List<Map<String,String>> responeList= new ArrayList<Map<String,String>>();
try{
InputStream in = sftpConnection.get(fullPath);// getting File from server
BufferedReader br = new BufferedReader(new InputStreamReader(in, "UTF-8"));
String line = null;
while ((line = br.readLine()) != null){
totalNumOfRows++;
if(totalNumOfRows==1){
headers =line.split(",");
for(int h=0;h<headers.length;h++){
headerAndValidRecord.put(headers[h], 0);
}
}
else{
columnsValue =line.split(",");
for(int cV=0;cV<columnsValue.length;cV++){
if((columnsValue[cV]!=null) && (!((columnsValue[cV].trim()).isEmpty()))){
int countOfValidRecord=0;
countOfValidRecord=headerAndValidRecord.get(headers[cV]);
countOfValidRecord=countOfValidRecord+1;
headerAndValidRecord.put(headers[cV], countOfValidRecord);
}
}//--For loop close.
}
} 
totalNumOfRowsExcludeHeader=totalNumOfRows-1;
);
headerAndPercentageOfValidRecord=calculatePercentage(headerAndValidRecord,totalNumOfRowsExcludeHeader);	
}catch(Exception e){
e.printStackTrace();
}
return responeList;
}

答案1

得分: 1

为什么不尝试（total_filled/total_column）* 100。