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

link之家

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

冷冷的胡萝卜 · SpringBoot学习笔记（八）——JWT ...· 3 周前 ·

刀枪不入的马铃薯 · ASP.NET Core 中的配置 | ...· 2 周前 ·

呐喊的书签 · java循环出现异常，不终止程序，继续执行 ...· 1 周前 ·

愉快的黄豆 · java中文件名目录名或卷标语法不正确_mo ...· 2 天前 ·

长情的椅子 · ASP.NET SignalR 中心 ...· 16 小时前 ·

微笑的花生 · 大学生，你真的“社恐”吗？-交通运输工程学院 ...· 4 月前 ·

玩足球的红薯 · 盘点NBA现役臂展王，马扬诺维奇上榜，一位臂 ...· 8 月前 ·

读研的盒饭 · 一拳超人清炭版本哪能看 - 抖音· 1 年前 ·

任性的小熊猫 · 拜访小屋影评 - 抖音· 1 年前 ·

刚毅的斑马 · 百度一下· 1 年前 ·

腾讯云

开发者社区

文档意见反馈控制台

首页 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用户