-
Notifications
You must be signed in to change notification settings - Fork 3.6k
/
main.go
66 lines (57 loc) · 1.2 KB
/
main.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
package main
import (
"encoding/csv"
"encoding/json"
"log"
"os"
"strconv"
)
type StockData struct {
Date string
Open float64
High float64
Low float64
Close float64
Volume float64
AdjClose float64
}
func toFloat(str string) float64 {
v, _ := strconv.ParseFloat(str, 64)
return v
}
func main() {
src, err := os.Open("../../../resources/table.csv")
if err != nil {
log.Fatalln("couldn't open file", err.Error())
}
defer src.Close()
dst, err := os.Create("output.txt")
if err != nil {
log.Fatalln("couldn't open file", err.Error())
}
defer dst.Close()
rdr := csv.NewReader(src)
data, err := rdr.ReadAll()
if err != nil {
log.Fatalln("couldn't readall", err.Error())
}
listOfStockData := []StockData{}
// put data into struct
for _, row := range data {
sd := StockData{
Date: row[0],
Open: toFloat(row[1]),
High: toFloat(row[2]),
Low: toFloat(row[3]),
Close: toFloat(row[4]),
Volume: toFloat(row[5]),
AdjClose: toFloat(row[6]),
}
listOfStockData = append(listOfStockData, sd)
}
//convert to JSON
err = json.NewEncoder(dst).Encode(listOfStockData)
if err != nil {
log.Fatalln("couldn't encode", err.Error())
}
}