比较CSV文件并得出差异的结论。

huangapple
go评论117阅读模式
英文:

Compare CSV and conclusion of differences

问题

我开始编写一个程序来比较两个CSV文件。在阅读文档后，我找到了一个解决方案，但我不知道如何打印第二个文件中的差异，因为该函数只返回true/false。

  1. package main
  3. import (
  4.     "encoding/csv"
  5.     "fmt"
  6.     "os"
  7.     "reflect"
  8. )
  10. func main() {
  11.     file, err := os.Open("sms_in_max.csv")
  12.     if err != nil {
  13.         fmt.Println(err)
  14.     }
  15.     reader := csv.NewReader(file)
  16.     records, _ := reader.ReadAll()
  17.     fmt.Println(records)
  18.     file2, err := os.Open("sms_out.csv")
  19.     if err != nil {
  20.         fmt.Println(err)
  21.     }
  22.     reader2 := csv.NewReader(file2)
  23.     records2, _ := reader2.ReadAll()
  24.     fmt.Println(records2)
  25.     allrs := reflect.DeepEqual(records, records2)
  26.     fmt.Println(allrs)
  27. }

请注意，这只是一个比较两个CSV文件并打印差异的示例程序。你可能需要进一步处理差异并进行适当的输出。

英文:

I started writing a program to compare two CSV files. After reading the documentation, I found a solution for I can't figure out how to print the differences from the second file since the function returns true/false

  1. package main
  3. import (
  4.     "encoding/csv"
  5.     "fmt"
  6.     "os"
  7.     "reflect"
  8. )
  10. func main() {
  11.     file, err := os.Open("sms_in_max.csv")
  12.     if err != nil {
  13.         fmt.Println(err)
  14.     }
  15.     reader := csv.NewReader(file)
  16.     records, _ := reader.ReadAll()
  17.     fmt.Println(records)
  18.     file2, err := os.Open("sms_out.csv")
  19.     if err != nil {
  20.         fmt.Println(err)
  21.     }
  22.     reader2 := csv.NewReader(file2)
  23.     records2, _ := reader2.ReadAll()
  24.     fmt.Println(records2)
  25.     allrs :=reflect.DeepEqual(records, records2)
  26.     fmt.Println(allrs)
  27. }

答案1

得分: 1

csv的ReadAll()函数返回行的切片，其中每一行都是列的切片。
我们可以循环遍历行，在每一行中再循环遍历列，并比较每一列的值。
以下是打印所有有差异的行及其行号的代码。

  1. package main
  3. import (
  4. 	"encoding/csv"
  5. 	"fmt"
  6. 	"os"
  7. )
  9. func main() {
  10. 	file, err := os.Open("sms_in_max.csv")
  11. 	if err != nil {
  12. 		fmt.Println(err)
  13. 	}
  14. 	reader := csv.NewReader(file)
  15. 	records, _ := reader.ReadAll()
  16. 	fmt.Println(records)
  17. 	file2, err := os.Open("sms_out.csv")
  18. 	if err != nil {
  19. 		fmt.Println(err)
  20. 	}
  21. 	reader2 := csv.NewReader(file2)
  22. 	records2, _ := reader2.ReadAll()
  23. 	fmt.Println(records2)
  25. 	// 打印有差异的行
  26. 	for i := range records {
  27. 		diff := false
  28. 		for j := range records[i] {
  29. 			if records[i][j] != records2[i][j] {
  30. 				diff = true
  31. 				break
  32. 			}
  33. 		}
  34. 		if diff {
  35. 			fmt.Printf("第 %d 行: %v, %v\n", i+1, records[i], records2[i])
  36. 		}
  37. 	}
  38. }
英文:

The csv ReadAll() function returns slice of rows, where row is a slice of columns.<br>
We can loop over the rows, and within a row, again loop over the columns and compare each column value.<br><br>
Here is the code that prints all lines that have differences alongwith their line numbers.

  1. package main
  3. import (
  4. 	&quot;encoding/csv&quot;
  5. 	&quot;fmt&quot;
  6. 	&quot;os&quot;
  7. )
  9. func main() {
  10. 	file, err := os.Open(&quot;sms_in_max.csv&quot;)
  11. 	if err != nil {
  12. 		fmt.Println(err)
  13. 	}
  14. 	reader := csv.NewReader(file)
  15. 	records, _ := reader.ReadAll()
  16. 	fmt.Println(records)
  17. 	file2, err := os.Open(&quot;sms_out.csv&quot;)
  18. 	if err != nil {
  19. 		fmt.Println(err)
  20. 	}
  21. 	reader2 := csv.NewReader(file2)
  22. 	records2, _ := reader2.ReadAll()
  23. 	fmt.Println(records2)
  24. 	// allrs := reflect.DeepEqual(records, records2)
  25. 	// fmt.Println(allrs)
  27. 	// Prints lines at which there is difference
  28. 	for i := range records {
  29. 		diff := false
  30. 		for j := range records[i] {
  31. 			if records[i][j] != records2[i][j] {
  32. 				diff = true
  33. 				break
  34. 			}
  35. 		}
  36. 		if diff {
  37. 			fmt.Printf(&quot;Line %d: %v, %v\n&quot;, i+1, records[i], records2[i])
  38. 		}
  39. 	}
  40. }

huangapple
  • 本文由 发表于 2021年8月17日 15:58:47
  • 转载请务必保留本文链接：https://go.coder-hub.com/68813652.html
  • csv
  • go
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定