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
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
|
use std::io::Write;
struct Sheet(Vec<Vec<String>>);
impl Sheet {
fn new(contents: &str) -> Self {
let mut rdr = csv::ReaderBuilder::new()
.has_headers(false)
.from_reader(contents.as_bytes());
let sheet = rdr
.records()
.map(|record| {
record.unwrap().iter().map(|s| s.to_string()).collect()
})
.collect();
Self(sheet)
}
#[allow(dead_code)]
fn value_at(&self, coord: &str) -> String {
let letter = coord.chars().next().unwrap();
let num: usize = coord[1..].parse().unwrap();
let row = num - 1;
let col = ((letter as u32) - ('A' as u32)) as usize;
let Self(sheet) = self;
sheet[row][col].clone()
}
fn rows(&self) -> impl Iterator<Item = &Vec<String>> + '_ {
let Self(sheet) = self;
sheet.iter()
}
}
fn main() {
let sheets: Vec<_> = std::env::args()
.skip(1)
.map(|u| Sheet::new(&reqwest::get(&u).unwrap().text().unwrap()))
.collect();
let mut file = std::fs::File::create("categories.tsv").unwrap();
for row in sheets[0].rows().skip(1) {
if row[0] == "" {
break;
}
let percentage: f64 = row[1].trim_end_matches('%').parse().unwrap();
file.write_all(
[
row[0].as_ref(),
format!("{}", (percentage * 100.0) as u32).as_ref(),
]
.join("\t")
.as_bytes(),
)
.unwrap();
file.write_all(b"\n").unwrap();
}
file.sync_all().unwrap();
let mut file = std::fs::File::create("holdings.tsv").unwrap();
for row in sheets[1].rows().skip(2) {
if row[0] == "" {
break;
}
file.write_all(
[
row[0].as_ref(),
if row[1] == "" { "\\N" } else { row[1].as_ref() },
if row[2] == "" { "\\N" } else { row[2].as_ref() },
row[3].as_ref(),
row[7].replace(['$', ','].as_ref(), "").as_ref(),
row[8].replace(['$', ','].as_ref(), "").as_ref(),
row[11].as_ref(),
]
.join("\t")
.as_bytes(),
)
.unwrap();
file.write_all(b"\n").unwrap();
}
file.sync_all().unwrap();
}
|
