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

相关文章推荐

淡定的盒饭 · ASP.NET 核心 Blazor ...· 1 月前 ·

傻傻的馒头 · STRING_SPLIT ...· 1 月前 ·

坚韧的啤酒 · 表达式和函数 - Azure Data ...· 1 月前 ·

犯傻的黄豆 · Branches API | GitLab ...· 2 周前 ·

迷茫的手术刀 · Java-“this”和“类名.this”以 ...· 10 小时前 ·

慷慨大方的薯片 · jAccount认证接入方法 | ...· 1 年前 ·

幸福的红酒 · 切片器如何不显示空白-掘金· 2 年前 ·

玩滑板的黄花菜 · ChatGPT在JetBrains-IDE上 ...· 2 年前 ·

坚韧的板栗 · 解决 anaconda 报错 ...· 2 年前 ·

腾讯云

开发者社区

文档意见反馈控制台

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