如何将CSV文件重新排序为按特定列的内容分组开发者社区

相关文章推荐

暴躁的石榴 · 翻译 - Dolibarr ERP CRM ...· 5 月前 ·

不羁的饺子 · Debezium | Apache Flink· 5 月前 ·

讲道义的烈酒 · Debezium-JSON--流式计算 ...· 5 月前 ·

从容的大脸猫 · 零代码第三方数据接入 | TDengine ...· 5 月前 ·

迷茫的马克杯 · 从VBA中的范围中删除特殊字符开发者社区· 4 月前 ·

忐忑的香菜 · oracle一行转多行sql_Knime数据 ...· 1 年前 ·

气势凌人的牛肉面 · 使用CPU时间戳进行高精度计时 - ...· 2 年前 ·

独立的跑步鞋 · 【分享】讯飞星火认知大模型Python调用上 ...· 2 年前 ·

眼睛小的生姜 · android - error: ...· 3 年前 ·

愤怒的豆芽 · 清华大学交叉信息研究院· 3 年前 ·

腾讯云

开发者社区

文档意见反馈控制台

首页 TVP

文章/答案/技术大牛

发布

test,test-cat,skipped
test,test-cat,failed
test,test-cat,passed
test,test-cat,skipped
test,test-cat,passed
test,test-cat,failed

test,test-cat,skipped
test,test-cat,skipped
test,test-cat,failed
test,test-cat,failed
test,test-cat,passed
test,test-cat,passed

package main
import (
        "bufio"
        "fmt"
        "strings"
func main() {
        var FailStat, SkipStat,PassStat []string
        file, err := os.Open("test.csv")
        if err != nil {
                fmt.Println(err)
        } else {
                scanner := bufio.NewScanner(file)
                for scanner.Scan() {
                        line := scanner.Text()
                        if strings.Contains(line, "failed") {
                                FailStat = append(FailStat, line)
                        if strings.Contains(line, "skipped") {
                                SkipStat = append(SkipStat, line)
                        if strings.Contains(line, "passed") {
                                PassStat = append(PassStat, line)
        file.Close()
        var finalstat []string
        finalstat = append(SkipStat, FailStat...)
        finalstat = append(finalstat, PassStat...)
        for _, line := range finalstat {
           fmt.Println(line)
}

$ ./readfile 
test,test-cat,skipped
test,test-cat,skipped
test,test-cat,failed
test,test-cat,failed
test,test-cat,passed
test,test-cat,passed

package main
import (
    "encoding/csv"
    "log"
    "sort"
    "strings"
type Row struct {
    Name, Category, Status string
func main() {
    in := `test,test-cat,skipped
test,test-cat,failed
test,test-cat,passed
test,test-cat,skipped
test,test-cat,passed
test,test-cat,failed
    r := csv.NewReader(strings.NewReader(in))
    rows := make([]Row, 0)
    for {
        record, err := r.Read()
        if err == io.EOF {
            break
        if err != nil {
            log.Fatal(err)
        row := Row{record[0], record[1], record[2]}
        rows = append(rows, row)
    sort.Slice(rows, func(i, j int) bool { return rows[i].Status < rows[j].Status })
    w := csv.NewWriter(os.Stdout)
    for _, row := range rows {
        w.Write([]string{row.Name, row.Category, row.Status})
    w.Flush()
    if err := w.Error(); err != nil {
        log.Fatal(err)
}

test,test-cat,failed
test,test-cat,failed
test,test-cat,passed
test,test-cat,passed
test,test-cat,skipped
test,test-cat,skipped

// ...
rows := make([][]string, 0)
for {
    row, err := r.Read()
    // ...
    rows = append(rows, row)
sort.Slice(rows, func(i, j int) bool { return rows[i][2] < rows[j][2] })
w := csv.NewWriter(os.Stdout)
for _, row := range rows {
    w.Write(row)
// ...

    // ...
    recordGroups := make(map[string][][]string)
    for {
        records, err := r.Read()
        if err == io.EOF {
            break
        if err != nil {
            log.Fatal(err)
        groupName := records[2]
        recordGroups[groupName] = append(recordGroups[groupName], records)
    w := csv.NewWriter(os.Stdout)
    // Control the order with this slice of group names
    groupNames := []string{"failed", "passed", "skipped", "Bogus group!"}
    for _, groupName := range groupNames {
        recordGroup, ok := recordGroups[groupName]
        if !ok {
            log.Printf("did not find expected group %q\n", groupName)
            continue
        for _, record := range recordGroup {
            if err := w.Write(record); err != nil {
                log.Fatalln("error writing record to csv:", err)
    // ...

2009/11/10 23:00:00 did not find expected group "Bogus group!"
test,test-cat,failed
test,test-cat,failed
test,test-cat,skipped
test,test-cat,skipped
test,test-cat,passed
test,test-cat,passed

package main
import (
    "encoding/csv"
    "log"
    "strings"
func main() {
    in := `test,test-cat,skipped
test,test-cat,failed
test,test-cat,passed
test,test-cat,skipped
test,test-cat,passed
test,test-cat,failed
    r := csv.NewReader(strings.NewReader(in))
    dictMap := make(map[string][][]string)
    for {
        records, err := r.Read()
        if err == io.EOF {
            break
        if err != nil {
            log.Fatal(err)
        dictMap[records[2]] = append(dictMap[records[2]], records)
    w := csv.NewWriter(os.Stdout)
    for _, records := range dictMap {
        for idx := range records {
            if err := w.Write(records[idx]); err != nil {
                log.Fatalln("error writing record to csv:", err)

回答 2

Stack Overflow用户

Stack Overflow用户