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

相关文章推荐

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

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

长情的椅子 · ASP.NET SignalR 中心 ...· 1 周前 ·

刚分手的茶壶 · 把string类型的R.drawable.x ...· 6 天前 ·

卖萌的小马驹 · 案例1：Redis当作缓存，mysql查询案 ...· 5 天前 ·

纯真的毛衣 · 国家概况_中华人民共和国外交部· 4 月前 ·

任性的筷子 · 台山市人民政府关于印发《台山市能源发展“十四 ...· 8 月前 ·

风流倜傥的跑步鞋 · 云缨救阿离_王者荣耀_剧情· 8 月前 ·

八块腹肌的啤酒 · 三年级上册英语电子书_抖抖音· 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用户