Die ersten Schritte mit R sind gemacht, ich möchte mich herzlich für den Hinweis bedanken! ☺ ☺ ☺
Diese Auswertung braucht nur zwei Minuten Laufzeit:
> # Einlesen
> db <- read.csv2("1018_00_D_09_E_20090406.csv")
>
> # Übersicht/Struktur
> str(db)
'data.frame': 4394479 obs. of 10 variables:
$ EXCHANGE : Factor w/ 3 levels "EDE","EDF","EDV": 1 1 1 1 1 1 1 1 1 1 ...
$ DATE : Factor w/ 1 level "2009-04-06": 1 1 1 1 1 1 1 1 1 1 ...
$ TIMESTAMP : Factor w/ 37835 levels "2009-04-06 09:00:00",..: 11331 11332 11333 11333 11333 11333 11333 11333 11334 11333 ...
$ HSEC : int 14 32 50 85 82 56 46 87 10 98 ...
$ WKN : Factor w/ 388336 levels "100700","100701",..: 386350 8337 4771 8397 8397 8337 8337 8397 8397 8397 ...
$ ISIN : Factor w/ 388336 levels "AEDFXA0M6V00",..: 354412 11889 10353 11895 11895 11889 11889 11895 11895 11895 ...
$ INSTRUMENT_NAME: Factor w/ 73935 levels "012 SMILE.COMMUNICATIONS",..: 71363 3487 36325 54195 54195 3487 3487 54195 54195 54195 ...
$ PRICE : num 65.5 69.3 46 98.4 98.4 ...
$ PRICE_TYPE : Factor w/ 17 levels ""," ","- ",..: 1 1 1 1 1 1 1 1 1 1 ...
$ TRADED_UNITS : num 53 600 70 188 719 20 180 198 232 91 ...
>
> # mit enthaltenen Feldern arbeiten
> attach(db)
>
> # Minimum, Maximum
> min(as.vector(TIMESTAMP))
[1] "2009-04-06 09:00:00"
> max(as.vector(TIMESTAMP))
[1] "2009-04-06 19:59:59"
>
> # Auszählen
> table(EXCHANGE)
EXCHANGE
EDE EDF EDV
275030 4119440 9
>
> # Summe aller Umsätze
> sum(TRADED_UNITS * PRICE)
[1] 18622686558
>
> # nur ProSieben
> detach(db)
> db <- subset(db, WKN == "777117")
> attach(db)
>
> # Summe aller Umsätze
> sum(TRADED_UNITS * PRICE)
[1] 4462760
>
> # Kreuztabelle
> table(PRICE, EXCHANGE)
EXCHANGE
PRICE EDE EDF EDV
1.53 0 2 0
1.54 6 0 0
1.55 25 0 0
1.56 29 2 0
1.561 1 0 0
1.568 1 0 0
1.569 1 0 0
1.57 79 8 0
1.571 7 0 0
1.579 8 0 0
1.58 88 6 0
1.581 5 0 0
1.589 5 0 0
1.59 53 9 0
1.591 5 0 0
1.599 6 0 0
1.6 79 11 0
1.601 5 0 0
1.609 3 0 0
1.61 65 6 0
1.611 4 0 0
1.619 6 0 0
1.62 87 8 0
1.621 4 0 0
1.629 1 0 0
1.63 67 6 0
1.631 2 0 0
1.639 3 0 0
1.64 38 9 0
1.641 4 0 0
1.644 1 0 0
1.649 3 0 0
1.65 46 7 0
1.651 1 0 0
1.659 2 0 0
1.66 23 4 0
1.669 3 0 0
1.67 18 1 0
1.679 1 0 0
1.68 22 0 0
1.681 2 0 0
1.689 2 0 0
1.69 13 3 0
1.691 2 0 0
1.699 3 0 0
1.7 25 1 0
1.709 1 0 0
1.71 12 1 0
1.719 1 0 0
1.72 8 1 0
1.729 1 0 0
1.73 1 0 0