Importing Data into R

ID 529: Data Management and Analytic Workflows in R

Dean Marengi | Tuesday, January 10th, 2023




“See the data, read the data, be the data.”

Someone, somewhere, probably

Motivation

  • So far, we’ve learned a bit about:
    • Data dictionaries and their importance for reproducible research
    • Git and GitHub for code version control and management
    • R and R Studio as tools for working with and analyzing data


  • Before data cleaning, analysis, and visualization can begin data must be imported into R
    • First step in a data analysis workflow
    • Reading data into R is often straightforward
    • However, it is important to be aware of idiosyncrasies in data storage methods to ensure:
      • The data import process is efficient
      • The accuracy and integrity of data is maintained

Learning objectives

  • Learn about common data storage methods you may encounter as researcher
    • Flat data files
    • Statistical software files
    • Excel files
    • Databases
  • Learn different approaches for reading data into R
    • Base R functions
    • R packages with functions to accommodate more file types
  • Understand the potential challenges you may face when reading data into R
    • File types
    • Data formatting
    • Data types

Data Storage Methods

Flat files

  • Class of file types that store data in a simple, text-based format
    • Each row represents a data record
    • Each column represents a variable
    • Parsed using a delimiter (comma, tab, etc.)
    • Highly compatible with most software tools
      • No formatting or other features
      • Small file size relative to other formats
  • Flat file types typically include:
    • csv: comma-separated values
    • tsv: tab-separated values
    • txt: plain text with other delimiter
    • fwf: fixed-width files (stored as a txt file)

Excel files

  • Excel can store data in file formats other than a csv
    • xlsx and the older xls format
  • Supports Excel formatting, formulas, or other features
  • Distinct from flat data files, which store data in a simple text format
  • Drawbacks include:
    • Less portable between statistical software packages and data systems
    • Require specific import functions to accommodate unique data storage features
    • Compatibility issues from updates to proprietary file formats over time

Statistical software files

  • Most statistical software packages have proprietary file formats (binary files)
    • R: rds and rda
    • Stata: dta
    • SAS: sas7bdat
    • SPSS: sav
  • Optimized storage and use in the software for which they were developed
  • Leverage internal software capabilities not available in other formats
  • Drawbacks include:
    • Less portable between statistical software packages and data systems
    • Require specific import functions to accommodate unique data storage features
      • Data types, layout, or other attributes, such as variable labels
    • Compatibility issues from updates to proprietary file formats over time

Relational databases

  • Databases are efficient, scalable, and secure modes of data storage
  • Several R packages enable users to connect to databases to read data. For example:
    • RODBC
    • RMySQL
    • RSQLite
    • RPostgreSQL
  • Users must supply database credentials and other information to connect to databases
    • Hostname, port number, and other parameters
  • Database tables can be queried from R once a connection is established

How can we import data into R?

  • Base R read functions
    • Installed as part of the core R distribution
    • Fast, simple solution for data imports
    • Limited range of file types supported
  • Packages for reading data
    • User-friendly functions with good documentation
    • Functions that accommodate many data formats
    • Robust error handling
    • Some packages optimized for performance
      • Efficient for importing large datasets
  • The read functions you use will ultimately depend on:
    • The unique needs of your project
    • The characteristics of the underlying data

Base R read functions

Base R read funtions

  • Reading tabular data from flat and rds files
  • Imported data stored as a data frame
  • Fewer function arguments to customize data import
  • Less efficient data handling for large datasets
  • Core functions:
    • read.table(): multiple file types
    • read.csv(): comma-separated values (csv)
    • read.delim(): delimited text files
    • read.fwf(): fixed-width text files
    • readRDS(): R data stream (rds) files
  • These read functions are wrappers around read.table (with the exception of readRDS)
read.table(
  file,
  header = FALSE,
  sep = "",
  quote = "\"'",
  dec = ".",
  numerals = c("no.loss"),
  row.names,
  col.names,
  as.is = !stringsAsFactors,
  na.strings = "NA",
  colClasses = NA,
  nrows = -1,
  skip = 0,
  check.names = TRUE,
  fill = !blank.lines.skip,
  strip.white = FALSE,
  blank.lines.skip = TRUE,
  comment.char = "#",
  allowEscapes = FALSE,
  stringsAsFactors = FALSE,
  fileEncoding = ""
  )

Example: read.csv()

# Read in the data
data <- read.csv("data/cvdstudy.csv")

data
        id   survdate age edu smoke cigs   sbp   dbp chol glucose
1    32955 2019-11-04  54   2     1   15 230.0 110.0  262      97
2    36997 2019-10-31  49   3     1    9 110.0  76.0  281      78
3    34659 2019-07-14  57   1     0    0 146.0  76.0  258      87
4    36762 2019-04-18  58   2     1   60 150.0  97.0  250      65
5    32197 2019-02-20  56   1     1    3 145.0 100.0  285      86
6    33534 2019-07-07  45   3     1   23 115.0  76.0  263      78
7    36763 2019-01-04  37   1     1   20 112.0  73.5  166      93
8    33026 2018-09-18  48   1     1   25 102.0  66.5  304      66
9    35364 2019-06-13  62   1     0    0 130.0  87.0  157      47
10   34177 2019-03-19  54   1     0    0 136.5  83.0  254      95
11   32650 2017-03-20  45   3     0    0 121.0  78.5  222      NA
12   32631 2019-01-17  47   2     1    3 120.0  80.0  198      76
13   34380 2017-03-15  42   1     1   10 111.0  67.5  194      47
14   36118 2018-10-21  46   1     0    0 145.0  90.0  295      79
15   35064 2019-07-04  39   1     1   30 139.0  90.0  300     107
16   35134 2018-11-27  39   3     0    0 125.0  87.0  213      75
17   34949 2018-02-14  54   1     0    0 123.0  75.0  250      71
18   35208 2018-05-18  45   2     1   20 117.5  76.0  311      67
19   33548 2019-06-05  46   2     1   30 143.5  92.0  235     115
20   36513 2019-02-28  45   1     0    0 127.5  83.5  238      78
21   33580 2018-05-09  58   1     0    0  85.5  51.0  260     206
22   36734 2018-12-13  55   2     1    9 157.0  82.5  248      83
23   36715 2019-10-21  54   2     1    3 127.5  83.0  231     115
24   32719 2018-04-14  41   3     1   20 166.0  71.0  240      57
25   34485 2019-07-21  46   1     1   40 154.0  91.0  210      82
26   35899 2018-12-22  55   3     0    0 153.0  80.0  237      72
27   34742 2019-04-28  56   2     0    0 144.0  87.0  223      92
28   32774 2019-08-17  65   3     0    0 176.0  95.0  242     103
29   35066 2019-01-12  50   1     0    0 120.0  75.5   NA      NA
30   32359 2017-03-09  57  NA     1   NA 107.5  72.5  223     103
31   34386 2017-09-06  43   1     1   20 120.0  87.0  259      71
32   34717 2019-07-24  51  NA     0    0 159.0  99.0  275      88
33   35634 2019-04-25  44   3     1   10 136.5  83.5  250      95
34   35670 2017-12-07  54   1     1    9 101.0  72.0  241      70
35   35423 2018-12-30  48   2     0    0 132.0  85.0  273      78
36   33161 2019-04-24  49   2     1   20 127.0  86.0  283      78
37   33927 2018-01-31  40   1     0    0 127.0  82.0  137      71
38   34076 2019-02-07  58   2     1   20 110.0  80.0  207      78
39   34088 2019-09-14  47   1     1   40 144.0  91.0  221      66
40   35026 2017-03-04  61   1     1   20 156.0  92.0  183      79
41   35337 2017-10-09  48   1     0    0 107.0  76.0  186      90
42   33461 2019-03-25  50  NA     0    0 108.0  69.0  268      67
43   34195 2017-04-06  58   3     0    0 138.0  83.0  266     100
44   35136 2018-05-25  41   2     1   20 147.5  92.5  196      71
45   32365 2019-05-29  64   1     0    0 132.0  82.0  251      82
46   34009 2017-04-15  63   1     1   20 141.0  82.0  228      81
47   36178 2018-03-13  48   2     0    0 114.0  80.0  263      77
48   34587 2017-04-11  43   2     0    0 122.5  82.0  194      80
49   35034 2019-04-07  36   4     0    0 117.0  90.0  194      87
50   35494 2018-06-03  69   1     1    1 123.0  77.0  245      81
51   33453 2019-04-04  48   2     0    0 119.0  80.0  240      79
52   33714 2018-03-10  47   2     1    2 133.0  86.0  232      74
53   32638 2019-11-07  35   2     0    0 130.0  68.0  216      90
54   32487 2018-08-25  35   2     0    0 107.0  73.0  248      80
55   34752 2018-10-18  52   2     0    0 159.5  94.0  600     140
56   36288 2019-01-22  38   1     1   10 107.0  67.5  212      87
57   35836 2017-09-12  62   1     1   10 134.0  88.0  180      78
58   33182 2018-09-14  52   1     0    0 129.0  97.0  203      77
59   33312 2017-08-19  38   2     1   15 110.0  80.0  176     113
60   36802 2017-07-25  61   1     0    0 119.0  78.0  238      75
61   36453 2019-04-15  67  NA     1   25 144.0  84.0  221      73
62   35568 2017-10-26  50   1     0    0 145.0  94.0  240      68
63   36034 2017-11-30  53   2     0    0 113.0  68.0  234     108
64   34620 2018-12-24  43   2     1   20 104.0  57.0  195      78
65   33692 2017-02-05  53   4     0    0 173.0  89.0  263      82
66   32619 2017-01-19  43   2     1   15 103.0  67.5  190      69
67   33581 2017-02-17  50   3     1   15 121.0  84.0  150      88
68   33254 2018-08-02  38   3     1   25 117.5  77.0  205      NA
69   36920 2018-11-24  54   1     1   NA 110.0  72.0  219      86
70   34318 2017-12-03  68   1     1   15 106.0  48.0  157      65
71   35856 2017-08-20  57   2     1   10 157.0  80.0  272      95
72   36613 2018-01-13  50   1     0    0 122.0  81.0  204      73
73   32551 2018-12-01  48   2     1   40 110.0  70.0  228      76
74   34074 2017-08-08  44   3     0    0 129.0  93.0  257      76
75   33838 2018-06-04  39   1     1   30 135.0  85.0  220      81
76   36948 2017-12-28  55   3     0    0 137.5  87.0  238     107
77   33338 2019-01-18  44   1     1   40 142.5 104.5  201      67
78   33530 2018-10-05  47   1     0    0 122.0  78.0  205      83
79   34020 2019-04-03  53   2     0    0 133.0  89.0  213      73
80   36583 2019-02-10  60   2     1    3 141.0  93.0  314      94
81   32713 2018-07-25  42   1     0    0 124.0  82.0  216      67
82   35345 2019-12-24  37   4     1   20 120.0  79.0  240      80
83   35686 2019-10-10  65   1     0    0 235.0 100.0  240     297
84   33311 2019-11-14  62   1     1   20 124.0  84.0  185      70
85   35954 2018-10-27  48   3     1    9 114.5  70.0  248      75
86   34807 2017-07-20  58   1     1   15 156.0  90.0  247      94
87   32073 2019-07-05  39   3     1   30 133.0  86.0  196      80
88   33149 2017-07-26  54   2     0    0 146.0  98.0  207      91
89   32739 2017-10-31  50   1     1   15 120.0  80.0  168      60
90   33832 2017-02-01  44   1     0    0 113.0  78.0  178      74
91   32727 2017-01-31  40   1     1   20 131.0  80.0  228      74
92   33281 2019-06-04  53   3     1   15 130.0  94.0  233      75
93   33525 2018-09-11  49   1     1   20 150.0  88.0  247      74
94   32033 2018-10-06  64   1     0    0 145.0  85.0  229      74
95   34002 2017-07-17  54   2     0    0 116.0  78.5  175      67
96   34831 2019-07-09  35   1     0    0 110.0  69.0  170      83
97   33852 2018-05-30  45   4     0    0 128.5  73.0  201      82
98   33520 2018-08-04  43   4     0    0 129.0  90.0  260      62
99   34881 2019-07-19  34   2     1   20 111.0  56.0  180      78
100  35755 2017-04-08  40   1     0    0 110.0  74.0  156      76
101  33445 2018-07-27  49   3     0    0 131.0  88.0  300      73
102  32489 2019-06-09  39   1     0    0 139.5  87.0  205      85
103  36255 2019-08-02  41   1     1   15 107.5  75.0  249      78
104  35390 2017-03-05  46   2     1   20 120.0  84.0  211      87
105  35212 2019-04-21  63   4     1   20 134.0  80.0  239     126
106  34890 2018-08-01  49   3     1   15 107.0  74.0  267      75
107  33316 2018-11-22  36   3     0    0 123.0  94.5  264      70
108  35898 2017-02-27  48   4     0    0 124.0  80.0  195      73
109  36818 2017-12-16  46   1     1   20 114.0  84.0  219      60
110  35327 2019-11-17  46   4     0    0 117.0  77.0  255      76
111  35510 2017-02-17  41   2     0    0 143.5  90.0  235      83
112  32170 2019-09-16  47   2     1   15 137.0  97.0  225      NA
113  33238 2019-05-22  56   2     0    0 160.0 105.0  199      83
114  36834 2019-12-07  54   4     0    0 121.0  82.0  265      67
115  34719 2019-07-23  41   4     0    0 118.0  81.0  240      80
116  34630 2018-02-13  38   3     0    0 105.0  70.0  162      71
117  32383 2017-11-09  62   2     0    0 132.5  80.0  193      78
118  36774 2018-02-12  53   2     0    0 100.0  71.0  213      75
119  34263 2017-09-15  39   3     1   30 196.0 116.0  235      87
120  32722 2017-12-13  68   1     0    0 168.0  97.0  176      79
121  34900 2019-09-18  48   2     1   43 162.5  87.5  210      NA
122  35282 2017-08-08  48   1     0    0 131.0  92.0  224      NA
123  32313 2017-06-12  43   1     0    0 123.5  77.5  185      NA
124  32431 2019-07-06  47   1     0    0 116.0  82.0  219      87
125  33597 2018-02-15  40   3     1   30 110.0  70.0  190      72
126  32544 2017-05-17  56   1     0    0 140.0  88.0  227      78
127  34690 2017-04-11  41   2     0    0 125.0  88.0  185      75
128  32559 2017-11-09  36   2     0    0 122.0  78.0  230      78
129  34261 2018-06-14  60   1     1   20 127.5  72.5  260      75
130  34182 2018-02-22  59   1     0    0 120.0  73.0  241      88
131  33106 2019-05-17  54   1     0    0 148.0  89.0  226      92
132  32085 2018-08-11  58   3     1   30 112.0  74.5  200      62
133  32314 2018-10-27  63  NA     0    0 151.0  88.0  246      73
134  33459 2017-02-15  37   2     1   20 106.0  59.5  154      50
135  35918 2019-12-13  55   3     0    0 130.0  84.0  265      69
136  33705 2019-08-13  47   3     1   15 127.0  93.0  220      57
137  35255 2019-04-16  56   1     1   60 125.0  79.0  246      85
138  36870 2017-01-31  55   1     0    0 131.0  87.0  204      70
139  35863 2019-11-28  38   2     1    2  98.0  53.0  172      82
140  36731 2018-05-05  47   1     1   20 137.0  91.0  284      61
141  34198 2019-11-17  40   4     1   30 120.0  80.0  212      57
142  34946 2018-03-15  46   1     1   NA 109.0  78.0  181      NA
143  35826 2019-01-10  58   2     0    0 128.0  88.0  230      58
144  34713 2017-10-02  44   2     1   30 125.0  80.5  245      80
145  36081 2018-11-29  42   1     0    0 137.5  82.5  193      69
146  35657 2019-04-06  42   1     1   20 116.0  83.0  410      83
147  36518 2017-11-18  53   1     1   20 123.0  82.0  222      67
148  34810 2017-10-15  52   2     0    0 157.5  83.0  269      80
149  32305 2019-09-27  59   2     0    0 244.0 124.0  264     120
150  32787 2018-09-29  50   1     0    0 169.0 117.0  212      68
151  33472 2018-04-29  55  NA     0    0 117.0  71.0  270      72
152  33847 2018-01-08  40   2     1   15 122.5  75.0  200      67
153  32297 2017-01-01  53   3     1   20 152.0  74.0  204      89
154  36021 2018-01-24  38   1     1   20 101.0  70.0  214      77
155  32363 2018-10-14  51   3     1   15 101.0  67.0  326      87
156  34197 2017-05-17  42   3     0    0 111.0  72.0  215      55
157  34574 2019-11-27  47   1     1   20 139.0  85.0  186     125
158  34062 2018-01-16  66   3     0    0 213.0 133.0  226      67
159  35637 2019-12-26  41   2     1   20 119.0  82.0  208      NA
160  36250 2018-04-15  50   1     1   20 131.5  83.0  195      78
161  34671 2018-09-02  51   1     1   30 126.5  78.5  241      70
162  34394 2017-09-24  39   2     0    0 120.0  80.0  190      85
163  33630 2017-08-09  63   1     1    9 113.0  82.0  188      93
164  32909 2017-04-03  57   3     0    0 128.5  87.5  238      89
165  34087 2017-06-01  45   2     1   20 117.0  78.0  229      86
166  33868 2017-11-16  37   3     1   40 109.0  72.0  224      93
167  35911 2017-07-07  60   3     0    0 127.0  70.0  328      63
168  35959 2018-07-27  43   4     1   20 129.0  92.0  201      63
169  32380 2019-01-13  39   4     0    0 123.0  90.0  320      69
170  32936 2018-06-30  58   1     1   13 120.0  74.0  196      73
171  35896 2017-06-27  60   1     0    0 155.0  92.5  226      87
172  36472 2018-02-24  59   2     0    0 148.0  98.0  207      93
173  33893 2019-05-05  48   1     1   30 108.0  75.0  205      70
174  32728 2017-09-23  58   1     0    0 159.0  90.0  274      81
175  33709 2019-02-28  42   4     1   20 110.0  70.0  166      69
176  34123 2017-09-20  64   2     0    0 140.0  84.0  293      76
177  33719 2017-03-28  42   4     1   20 120.0  83.5  274      79
178  32432 2017-08-19  48   4     1   20 120.0  72.0  212      77
179  34130 2018-11-10  45   1     1   43 139.5  75.0  191      NA
180  35534 2017-08-19  63   1     0    0 135.0  82.0  273      56
181  32780 2017-06-26  61   1     0    0 115.0  60.0   NA      99
182  32495 2017-12-24  62   1     0    0 126.0  82.0  216      69
183  32492 2019-07-29  35   2     0    0 121.5  74.5  175      93
184  35170 2019-05-14  39   3     0    0 120.0  82.0  179      NA
185  33047 2017-04-20  44   2     0    0 122.0  83.0  187      75
186  33896 2019-08-01  41   3     0    0 113.0  68.0  215      87
187  32608 2018-03-10  58   1     1   20 143.0  98.0  192      68
188  33172 2019-05-22  45   3     0    0 109.0  69.0  129      NA
189  34274 2017-01-13  41   3     1   15 120.5  76.0  195      70
190  33439 2018-06-30  55   2     0    0 161.5  95.0  250      83
191  33649 2018-09-28  44   3     0    0 110.0  70.0  180      67
192  32028 2019-07-16  55   1     0    0 140.0  93.0  219      70
193  34982 2017-03-06  36   2     1   20 124.0  76.0  226      70
194  36162 2018-09-13  48   2     0    0  96.0  70.0  196      68
195  34708 2018-09-19  45   1     1   20 130.0  87.0  218      64
196  35126 2018-11-19  49   2     0    0 143.0  93.0  239      87
197  33737 2019-03-27  55   1     0    0 127.5  69.0  282      NA
198  36607 2019-01-14  36   4     0    0 121.0  66.0  219      76
199  36940 2018-12-01  55   4     0    0 113.0  82.0  230      NA
200  35105 2017-10-22  56   1     0    0 138.0  87.0  259      75
201  34099 2019-04-11  54   1     1   20 147.0  74.0  214      87
202  36814 2017-04-27  54   2     0    0 146.0  87.0  252     100
203  32997 2018-03-22  60   3     0    0 156.0 100.0  285      85
204  33335 2018-10-23  62   3     1   20 127.0  79.0  245      73
205  32613 2018-10-05  59   1     0    0 100.5  66.0  229      81
206  36908 2019-10-21  43   4     0    0 121.0  79.0  262      87
207  33961 2019-05-14  63   1     0    0 118.0  78.0  270      NA
208  33493 2017-12-16  64   1     0    0 206.0 104.0  263      91
209  35723 2018-03-06  65   1     0    0 171.0  89.0  245      93
210  35190 2019-12-15  39   2     1   40 105.0  67.5   NA      NA
211  35365 2018-12-28  41   1     0    0  93.0  71.0  228      85
212  36729 2019-05-22  52   1     0    0 145.0  89.0  245      80
213  34699 2018-01-11  44   3     1   15 112.0  68.0  198      NA
214  34133 2018-10-27  50   1     0    0 152.0  99.0  227     115
215  36806 2019-07-25  50   1     0    0 133.0  91.0  230      70
216  33679 2019-09-30  43   2     1   20 155.0 100.0  243      63
217  33205 2018-11-25  43   2     1   20 119.0  69.0  208      73
218  32076 2018-06-03  55   1     1    1 107.5  70.0  240     140
219  32921 2017-05-10  46   1     1   20 164.0 107.0  208      70
220  33367 2017-12-27  62   1     0    0 176.5  92.0  186      60
221  34063 2019-03-21  38   2     0    0 126.0  76.0  251      66
222  34264 2019-10-30  51   4     0    0 127.5  92.0  260      93
223  33857 2017-07-20  42   1     1   20 125.0  86.0  234      70
224  33273 2019-01-31  43   4     0    0 110.5  66.0  240      80
225  33748 2019-04-01  57   1     0    0 125.0  72.5  320      82
226  33126 2017-02-14  61   3     0    0 141.0  80.0  257      60
227  34039 2019-11-12  54   1     1   20 111.0  81.0   NA      NA
228  33054 2017-12-20  56   3     1   20 160.0  97.5  325      86
229  33088 2019-02-01  46   2     1   43 145.0  88.0  272      65
230  32839 2017-01-03  57   2     1   15 117.0  72.0  221      83
231  36383 2019-07-18  60   1     1   20 179.0  94.0  170      83
232  33494 2019-04-17  62   1     0    0 184.5  83.0  390      47
233  32467 2017-03-19  54   2     0    0 150.0  93.0  321     131
234  34726 2019-03-03  47   3     1   20 120.0  77.5   NA      NA
235  33232 2019-02-12  62   2     0    0 164.0  94.0  313      81
236  35715 2018-05-21  39   2     1   15 115.5  65.5  284      78
237  35708 2019-04-27  63   1     0    0 130.0  73.5  248      83
238  34962 2019-11-07  42   3     1   43 128.0  83.0  272      63
239  35041 2019-09-01  51   3     0    0 124.0  69.0  245      NA
240  32775 2019-01-06  55   1     0    0 129.0  81.0  227      74
241  34965 2019-05-06  49   3     1   40 119.0  67.0  167      83
242  33702 2018-08-30  52   1     1   30 133.0  82.0  223      77
243  33712 2018-09-04  46   1     1   20 134.0  96.0  247      72
244  34648 2018-01-29  65   1     1   20 179.0  96.0  246      76
245  32876 2019-03-27  58   2     1    3 123.0  69.0  242      72
246  32535 2018-05-12  38   2     1    5 130.5  85.5  243      79
247  32275 2017-05-02  52   2     1   20 135.0  82.0  240      87
248  33921 2019-08-11  40   2     1   43 106.0  72.0  224      71
249  36602 2019-10-14  52   4     0    0 128.0  82.0  224      68
250  33193 2019-05-31  41   2     1   10 121.5  82.5  210      89
251  35389 2018-10-31  48   3     1   25 126.5  91.5  200      NA
252  32269 2019-11-10  39   3     0    0 103.0  62.0  181      69
253  33219 2019-07-31  56   1     0    0 136.0  80.0  273     210
254  34122 2019-10-21  43   2     1   20 106.0  65.0  291      82
255  34427 2017-09-04  65   4     1    1 165.0  95.0  322      81
256  32557 2018-05-18  35   2     1   20 122.0  72.5  231      93
257  35651 2019-06-18  44   1     1   20 128.0  94.0  214      66
258  35131 2019-12-15  53   3     0    0 160.0  97.0  285      65
259  32463 2018-07-03  37   4     0    0 104.0  66.0  169      72
260  34451 2017-12-16  62   1     0    0 164.0 102.5  178      83
261  34931 2018-07-05  44   1     0    0 114.0  83.0  268      76
262  35976 2019-01-27  40   1     1    5 113.0  78.0  220      NA
263  34181 2017-07-11  55   1     0    0 130.0  82.0  252      85
264  34450 2019-05-15  45   1     1   20 126.0  80.0  234      88
265  33114 2019-06-07  36   1     0    0 112.0  76.0  200      62
266  36752 2018-02-08  55   1     1   30 144.0  96.5  239     102
267  33817 2019-04-05  44   1     0    0 112.0  62.0  192      82
268  33153 2017-12-19  48   3     1   20 102.0  69.0  187      72
269  32587 2019-01-19  68   1     0    0 142.0  85.0  164     120
270  35147 2018-10-02  45   1     0    0 133.0  87.0  218     115
271  33641 2018-04-13  57   2     1   20 120.0  77.5  210      71
272  32736 2018-02-18  55   2     0    0 158.0  86.0  183     102
273  36605 2017-12-07  60   1     1   20 141.0  92.0  253      76
274  35966 2018-06-02  60   3     0    0 182.0 106.0  325      77
275  36561 2019-02-25  42   2     1   15 124.0  81.0  197      63
276  34436 2019-03-02  40   1     1   20 152.0 103.0  229      72
277  34541 2017-12-27  67   1     0    0 122.0  74.0  203      79
278  35383 2019-07-13  51   3     0    0 132.0  80.0  304     106
279  33983 2017-11-22  50   4     1   20 180.0 100.0  261      66
280  35813 2019-10-22  60   1     0    0 167.0 105.0  191      85
281  36986 2019-02-27  45   1     1    1 140.0  84.0  277      74
282  34161 2018-10-08  52   3     0    0 146.0  89.0  240      73
283  33866 2019-02-18  60   1     0    0 137.0  80.0  264      58
284  33908 2017-02-07  41   2     1   20 122.0  76.5  201      73
285  34937 2017-11-24  47   3     0    0 143.5 109.0  248      66
286  34188 2019-05-25  61  NA     0    0 136.5  89.0  270      87
287  35583 2018-05-17  45   4     1   43 137.5  85.0  216     105
288  34845 2019-08-08  40   2     1   20 124.0  76.0  197      69
289  33390 2017-10-14  42   1     1   20 141.0  92.0  199      60
290  32856 2017-06-25  39   3     0    0 124.0  83.0  180      77
291  36002 2019-03-19  64   1     0    0 149.5  84.0  232      96
292  36056 2019-07-17  50   1     1   20 114.0  64.0  261      71
293  34788 2019-06-15  50   1     0    0 127.0  80.0  258     124
294  36594 2017-12-06  38   2     1   10 113.0  68.0  309      75
295  36781 2017-04-20  43   4     1   30 152.0  87.0   NA      NA
296  34035 2017-07-27  36   3     0    0 111.0  73.0  180      80
297  36876 2019-08-19  44   1     0    0 119.0  75.5  229      88
298  33883 2018-05-23  48   1     1    1 130.0  95.0  259      NA
299  36050 2017-07-13  67   4     0    0 151.0 101.0  259      86
300  34145 2019-09-02  48   4     1    5 123.0  72.5  150      NA
301  32045 2019-02-13  34   3     0    0 102.0  68.0  227      75
302  35729 2018-01-22  40   3     1   40 120.0  80.0  208      66
303  32427 2017-04-28  46   3     0    0 133.0  92.0  297      64
304  36577 2018-05-13  56  NA     1    3 131.0  86.5  289      71
305  33659 2017-08-28  41   1     0    0 121.0  83.0  179      90
306  36751 2018-08-26  44   1     0    0 132.0  82.0  212      73
307  36536 2019-09-06  42   2     0    0 113.0  69.0  232      70
308  32643 2017-10-06  55   2     0    0 146.5  80.0  271      89
309  33424 2019-11-25  48   1     1    5 117.0  73.0  296      78
310  34952 2017-10-02  49   1     0    0 103.5  66.5  211      87
311  33904 2018-02-24  46   3     0    0 172.5 116.5  295      77
312  36832 2018-07-13  38   2     0    0 142.0  72.0  216      75
313  33913 2019-07-11  52   3     0    0 126.0  85.0  234      96
314  36903 2017-01-28  51   1     1    2 127.0  81.0  261      96
315  34241 2017-10-06  43   2     0    0 134.0  90.0  170      73
316  35525 2017-03-15  37   3     0    0 104.0  65.0  197      97
317  36558 2018-09-16  36   3     1   15 105.5  67.0  202      63
318  33049 2017-05-05  57   1     1   20 154.0 100.0  158      70
319  36302 2017-11-13  64   1     1    5 121.0  79.0  180      92
320  32773 2017-10-07  39   4     1    3 140.0  97.0  230      NA
321  36300 2019-01-18  51   1     1   30 127.0  80.0  240      67
322  35905 2018-11-27  37   2     1   20 111.0  70.0  229      70
323  35555 2018-10-06  51   2     0    0 131.0  87.0  295      77
324  34805 2017-04-23  56   4     0    0 169.0  91.0  287      83
325  32382 2018-04-08  36   2     1   20 135.0  94.5  248      85
326  32194 2018-06-13  65   1     0    0 145.0  91.0  225      83
327  36603 2019-09-10  49   1     0    0 120.0  90.0  152      93
328  35671 2019-03-26  63   3     1   20 180.0 101.0  269      84
329  33848 2019-02-17  38   2     0    0 115.0  75.0  148      74
330  33237 2017-01-10  56  NA     1   25 138.0  80.0  255      79
331  36813 2019-08-15  43   3     0    0 115.5  68.0  202      73
332  35678 2018-08-20  63   2     0    0 182.5  97.5  284      87
333  34131 2018-03-23  52  NA     0    0 130.0  74.0  232     248
334  36463 2017-12-04  49   1     0    0 134.0  88.0  193      76
335  36441 2019-02-03  64   2     1    2 177.0 110.0  230     113
336  32136 2019-11-07  57   1     0    0 133.0  77.0  382      81
337  32159 2017-04-15  49   3     1    8 106.0  63.0  215      66
338  33278 2019-09-16  59   2     1    3 122.5  67.5  240      81
339  36474 2017-10-21  63   1     0    0 135.0  83.0  281      68
340  33327 2018-01-02  50   1     0    0 159.0  95.0  167      87
341  35857 2017-05-13  41   2     0    0 115.0  84.0  180      64
342  33086 2018-06-02  36   2     1   30 126.0  87.0  310      78
343  35581 2019-11-05  44   2     0    0 112.5  72.5  286      76
344  33122 2018-10-18  57   3     0    0 124.0  77.0  235      86
345  33928 2018-05-10  63   3     0    0 153.0  89.0  241      75
346  36916 2019-08-19  65   1     0    0 143.5  93.0  274      63
347  32385 2018-12-04  49   2     1   20 141.0  99.0  212      70
348  33555 2019-07-19  65   1     0    0 150.0  77.0  167      NA
349  35553 2018-08-09  41   2     1    9 114.0  70.0  180      NA
350  34163 2019-03-07  58   1     1   20 126.0  77.0   NA      NA
351  35179 2018-03-22  47   2     1    3 122.5  77.5  155      78
352  33916 2017-06-01  55   1     0    0 123.0  81.0  235      78
353  36134 2019-01-13  40   1     0    0 125.0  90.0  290      87
354  35658 2017-01-12  63  NA     1   10 131.0  73.5  271     107
355  32070 2018-03-08  44   2     0    0 128.0  77.0  244      90
356  34554 2017-03-26  46   4     1    5 110.0  80.0  228     127
357  36833 2017-02-17  44   1     0    0 121.0  81.0  206      77
358  35862 2018-10-16  42   3     0    0 102.0  72.5  252      NA
359  34249 2019-06-08  44   1     1    9 133.0  69.0  185      76
360  36405 2018-08-02  43   1     1   20 132.0  90.0  263      71
361  32510 2019-11-01  40   2     0    0 108.5  75.0  233      73
362  32737 2017-10-23  55   4     0    0 159.0 102.0  239      71
363  36268 2018-10-29  61   3     0    0 121.0  78.0  340      73
364  35480 2019-02-15  57   1     1   43 134.0  90.5  185     103
365  34447 2017-11-25  60   1     1   40 149.0  95.0  230      92
366  35795 2018-09-15  46   2     0    0 125.0  80.0  229      80
367  35999 2018-01-21  44   2     1   20 138.0  92.0  264      67
368  35169 2018-04-21  53   2     0    0 167.5 102.5  284      87
369  35069 2018-08-01  60   1     0    0 138.0  87.0  275      86
370  36674 2017-09-09  43   2     0    0 131.0  88.0  247      61
371  36637 2018-11-07  36   1     1   20 101.5  67.0  203      74
372  36499 2018-07-25  48   4     1   15 134.5  90.5  194      72
373  33750 2019-05-27  45  NA     1   30 131.0  85.0  203      70
374  36060 2017-12-24  68   1     1   15 145.0  67.0  193      72
375  35527 2017-05-15  48   1     0    0 111.5  72.0  202      77
376  36404 2018-03-01  64   1     0    0 160.0  82.0  262      90
377  32392 2017-06-23  42   1     1    5 102.0  70.5  197      45
378  34808 2018-07-15  40   1     1   15 122.0  82.0  199      77
379  36448 2017-01-29  43   3     0    0 107.5  67.5  192      NA
380  34151 2017-11-07  55   2     1    9 154.0  87.0  265      66
381  34843 2018-11-07  49   1     1    5 135.0  86.5  350      83
382  32680 2019-08-12  60   1     1    5 139.0  84.0  267     112
383  33978 2018-02-03  39   1     1   15 115.0  75.0  181      NA
384  36076 2017-12-01  44   2     0    0 123.0  82.0  226      70
385  34839 2018-04-22  65   1     1    3 169.0 111.0  217      78
386  32089 2017-07-02  56   3     0    0 155.0 102.0  186      75
387  32268 2018-12-25  63   4     0    0 120.5  75.0  252      77
388  34624 2017-02-03  56   4     1   20 151.5 103.0  228      66
389  33738 2018-12-06  40   2     0    0 121.5  74.5  190      93
390  34272 2019-10-02  46   2     1   20 144.0  78.0  197      60
391  36627 2018-07-07  58   1     1    8 185.0 105.0   NA      NA
392  33814 2018-09-03  37   2     1   30 112.0  70.0  249      76
393  36222 2018-10-14  51   2     0    0 111.5  77.0  224      74
394  32145 2017-03-17  61   2     0    0 124.0  70.0  246      78
395  33043 2019-03-01  63   1     1   43 172.0  82.0  253     137
396  36176 2018-10-05  64   2     0    0 196.0 119.0  254      79
397  33419 2017-08-22  53   1     1   10 116.0  83.0  366      NA
398  36950 2017-01-07  40   4     1   19 122.0  87.0  233      69
399  33222 2017-04-27  48   2     0    0 112.5  79.0  232     100
400  35925 2017-12-20  60   1     1   15 177.0 101.0  254      79
401  32063 2018-09-21  51   1     1   43 140.0  88.0  176      83
402  36747 2018-06-10  46   1     0    0 118.0  76.5  205      77
403  35596 2018-03-25  60   3     1    3 130.0  72.5  270     102
404  33539 2017-10-27  61   3     0    0 182.0 121.0  272      65
405  35168 2019-05-23  42   1     1   30  96.0  67.0  187      84
406  35957 2019-02-18  35   2     0    0 159.0  95.5  245      NA
407  35618 2018-05-12  52   1     1   10 130.0  71.0  188      89
408  32723 2019-12-10  51   1     0    0 151.0  87.5  220      86
409  33270 2019-08-24  59   1     1   10 123.0  76.5  236     107
410  32747 2017-04-24  62   1     1   23 164.0  88.0  286     126
411  32574 2017-06-22  57   1     0    0 124.0  80.0  206      60
412  35492 2018-01-22  64   1     1   30 178.0 106.0  253      76
413  34746 2017-02-07  61   4     0    0 113.0  70.0  235      77
414  35551 2017-11-03  39   1     0    0 124.0  90.0  160      67
415  32861 2017-07-01  43   1     1   25 161.5  96.0  258      84
416  35675 2017-10-17  54   2     1   40 136.5  85.0  328      85
417  36810 2019-07-08  66   1     1   20 128.0  65.0  178      95
418  35401 2018-07-31  56   3     0    0 123.0  75.0  280     112
419  35303 2017-09-09  49   3     1    4 150.0  91.0  227      83
420  34209 2017-10-01  40   2     1    3 124.0  79.0  256      81
421  35112 2017-01-05  38   2     0    0 122.0  80.5  220      77
422  34094 2018-11-04  52   2     0    0 133.5  83.0  269     107
423  36683 2019-09-25  52   1     1   25 121.0  73.0  271      86
424  36620 2018-04-01  41   4     0    0 110.0  69.0  205      67
425  34595 2017-09-18  69  NA     1   23 179.0  93.0  186      67
426  33195 2017-07-24  60   3     0    0 123.0  79.0  325      85
427  36447 2019-05-25  57   1     1    3 177.5 120.0  225      96
428  36382 2018-09-26  54   1     0    0 116.0  72.0  217      77
429  32660 2018-11-12  46   2     0    0 188.0 123.0  184      NA
430  34849 2017-09-20  54   1     0    0 139.0  98.0  273      73
431  33178 2017-05-24  43   2     1   20 130.0  83.5  153      NA
432  33607 2019-01-18  43   4     1   40 114.0  81.0  263      74
433  36541 2018-07-20  52   2     0    0 136.0  84.0  246      86
434  32181 2019-10-16  55   4     1   20 128.0  87.0  268      87
435  35047 2017-02-17  54   2     1   40 145.0  90.0  230      85
436  35039 2017-05-28  60   4     1   30 126.0  79.0  243      65
437  34433 2017-09-28  36   1     1   40 118.0  76.0  215      97
438  35154 2019-10-05  56   2     0    0 140.0  90.0  322      64
439  33932 2017-04-10  64   3     0    0 105.0  72.5  229      77
440  33688 2017-03-31  63   2     1    3 163.0  82.0  246     108
441  34780 2019-07-15  41   2     1   43 125.0  87.0  249      81
442  34600 2017-12-02  58   3     0    0 120.0  70.0  326      68
443  36628 2019-04-06  48   2     0    0 124.5  66.5  237      91
444  36677 2019-06-03  62   1     0    0 141.0  82.0  219      90
445  34239 2017-03-23  66   2     0    0 140.0  80.0  238      83
446  35050 2019-04-11  44   2     0    0 115.0  69.0  185      82
447  33417 2018-01-17  40   2     1   15 131.5  80.0   NA      NA
448  32010 2017-08-22  42   2     1    9 110.0  73.0  205      66
449  34721 2017-02-07  54   1     1   20 120.0  79.0  231      NA
450  36462 2017-04-12  55   1     0    0 124.0  85.0  291      80
451  33001 2019-06-23  51   2     0    0 146.0  77.0  206      90
452  34007 2018-10-11  62   4     0    0 118.5  71.0  288      87
453  36798 2018-01-02  48   1     0    0 140.0  94.0  306      70
454  32448 2019-01-04  59   2     0    0 148.5  90.0  201      83
455  32555 2018-01-19  41   3     1   15 140.0  92.5  268      90
456  36547 2018-03-06  39   2     1   15 118.0  75.5  318      70
457  32111 2018-10-10  47   1     1    9 144.0  92.0  214      57
458  34220 2019-11-22  63   1     0    0 140.0  93.0  234      87
459  32006 2017-07-17  50   1     1   20 140.0  82.0  213      72
460  33652 2019-05-29  56   1     1   20 165.0 112.0  300      78
461  33228 2018-03-30  64   1     1   20 155.0  99.0  214      82
462  36419 2018-03-04  46   1     0    0 119.0  80.0  220      95
463  35733 2017-01-03  39   2     1   NA 121.0  82.0  285      65
464  36695 2017-10-15  37   1     0    0 120.5  80.0  181      67
465  35258 2018-01-16  55   1     0    0 105.0  82.0  231      66
466  32605 2018-04-17  47   3     0    0 114.0  77.0  250      93
467  35254 2017-05-27  51   3     0    0 148.5  90.0  250      NA
468  33995 2017-02-13  42   1     1   20 121.5  79.0  190      77
469  35645 2018-05-31  52   3     1    9 102.0  70.5  275      NA
470  32552 2017-10-06  57   1     0    0 151.0  95.0  266     109
471  36987 2017-12-27  52   4     0    0 139.0  80.0  240      NA
472  36967 2019-09-19  46   1     1   20 120.0  78.0  182      85
473  36921 2019-10-27  50   3     1   10 176.5 115.0  240      83
474  35802 2017-05-13  49   1     1   30 118.0  66.0  238      82
475  33774 2019-03-25  54   1     0    0 116.0  77.0  260      61
476  36493 2018-10-16  57   4     0    0 164.0 100.0  236      67
477  36750 2017-04-01  39   4     1    9 110.5  69.0  170     103
478  34792 2018-06-30  46   1     1   20 112.5  60.0  250      74
479  35072 2017-09-15  59   2     1   20 167.0  89.5  206      75
480  33755 2017-05-02  45   3     0    0 134.0  93.0  297      74
481  35982 2019-02-01  44   4     1    5 110.0  78.0  265      68
482  35760 2019-05-12  46   1     1   20 117.0  78.0  182      59
483  32254 2018-03-09  59   1     1    3 182.0 102.0  230     147
484  35597 2019-02-23  48   4     1   20 118.0  73.0  245     102
485  36078 2019-03-19  57   1     0    0  96.0  64.0  197      77
486  32800 2017-06-27  54   3     0    0 110.0  74.0  286      90
487  34591 2018-08-28  48   1     1   20 109.0  77.0  210      79
488  34564 2017-09-26  47   1     0    0 118.5  81.0  346      NA
489  33757 2017-02-01  38   1     0    0 121.0  86.0  319      77
490  35163 2019-06-18  55   1     1   10 131.0  81.0  346      77
491  32763 2019-04-06  63   2     0    0 127.0  75.0  207      77
492  32174 2017-01-22  64   1     0    0 155.0  86.0  273      91
493  32859 2018-05-09  56   3     0    0 122.0  74.0  220      93
494  35616 2019-09-29  40   2     1   20 122.0  78.0  193      93
495  32712 2018-11-05  43   1     1   20 124.0  85.0  309     215
496  36891 2017-12-26  65   3     1   20 111.5  72.5  305      NA
497  35421 2019-09-07  53   3     1   15 116.0  74.5  161      90
498  32975 2018-12-25  63   1     0    0 154.0  87.0  252      45
499  36770 2018-07-19  45   3     1   30 151.0  95.0  233      95
500  32222 2019-08-22  52   2     1   15  94.0  66.5  240      88
501  32238 2017-04-01  54   1     0    0 132.0  84.0  293      NA
502  34782 2017-01-22  46   1     1   20 131.0  81.0  288      80
503  33799 2017-01-29  54   1     1   20 146.5  92.0  299      71
504  34629 2017-01-03  57   4     0    0 133.0  78.0  194      92
505  34383 2017-10-03  52   3     1   20 136.5  92.5  205      NA
506  36332 2019-08-31  56   2     1    5 128.5  82.0  310      85
507  32355 2018-09-08  40   2     0    0 112.0  82.0  222      85
508  33301 2017-07-28  45   2     1    3 133.5  85.5  220      73
509  35368 2019-10-27  54   1     0    0 187.0  95.0  326     235
510  35057 2018-11-22  49   1     0    0 121.0  82.0  184      78
511  34212 2018-04-02  63   2     1   43 127.0  82.0  230      67
512  34323 2019-04-13  48   1     1   35 154.0  84.0  174      90
513  32949 2017-02-15  53   2     0    0 138.0  86.5  210      87
514  36574 2018-12-19  47   2     1   20 141.0  93.0  296     332
515  32038 2018-03-04  41   2     1    3 130.0  80.0  226      73
516  32851 2019-04-13  50   4     1    9 119.0  90.0  296      69
517  32960 2017-10-27  40   3     0    0 111.0  95.5  286      89
518  33560 2019-04-05  42   1     0    0 117.5  90.0  245      96
519  35992 2017-03-27  53   2     0    0 129.0  80.0  196      89
520  35204 2017-08-02  67   1     0    0 139.0  80.0  264      87
521  33220 2019-12-12  64   1     0    0 160.0  93.0  233     111
522  33585 2019-09-03  55   1     1   20 128.0  94.0  233      95
523  35721 2019-08-19  48   4     1   30 132.5  73.0  178      70
524  35788 2017-11-06  49   3     1    1 120.0  74.0  186      69
525  35402 2019-04-14  53   1     1   40 136.0  73.0  232      73
526  34753 2019-06-07  55  NA     0    0 165.0 105.5  279      87
527  34864 2017-09-17  48   4     1    3 142.5  86.5  247      68
528  33230 2018-08-20  43   1     1   15 125.0  76.0  175      95
529  33448 2017-01-19  37   1     0    0 137.5  88.5  184      68
530  35055 2018-12-21  54   3     0    0 142.5  83.5  239      84
531  32628 2017-01-02  56   3     0    0 124.0  77.0  177      88
532  32239 2018-09-17  50   1     1   20 126.0  76.0  231      NA
533  35366 2017-09-29  38   3     0    0 125.5  86.0  171      71
534  32301 2018-02-15  53   1     1   20 127.0  79.0  242      74
535  33713 2018-05-12  51   2     1    6 131.5  89.0  190     100
536  34505 2017-08-09  64   1     1   20 115.0  81.0  259      78
537  34572 2017-11-22  53   2     1   20 112.5  70.0  211      NA
538  36315 2018-07-11  67   1     0    0 147.0  92.0  302      87
539  33163 2019-12-21  66   1     1   20 188.0 128.0  228      67
540  34005 2017-02-27  62   2     1    6 168.0 102.0  244     105
541  35017 2019-07-03  38   3     1   20 119.0  83.5  238      71
542  34686 2017-04-10  36   2     1   15 112.0  78.0  204      82
543  35677 2017-01-13  67   1     1   40 124.0  79.0  188      75
544  33032 2018-09-09  54   1     0    0 130.0  85.0  218      85
545  34986 2019-11-02  44   1     0    0 118.5  87.0  160      NA
546  35218 2018-08-27  36   2     1   43 124.0  73.0  201     100
547  32370 2017-06-09  51   1     1   20 112.5  74.0   NA      NA
548  34643 2017-05-16  54   2     0    0 132.0  83.5  195     100
549  33303 2019-04-14  59   2     1    1 139.0  84.0  236      NA
550  34222 2019-07-22  49   2     1   NA 158.0 102.0  233      72
551  32553 2018-11-09  52   1     1   20 180.0 114.0  161     104
552  33277 2017-02-17  70   2     0    0 136.0  84.0  231      95
553  34875 2018-05-20  53   1     0    0 123.0  83.0  157      88
554  33055 2017-05-02  61   2     0    0 179.0 100.0  210      95
555  34079 2017-03-08  60   1     0    0 135.0  97.5  173      86
556  34921 2018-10-14  63   1     0    0 195.0 105.0  306      87
557  34411 2019-07-20  47   4     0    0 120.0  81.0  190      73
558  35043 2019-09-23  64   1     0    0 175.0 110.0  260      74
559  33203 2018-12-28  37   3     0    0 102.0  65.0  190      87
560  33403 2018-10-09  56   1     0    0 107.0  66.0  252      72
561  32581 2018-06-18  58   1     0    0 138.0  78.0  295      81
562  34516 2019-03-12  41   4     0    0 124.0  90.0  206      83
563  33678 2017-01-11  40   1     1   15 121.0  76.0  315      85
564  33484 2017-12-15  55   3     1   20 125.0  80.0  216     244
565  33028 2018-09-08  57   1     0    0 170.0 101.0  259      75
566  35515 2019-06-01  63   3     1   10 189.0 103.0  236      74
567  32473 2018-02-04  42   1     0    0 113.0  79.0  170      65
568  36544 2017-08-04  54   2     1    5 132.5  91.0  272      78
569  33078 2017-03-12  41   1     1   15 114.5  80.0  198      75
570  32562 2017-01-10  42   1     1   15 110.0  67.0  214      75
571  33894 2019-07-08  49   3     0    0 118.0  78.0  222      73
572  33975 2019-01-27  39   2     1   40 112.5  60.0  218      NA
573  32182 2018-06-26  58   4     1    3 116.5  83.0  290      85
574  36872 2019-09-24  46   1     1   30 115.0  72.0  217      73
575  36089 2019-11-20  37   1     1   25 125.0  75.0  243      78
576  32561 2017-06-07  59   3     0    0 114.0  84.0  292      72
577  34350 2018-10-26  37   4     0    0 123.0  92.0  230      80
578  35015 2018-10-04  61   3     1   30 150.0  95.0  225     103
579  32702 2017-01-14  47   1     1   20 143.0  88.0  290      77
580  33395 2018-03-11  36   4     1   30 126.0  72.0  155      70
581  36197 2019-10-28  53   1     0    0 127.0  76.0  220      74
582  36956 2018-06-27  52   1     1   20 125.0  88.0  239     123
583  35248 2019-11-19  47   1     0    0 113.5  73.0  232      77
584  32532 2017-09-12  62   2     0    0 149.5  85.0  202      80
585  35271 2018-10-24  60   1     1   15 116.0  82.0  353      71
586  34697 2017-11-01  63   3     0    0 196.0 102.0  161      88
587  34458 2017-08-11  41   3     0    0 150.0 101.0  230      65
588  35404 2017-10-13  50   1     1   20 149.0  96.0  193      NA
589  34454 2017-09-29  43   1     1   25 121.0  82.0  201      91
590  33717 2017-03-30  56   4     1   10 126.0  73.0  186      65
591  33389 2019-02-14  52   1     0    0 146.5  82.0  210      72
592  34653 2018-10-06  58   1     1   20 152.5 105.0  241      85
593  32992 2019-12-15  67   3     0    0 140.0  88.0  260      65
594  34071 2018-03-22  47   2     0    0 126.0  75.0  195      NA
595  35739 2019-12-16  56   3     0    0 114.0  80.0  193      88
596  36639 2019-09-29  57   2     0    0 130.0  75.5  309      75
597  32419 2018-08-30  45   3     1    5 100.0  70.0  268      87
598  35920 2018-03-28  49   2     1   20 142.0 108.0  273      72
599  34748 2019-10-12  46   1     0    0 166.5 107.0  239      70
600  34800 2019-07-25  46   1     1   43 116.5  87.0  270      71
601  33186 2019-07-30  38   2     1    9 102.5  67.5  160      68
602  36090 2019-04-24  41   2     1    5 105.0  74.0  205      NA
603  33113 2018-03-09  63   4     0    0 150.0  96.5  263      75
604  36687 2019-03-14  38   4     0    0  99.0  62.0  227      90
605  32689 2017-11-16  44   3     1    9 114.0  83.0  226      NA
606  36068 2018-01-31  56   1     0    0 158.0  70.0  206      88
607  33300 2017-04-08  45   2     1   20 116.0  87.0  285      55
608  32821 2019-01-29  46   2     0    0 121.0  81.0  250      76
609  33358 2018-11-06  45   3     1   20 138.0  85.0  230      67
610  34660 2018-03-08  36   2     1   25 122.0  83.0  190      NA
611  34160 2017-05-11  51   2     1   13 137.0  76.0  245      73
612  34422 2017-10-25  46   1     1   20 137.0  90.0  185      NA
613  35572 2017-03-10  63   1     1   20 136.0  66.0  238      92
614  32586 2019-11-18  51   3     0    0 128.0  83.5  216      75
615  36349 2019-08-22  62   1     1    5 157.0  96.0  243      71
616  34464 2018-10-11  51   2     0    0 127.5  77.5  239      79
617  35817 2018-01-06  61   1     0    0 232.0 136.0  238      79
618  35200 2019-05-01  42   2     1   15 158.0 108.0  453     110
619  34359 2017-01-01  53   1     0    0 115.0  61.0  246      60
620  36069 2018-09-28  42   2     1   30 130.0  86.0  209      55
621  32450 2018-06-04  67   1     0    0 160.0 100.0  218      71
622  34084 2017-10-29  43   2     0    0 107.5  73.5  206      71
623  34278 2017-01-18  49   1     0    0 131.0  92.0  254      65
624  33822 2018-03-03  42   4     0    0 112.0  74.5  195     110
625  33133 2019-04-28  53   2     1   10 130.0  86.0  276      56
626  32671 2017-06-03  45   2     1   10 136.0  85.0  232      66
627  33587 2018-09-21  52   1     0    0 129.0  73.0  211     117
628  36994 2018-07-17  59   1     0    0 135.0  70.0  246     107
629  36974 2019-04-04  42   4     1   40 129.0  90.0  218      73
630  36464 2018-07-24  38   2     1    5 122.0  84.5  195      78
631  35054 2019-04-25  57   1     0    0 121.0  74.0  300     155
632  34872 2019-01-27  46   2     1   30 123.0  76.0  250      78
633  36777 2017-03-11  41   4     0    0 134.0  87.0  197      75
634  35240 2018-02-01  64   1     0    0 157.0  71.0  270      93
635  33704 2017-05-14  61   1     1    6 178.0  91.0  290      80
636  36192 2019-07-19  57   4     1    9 140.0  94.0  382      70
637  32330 2018-06-16  47   4     1   15 163.5  97.0  210     183
638  32296 2017-11-13  44   3     1   15 125.0  78.0  340      90
639  35103 2018-04-05  65   1     0    0 157.0  86.0  196      80
640  36478 2018-07-24  42   3     0    0 128.0  87.0  464      72
641  33352 2019-01-27  44   1     0    0 119.0  82.0  198      66
642  36808 2019-08-15  34   2     0    0 108.0  66.0  189      88
643  33887 2017-11-03  51   3     0    0 108.0  77.0  242      80
644  32114 2018-11-12  63   3     0    0 125.0  80.0  281      99
645  32058 2018-09-22  47   2     0    0 142.0  96.0   NA      NA
646  32700 2017-04-12  41   2     0    0 130.0  80.0  173      61
647  36486 2017-10-26  49   3     1    3 130.0  82.0  219      65
648  34546 2018-10-19  39   2     1   30 118.0  76.0  257      76
649  32738 2019-10-20  39   1     0    0 116.0  79.0  243      82
650  32024 2019-11-18  60   4     0    0 131.0  81.0  247      94
651  35236 2017-12-14  51   4     1   15 125.0  80.0  238      66
652  32731 2018-06-30  44   3     0    0 131.5  76.0  270     113
653  34877 2019-03-31  38   2     0    0 137.0  82.5  209      84
654  36555 2017-09-06  62   3     0    0 176.0  89.0  249      81
655  32429 2017-01-10  46   1     0    0 115.0  79.5  265      61
656  36932 2018-02-26  46   1     0    0 130.0  86.5  328      82
657  33801 2017-03-23  60  NA     0    0 163.0 107.0  242      71
658  34729 2019-03-12  49   2     0    0 123.5  84.0  261      75
659  35944 2017-04-24  43   4     1   20 104.0  69.0  202      63
660  32659 2018-02-20  59   3     0    0 148.0  89.0  282      NA
661  32669 2019-10-02  55   3     0    0 135.0  80.0  195      75
662  36443 2019-12-25  53   1     0    0 174.5 103.0  240      74
663  36484 2017-11-19  42   1     1   30 169.0  96.0  240      NA
664  32128 2019-12-01  52   1     0    0 125.0  82.0  219     173
665  34515 2018-02-02  51   3     0    0 206.0 116.0  268      70
666  36473 2019-02-23  42   2     0    0 122.0  75.0  218      85
667  33258 2019-03-05  42   3     0    0 137.0  91.0  283      67
668  33565 2018-11-21  69   3     0    0 117.0  73.0  286     103
669  32469 2018-04-24  59   1     0    0 158.0  90.0  288      87
670  36805 2019-02-07  53   2     1   20 131.0  82.0  240      80
671  34863 2017-04-09  59   1     0    0 146.0  92.0  252      80
672  34785 2018-01-04  62   1     0    0 111.0  63.0  275      78
673  33465 2018-03-18  55   1     1   20 125.0  93.0  244      NA
674  36533 2017-01-12  59   1     0    0 143.5  92.5  254      NA
675  35934 2017-10-09  36   2     0    0 125.0  85.0  176      83
676  35298 2019-07-01  45   2     0    0 152.5  82.0  215      75
677  35848 2019-02-28  42   2     1   10 105.0  70.0  173      79
678  36321 2019-02-10  46   3     0    0 128.0  74.0  190      78
679  33909 2018-03-12  53   1     1    5 139.0  88.0  247      53
680  35167 2019-10-19  49   3     1    3 121.0  82.0  247      69
681  32801 2019-04-04  36   1     1   15 100.0  64.0  164      65
682  34662 2017-04-14  51   3     0    0 115.0  75.0  218      62
683  32664 2017-08-02  61   1     1   25 147.5  72.5   NA      NA
684  35580 2018-08-29  47   3     1    5 110.0  77.0  237      83
685  36115 2017-06-15  36   2     1   20 124.5  84.5  226      74
686  35450 2019-07-12  63   1     0    0 125.0  79.0  235      83
687  32588 2018-06-30  61   1     0    0 133.0  83.0  271      60
688  33211 2017-05-30  43   1     1   43 122.0  76.0  215      74
689  35063 2019-01-04  53   2     1   20 163.0 105.0  266      79
690  34873 2019-06-11  36   3     1   25 125.0  85.0  220      82
691  32406 2019-11-28  48   3     0    0 127.0  79.5  281      80
692  32281 2019-01-23  37   1     1   10 120.5  67.5  205     113
693  36158 2019-12-13  63   1     0    0 129.5  68.5  294      NA
694  35460 2017-04-07  42   4     1    7 111.0  73.0  273      89
695  36779 2017-11-07  58   1     0    0 102.0  60.0  210      90
696  32016 2017-05-27  44   1     1   20 134.0  80.0  260      81
697  35612 2019-10-15  57   1     0    0 122.0  80.0  372      81
698  35121 2017-02-20  58   3     1   20 134.0  81.0  281      74
699  32338 2019-04-29  57  NA     0    0 155.0  85.0  190      66
700  35001 2017-03-29  48   1     0    0 134.0  87.0  270      77
701  36416 2018-05-03  48   3     1    5 114.0  80.0  172      NA
702  35629 2019-11-10  55   1     1   20 122.0  86.0  307      74
703  32531 2019-01-30  55   1     0    0 142.0  92.0  243      85
704  32140 2018-08-19  44   3     1   15 135.0  89.0  242      77
705  34565 2017-12-19  46   1     1    3 118.0  92.0  193      78
706  34224 2017-12-01  68   1     0    0 124.0  70.0  230      60
707  35376 2017-01-02  55   2     0    0 126.0  88.0  309      NA
708  36949 2017-09-15  49   2     0    0 132.0  85.0  215      75
709  35100 2019-12-16  45   2     0    0 110.0  70.0  218      78
710  33447 2018-01-29  67   2     1   60 170.0 100.0  261      79
711  35706 2017-01-13  65   1     1   20 119.0  82.5  177      88
712  34089 2019-03-15  49   4     0    0 183.0 114.5  215      90
713  32838 2017-11-24  38   2     0    0 131.5  77.5  155      84
714  34213 2018-09-08  47   4     0    0 119.0  87.0  230      NA
715  36421 2017-12-17  40   2     1    3 130.0  84.0   NA     112
716  36161 2017-08-23  47   2     0    0 127.5  90.0  187      72
717  33942 2019-04-17  55   1     1   20 116.0  72.0  243      72
718  33139 2019-03-17  51   1     0    0 115.0  82.5  166      67
719  35213 2019-08-29  42   2     1    5 113.0  81.0  355      71
720  36022 2017-05-05  46   1     1    3 112.0  70.0  237      62
721  36148 2018-05-24  57   1     0    0 135.5  77.0  264      93
722  33108 2017-05-02  42   4     0    0 125.0  77.5  238      77
723  36562 2018-04-05  50   4     1   30 176.0 113.0  214      71
724  34733 2018-06-30  51   2     0    0 117.5  77.5  223      97
725  34747 2017-06-03  53   1     1   15 142.0  88.0  260      77
726  34126 2017-06-16  37   2     1   20 107.5  80.0  309      84
727  35379 2017-06-16  44   4     0    0 145.0  85.0  254     137
728  33298 2017-11-05  45   1     1    9 156.5  86.0  265      76
729  36882 2017-01-03  53   1     0    0 126.0  84.0  237      88
730  34300 2017-06-11  59   1     1   20 111.5  67.0  207      84
731  34803 2019-05-10  55   3     1   20 109.0  66.5  249      85
732  32386 2019-03-11  60   1     0    0 134.0  74.0  275      85
733  34183 2017-04-26  56   1     1   10 174.0  97.0  241     135
734  32352 2017-05-15  46   1     0    0 122.0  76.0  208      70
735  32755 2017-06-27  40   4     1    3 105.0  65.0  188      70
736  35033 2017-02-26  60   1     0    0 122.0  74.0  261      NA
737  35241 2017-02-27  45   2     1   25 124.0  81.0  288     118
738  35270 2017-05-31  41   3     0    0 128.5  74.5  166      NA
739  34487 2017-08-11  53   3     0    0 172.5  91.0  238      NA
740  35475 2018-09-07  52   1     1   30 157.5 105.0  240      80
741  34288 2019-12-11  39   1     1   20 104.0  64.0  253      74
742  32565 2019-08-23  56   3     0    0 142.0  94.0  310      65
743  35299 2019-05-20  52   1     0    0 146.0  88.0  247      63
744  34332 2019-04-20  55   3     1   35 144.5  88.5  275      79
745  33309 2019-08-29  49   3     0    0 108.0  68.0  230      82
746  34519 2018-03-24  56   1     1    3 150.0  84.0  265      73
747  33730 2017-10-30  39   1     1   20 128.5  74.5  160      83
748  36273 2017-10-13  51   1     1   15 142.0  88.0  345      73
749  32483 2019-03-30  52   2     1   20  98.0  65.0  215      76
750  32761 2019-04-03  57   1     0    0 136.0  92.0  287      71
751  34789 2019-01-23  44   2     1   35 144.0  99.0  217      60
752  35196 2019-11-27  62   2     0    0 140.0  93.0  229     111
753  34731 2017-01-19  52   1     0    0 163.0  87.0  220      94
754  34507 2019-09-01  58   1     1    9 164.0  85.5  242     106
755  33310 2017-04-28  48   1     1   20 122.0  70.0  170      73
756  34579 2019-03-13  59   1     0    0 166.0  88.0  258      78
757  33166 2018-01-19  43   1     1   20 133.0  86.5  204      79
758  32948 2018-01-07  44   2     1   15 101.0  66.0  244      76
759  32784 2017-08-03  57   2     0    0 127.0  81.0  239      87
760  35946 2017-01-30  39   1     1   43 177.5 100.0  291      91
761  33490 2017-10-24  39   2     0    0 125.0  86.0  252      93
762  36811 2017-09-07  49   3     1   25 134.0  79.0  282      78
763  35202 2018-08-27  39   2     0    0 155.0 110.0  285      70
764  35411 2018-08-22  44   1     0    0 132.5  90.0  271      95
765  35060 2017-08-30  52   1     1   30 152.5  91.0  309     103
766  32348 2019-03-07  63   1     1   10 182.0  92.0  213      63
767  32498 2018-05-12  58   2     0    0 145.0  95.0  270     120
768  35495 2018-02-16  50   4     0    0 114.0  78.0  220      83
769  35456 2018-06-07  49   4     0    0 170.0 107.5  403      93
770  36298 2018-01-13  36   3     0    0 123.0  69.0  185      75
771  33949 2018-04-26  47   1     1   20 134.0  81.0  195      NA
772  32199 2018-06-22  49   1     1   20 124.0  86.0  222      NA
773  35702 2017-04-23  63   1     1   20 163.0  94.0  213      69
774  32539 2019-11-13  38   2     1   20 116.0  72.0  195      90
775  33376 2019-03-12  55   1     1   25 129.0  82.0  270      60
776  32282 2017-07-16  41   2     1   20 132.0  86.0  293      75
777  34762 2019-02-15  45   2     1   15 120.0  70.0  258      72
778  34694 2018-11-09  46   2     0    0 127.5  87.0  165      75
779  36776 2017-12-21  64   1     0    0 135.0  74.0  268      83
780  35141 2019-11-12  59   1     0    0 145.0  86.0  220      77
781  36553 2018-09-30  47   3     1   25 105.0  74.0  261      75
782  34979 2017-11-24  56   2     0    0 145.0  77.0  261      95
783  32113 2019-11-01  41   1     0    0 133.0  90.0  252      64
784  36539 2018-07-22  69   1     1    4 151.0  74.0  232      62
785  33007 2020-01-01  39   2     1   20 102.5  65.0  206      85
786  35244 2017-01-07  64   2     0    0 190.0 100.0  246     102
787  35288 2018-07-03  40   2     0    0 119.0  81.0   NA      NA
788  34502 2019-12-24  40   2     1   20 114.0  65.0   NA      NA
789  34255 2017-06-22  47   1     1   30 126.5  81.0  260      82
790  36969 2017-07-30  62   2     0    0 185.0  95.0  276     110
791  34018 2017-05-02  46   1     1    9 137.0  97.0  346      82
792  35523 2017-03-09  56   1     1   20 133.0  84.0  278      96
793  32435 2018-06-21  39   1     1   20 122.5  87.0  228      73
794  36376 2019-05-16  54   1     0    0 113.5  75.5  275      78
795  32582 2018-08-21  45   2     1   20 142.0  91.0  297      86
796  32245 2018-12-10  48   1     1    5 141.0  88.0  262      NA
797  33345 2018-05-02  38   2     1   30 146.0 104.0  195      80
798  33274 2020-01-01  62   1     0    0 120.0  67.5  232      62
799  32635 2019-05-26  53   3     0    0 140.0  86.5  315      81
800  36377 2018-07-18  45   1     0    0 137.0  92.5  172      83
801  34462 2019-11-18  45   2     0    0 116.0  81.5  155      82
802  34972 2019-12-26  38   1     0    0 119.0  73.0  198      70
803  36743 2017-11-26  53   2     0    0 142.5  82.0  198      78
804  36521 2017-04-20  61   4     0    0 207.0 122.5  235      72
805  36556 2019-03-19  44   1     1    5 120.0  83.5  205      77
806  34119 2019-10-15  56   1     0    0 164.5 102.0  290     105
807  33144 2018-07-26  52   1     1   20 114.0  78.0  233      73
808  34152 2018-06-21  43   4     1   20 127.5  81.0  184      75
809  33751 2017-10-26  40   2     0    0 142.5  95.0  170      62
810  32920 2018-12-08  64   1     1    5 119.0  80.0  174      78
811  36580 2017-09-29  61   2     0    0 148.0  89.0  194     101
812  35079 2018-06-26  48   1     0    0 130.5  90.0  232     118
813  35673 2017-08-14  41   2     1   30 114.0  68.0  224     107
814  35617 2019-06-20  60   3     0    0 144.0  91.0  229      82
815  34439 2017-11-13  42   1     1   20 196.0 109.0  306      87
816  32488 2017-04-18  38   4     1   10 113.0  69.5  168      NA
817  36630 2019-11-27  42   2     1   20 120.0  70.0  246      78
818  35913 2018-02-20  55   1     0    0 168.0  82.0  305      78
819  34755 2019-02-26  41   2     1   20 126.0  78.0  255      76
820  32484 2017-08-07  50   2     1   10 122.0  80.0  220      72
821  35834 2018-07-22  46   3     0    0 173.0 102.0  259      75
822  33173 2017-03-04  35   2     1   30 148.0  84.0  245      73
823  32959 2019-03-11  39   3     0    0 133.0  87.0  190      80
824  32253 2018-06-17  37   1     1   20 118.0  79.5  315      70
825  34988 2018-08-21  37  NA     1   20 113.0  81.0  184      63
826  36495 2019-05-15  54   3     0    0 115.0  81.0  318      76
827  35481 2019-11-01  40   1     1   43 138.0  90.0  290      73
828  32299 2017-03-12  45  NA     1   20 107.0  75.0  215     105
829  36516 2017-12-22  46   1     1   15 117.0  78.5  210     115
830  32846 2018-07-21  56   4     0    0 126.0  83.0  232      NA
831  36386 2018-10-26  52   2     1   20 147.0  86.0  334      63
832  32590 2017-03-23  62   1     1   30 106.0  67.5  226      87
833  36635 2017-01-07  59   1     0    0 127.5  80.0  250     108
834  33979 2019-09-05  39   4     0    0 105.0  75.0  241      87
835  35693 2018-11-11  45   1     0    0 151.0 101.0  183      63
836  33879 2019-09-27  40   4     0    0 122.0  85.0  161      85
837  34192 2019-11-22  39   4     1   25 110.0  68.0  200      62
838  32138 2019-05-18  60   4     0    0 105.5  67.5  234      73
839  32907 2017-10-13  51   1     0    0 166.0  89.0  292      88
840  32410 2018-04-17  44   4     0    0 139.0  92.5  300      59
841  34601 2018-07-27  45   2     0    0 107.5  64.5  201      NA
842  34298 2017-08-13  47   3     1    2 110.0  70.0  232      82
843  36961 2018-05-02  48   1     1   20 116.5  82.0  268      82
844  34837 2019-12-21  51   3     0    0 145.0  92.5  214      NA
845  35109 2019-06-06  36   2     0    0 126.0  80.0  213      79
846  35643 2018-09-07  37   2     1    9 102.0  72.0  237      83
847  32548 2019-03-10  40   3     1   30 115.0  81.0  280      84
848  34568 2017-03-15  53   2     0    0 108.0  81.0  220      NA
849  35884 2017-10-09  52   1     0    0 141.5  89.0  260      79
850  33950 2019-08-01  38   2     1   20 148.0 109.0  309      NA
851  32676 2019-02-03  52   3     1   20 128.0  74.0  248      79
852  33940 2017-09-20  65   1     0    0 179.5 114.0  252      87
853  33045 2017-05-07  40   3     1   15 121.0  88.0  304      80
854  35512 2018-01-15  43   2     0    0 127.5  82.5  210      80
855  36025 2019-04-27  66   3     1   20 112.0  66.0  241      74
856  33710 2019-05-28  64   2     0    0 113.0  77.0  283      67
857  35547 2019-05-26  40   3     0    0 158.0 103.0  202      80
858  35478 2018-09-16  54   3     1   30 141.5  91.0  267      87
859  32486 2017-05-11  53   1     1   20 120.0  80.0  260      73
860  36094 2017-01-30  45   2     1   20 189.0  87.0  234      90
861  32540 2017-05-25  54   1     0    0 195.0 110.0  306      68
862  34797 2018-06-24  56   3     0    0 115.0  80.0  214     292
863  34050 2018-07-26  36   4     0    0 112.0  85.5  210      77
864  34847 2019-12-19  64   4     0    0 123.0  73.5  273      84
865  35970 2017-01-27  40   2     0    0 131.0  85.0  157      78
866  34835 2017-02-06  51   1     1   10 147.5  95.0  201      67
867  36257 2019-04-23  62   4     0    0 126.0  85.5  281      63
868  36338 2019-10-12  56   1     1   30 109.0  70.0  241      87
869  34404 2017-03-28  50   1     1   20 116.0  69.0  242      73
870  32099 2018-01-29  51   1     1   20 146.5  83.0  240     140
871  36930 2019-11-21  64   3     0    0 180.0 100.0  206      74
872  34171 2017-01-22  62   3     0    0 212.0 103.0  202     105
873  35851 2017-08-12  62   1     0    0 127.5  75.0  207      80
874  34743 2017-01-29  65   1     1   20 140.0  82.5  285      NA
875  32026 2017-01-16  40   3     1    8 122.0  95.0  302      82
876  36311 2017-09-21  45   1     0    0 106.0  58.0  235      79
877  32155 2019-05-21  55   2     1    5 123.0  77.5  315      84
878  33629 2017-07-16  46   3     1   30 114.0  75.0  196      69
879  32786 2017-05-11  34   4     0    0 131.5  84.0  227      87
880  33807 2018-04-12  46   2     0    0 132.0  82.0  212      72
881  32753 2019-06-20  60   1     0    0 213.0  94.5  282      78
882  32505 2017-02-11  42   1     0    0 101.0  70.0  249      60
883  35101 2017-05-15  48   2     1   20 102.5  69.0  194      83
884  36615 2018-03-07  38   2     1    9 124.0  66.0  180      68
885  34862 2017-10-01  53   3     0    0 122.5  75.5  252      71
886  36958 2018-03-14  56   2     0    0 101.0  71.0  280      67
887  35148 2018-06-22  45   1     1   20 111.0  72.0  246     118
888  34158 2018-01-27  47   3     0    0 153.0  98.0  219      92
889  32993 2017-01-18  43   4     1   10 133.0  86.0  214      77
890  35232 2018-01-26  44   1     0    0 175.0 101.0  208     193
891  33569 2019-07-11  43   1     1   10 139.0  96.0  269      71
892  35233 2017-06-18  67   1     0    0 111.0  73.0  223      63
893  35842 2019-01-24  64   1     0    0 130.0  78.0  203      70
894  33315 2019-04-08  48   3     0    0 124.0  74.0  310      73
895  32895 2018-09-09  36   2     0    0 102.0  69.0  212      71
896  35444 2017-01-06  51   3     1   43 126.5  80.0  207      68
897  35439 2017-04-30  46   2     1   20  97.0  65.0  188      60
898  35965 2018-02-21  44   1     0    0 127.0  80.0  260      73
899  32018 2019-01-28  45   3     1   30 147.0 101.0  233      99
900  32928 2019-04-18  37   3     0    0 105.0  73.0  145      80
901  33349 2018-06-25  42   4     0    0 116.0  72.0  253      88
902  36232 2017-05-24  53   2     1   20 128.0  77.0  314      78
903  36229 2019-02-18  61   1     0    0 143.0  80.0  239      NA
904  32640 2019-03-28  54   1     0    0 132.5  81.0  255      NA
905  36351 2018-09-21  36   1     1    3 108.0  74.0  135      75
906  34486 2017-04-18  43   4     1   15 128.5  96.0  205      NA
907  32454 2019-06-21  38   2     0    0 128.0  84.5  239      80
908  33087 2018-08-03  39   1     0    0 129.5  93.5  195      85
909  32346 2019-07-03  48   4     0    0 118.0  78.0  200      98
910  33666 2017-12-21  43   2     1   15 137.0  86.0  240      NA
911  32604 2018-08-17  61   1     0    0 122.0  81.0  210      97
912  36175 2017-11-09  55   1     0    0 134.0  80.0  199      NA
913  33960 2017-01-05  61   1     0    0 127.0  81.0  235      90
914  36098 2018-04-14  47   1     1   25 195.0  90.0  258      NA
915  33888 2019-12-07  49   3     1    1 137.0  79.0  248      74
916  32644 2019-07-05  51   1     1   40 119.0  82.0  264      63
917  32536 2017-10-09  42   1     1   15 140.5  94.0  225      73
918  32813 2019-03-21  57  NA     1   NA 115.0  69.0  229      93
919  34048 2017-06-08  61   1     1    3 165.0  80.0  256      97
920  33522 2018-06-15  39   1     0    0 107.0  82.0  153      82
921  34865 2017-01-19  36   2     0    0 115.0  65.0  197      77
922  34966 2018-05-26  51   1     1   20 154.0  96.0  195      75
923  33810 2019-11-30  49   1     0    0 135.0  89.0  305     117
924  36477 2018-07-28  58   1     0    0 143.0 104.0  220      87
925  36769 2018-09-05  46  NA     1   20 122.5  75.5  212     103
926  35424 2019-01-10  46   1     0    0 120.5  73.5  222      60
927  32209 2019-09-19  49   1     1   20 123.0  69.0  197      60
928  34219 2019-06-09  59   3     0    0 159.0 102.0  223      83
929  33233 2018-06-25  47   2     1   20 134.0  87.0  328      99
930  32651 2019-04-08  40   1     1   30 112.5  64.5  202     103
931  32817 2019-06-01  43   2     0    0 110.0  70.0  308      83
932  36714 2017-08-29  66   1     0    0 152.5  90.0  290      76
933  35756 2017-06-23  54   1     0    0 173.0  88.0  260      87
934  36225 2019-11-20  62   2     0    0 130.0  80.0  283      83
935  36669 2018-01-20  59   2     1    1 108.0  73.0  232      81
936  33021 2018-12-06  47   2     1   20 102.5  71.0  344      80
937  33621 2019-12-20  62   1     0    0 162.5  93.5  312      83
938  35775 2017-06-05  43   1     1   10 108.0  76.0  249      76
939  32066 2019-10-21  40   2     1    1 142.0  84.0  178      77
940  33488 2019-11-04  46   2     0    0 111.0  72.0  195     108
941  35116 2018-02-18  52   4     1   15 118.0  80.0  190      88
942  34339 2018-06-30  50   1     1   20 108.0  81.0  259      72
943  34794 2019-11-21  58   1     0    0 126.0  52.0  240      63
944  32420 2018-12-15  33   2     1    5 119.0  74.0  200      74
945  36858 2017-07-04  55   1     0    0 136.0  70.0  211      83
946  33809 2019-01-13  42   2     1   20 128.0  86.0  235      70
947  36868 2017-05-06  63   1     0    0 116.0  69.0  246      78
948  34964 2019-02-12  52   1     0    0 107.0  75.0  266      98
949  36709 2019-04-30  51   1     1   20 128.0  69.0  246      72
950  32261 2017-09-06  62   3     0    0 204.0 118.0  312      86
951  36616 2018-01-13  61   1     1   30 103.0  70.0  266      93
952  35387 2017-03-30  36   2     1    1  98.0  66.0  160      73
953  33672 2017-07-13  58   2     0    0 161.0  96.0  200      NA
954  36256 2018-12-29  55   1     0    0 140.0  84.0  185      90
955  33617 2017-09-27  47   1     1   43 132.5  85.0  252      80
956  33035 2018-01-30  65   4     0    0 149.5  78.0  289      86
957  32212 2017-03-22  56   3     0    0 122.0  82.5  192      58
958  35648 2019-05-12  62   4     0    0 135.0  97.5  241      96
959  34058 2017-05-02  56   3     1   20 112.5  71.5  240      NA
960  34625 2018-06-15  63   1     0    0 159.0  90.0  222      95
961  32772 2018-06-15  59   1     1    9 122.0  74.0  184      67
962  32121 2018-07-17  65   1     0    0 151.0  91.0  375      67
963  33427 2019-11-14  48   3     0    0 140.0  99.0  205      92
964  32235 2017-11-18  39   2     0    0 109.0  78.0  167      71
965  35758 2017-10-29  52   1     1   20 115.0  80.0  232      68
966  33148 2019-12-08  59   1     0    0 141.0  79.0  278      94
967  34551 2019-10-26  46   1     1   10 157.0  94.0  202      65
968  32152 2018-08-18  42   1     0    0 100.0  73.0  160      93
969  33120 2017-06-06  53   2     1   20 128.0  90.0  256     102
970  35397 2017-12-28  43   2     1   20  99.0  62.0  276      80
971  33594 2019-02-04  43   2     1    9 131.0  87.0  229      74
972  35807 2017-02-06  35   3     1   40 112.0  62.5  175      69
973  35772 2018-08-26  58   1     0    0 143.0  76.0  282      92
974  35465 2019-01-15  49   2     0    0 155.0  89.0  275      85
975  36764 2019-02-21  45   2     1    9 137.0  82.0  208      NA
976  36126 2019-04-08  46   1     1   60 121.0  82.0  285      79
977  33004 2017-12-17  61   1     1   20 141.0  81.0  286      52
978  36420 2019-04-22  49   1     1   NA 123.0  69.0  252      89
979  35514 2019-05-26  50   3     0    0 105.0  72.5  229      79
980  33691 2017-07-15  44   1     0    0 135.0  88.0  234      83
981  34957 2017-12-20  36   2     1   25 117.0  84.0  210      96
982  36593 2017-09-26  39   2     1    9 148.0 103.0  273      74
983  36317 2017-09-28  46   3     0    0 150.0  88.0  305      75
984  36512 2017-01-10  50   2     0    0 129.0  76.0  214      75
985  35382 2019-11-19  65   1     0    0 186.0 109.0  202      75
986  35262 2018-08-19  53   3     1   43 126.0  72.0  238      73
987  36758 2019-07-19  48   4     1   25 144.0  79.0  216      85
988  34504 2017-08-21  59   1     0    0 138.5  85.0  258     103
989  36675 2019-06-05  62   1     0    0 143.5  90.0  268      83
990  35062 2018-03-12  59   1     0    0 142.5  74.5  205      83
991  34227 2019-03-09  47   2     1   43 147.0  81.0  218      NA
992  35482 2017-04-22  41   1     1    4 113.0  75.0  176      55
993  35916 2018-05-14  53   1     1    9 130.0  86.0  309      80
994  34633 2019-06-15  46   1     1   20 117.0  68.0  203      85
995  36325 2019-09-02  53   2     0    0 131.0  83.0  268      78
996  32840 2017-08-13  36   4     0    0 168.0  98.0  212      75
997  33042 2017-03-27  65   4     0    0 106.0  73.0  205      87
998  32047 2019-09-19  60   3     0    0 123.0  82.0  268      85
999  36101 2017-11-14  42   1     1   20 103.0  71.0  234      82
1000 33479 2017-12-25  45   2     1    5 141.0  87.0  238      68
1001 32966 2017-09-10  42   2     0    0 142.5  90.0  249      82
1002 34993 2019-11-17  56   2     0    0 158.0 102.5  260      88
1003 33531 2017-02-06  50   1     1   20 135.0  80.0  239      67
1004 35632 2018-05-03  57   2     0    0 112.0  71.0  163      78
1005 35038 2019-03-02  48   3     1   20 114.0  64.0  215      64
1006 33492 2017-06-10  48   3     1    3 129.0  86.0  246      87
1007 32107 2019-06-01  56   3     0    0 125.0  83.0  273      66
1008 35797 2018-04-19  43   3     1    5 121.0  84.0  214      74
1009 32697 2019-11-01  40   3     0    0 136.5  89.0  180      77
1010 32266 2018-03-07  44   4     1    5 133.0  89.0  231      83
1011 34594 2017-03-28  48   2     0    0 149.0 100.0  211      62
1012 36871 2019-08-15  49   1     0    0 149.0  91.5  233      NA
1013 34114 2018-05-07  66   2     0    0 140.0  71.0  189     119
1014 36187 2017-02-16  51   2     0    0 120.0  81.0  233      75
1015 32842 2019-04-10  49   4     0    0 125.0  83.0  232      77
1016 32449 2018-10-05  58   4     0    0 154.5  88.0  223      81
1017 36119 2019-08-26  39   1     0    0 161.0 103.0  219     106
1018 36075 2018-08-11  50   2     1   20 123.0  70.0  258      71
1019 34129 2019-07-06  56   1     1   10 120.0  70.0  225      NA
1020 33612 2019-05-28  43   1     1   15 101.0  68.5  179      76
1021 34452 2017-09-10  41  NA     0    0 124.0  83.0  190      87
1022 34559 2017-08-05  54   1     1   20 128.0  74.0  245      75
1023 35921 2017-01-01  52   4     0    0 181.0 112.5  264      77
1024 36177 2017-01-12  50   2     1    9 145.0  89.0  161      81
1025 35641 2018-07-04  38   3     0    0 124.0  84.0  216      75
1026 34820 2017-08-04  46   1     1   20 118.0  79.0  219      90
1027 33422 2017-02-01  40   3     1   15 122.0  81.0  211      91
1028 36839 2017-11-22  64   1     0    0 122.0  87.5  262      85
1029 32304 2018-10-01  39   2     1   20 118.0  70.0  190      69
1030 36894 2017-11-01  45   1     0    0 129.5  83.0  195      74
1031 36100 2019-11-29  53   1     1    3 136.5  94.5  268      NA
1032 36626 2019-11-08  57   1     1    1 146.5  81.0  254      85
1033 32580 2017-03-20  49   4     0    0 130.0  87.0  224      73
1034 35030 2018-11-06  53   4     0    0 146.0  91.0  310      72
1035 36169 2018-09-21  66   1     0    0 187.0  88.0  278      84
1036 34041 2019-03-15  47   1     0    0 162.5  92.5  222      80
1037 35554 2018-12-21  58   2     0    0 143.0 101.0  210      80
1038 32749 2017-07-12  59   2     0    0 153.5  85.0  237      NA
1039 32603 2017-08-04  37   2     0    0 125.0  80.0  176      65
1040 32438 2019-03-19  64   3     0    0 150.0  84.0  196      93
1041 33183 2017-02-15  48   1     1   20 127.5  80.0  245      70
1042 36912 2019-04-02  67   3     0    0 120.0  83.0  250      78
1043 33405 2017-02-28  41   3     1    3 110.0  60.0  140      82
1044 35747 2019-03-06  55   4     0    0 120.0  80.0  260      68
1045 34116 2018-05-15  37   3     1   15 101.0  69.0  173      73
1046 32797 2017-07-02  43   1     1   30 112.0  78.0  252      65
1047 32906 2019-02-03  63   1     1    9 158.5  90.0  281      NA
1048 35908 2018-07-20  38   1     0    0 130.0  87.0  221      55
1049 36209 2017-03-11  45   2     0    0 143.5  90.0  279      87
1050 32080 2018-11-02  40   3     1    1 125.0  73.5  205      99
1051 33271 2018-12-01  59   2     0    0 127.0  88.5  239      78
1052 35415 2019-07-18  61   1     1   15 130.0  80.0  206      82
1053 36507 2019-12-28  45   4     1   15 117.0  74.5  224      87
1054 35428 2019-07-31  65   1     0    0 124.0  70.0  276      75
1055 34494 2018-11-05  47   2     1   30 143.0  87.0  198      79
1056 35085 2019-08-21  43   2     1   15 120.0  78.0  300     106
1057 32612 2018-09-16  52   3     0    0 118.5  69.0  272      75
1058 34479 2017-12-24  66   1     0    0 167.0  96.0  260      82
1059 34254 2019-01-02  52   3     0    0 130.0  84.0  265      69
1060 32416 2017-08-06  66   3     0    0 109.0  71.0  288      80
1061 34465 2017-01-24  45   3     1   20 119.0  80.0  198      79
1062 36540 2019-03-28  53   2     0    0 172.5 112.5  325      74
1063 33722 2019-05-18  53   2     0    0 122.0  80.0  287      85
1064 33895 2019-11-14  39   4     0    0 112.0  71.0  181      67
1065 32744 2018-10-21  52   1     0    0 208.0 136.0  252      82
1066 34604 2019-09-12  37   4     0    0 128.5  83.0  166     108
1067 32234 2018-07-05  62   1     1   20 139.0  80.0  295      97
1068 34364 2017-01-31  41   1     1   15  95.0  57.0  190      77
1069 32394 2018-06-05  57   1     0    0 136.0  84.0  220      64
1070 33075 2018-07-11  59   3     1    3 205.0  92.5  216      84
1071 32202 2018-01-30  42   2     1   20 125.5  80.5  272      71
1072 34194 2019-01-06  41   2     1   40 114.0  79.0  313      93
1073 34328 2017-10-08  50   3     0    0 127.5  85.0  232      79
1074 35506 2017-07-29  51   4     0    0 115.0  76.0  200      NA
1075 34354 2017-09-18  41   2     0    0 108.0  73.0  177      72
1076 34528 2018-10-19  50   2     0    0 107.5  70.0  240     102
1077 34096 2017-04-27  60   1     0    0 130.0  70.0  242      84
1078 32214 2018-12-18  59   1     1   20 110.0  64.0  225      64
1079 34909 2019-07-21  63   2     0    0 144.0  90.0  276      78
1080 35900 2017-10-21  52   1     1   15 159.0  89.0  253      NA
1081 36261 2019-10-20  66   1     0    0 150.0  74.0  312      90
1082 32005 2017-08-24  60   1     0    0 126.0  70.0  277     100
1083 33460 2019-02-17  61   4     1   10 130.0  70.0  258      78
1084 36725 2018-06-20  59   2     0    0 133.0  97.0  266      70
1085 33729 2017-07-07  42  NA     1   15 143.0  92.0  222      89
1086 35736 2018-06-03  65   2     0    0 135.0  80.0  286     116
1087 35928 2019-04-15  61   2     0    0 114.0  70.5  255     107
1088 34566 2019-10-21  60   1     1    5 160.0  92.0  246      73
1089 33226 2017-11-29  60   1     0    0 134.0  84.0  238      66
1090 34153 2019-08-20  54   2     0    0 127.0  68.5  253      76
1091 33886 2018-11-18  41   4     1   15 111.0  60.0  207      76
1092 34265 2018-04-08  43   1     1    1 120.0  72.0  186      86
1093 35766 2017-06-18  40   1     1   43 138.0  91.0  216      NA
1094 33052 2018-03-21  40   2     1   20 130.0  80.0  213      76
1095 35655 2018-05-11  40   4     0    0 123.5  83.0  209      63
1096 32654 2018-04-03  39   1     1   20 122.0  82.0  325      93
1097 34917 2018-07-11  62   1     1   20 117.5  80.0  286     195
1098 35407 2018-07-02  44   1     1   40 147.0 103.0  262      NA
1099 32015 2018-08-11  41   2     1    9 122.0  78.0  206      NA
1100 34443 2018-06-26  48   2     1   20 113.0  87.0  246      63
1101 32726 2019-04-11  60   3     0    0 143.5  77.5  224      81
1102 36359 2019-04-22  40   1     1   30 125.0  94.0  154      84
1103 35394 2017-03-28  60   3     1   10 122.0  80.0  227      80
1104 36242 2018-05-23  60   1     1    1 173.0 106.0  232      64
1105 33188 2017-06-27  58   3     1    3 155.0  82.5  290     113
1106 34208 2017-08-03  51   1     0    0 126.0  86.0  197      NA
1107 32760 2018-08-11  39   3     0    0 121.0  78.5  201      90
1108 36501 2018-04-19  48   1     1   30 118.5  73.0  305      84
1109 33772 2019-08-05  40   2     1   15 124.0  83.0  284      71
1110 32399 2019-05-11  36   1     0    0 145.0 102.0  182      70
1111 36608 2019-06-20  56   3     0    0 129.0  83.5  205      64
1112 33675 2018-10-18  51   3     0    0 142.5  80.0  198     100
1113 34968 2017-01-14  46   4     1   40 107.0  82.0  165      77
1114 34199 2017-03-31  57   4     0    0 162.0 108.0  195      73
1115 34358 2017-06-26  63   1     0    0 158.0  80.0  289      84
1116 33369 2017-02-12  49   2     1    1 110.0  71.0  240      84
1117 36352 2018-05-31  44   4     1    1 118.0  68.0  253     110
1118 36042 2019-11-24  34   2     1   25 119.0  77.0  250      80
1119 33414 2018-02-20  51   1     1   20 102.0  64.0  262      66
1120 34117 2017-10-02  56   1     0    0 106.0  65.0  254      NA
1121 32106 2017-08-09  39   1     1    5 137.5  77.5  170      70
1122 36618 2018-01-15  64   1     0    0 164.0 102.0  232      73
1123 36385 2017-03-07  39   1     1    3 116.0  86.0  273      NA
1124 33618 2019-04-07  38   1     1   20 107.0  73.0  223      78
1125 36384 2017-12-27  42   2     0    0 124.0  80.5  234      NA
1126 33318 2018-09-14  41   4     1   20  97.0  63.0  243      64
1127 36124 2018-06-03  66   1     0    0 154.0  80.0  311     104
1128 35859 2019-09-17  44   1     1   20 134.0  88.0  193      77
1129 32069 2018-07-26  42   2     1   30 145.0  95.0  283      84
1130 32641 2018-03-05  49   3     0    0 154.0  80.0  273      63
1131 36111 2017-01-15  41   4     1   40 141.0 100.0  254      NA
1132 32418 2018-09-14  52   1     0    0 130.0  75.0  234      72
1133 34322 2018-06-10  52   2     0    0  98.0  67.0  214      90
1134 32030 2019-02-27  51   4     1    9 160.0  98.0  251      85
1135 33972 2019-01-19  61   1     0    0 163.0 112.5  240      82
1136 36061 2018-04-24  56  NA     1   25 121.0  82.0  171      78
1137 33732 2017-04-25  43   3     0    0 126.0  73.0  232      75
1138 36543 2019-02-26  64   3     0    0 176.0  78.0  195     370
1139 36411 2017-01-25  54   1     0    0 113.5  74.0  225      80
1140 33438 2017-05-04  47   1     1   20 120.0  73.0  234      NA
1141 32368 2017-07-26  51   3     1   20 140.0  80.0  251      NA
1142 33176 2017-04-20  64   3     0    0 108.0  82.0  330      80
1143 36433 2018-01-14  59   1     0    0 176.0  98.0  317      63
1144 32872 2017-01-17  46   3     1   20 129.0  83.0  259      84
1145 33976 2018-01-03  62   1     0    0 173.0  67.0  212      97
1146 33933 2018-08-06  41   1     0    0 127.0  83.0  193      80
1147 34247 2020-01-01  42   2     0    0 144.0  78.0  227      97
1148 33067 2017-10-09  44   1     1   20 114.0  81.0  277      76
1149 32987 2019-03-03  40   1     1   20 121.5  76.5  201      94
1150 33100 2019-08-11  38  NA     1    5 121.0  79.0  190      84
1151 36430 2017-07-29  46   2     0    0  90.0  60.0  232      82
1152 33683 2019-08-17  47   2     1   11 127.0  76.5  229      64
1153 36901 2019-06-19  57   1     0    0 199.5 107.0  194      69
1154 36584 2018-01-01  39   3     0    0  97.5  60.0  195      68
1155 32293 2018-10-11  47   2     0    0 120.0  74.0  223      76
1156 32970 2019-10-13  49   3     0    0  97.0  67.0  238      77
1157 36844 2018-06-18  61   2     1   20 141.0  75.0  326      72
1158 33332 2018-12-11  49   4     1   15 145.0  92.0  309      73
1159 36435 2018-04-01  64   2     1    3 135.0  80.0  315      89
1160 35308 2019-07-20  56   1     1   20 125.0  79.0  240      82
1161 36194 2018-03-23  45   4     1   10  93.5  58.0  202      60
1162 32088 2019-05-16  35   3     0    0 115.0  77.0  190      80
1163 33510 2018-09-15  51   2     1    6 129.0  94.0  234      96
1164 33158 2018-12-16  38   1     0    0 116.0  81.0  203      80
1165 36295 2019-02-28  46   1     0    0 102.0  56.0  199      84
1166 34157 2019-08-09  44   1     0    0 127.5  87.0  240      NA
1167 34696 2017-04-17  66   1     0    0 151.0  91.0  235      87
1168 34913 2017-07-26  45   1     1   10 105.5  57.5  150      87
1169 36221 2017-10-07  62   3     1   20 108.0  73.0  300      80
1170 35098 2019-03-24  41   1     1   15 130.0  80.0  265      63
1171 34414 2017-09-15  44   3     0    0 126.0  76.0  213      84
1172 33633 2019-10-21  48   2     1   20 130.0  84.0  271      85
1173 32087 2018-05-30  36   4     1   35 114.0  76.0  240      NA
1174 35346 2018-03-20  41   2     1   20 139.0  80.0  199      62
1175 36437 2018-03-12  38   4     0    0 107.0  73.5  220      80
1176 36878 2019-09-13  54   2     1    5 150.0  94.0  390      71
1177 35519 2019-05-28  40   1     1   15 131.5  82.5  220      78
1178 33276 2018-06-30  64   1     0    0 127.0  78.0  295      73
1179 32529 2017-01-12  46   3     0    0 138.0 105.0  256     100
1180 36195 2017-11-14  63   2     0    0 190.0  88.0  250     118
1181 33753 2017-08-10  57   3     0    0 131.0  85.0  210      77
1182 36990 2017-09-11  60   1     1   20 164.0 113.0  174      93
1183 36279 2017-11-04  60   3     0    0 152.5  85.0  232     123
1184 36180 2019-01-05  50   3     1    3 112.5  60.0  271      61
1185 32942 2019-04-06  42   1     1   30 130.0  91.0  232      70
1186 35432 2019-11-16  62   2     0    0 126.0  75.0  317      86
1187 36767 2019-12-29  52   2     0    0 124.0  69.0  221      81
1188 35700 2018-05-27  43   4     1   20 116.0  74.0  198      78
1189 32923 2017-04-29  65   1     0    0 170.0  81.0  182      82
1190 32342 2019-08-21  50   1     1   30 133.5  86.0  225     106
1191 35446 2019-03-05  58   2     1    5 114.0  72.5  177      NA
1192 33785 2017-12-16  38   3     1   10 100.0  70.0  203      80
1193 36591 2019-01-23  48   1     0    0 128.0  86.5  215      85
1194 32009 2018-04-06  57   2     0    0 152.5  92.5  250      94
1195 33159 2017-06-19  37   2     1   20 116.5  77.5  211      78
1196 34912 2019-08-01  49   4     1    9 137.0  96.5  231      NA
1197 32146 2017-02-19  45   2     1    7 124.0  78.0  199      78
1198 33919 2017-11-19  37   2     0    0 113.0  83.0  228      73
1199 33217 2018-11-23  46   2     1   20 158.0  94.0  271      71
1200 34787 2017-02-24  37   2     1   20 114.5  80.0  272      57
1201 34980 2017-02-28  54   4     0    0 134.5  92.5  225      69
1202 36024 2017-05-29  61   1     0    0 103.5  70.0  352     105
1203 32445 2018-09-13  50   3     1   40 157.0  88.0  175      85
1204 36341 2017-11-25  40   2     1   15 141.0 102.0  246      67
1205 32407 2017-10-17  40   2     0    0 102.0  72.0  185      83
1206 33279 2019-08-15  59   1     0    0 139.0  79.5  249      NA
1207 33192 2017-05-15  63   2     1   20 142.5  90.0  310      70
1208 34026 2017-07-31  44   2     1    9 147.5  96.0   NA      NA
1209 35698 2017-11-12  48   3     0    0 141.0  98.0  234      82
1210 36601 2018-05-06  48   2     1   10 124.5  75.5  260      85
1211 36520 2018-03-28  63   3     0    0 143.5  89.0  241      80
1212 34223 2018-06-17  38   2     1   10 166.0  96.0  186      75
1213 36139 2018-03-26  48   1     1    5 120.0  81.0  235      80
1214 35870 2017-05-06  58   4     1   20 162.0  99.0  213      70
1215 32969 2019-08-19  44   2     1    3 105.0  60.0  244      NA
1216 33954 2017-10-17  65   1     0    0 158.0  90.0  223      93
1217 35676 2018-01-17  42   1     0    0 139.0  88.0  266      78
1218 35363 2019-02-09  46   1     1   20 118.0  82.0  279      74
1219 36976 2017-11-13  52   1     1    2 122.0  81.0  246      98
1220 32228 2017-01-21  53   2     0    0 146.0  89.0  272      67
1221 32579 2019-01-28  49   1     1   20 123.5  78.0  323      63
1222 35777 2018-08-21  41   2     1   30 100.0  60.0  193      69
1223 35326 2018-09-06  43   1     0    0 138.5  95.5  210      NA
1224 33098 2018-07-10  56   1     1    1 147.0  94.0  280      85
1225 35577 2017-10-28  56   1     1    3 136.0  94.0  279     102
1226 33535 2017-07-23  34   1     1   10 120.0  85.0  210      NA
1227 36366 2018-04-15  63  NA     0    0 136.0  94.0  240      57
1228 32173 2018-10-18  56   1     1   20 130.0  70.0  191      97
1229 32849 2018-08-25  64   2     0    0 149.5  86.0  272      62
1230 33592 2017-11-17  48   1     1    1 101.0  67.0  197     100
1231 34925 2019-01-17  38   2     1   20 126.0  88.0  220      74
1232 35650 2017-06-26  48   2     1   30 138.5  85.5  208      64
1233 33647 2017-08-15  53   4     0    0 133.5  82.5  240      NA
1234 33715 2018-03-16  53   3     0    0 115.0  81.0  253      84
1235 36537 2019-11-13  36   1     1   15 102.5  65.0  178      94
1236 36160 2017-08-03  46   2     0    0 107.5  70.0  244      88
1237 33549 2018-01-28  57   3     1   20 102.0  62.0  267      NA
1238 36097 2018-11-26  48   1     0    0 171.0  97.0  202      78
1239 36475 2017-08-03  50   1     0    0 117.5  80.0  301      72
1240 34922 2019-07-16  45   2     1   15  95.0  58.0  222      77
1241 36681 2018-04-15  46   2     1   20 124.0  81.0  291      NA
1242 36439 2018-12-12  57   4     0    0 105.0  70.0  160      61
1243 34593 2017-12-29  59   1     1   40 111.0  72.0  188      44
1244 35359 2018-06-11  56   2     1   20 198.0 107.0  285      97
1245 32471 2018-11-06  62   1     1    4 163.0  83.0  192      97
1246 35576 2017-01-07  47  NA     0    0 123.0  87.0  292      78
1247 34334 2017-06-21  47   3     1    9 127.5  75.0  221      73
1248 36745 2018-01-03  45   2     1   20 109.0  72.0  217      68
1249 32835 2017-06-06  68   3     1   20 158.0  94.0  258      84
1250 35816 2019-09-14  51   1     0    0 135.0  87.5  237      63
1251 35468 2019-02-06  44   1     1   30 131.0  74.0  334      77
1252 36578 2017-09-03  38   2     1    3 115.0  86.0  180      NA
1253 33132 2017-11-01  52   1     0    0 125.0  76.0  222      77
1254 33059 2018-05-19  48   1     1   30 139.0  86.0  212      62
1255 32673 2018-10-27  51   3     0    0 119.0  80.0  204      87
1256 33574 2017-10-08  53   1     0    0 132.0  80.0  265      76
1257 34078 2018-02-18  38   1     0    0 100.0  80.0  196      74
1258 35347 2017-11-16  63   4     0    0 148.0  85.5  210      88
1259 35469 2018-06-24  66   1     0    0 188.0  92.0  280     101
1260 33721 2019-06-07  38   2     0    0 121.5  74.0  208      90
1261 33016 2018-07-06  56   3     1    5 123.0  78.5  230      87
1262 33443 2017-04-09  49   2     1   30 144.0  86.0  265      68
1263 35947 2018-10-31  52   3     1    9 112.0  75.0  249      71
1264 34532 2019-01-11  49   1     0    0 145.0  81.0  262      83
1265 36519 2018-04-30  47   4     1    3 133.5  76.0  231      73
1266 34926 2019-02-25  53   4     1   30 110.0  67.5  189      63
1267 36889 2018-11-28  36   3     1   15 122.0  74.5  245      85
1268 33259 2018-03-03  55   1     0    0 140.0  88.0  268     117
1269 33677 2018-07-03  54   4     0    0 163.5 103.0  195      80
1270 33398 2017-01-04  62   1     0    0 205.5 104.5  300     117
1271 34916 2018-11-27  55   2     1    9 141.0  83.5  289      76
1272 35019 2017-09-13  42   3     1   10 128.0  82.0  225      85
1273 36456 2017-07-31  42   1     1   20 111.0  71.0  225      85
1274 36339 2018-12-18  54   3     0    0 127.5  83.0  278      78
1275 36166 2018-05-16  47   1     0    0 156.0  96.0  278      70
1276 33638 2018-09-21  50   1     0    0 119.0  74.0  260      72
1277 32600 2017-12-08  39   2     0    0 114.0  68.0  175      93
1278 36703 2017-08-09  67   1     1   40 148.0  70.0  216     103
1279 33882 2019-07-06  52   3     0    0 112.5  75.5  272      83
1280 36278 2017-12-24  48   4     0    0 123.0  80.0  240      74
1281 36600 2017-03-10  49   1     0    0 147.0 102.0  304      77
1282 36548 2018-07-02  48   1     0    0 147.5  87.5  259      73
1283 33482 2018-07-19  48   1     1   35 132.0  91.0  263      91
1284 36803 2019-12-17  42   2     0    0 120.5  80.0  172      61
1285 32511 2017-07-22  54   1     0    0 130.0  87.0  192      NA
1286 35630 2018-04-24  39   2     0    0 123.0  92.5  250      71
1287 32096 2017-01-07  65   1     0    0 153.0 100.0  193     107
1288 36671 2019-09-29  55   1     0    0 213.0 103.0  283      76
1289 33324 2018-06-12  54   2     1   20 120.0  85.0  215      75
1290 36581 2017-01-16  54   1     0    0 171.5 105.5  237     104
1291 32887 2018-10-13  65   1     0    0 159.0  87.0  230      65
1292 35118 2017-08-07  58   1     1   15 127.5  79.5  272      66
1293 36374 2017-12-06  60   1     1    5 164.0  94.5  239      89
1294 33953 2017-06-05  64   1     0    0 133.0  77.5  213      74
1295 35738 2019-06-05  51   2     1   30 176.0  99.0  295      NA
1296 36044 2017-11-21  39   2     0    0 141.0  87.0  200      70
1297 36589 2018-08-26  46   3     1   10 134.0  78.0  269     104
1298 35705 2019-10-30  40   3     0    0 117.5  72.5  154      87
1299 35314 2019-09-24  53   1     0    0 141.0 105.0  219      60
1300 33958 2019-04-20  63   1     0    0 172.5  98.0  226      81
1301 35463 2018-11-04  42   4     0    0 118.0  80.0  191      63
1302 33907 2017-12-15  48   1     1   30 126.0  84.0  240      73
1303 35332 2017-05-29  45   1     0    0 135.0  88.0  288      79
1304 35642 2018-01-21  41   2     0    0 121.0  61.5  274      76
1305 34378 2019-05-03  44   4     1   25 111.0  78.0  241     167
1306 36964 2018-06-29  47   1     1   43 182.0 110.0  237      83
1307 34229 2019-11-15  42   1     1   20 106.0  70.0  248      NA
1308 33167 2017-06-21  65   4     0    0 115.0  73.0  280      58
1309 33764 2017-02-24  44   1     1   20 116.0  67.0  258      79
1310 32354 2019-09-27  45   1     1    3 126.0  85.0   NA      NA
1311 34085 2018-12-11  63   1     1   20 149.0  90.0  252      83
1312 32115 2017-10-27  40   1     0    0 122.0  78.0  190      87
1313 35059 2018-09-21  41   1     0    0 124.0  86.0  203      80
1314 34110 2019-08-30  56   4     1    1 150.0  92.0  289      84
1315 34031 2017-07-30  38   2     1   30 149.0  91.0  266      61
1316 32957 2017-06-10  58   4     1    5 106.0  70.5  243      80
1317 32178 2017-02-21  45   2     1   15 117.5  83.5  200      73
1318 36458 2018-11-24  45   4     0    0 160.0 105.0  252      83
1319 36151 2017-04-14  47   3     1   25 117.5  77.5  173      75
1320 34302 2017-03-20  45   3     0    0 125.0  89.0  162      83
1321 34336 2018-07-27  42   2     1    2 124.0  80.0  230      77
1322 32691 2018-02-04  44   1     0    0 128.0  82.0  200      73
1323 35078 2019-06-27  55   1     0    0 155.0  90.0  325      72
1324 32053 2019-05-26  45   3     1   20 175.0 114.0  238      70
1325 36755 2018-01-07  61   2     0    0 151.0  89.5  239      88
1326 35477 2017-05-20  43   1     1   30 105.0  72.5  262      70
1327 33314 2017-04-22  64   1     0    0 160.0  87.0  285      87
1328 36845 2018-01-29  48   4     1   20 135.0  90.0  259      81
1329 34149 2018-11-06  61   1     0    0 136.5  76.0  312      85
1330 34907 2017-12-03  44   1     0    0 130.0  81.5  230      77
1331 36106 2019-10-12  45   1     0    0 119.0  84.0  172      98
1332 35530 2019-02-24  51   2     1   18 146.0  94.0  176      85
1333 32799 2019-06-24  53   3     1   14 120.0  74.0  252      NA
1334 33850 2018-09-16  38   2     0    0 123.0  92.0  256      82
1335 33595 2018-01-29  65   3     0    0 140.0  82.0  217      NA
1336 35711 2019-09-17  50   2     1   10 156.0  90.0  298     100
1337 32148 2019-11-27  44   2     0    0 131.0  79.0  267      79
1338 33458 2019-09-16  52   2     0    0 111.0  79.0  209      70
1339 34757 2019-09-26  42   2     0    0 127.5  91.0  185      59
1340 33128 2018-11-09  41   2     1    3 119.0  73.0  223      77
1341 35006 2017-05-29  44   4     0    0 104.0  78.0  175      82
1342 35699 2017-04-10  58   1     1   20 170.0  98.0  156      NA
1343 33155 2018-04-18  58   1     1   20 146.0  77.0  225      53
1344 35487 2017-08-11  63   1     1    6 138.5  77.5  256      84
1345 35989 2017-08-27  56   1     0    0 166.0 107.0  254      83
1346 36887 2018-11-27  62   4     0    0 129.0  83.0  273      70
1347 35336 2018-05-05  54   2     1   20 117.0  74.0  261      77
1348 34245 2019-05-28  41   3     0    0 123.0  70.0  239      NA
1349 36410 2017-12-30  36   2     1   20 118.5  84.5  242     103
1350 33575 2018-12-08  59   2     0    0 148.0  95.0  345      60
1351 35936 2018-04-27  46   1     0    0 131.5  77.0  217      76
1352 34159 2018-09-27  46   1     1   20 170.0 118.0  275      84
1353 33353 2019-05-07  44   1     0    0 136.5  77.5  173      72
1354 35531 2017-02-10  44   1     1    8 106.0  65.0  351      69
1355 35127 2018-01-23  53   1     0    0 144.0  96.0  342      NA
1356 34139 2017-07-18  45   3     1   15 109.0  70.0  266      71
1357 36510 2019-09-11  43   2     1   30 125.0  65.0  185      76
1358 33489 2017-06-25  42   1     0    0 111.0  71.0  199     107
1359 35024 2018-03-09  40   3     1   10 103.0  71.0  210      68
1360 33700 2017-03-18  40   2     1   10 123.5  77.5  169      NA
1361 36388 2019-03-10  64   2     1    9 145.0  79.0  250      86
1362 33394 2017-01-31  57   1     0    0 163.5  93.0  241      67
1363 33469 2018-08-13  64   2     1    3 148.0  85.0  221      80
1364 33209 2018-12-30  38   4     1   15  96.0  67.0  178      82
1365 36879 2018-03-31  41   2     1   20 146.0  86.0  245      72
1366 32334 2019-06-13  61   1     0    0 142.0  89.0  243      67
1367 35152 2017-08-19  57   1     0    0 108.5  70.5  201      84
1368 34840 2018-04-24  62   1     1   NA 242.0 141.0  206      94
1369 32759 2018-03-15  51  NA     0    0 125.0  84.0  219      76
1370 32634 2018-05-18  43   4     1   20 107.0  68.0  265      95
1371 35291 2019-10-25  51   3     1    4 112.0  74.0  220      66
1372 34292 2018-08-07  42   1     1   20 116.0  74.0  319     136
1373 35328 2018-11-30  58   2     1   NA 127.5  76.0  235     135
1374 34759 2018-11-03  39   2     1   10 102.0  64.5  215      62
1375 36293 2017-12-05  63   2     1   40 116.0  69.0  179      75
1376 33221 2017-12-25  61   1     1   20 215.0 129.0  220      NA
1377 34187 2019-01-06  61   2     0    0 102.0  59.0  219      62
1378 32591 2019-03-01  48  NA     1   40 133.0  77.5  247      95
1379 34664 2018-10-23  55   2     0    0 125.0  80.0  273      67
1380 33768 2019-05-30  55   1     1    6 148.0  94.0  274      65
1381 33399 2017-04-20  41   4     1    9 102.0  67.0  218      78
1382 32844 2019-08-14  54   1     0    0 160.0  94.0  302      75
1383 36491 2019-01-08  54   2     0    0 142.5  83.5  220      84
1384 34060 2017-07-09  47   1     1   30 137.0  86.0  277      85
1385 36860 2019-05-07  33   1     0    0 108.0  67.0  158      69
1386 33749 2019-03-23  51   2     0    0 150.5  95.0  262      77
1387 32109 2019-08-16  66   4     1    9 172.5  88.0  243      90
1388 32837 2018-01-02  60   1     0    0 174.0 110.0  231      82
1389 35850 2019-11-30  42   1     0    0 115.0  77.0  271      82
1390 36926 2019-09-11  41   2     0    0 104.0  73.0  247      68
1391 35619 2018-10-01  60   1     1   30 122.5  68.5  288      88
1392 32034 2017-09-30  35   2     0    0 136.5  95.0  242      88
1393 36287 2019-07-23  44   1     1   20 118.0  81.0  197      75
1394 35418 2018-11-19  38   2     1   20 134.0  78.0  268      NA
1395 36919 2019-07-19  50   1     1   20 158.0  88.0  233      94
1396 34567 2018-10-22  41   3     1   11 108.0  71.0  201      75
1397 35097 2018-10-17  59   2     0    0 129.0  70.0  310      70
1398 35434 2019-08-03  59   3     1   30 168.0 100.0  239      96
1399 36623 2017-11-29  36   1     1    5 147.0  94.0  222      71
1400 32767 2018-01-30  58   2     1   10 125.0  75.0  226      73
1401 33699 2019-06-23  45   1     1   20 129.0  80.0  241      65
1402 33724 2019-06-24  38   3     0    0 122.0  81.0  155      70
1403 33081 2017-02-16  41   1     1   20 114.0  72.0  223      NA
1404 32916 2018-11-11  34   2     1   40 118.0  77.0  184      NA
1405 34540 2018-12-17  43   2     0    0 129.0  95.0  285      74
1406 34106 2019-12-03  39   2     1   20 127.0  78.0  236      76
1407 32943 2019-01-31  62   1     1   30 138.5  85.0  373      67
1408 32201 2019-02-10  66   2     0    0 138.0  91.0  124      96
1409 34687 2018-07-19  40   3     0    0 108.0  72.0  240      NA
1410 33383 2018-02-12  57   2     0    0 134.0  84.0  245      NA
1411 34560 2018-03-10  38   2     0    0 117.5  77.5  227      NA
1412 32721 2017-06-13  57   1     1   20 131.5  92.0  262      78
1413 32652 2018-10-19  57   1     0    0 129.0  75.0  262      95
1414 32683 2019-03-31  60   3     0    0 123.0  73.0  213      79
1415 36935 2017-11-02  64   1     0    0 147.0  87.0  217      NA
1416 34576 2017-08-02  49   1     1   20 101.0  61.0  221      79
1417 34588 2017-03-13  66   1     0    0 197.0  91.0  273      80
1418 32364 2019-02-28  48   2     1   20 121.0  72.0  182      NA
1419 35562 2017-03-19  45   2     0    0 133.0  83.0  262      92
1420 36133 2017-06-12  56   1     0    0 138.0  97.0  215      69
1421 33875 2018-05-10  39   2     1   20 134.0  90.0  310      88
1422 35093 2017-10-07  41   1     0    0 121.0  84.0  197      NA
1423 35885 2018-08-27  40   2     1    5 120.0  87.0  282      NA
1424 35171 2018-03-20  40   4     0    0 145.0 100.5  213     117
1425 36451 2019-01-02  67   1     1    6 120.0  67.0   NA      NA
1426 32990 2017-04-01  44   3     1   30 140.0  87.0  363      79
1427 36146 2019-11-08  48   4     0    0 136.0  95.5  240      73
1428 32977 2017-06-29  43   1     1   40 135.0  86.0  212      75
1429 36423 2017-09-06  57   3     0    0 141.0  90.0  213      77
1430 35377 2018-07-12  51   4     1   10 110.0  72.0  231      81
1431 34661 2018-12-04  51   2     1   20 151.0  92.0  293      77
1432 32614 2019-10-16  38   4     1   15 179.5  97.0  267      67
1433 32864 2019-10-28  34   2     1   20 117.5  67.5  220      86
1434 32459 2018-11-29  50   2     0    0 100.0  70.0  216      73
1435 32414 2017-08-06  54   1     0    0 137.5  89.0  207      72
1436 35953 2017-11-22  48   1     1   15 132.0  91.0  170      57
1437 35860 2019-11-29  41  NA     0    0 128.0  84.0  260      48
1438 36431 2017-08-13  61   1     0    0 167.5  91.5  259      85
1439 35610 2017-05-01  56   1     0    0 113.0  83.0  220      86
1440 33686 2017-07-24  40   2     1   10 110.0  70.0  195      NA
1441 32729 2017-06-21  41   1     0    0 113.5  65.5  170      93
1442 33833 2017-06-22  42   3     1   30 133.5  97.5  240      73
1443 35812 2017-01-24  52   2     0    0 171.0 118.0  260      80
1444 35268 2018-06-22  55   1     0    0 132.0  81.0  257      86
1445 34044 2019-09-28  54   2     0    0 138.0  79.0  243      95
1446 36587 2018-02-07  64   4     0    0 123.0  81.0  210      75
1447 32576 2019-06-22  48   2     1   40 117.5  80.0  226      66
1448 36817 2019-04-15  44   1     0    0 114.0  79.0  195      76
1449 34434 2018-08-09  62   1     0    0 190.0  99.0  212     202
1450 35199 2018-11-07  38   3     0    0 126.5  75.5  240      64
1451 35056 2017-12-11  52   4     1   20 134.0  80.0  167     102
1452 34589 2018-01-13  44   1     1   10 141.0  76.0  310      90
1453 34330 2018-06-07  49   4     1   NA 127.5  81.5  256      85
1454 35324 2019-12-05  48   4     1   20 135.5  90.0  230      91
1455 33117 2017-06-16  56   1     1   17 127.0  79.0  177      88
1456 36662 2019-01-17  48   1     0    0 152.5  90.0  224      85
1457 36264 2018-05-29  58   2     0    0 150.0  80.0  240     255
1458 32898 2017-12-28  42   4     0    0 110.0  65.0  212      63
1459 32057 2019-03-21  53   2     1   20 153.0 108.0  215      70
1460 36064 2017-08-22  57   2     1   10 133.0  72.0  238     115
1461 32830 2018-05-04  46   3     1    1 130.0  82.0  241      93
1462 34736 2018-09-12  45   3     1   NA 145.5  99.0  170      85
1463 35211 2018-02-01  39   1     0    0 109.0  82.0  173      NA
1464 36492 2018-02-26  40   2     1   20 117.0  76.0  211      79
1465 34297 2019-07-08  61   1     0    0 108.5  71.0  193      NA
1466 36329 2019-04-11  68   1     0    0 130.0  62.0  237      82
1467 36713 2017-07-02  50   1     1   20 110.0  65.0  265      70
1468 34622 2019-12-30  55   1     0    0 131.0  96.0  250      80
1469 36163 2019-06-18  46   2     0    0 142.0  91.0  280      65
1470 32237 2017-11-21  63   1     1   15 112.0  80.0  197      76
1471 32517 2019-08-30  50   3     0    0 151.0 106.5  305      75
1472 32956 2019-07-28  65   1     0    0 141.0  82.5  221      93
1473 32101 2018-11-16  45   2     1   20 111.0  72.0  255      65
1474 32158 2018-04-19  42   1     0    0 105.0  84.0  197      67
1475 33374 2018-12-04  39   1     1   20 122.5  78.5  232      73
1476 36122 2019-07-01  37   2     1   30 115.0  79.0   NA      NA
1477 34841 2019-02-26  59   1     1    9 124.0  77.0  200      NA
1478 32823 2019-03-16  37   4     1   30 111.0  74.0  170      67
1479 35545 2018-02-18  40   2     0    0 106.0  82.0  173      83
1480 36455 2018-12-27  62   1     1   20 158.0  86.5  245      74
1481 35292 2018-09-19  57   1     0    0 153.0  85.0  432      75
1482 35787 2019-08-10  36   1     1   15 102.0  66.5  300     100
1483 33294 2018-05-11  48   2     0    0 134.0  84.0  274      80
1484 33495 2017-05-17  39   2     0    0 120.0  80.0  235      87
1485 33138 2017-04-08  59   1     0    0 142.0  79.0  410      90
1486 34844 2019-08-30  49   1     1   20 101.0  69.0  206      82
1487 32764 2018-10-18  61   1     0    0 121.0  81.0  267      95
1488 32240 2018-03-12  63   3     0    0 133.5  92.0  297      74
1489 36365 2017-06-22  42   2     0    0 160.5 100.0  236      74
1490 32566 2017-05-21  54   1     0    0 122.0  88.5  195      67
1491 36418 2019-12-03  65   2     0    0 155.0  84.0  240      91
1492 32930 2017-03-09  54   2     0    0 133.5  80.0  334      77
1493 36434 2019-12-31  60   1     0    0  95.5  59.0  260     160
1494 34472 2018-04-24  43   2     1   15 158.5 100.5  174      88
1495 36127 2018-05-19  56   1     1    7 159.0  91.5  222      80
1496 32462 2018-09-04  42   2     0    0 150.0  88.0  263      78
1497 33685 2018-02-17  48   4     0    0 149.0 100.0  293      76
1498 34176 2018-06-26  48   4     1    3 132.0  78.0  249     137
1499 32457 2019-06-09  35   2     1   20 132.0  91.0  225      83
1500 33851 2017-02-08  63   1     0    0 152.0  88.0  150     170
1501 35844 2018-06-05  42   1     1    9 109.5  67.0  218      71
1502 33462 2018-07-27  51   4     0    0 113.0  68.0  199      68
1503 35603 2019-07-01  67   1     1   15 155.0  90.0  285      77
1504 34963 2018-03-20  46   3     1   15 125.0  80.0  247      80
1505 34138 2019-10-03  51   1     1   40 122.5  73.0  212      74
1506 33406 2019-11-05  64   4     1    9 128.0  71.0  342      62
1507 36048 2017-09-17  58   1     0    0 141.0  73.5  251      96
1508 36951 2018-03-14  46   2     0    0 117.5  77.5  217      83
1509 32230 2017-03-23  55   2     0    0 143.0  82.5  256      90
1510 34095 2018-08-08  42   1     1   20 115.0  70.0  223      81
1511 32688 2017-03-04  55   1     0    0 170.0  92.0  232      74
1512 33215 2017-01-13  38   1     1   30 113.0  68.0  164      75
1513 32356 2018-08-26  64   3     0    0 102.0  61.0  227      81
1514 33650 2019-09-29  49   4     0    0 166.0  98.0  280      72
1515 36673 2019-02-19  42   3     1   15 115.0  72.0  212     100
1516 33853 2019-02-20  66   1     1    1 154.0  97.0  261      81
1517 35215 2017-02-01  46   1     0    0 150.0  81.0  219      93
1518 36444 2017-02-11  41   2     1    9 129.0  89.0  280      65
1519 35354 2017-01-16  45   3     1   30 140.0  94.0  270      80
1520 35853 2019-02-03  68   2     0    0 144.0  95.0  257      77
1521 33533 2019-10-22  45   2     1    3 130.0  80.0  250      86
1522 34537 2018-09-14  39   2     1   25 124.0  78.0  206      80
1523 32771 2019-11-15  44   1     1   40 120.0  80.0  200      74
1524 32323 2017-11-23  39   3     1   20 101.0  62.0  148      81
1525 34091 2018-12-06  53   1     0    0 140.5  90.0  202      74
1526 32819 2018-07-05  52   2     1   30 108.0  70.0  222      61
1527 34017 2019-12-09  62   1     1   20 129.5  87.0  168      80
1528 35349 2018-02-25  51  NA     1   15 180.0 107.5  240      80
1529 36902 2017-07-27  46   3     1   20 115.5  62.0  218      77
1530 32611 2017-09-02  40   2     0    0 116.0  75.0  208      82
1531 32207 2018-03-04  50  NA     0    0 126.0  88.0  200      76
1532 33516 2018-11-30  61   1     0    0 200.0 125.0  265     256
1533 35571 2017-03-12  37   3     1   20 119.0  62.5  254      69
1534 35467 2019-11-07  52   1     0    0 113.0  76.5  200      73
1535 36661 2018-04-24  51   2     1   20 139.0  74.0  227      67
1536 34842 2018-04-02  54   4     0    0 156.0  93.0  201      70
1537 34656 2018-12-08  43   2     1   55 131.0  85.0  264      67
1538 33658 2019-01-26  46   3     1   10 118.0  82.0  214      94
1539 32911 2017-10-20  49   3     0    0 160.5 109.0  267      75
1540 34004 2019-03-23  60   1     1   NA 140.0  80.0  269     100
1541 32818 2019-08-29  53   4     0    0 116.0  71.5  232      83
1542 34395 2018-04-10  44   4     1   35 143.5  90.0  198      NA
1543 32572 2017-08-26  43   1     0    0 105.0  59.5  245      77
1544 34326 2018-12-10  55   1     0    0 122.0  86.0  215      87
1545 36362 2019-09-28  58   2     1   20 165.0  94.5  231      80
1546 33094 2017-06-05  55   1     0    0 100.5  62.0  204      88
1547 33805 2017-12-21  47   1     1   30 112.0  66.0  210      84
1548 34068 2019-02-08  68   1     0    0 127.0  66.5  276     104
1549 34293 2019-02-08  56   1     0    0 180.0  90.0  296     120
1550 36286 2017-06-30  62   4     0    0 152.0  95.0  240      70
1551 32607 2017-02-21  62   2     1    3 123.0  77.0  286      86
1552 35803 2017-01-29  58   1     1    1 148.0  81.0  240      78
1553 36337 2019-04-08  60   3     0    0 172.5  85.0  286      71
1554 32998 2018-06-07  49   1     0    0 127.0  74.0  168      85
1555 33818 2018-10-01  51   1     1   25 117.0  70.0  327      76
1556 33000 2018-06-25  54   3     0    0 131.0  71.0  248      73
1557 35574 2018-08-07  53   4     0    0 164.0 111.0  243      70
1558 33680 2018-10-11  51   3     0    0 139.0  93.0  214      82
1559 36678 2018-04-11  64   1     0    0 176.0  97.0  194      89
1560 36154 2019-03-26  60   1     1    3 130.0  78.0  239      99
1561 32250 2017-02-10  56   3     1   20 124.0  75.0  307      84
1562 35995 2017-03-23  61   1     0    0 127.0  75.0  300      NA
1563 34977 2017-08-21  59   2     0    0 120.5  80.5  250      75
1564 34474 2018-12-05  40   2     0    0 128.0  81.0  192      76
1565 34903 2017-05-29  34   2     1   10  92.5  70.0  159      68
1566 34104 2018-01-10  59   1     1   60 153.5 105.0  298      84
1567 32285 2019-12-16  42   3     1   20 123.0  87.0  231      44
1568 34279 2019-08-16  37   4     1   60 122.5  82.5  254      83
1569 36018 2018-05-14  65   1     0    0 127.5  75.0  251      74
1570 32409 2019-03-21  62   1     1   20 145.5  87.5  270      67
1571 33619 2018-08-06  37   1     1   20 112.5  68.0  200      67
1572 36595 2018-09-12  40   2     1   30 129.0  76.5  162      73
1573 36017 2017-10-14  67   1     0    0 127.5  80.0  214      84
1574 35185 2017-03-27  63   4     1   20 135.0  80.0  248     118
1575 36267 2017-02-07  55   1     1   45 134.0  89.0  345      60
1576 34331 2018-01-29  64   4     1    6 143.0  84.0  239      73
1577 33080 2018-09-11  56   3     0    0 147.0  98.0  274      82
1578 35277 2017-07-12  53   1     1   20 167.0  96.5  186     113
1579 33006 2018-07-29  43   3     1   20 109.0  73.0  292      93
1580 35352 2017-05-12  47   4     0    0 115.0  82.0  194      76
1581 35445 2018-01-25  48   3     1    1 120.0  81.0  234      83
1582 36150 2019-04-21  58   1     1   15 156.0  86.0  264     103
1583 36993 2017-07-02  55   3     0    0 145.0  82.0  329      95
1584 33628 2019-02-22  45   3     0    0 118.0  84.0  237      78
1585 35688 2017-11-07  63   2     0    0 143.0  87.0  192     100
1586 34590 2018-10-26  41   2     1   15 107.5  68.0  235     113
1587 33014 2019-03-03  51   3     1   20 123.0  72.0  260      65
1588 35440 2017-08-04  37   4     1   30 120.0  72.0  210      97
1589 33348 2018-08-02  38   4     0    0 116.5  74.0  210      89
1590 32778 2019-10-13  55   4     1    9 155.0  84.0  263      60
1591 35132 2019-04-03  51   3     0    0 153.5 103.5  214      71
1592 34500 2019-08-12  43   2     0    0 130.0  80.0  237      NA
1593 35331 2018-02-02  41   4     1   43 124.0  86.0  252      70
1594 34508 2019-05-18  60   1     0    0 146.0  80.0  212      72
1595 34047 2019-07-29  57   2     1   20 127.0  75.0  205      65
1596 32945 2017-10-18  40   2     0    0 132.0  81.0  195      86
1597 34815 2018-07-02  42   2     0    0 132.0  82.0  233      71
1598 34869 2019-07-11  63   1     0    0 199.0 114.0  235      84
1599 32766 2017-08-19  58   1     0    0 139.0  96.0  333      78
1600 32624 2019-11-02  40   1     1    5 130.0  84.5  209     104
1601 36228 2017-12-15  42   1     1   30 127.0  90.0  240      69
1602 32117 2019-11-29  59   1     1   15 116.0  83.0  259      83
1603 33731 2017-12-08  58   2     0    0 121.0  75.0  220      76
1604 36648 2017-03-15  61   1     1   20 157.0  99.0  360      73
1605 33769 2018-11-01  60  NA     0    0 113.0  71.0  215      NA
1606 34833 2017-05-30  54   1     0    0 138.0  78.0  208      73
1607 36691 2018-05-29  41   2     1   40 124.5  86.5  242      67
1608 33418 2017-01-08  56   1     1    9 165.0 115.0  285     116
1609 36356 2018-04-25  38   4     1   10 142.0  93.0  226      63
1610 36960 2019-11-09  44   1     1    5 102.0  68.0  214      80
1611 32781 2017-11-16  47   2     1   18 145.0  74.0  439      90
1612 36130 2019-12-01  42   2     1   30 111.0  62.0  256      74
1613 32264 2018-07-01  61   1     1   10 187.0  95.5  200      64
1614 35425 2019-09-06  48   2     1   20 134.5  84.0  210      87
1615 32752 2019-06-03  50   3     1   30 190.0 110.0  320      71
1616 35082 2018-06-25  68   3     0    0 154.0  96.0  241      70
1617 34627 2019-09-07  56   1     1   15 108.0  70.0  195     117
1618 35013 2019-09-04  52   1     0    0 153.0 102.5  170      67
1619 34215 2018-06-11  44   1     1   20 131.0  81.5  160      70
1620 36123 2017-05-17  43   1     0    0 116.0  86.0  230      78
1621 35238 2017-04-26  39   2     1   20 131.5  85.0  323      93
1622 35263 2019-02-04  57   2     0    0 153.0  87.0  286      83
1623 34888 2018-07-01  39   3     0    0 126.0  80.0  221      80
1624 33863 2019-05-12  51   2     0    0 152.0  96.5  346      79
1625 36606 2018-05-22  64   1     1   30 114.0  73.0  185      97
1626 35774 2019-02-12  54   1     1    9 114.0  76.0  266      55
1627 36837 2019-09-08  45   1     1    5 140.0  94.0  272      79
1628 33356 2019-02-06  44   3     1   30 122.5  67.5  188      85
1629 36988 2017-07-18  46   4     1   20 101.0  71.0  259      73
1630 33998 2017-05-08  64   1     0    0 102.5  63.5  263      99
1631 36749 2017-12-02  47   3     1   20 128.0  85.0  215      90
1632 33872 2018-03-15  42   2     0    0 101.0  75.0  206      84
1633 34915 2019-11-11  54   4     0    0 122.5  77.5  226      71
1634 35652 2018-09-07  44   2     1   20 167.5  92.5  270      77
1635 35575 2017-12-19  38   1     0    0 124.0  78.0  293      76
1636 35752 2017-06-05  43   1     1   15 115.0  77.5  210      68
1637 35717 2017-10-06  54   1     0    0 110.0  67.5  223     294
1638 35214 2019-08-09  48   3     0    0 127.0  81.0  193      70
1639 36757 2018-10-09  55  NA     0    0 129.0  86.5  222      92
1640 34390 2019-02-24  42   2     0    0 118.0  80.0  238      76
1641 34309 2019-02-08  56   3     0    0 119.0  80.0  286      78
1642 32007 2019-11-27  45   1     0    0 124.0  72.5  290      87
1643 36819 2019-05-23  59   1     1   43 117.0  73.0  162      87
1644 33485 2018-07-06  62   1     1   20 111.0  67.0  185      77
1645 36511 2019-08-24  48   2     1    2 164.0 120.0  306      74
1646 36059 2017-03-28  58   2     0    0 105.5  74.0  225      93
1647 36417 2017-09-26  61   1     0    0 142.0  93.0  220      79
1648 32316 2018-09-19  59  NA     1   20  93.5  69.0  190      74
1649 32754 2017-03-25  57   1     0    0 146.0  94.0  263      NA
1650 32357 2019-02-19  40   2     1    9 105.0  60.0  193      85
1651 36219 2018-04-01  64   1     1   30 136.5  85.0  241      77
1652 33430 2018-11-11  37   1     1   30 127.0  85.0  189      84
1653 32642 2019-02-06  39   2     0    0 117.5  77.5  203      60
1654 35503 2017-02-26  52   4     0    0 142.0  87.0  309     110
1655 35801 2018-03-21  50   2     0    0 114.0  75.0  252      69
1656 34101 2019-12-18  64   1     0    0  94.0  62.0  185      68
1657 32715 2017-03-13  64   3     0    0 145.0  87.0  226      77
1658 32208 2018-10-20  38   2     1   20 124.0  87.0  279      75
1659 32262 2018-10-27  57   1     1   30 122.0  66.5  211      57
1660 32021 2018-04-24  40   1     0    0 110.0  67.5  206      80
1661 34539 2018-12-20  40   2     0    0 127.0  79.0  234      92
1662 36706 2018-07-29  44   4     1   25 103.0  78.0  210      77
1663 32986 2017-04-25  44   2     1   15 127.0  86.0  209      88
1664 36905 2019-07-04  42   3     1   20 129.0  91.5  193      74
1665 33101 2019-09-27  46   2     0    0 115.0  72.5  213     107
1666 35399 2017-02-07  47   1     0    0 139.0  79.0  259      71
1667 32303 2018-01-04  38   1     1   10 114.0  73.5  220      67
1668 36946 2019-01-31  49   4     1   30 137.0  96.5  240     118
1669 35443 2019-04-08  52   2     1   NA 157.0 112.0  292      84
1670 32198 2018-09-29  49   1     0    0 115.5  72.5  225      NA
1671 34360 2019-05-20  59   1     1    3 145.0  88.0  201      89
1672 34552 2018-12-15  43   2     1   43 126.0  79.0  240      40
1673 36276 2019-09-30  57   1     1   20 127.5  80.0  250      80
1674 35611 2018-09-22  57   1     0    0 184.0 106.0  233      40
1675 35573 2019-12-25  60   1     0    0 145.0  81.0  270      73
1676 35606 2017-09-06  41   2     0    0 132.0  85.5  298      90
1677 32077 2019-12-06  41   2     0    0 102.0  64.0  168      75
1678 32995 2018-07-07  59   4     0    0 195.0 118.0  240      73
1679 34706 2019-12-19  56   1     0    0 128.5  75.0  243      89
1680 35003 2017-04-29  42   2     1    9 126.0  81.0  195      77
1681 33234 2017-12-20  45   2     0    0 130.0  80.0  229      77
1682 35053 2019-03-01  55   2     1    3 108.5  63.5  252     121
1683 33948 2018-03-04  40   2     1   20 112.5  62.5  242      70
1684 35239 2019-12-08  53   4     0    0 113.0  84.0  241      73
1685 34542 2019-06-15  63   4     0    0 130.0  72.0  207      81
1686 34828 2018-12-21  65   1     1    3 122.0  68.0  194      73
1687 32769 2018-11-29  53   2     0    0 148.0  88.0  366      NA
1688 32694 2018-04-30  40   2     1    5 130.0  86.5  193      78
1689 33955 2018-12-17  38   2     0    0 115.0  60.0  169      60
1690 36457 2019-09-17  40   1     0    0 105.0  74.0  187      69
1691 36929 2019-02-12  67   1     0    0 157.0  89.0  254      74
1692 33296 2017-12-15  43   2     0    0 131.0  81.0  266      94
1693 33831 2017-01-27  39   3     0    0 119.0  84.0  195      73
1694 36045 2017-02-15  46   4     1    9 137.5  94.0  260      78
1695 32656 2018-11-25  50   4     1   30 113.0  79.0  199      64
1696 36181 2017-01-06  50   1     0    0 144.0  88.0  189      87
1697 33643 2019-04-27  43   2     1   20 132.5  85.0  226      58
1698 32790 2017-02-26  51   1     0    0 160.0  90.0  227      57
1699 32341 2019-09-28  35   2     0    0  98.5  69.5  170      77
1700 36873 2019-10-30  55   1     0    0 106.0  77.0  328      NA
1701 33943 2018-07-23  44   1     0    0 141.5  93.0  263      74
1702 34405 2017-12-26  55   3     1   15 121.5  81.5  215      98
1703 35522 2017-07-20  59   3     0    0 154.0 100.0  296      73
1704 34896 2019-02-21  44   4     1   43 127.0  82.5  275      76
1705 33005 2017-03-22  40   2     1    9 115.0  72.0  240      68
1706 35334 2018-06-19  59   2     0    0 131.5  84.0  237      94
1707 34596 2018-04-12  43   2     0    0  96.0  62.0  213      80
1708 33053 2019-07-23  55   4     0    0 133.0  78.0  245     115
1709 35090 2017-01-14  63   1     0    0 193.0 104.0  246      73
1710 35886 2018-02-08  49  NA     0    0 107.0  73.0  246      80
1711 36062 2018-08-01  44   3     0    0 146.0  91.0  243     104
1712 34943 2019-08-07  43   2     0    0 141.0  89.0  200     105
1713 35986 2017-10-17  43   2     0    0 147.5  92.0  177      90
1714 33231 2019-06-30  55   1     1    5 135.0  95.0  240     108
1715 35032 2017-10-20  59   1     0    0 132.0  80.0  225      88
1716 33885 2018-09-14  50   2     1   20 121.0  78.0  235      78
1717 34654 2019-02-14  65   1     0    0 127.5  67.5  308     366
1718 32951 2018-08-10  55   1     0    0 144.5  83.5  245      65
1719 35961 2017-07-15  38   2     1    9 127.0  80.0  196      NA
1720 33029 2018-11-13  42   3     0    0 122.5  75.0  188      68
1721 33877 2018-12-23  60   4     0    0 165.0  77.0  232      57
1722 36820 2018-11-23  39   1     0    0 138.0  89.0  227      60
1723 32598 2019-11-12  63   1     0    0 148.0  75.0  275      83
1724 35662 2019-01-02  46   4     1   20 108.0  74.0  233      82
1725 35940 2017-02-19  51   1     1   20 168.0 102.0  239      68
1726 35820 2019-04-28  39   3     0    0 114.0  66.5  152      71
1727 36780 2019-11-10  46   3     0    0 154.0  98.0  230      90
1728 35096 2018-05-10  45   4     1   20 164.0  98.0  271      81
1729 35881 2017-08-15  53   3     0    0 114.0  80.0  228      75
1730 36381 2018-01-12  57   3     1   15 132.0  77.0  245     207
1731 35955 2017-11-12  55  NA     0    0 142.0  92.0  262      82
1732 35343 2019-09-24  56   4     0    0 123.0  86.0  296      63
1733 34880 2018-06-11  41   1     1   20 151.0  85.0  260      91
1734 33514 2018-06-30  35   4     1    3 100.0  66.5  185      75
1735 36754 2018-02-04  58   3     0    0 160.0 120.0  188      85
1736 35894 2019-04-01  58   4     0    0 139.0  81.5  320      82
1737 35552 2018-04-17  47   2     1   30 107.0  69.0  175      70
1738 35505 2019-02-01  45   3     0    0 126.0  82.0  258      70
1739 33974 2018-10-25  44   2     1   20 108.0  70.0  157      82
1740 32732 2018-01-03  48   4     1   17 132.0  81.0  299      70
1741 34115 2019-03-13  60   1     0    0 132.0  82.0  275      62
1742 33609 2017-10-15  38   1     1   10 115.0  71.0  219      93
1743 32746 2019-08-13  65   2     0    0 122.0  81.0  238     150
1744 36432 2019-04-10  43   1     0    0 127.0  79.5  260      77
1745 35356 2018-06-17  59   1     0    0 144.5  91.5  274      63
1746 36128 2019-04-04  67   1     0    0 138.0  76.0  256     100
1747 32205 2018-04-25  51   1     1   30 118.0  79.0  241      56
1748 34356 2019-02-03  58   1     1   20 127.5  70.0  184      80
1749 32880 2019-06-24  62   1     0    0 138.0  82.0  261      77
1750 34623 2017-05-09  39   1     1   60 112.0  65.0  215      78
1751 32465 2019-09-09  42   3     0    0 118.5  74.5  260      75
1752 34712 2018-07-30  54   2     1   30 113.0  70.0  219      53
1753 34826 2017-09-24  50   1     1   30 128.5  82.0  203      84
1754 36053 2018-08-07  62   1     0    0 146.0  82.5  309      71
1755 34558 2018-01-17  44   4     1   20 138.0  98.0  230      93
1756 36218 2017-04-23  65   4     1    6 118.5  77.5  236      65
1757 32670 2019-04-28  63   3     0    0 156.0  90.0  315      74
1758 35897 2017-03-22  45   1     1    3 128.0  82.0  280      62
1759 32655 2019-08-01  56   2     0    0 126.5  74.5  220      80
1760 34365 2018-11-01  48   2     1   43 144.0  88.0  209      60
1761 33661 2019-04-22  61   1     0    0 160.0  96.0  218     223
1762 33362 2018-03-28  46   1     1   43 121.0  78.0  262      72
1763 36721 2019-02-13  61   1     1    9 134.5  87.0  259      91
1764 33115 2017-03-31  63   1     1   20 168.0  98.0  260      73
1765 36335 2018-10-09  42   2     1   30 129.5 100.0  270      88
1766 32025 2019-04-14  62   2     0    0 160.0  90.0  326      84
1767 36611 2018-01-07  41   2     1    9 124.0  76.0  200      86
1768 36619 2019-12-29  35   2     0    0 122.5  72.5  208      NA
1769 34638 2019-07-19  59   1     0    0 127.5  85.5  276      60
1770 33874 2018-10-12  55   3     1   20 196.0 103.0  250      75
1771 32545 2017-10-09  52   3     1   15 131.0  74.0  225      77
1772 36004 2019-01-04  55   1     0    0 134.0  92.0  273      67
1773 35624 2019-01-13  38   3     1   20 112.0  73.0  175      71
1774 32707 2017-09-09  41   2     1   10 119.0  72.0  169      74
1775 32573 2017-05-25  45   2     0    0  98.0  74.0  260      76
1776 35907 2018-03-16  64  NA     0    0 185.0  97.5  218      79
1777 34613 2017-05-11  40   4     1   30 146.0  93.5  267      89
1778 32468 2018-02-15  38   4     0    0 124.0  82.0  328      69
1779 36528 2018-05-12  38   2     1    7  95.0  65.0  160      77
1780 32743 2017-02-06  48   3     1   20 129.0  81.0  259      65
1781 36102 2018-10-26  57   1     0    0 175.0  80.0  207      75
1782 34908 2019-07-15  39   2     1   20 120.0  77.5  285      79
1783 32224 2018-05-09  42   3     1   NA 122.5  80.0  225      90
1784 34440 2017-01-31  54   3     0    0 137.0  84.0  292      94
1785 36389 2018-05-23  55   2     0    0 158.0  98.0  285      88
1786 35301 2019-04-01  40   2     1   20  99.0  59.0  176      78
1787 32413 2017-02-12  43   3     1   20 114.0  78.0  202      87
1788 32915 2018-04-12  46   2     1    5 115.5  65.0  174      80
1789 32989 2019-04-12  60   1     0    0 160.5  96.0  278      75
1790 35286 2019-11-17  49   2     1    9 106.0  71.0  226      57
1791 33372 2017-09-30  48   2     1   20 130.0  73.0  211      NA
1792 35924 2017-12-13  41   2     1   43 152.0  90.0  274      65
1793 36427 2018-09-10  43   3     0    0 115.0  82.5  263      NA
1794 32657 2019-02-28  55   1     0    0 127.5  83.5  250      73
1795 34375 2019-07-29  51   2     0    0 123.0  80.0  238     100
1796 36927 2018-10-05  61   1     1    5 139.0  67.0  222      72
1797 34066 2017-01-16  44   4     0    0 120.0  81.0  201      78
1798 35661 2019-11-06  56   4     1   30 136.5  97.0  303     106
1799 32374 2018-07-11  50   1     1   20 126.0  84.0  329      65
1800 36534 2019-10-22  40   2     0    0 126.0  85.0  196      96
1801 34237 2019-08-11  53   1     1   30 106.0  67.5  244      65
1802 36535 2019-11-18  62   1     0    0 144.0  80.0  208      66
1803 33181 2018-02-07  47  NA     0    0 128.0  80.0  240      64
1804 33457 2019-01-03  37  NA     0    0 119.0  79.0  200      87
1805 35969 2019-09-13  43   4     1   20 110.0  74.5  171      85
1806 36797 2018-07-24  45   4     1    3 145.0  90.0  218      70
1807 34655 2017-12-02  48   2     1    5 175.0 110.0  150      NA
1808 34756 2018-11-14  40   3     1   35 133.0  80.0  185      58
1809 35578 2019-08-27  39   4     1    9 119.0  78.0  191      73
1810 34317 2019-07-08  53   1     0    0 177.0  75.0  212     285
1811 36207 2017-11-04  41   1     1   25 108.0  73.0  172      73
1812 32698 2019-12-30  51   4     1   10 112.0  83.0  240      77
1813 33611 2018-02-23  46   2     1   20 110.0  73.0  214      60
1814 34268 2018-11-28  59   1     0    0 141.0  78.0  261      76
1815 35981 2018-05-30  47   1     0    0 118.0  84.0  228      90
1816 33841 2019-08-16  40   1     1   20 107.0  74.0  187      67
1817 32934 2018-01-28  37   1     1   20 117.0  74.0  168      77
1818 35089 2017-05-08  45   1     1   20 118.0  71.0  212      83
1819 33716 2019-02-14  49   4     1   40 118.5  82.0  222      87
1820 36612 2017-09-27  47   3     0    0 109.0  72.5  294      77
1821 32131 2017-09-21  46   4     0    0 107.5  80.0  190      75
1822 33034 2019-04-29  52   4     1   20 110.0  70.0   NA      NA
1823 32806 2019-06-07  58   1     0    0 153.0 106.0  241      84
1824 34283 2017-04-07  57   4     0    0 181.0 112.5  328      94
1825 35490 2019-09-07  35   1     1   40 167.5 104.5  265      NA
1826 35754 2017-02-15  56   1     1   20 117.5  72.5  212      75
1827 34716 2017-10-15  51   1     1    9 115.0  67.0  255      58
1828 34985 2019-07-06  45   1     0    0 107.5  80.0  285      NA
1829 35485 2017-08-02  51   2     0    0  98.0  64.5  220      79
1830 36676 2019-10-06  37   1     1    1 197.5 125.0  274      94
1831 36234 2019-07-29  40   3     1    5 125.5  80.0  143      95
1832 36409 2019-07-26  55   2     0    0 165.0 106.0  293      79
1833 34402 2018-03-01  42   4     0    0 110.0  73.0  225      65
1834 33743 2019-05-16  45   3     1   40 135.0  84.0  278      79
1835 32491 2017-11-20  57   1     1   10 148.0  91.0  250     103
1836 34203 2019-07-18  44   4     1   10 107.0  70.5  170      NA
1837 35631 2019-07-15  60   1     0    0 146.0  89.0  170      81
1838 34958 2018-12-06  53   1     1   20 163.5  87.0  181      71
1839 35978 2017-03-06  46   3     1    1 162.5  92.5  332      67
1840 35783 2019-09-20  60   2     1   NA 112.0  74.0  228      NA
1841 33467 2017-12-24  66   3     0    0 193.0 132.0  280      73
1842 33342 2018-10-23  56   2     1   15 142.0  66.0  214      94
1843 34412 2017-01-06  38   2     1   20 117.5  67.5  229      80
1844 36874 2018-12-30  60  NA     1   20 138.5  87.5  212      73
1845 35904 2019-06-10  62   3     0    0 163.0  89.0  180      83
1846 34352 2019-04-10  38   1     1    9 114.0  80.0  305      71
1847 32395 2019-03-22  45   2     1   NA 121.0  72.0  248      88
1848 33017 2019-02-28  39   2     1   20 134.0  92.0  230      56
1849 36342 2019-02-25  58   1     1   20 180.0 100.0  260      NA
1850 33981 2019-09-26  40   1     1    9 118.0  78.0  239      75
1851 33033 2018-09-15  46   3     1    6 165.0  85.0  315      91
1852 33984 2018-02-05  38   2     0    0 127.5  81.0  224      90
1853 36735 2018-12-29  39   3     1    3 114.0  77.0  186      85
1854 35452 2019-03-05  63   1     0    0 193.0  63.0  293      76
1855 32324 2019-11-10  48  NA     0    0 138.0  96.0  202      85
1856 35491 2018-01-10  49   3     0    0 120.0  70.5  241      84
1857 36171 2017-06-30  41   4     1   30 109.0  74.0  289      86
1858 34366 2017-02-12  60   1     0    0 140.5  89.0  279      69
1859 34289 2017-03-08  60   1     0    0 197.5 105.0  352      95
1860 33334 2018-11-10  43   4     0    0 100.0  70.0  223      68
1861 34408 2019-03-24  50   1     0    0 107.5  74.0  281      79
1862 33623 2017-03-17  53   1     1   50 127.0  82.5  306      NA
1863 33509 2019-08-06  55   2     0    0 136.0  93.0  198      83
1864 33441 2018-02-15  50   2     1   20 123.0  83.0  275      64
1865 34608 2018-09-14  35   2     0    0 107.5  70.0  234      NA
1866 33174 2017-12-14  47   1     0    0 133.0  93.0  205      60
1867 32361 2019-08-25  57   1     1   20 139.0  82.0  252      70
1868 35792 2017-08-16  44   1     1   10 105.0  70.0  220      68
1869 34771 2017-06-21  49   3     0    0 119.0  85.5  286      72
1870 36397 2018-09-08  62   3     1    5 178.0 127.0  310      79
1871 35486 2019-03-13  64   3     0    0 146.0 106.0  270      77
1872 32225 2018-09-01  51   2     1   20 108.0  75.0  274      68
1873 33164 2019-04-19  46   3     1    5 107.5  65.0  291      78
1874 35174 2018-12-19  58   1     0    0 141.5  87.0  296      NA
1875 36978 2019-03-25  56   1     0    0 134.0  86.0  243      66
1876 35183 2017-03-11  66   1     0    0 193.0  95.0  263      94
1877 32847 2018-01-24  42   1     0    0 120.0  81.0  214      77
1878 34693 2019-04-27  63   1     1   15 165.0 100.0  207      77
1879 35300 2017-12-28  61   1     0    0 185.0 121.0   NA      NA
1880 34790 2017-05-31  59   1     1    5 126.5  79.0  254      77
1881 36424 2018-05-20  56   2     1   25 130.5  82.0  273      91
1882 36800 2018-08-11  40   3     1   20 112.5  77.5  237      84
1883 34852 2019-04-21  43   2     1   20 111.0  76.0  275      65
1884 36167 2017-01-07  35   2     0    0 109.0  73.0  197      95
1885 33756 2017-11-23  50  NA     1   15 132.0  84.5  253      73
1886 33235 2018-11-19  64   4     0    0 114.5  65.5  239      NA
1887 33268 2018-09-07  35   2     0    0 104.0  61.0  274      68
1888 33455 2017-10-07  56   3     0    0 113.0  61.0  254      87
1889 34398 2019-09-03  43   1     1   20 115.0  80.0  200      81
1890 33793 2017-11-21  46   3     1   15 158.0  97.0  274      78
1891 34822 2018-05-11  46   3     1   20 119.0  65.0  267      75
1892 35276 2019-12-21  46   2     1    3 128.0  71.0  214      66
1893 35416 2018-05-26  40   2     1   20 131.0  81.0  186      87
1894 33156 2018-07-07  51   1     0    0 154.0  98.0  216     103
1895 32162 2018-05-07  42   1     1   20 111.0  81.0  171      77
1896 33808 2018-06-27  54   3     0    0 155.0  92.5  248      66
1897 36013 2017-07-10  47   3     1    9  98.0  73.0  250      88
1898 35636 2017-09-06  65   2     1   20 192.5 110.0  212      71
1899 34210 2018-08-18  51   1     1   20 122.0  72.0  195      64
1900 35825 2019-01-13  68   1     1    4 154.5  83.0  178      86
1901 35484 2017-11-07  38   3     1   23 128.0  80.0  165      85
1902 33044 2018-04-03  39   3     0    0 118.0  84.0  240      75
1903 35165 2019-09-04  58   3     0    0 145.0  94.0  232      80
1904 33450 2019-01-20  57   1     0    0 111.0  80.0  207      70
1905 32606 2017-05-14  59  NA     0    0 112.5  75.0  298      89
1906 35874 2019-06-10  61   4     0    0 120.0  67.0  204      75
1907 34055 2019-02-04  56   1     1   15 121.0  75.0  269      66
1908 36975 2017-10-30  63   3     1    9 116.0  83.0  176      75
1909 35779 2019-01-02  47   4     1   20 120.0  77.5  261      NA
1910 34778 2018-02-24  41   1     0    0 129.5  92.5  324     103
1911 32309 2017-03-14  39   4     1    9 118.0  74.0  271      76
1912 36494 2018-09-07  42   3     1   10 116.0  72.5  175      95
1913 32451 2019-07-12  62   1     0    0 121.5  77.5  224      NA
1914 34065 2017-11-11  50   2     1   20 110.0  74.0  265      88
1915 33988 2017-08-31  58   1     0    0 170.0 104.0  268      75
1916 32192 2017-10-29  39   4     1    9 113.0  73.0  180      73
1917 36307 2017-07-20  35   2     1   20 122.5  76.5  234      85
1918 35833 2018-10-07  43   2     1   15 113.0  79.0  165      72
1919 36700 2019-05-31  38   2     0    0 106.5  75.0  215      67
1920 33586 2018-03-22  43   2     0    0 144.5  95.0  245      45
1921 34644 2017-09-01  49   3     0    0 116.0  76.0  210      71
1922 34799 2019-09-29  43   4     1    9  95.5  70.0  207      79
1923 36039 2017-07-16  62   1     0    0 184.0  90.0  231      75
1924 36055 2018-08-15  67   2     1   15 166.0  85.0  371      86
1925 33780 2018-11-04  39   1     1   40 134.0  82.0  209      75
1926 35941 2017-05-30  44   1     0    0 125.5  82.5  197      50
1927 35242 2019-06-23  43   2     1   40 137.0  87.0  188      73
1928 35023 2017-12-17  49   2     1   40 148.0  85.0  240      68
1929 32055 2018-04-03  48   3     0    0 129.0  84.5  230      NA
1930 32135 2019-10-02  54   1     0    0 107.5  67.5  205      88
1931 33206 2019-02-21  60   1     1    9 108.5  73.5  235     102
1932 32765 2018-08-09  37   3     1   30 128.0  84.0  243      NA
1933 35902 2017-04-24  58   1     0    0 128.0  83.0  200      80
1934 34374 2018-06-30  62   1     0    0 156.0 105.0  312      82
1935 34640 2019-03-09  41   2     1   20 126.5  82.0  264      78
1936 33582 2017-01-22  49   1     1    1 108.0  70.0  185      58
1937 35926 2018-11-23  42   2     1   20 114.5  76.0  184      59
1938 32718 2018-02-02  54   1     1    3 121.0  79.0  173      68
1939 35845 2018-08-09  53  NA     0    0  96.0  72.0  185      82
1940 36503 2017-06-26  38   2     1   15 123.0  76.0  150      82
1941 35058 2018-10-16  49   2     1   20 130.0  80.0  346      77
1942 35435 2019-12-13  67   3     1    1 172.0  84.0  242     111
1943 34311 2017-05-04  38   1     1    9  90.0  70.0  224      57
1944 35370 2019-10-03  51  NA     1   20 128.0  80.0  168      93
1945 35903 2018-01-25  45   3     0    0 128.5  87.5  230      62
1946 35453 2018-02-13  41   1     0    0 120.5  85.5  255      79
1947 36782 2018-08-24  36   1     0    0 100.0  61.5  211      73
1948 34337 2018-06-21  60   1     0    0 114.0  64.0  391      83
1949 34525 2018-05-21  61   4     0    0 126.0  73.0  233      62
1950 34691 2019-05-08  42   3     1   25 121.5  74.0  256     115
1951 35719 2018-06-15  38   2     0    0 109.0  75.0  150      67
1952 35550 2017-04-26  57   1     0    0 148.0  89.5  277      89
1953 32908 2018-01-26  45   1     0    0 130.0  80.0  213      75
1954 32507 2019-02-21  49   2     0    0 136.0  90.0  221      80
1955 36638 2019-07-26  50   1     1   20 112.0  69.0  221      79
1956 32913 2018-02-01  38   2     0    0 135.0  90.0  199      85
1957 32289 2019-05-09  48   2     0    0 183.0 108.0  336      96
1958 36981 2018-11-26  40   1     0    0 115.0  83.0  204      76
1959 36701 2019-05-06  45   1     0    0 124.0  89.0  252      71
1960 34011 2018-06-16  60   4     1   12 135.0  75.0  233      60
1961 35889 2017-09-15  57   2     1    1 122.0  69.0  245      92
1962 35745 2018-07-21  42   2     0    0 136.0  88.0  196      78
1963 33008 2018-10-29  42   2     1    9 115.5  79.0  281      71
1964 32875 2017-05-01  58   2     0    0 132.0  67.0  190      70
1965 36253 2019-08-26  39   4     0    0 106.0  70.0  195      77
1966 35095 2019-03-27  46   1     0    0 119.0  86.0  325      64
1967 36074 2018-08-22  57   4     0    0 147.5  90.0  310      73
1968 32602 2017-03-10  45   1     0    0 128.0  90.0  218      77
1969 34340 2018-09-17  56   4     0    0 149.0  98.0  287      75
1970 33336 2017-05-24  59   3     1   40 116.0  66.0  279      79
1971 34003 2017-05-02  63   1     0    0 123.0  66.0  238      98
1972 32618 2019-10-24  55   1     0    0 154.0  88.5  214      90
1973 36481 2018-08-19  41   2     0    0 125.0  83.0  237      61
1974 33185 2018-10-26  59   1     1   20 175.0  95.0  270      76
1975 35987 2019-02-20  52   1     0    0 141.0  85.0  208      68
1976 34936 2017-11-26  47   3     1   20 116.5  81.0  221      75
1977 33922 2018-01-29  42   4     1    6 120.0  70.0  219      73
1978 36466 2018-09-17  41   3     1   30 154.0 100.0  187      78
1979 34526 2019-07-26  59   3     1   20 187.0  97.0  206      69
1980 36028 2018-01-01  57   2     1   NA 120.0  79.0  270      81
1981 35260 2018-10-11  53   3     0    0 135.0  87.0  280      80
1982 35794 2019-04-29  44   2     1    3 103.0  67.0  239      73
1983 35386 2017-05-09  43   1     0    0 155.0  93.5  249     115
1984 32789 2017-01-04  63   1     0    0 167.0 100.0  361     103
1985 34070 2018-06-22  40   2     1   20 112.0  67.0  261      61
1986 33177 2017-09-12  41   2     1   10 134.5  83.0  193     127
1987 32320 2017-11-04  45   1     1   20 118.5  81.0  264      90
1988 36211 2018-04-18  44   3     1   15 124.0  83.0  237      88
1989 36372 2018-06-22  60   2     1    9 150.5  90.0  280      NA
1990 36624 2018-10-19  51   1     0    0 102.0  71.5  244      77
1991 36684 2018-09-16  48   3     0    0 116.0  82.0  243      85
1992 35454 2019-11-09  48   1     0    0 112.0  77.0  251      88
1993 36665 2018-09-01  42   2     1   18 126.0  73.0  219      65
1994 34905 2018-07-09  45   2     1   20 138.0  86.0  279     144
1995 33470 2018-06-04  56   1     0    0 133.0  76.0  207      85
1996 33225 2019-02-18  41   3     0    0 103.0  72.5  192      70
1997 35250 2018-09-06  55   1     1   40 130.0  85.0  242      93
1998 34257 2018-05-03  60   2     1   20 112.5  75.0  305      98
1999 32609 2017-11-13  43   4     1   25 126.0  88.5  245      NA
2000 34651 2019-12-27  69   3     0    0 166.0  90.0  203      80
2001 32031 2017-05-13  42   3     1    5 122.0  76.0  152      78
2002 34688 2018-01-02  39   2     1   20 120.0  80.0  240      75
2003 33537 2019-11-04  44   2     1    5 130.0  80.0  175     117
2004 33991 2019-12-07  38   2     1   30 123.5  84.5  255      88
2005 34846 2017-04-21  64   1     1   15 141.0  76.0  240      60
2006 36357 2018-05-10  46   1     0    0 136.5  92.0  235      89
2007 36953 2017-06-25  40   2     1   30 128.0  83.0  165      60
2008 32791 2019-06-03  47   2     1    5 128.0  81.0  236      93
2009 35422 2018-05-19  65   1     0    0 119.0  76.0  246     156
2010 34294 2018-03-16  43   4     0    0 125.0  80.0  179      NA
2011 36500 2018-04-25  37   4     0    0 122.0  81.0  253      93
2012 34347 2019-06-11  36   4     0    0 133.0  88.0  234     100
2013 36233 2019-05-26  63   2     0    0 176.0  99.0  264      65
2014 35426 2017-06-24  61   1     0    0 143.0  96.0  206      87
2015 34250 2017-06-15  67   1     1   15 185.0 100.0  204     114
2016 33952 2019-09-12  44   2     1   20 129.0  88.0  243      83
2017 33432 2017-07-12  56   1     0    0 123.0  77.0  280      NA
2018 34605 2017-07-17  62   2     0    0 165.0  91.0  304      81
2019 36149 2019-09-11  45   1     1    5 109.5  69.0  170      66
2020 36668 2018-09-03  40   2     0    0 122.0  94.0  204      82
2021 32674 2018-10-09  43   1     0    0 124.0  79.0  229      77
2022 34497 2018-05-03  50   3     0    0 148.5  94.0  232      88
2023 35786 2018-01-25  43   4     1   25 137.0  90.0  296      97
2024 36390 2017-04-14  56   2     0    0 185.0 107.5  290      84
2025 35516 2018-03-25  50   2     0    0 132.0  81.0  225     103
2026 32506 2017-05-30  42   1     1   20 120.0  83.0  182      87
2027 33252 2018-03-31  39   2     1   20 122.0  72.0  149      75
2028 36449 2017-06-25  40   2     0    0 109.0  71.0  162      85
2029 35735 2019-02-12  56   1     1   20 200.0 120.0  217      72
2030 36552 2017-02-04  47   2     1   20 126.0  86.0  200      96
2031 32137 2017-12-07  37   4     0    0 117.5  77.5  169      NA
2032 32857 2017-10-11  35   2     1   20 106.0  73.0  227      79
2033 34438 2017-06-14  64   2     0    0 166.0  90.0  266      87
2034 34168 2019-12-22  36   3     0    0 112.5  73.5  230      65
2035 34919 2018-01-24  63   4     1   25 192.5 125.0  203      83
2036 34051 2019-06-01  47   1     1   15 125.0  72.0  206      74
2037 35257 2018-07-25  39   1     1   10  95.0  59.0  226      83
2038 35114 2019-10-18  58   1     0    0 157.0  94.0  267     205
2039 33989 2019-09-26  40   4     1   43 135.0  93.0  258      57
2040 35065 2017-11-22  39   4     1   30 108.0  75.0  255      70
2041 32054 2019-08-12  34   2     0    0 112.5  77.5  226      72
2042 32515 2019-04-21  44   1     0    0 135.0  81.0  175      NA
2043 36360 2019-05-30  50   3     0    0 126.5  84.0  208      79
2044 35647 2019-07-05  63   1     1    9 140.0  86.0  248      NA
2045 33250 2018-05-31  39   2     1   15 132.5  80.0  256      97
2046 35771 2018-04-02  38   3     1    5 118.0  78.0  187      63
2047 36445 2018-10-25  44   2     1   40 130.0  90.0  189      64
2048 35943 2017-04-12  52   1     0    0 177.0 111.0  258     270
2049 35543 2018-05-02  57   1     1    3 126.5  80.0  235      72
2050 34045 2019-02-02  57   2     0    0 116.0  83.0  274      83
2051 34956 2018-11-13  61   2     1   20 128.0  87.0  231      93
2052 34639 2017-01-23  61   2     0    0 155.0  71.0  224      86
2053 33475 2018-01-26  63   4     0    0 148.0  93.0  261      75
2054 34319 2018-12-18  42   2     1   30 108.0  70.5  190      85
2055 33293 2018-02-09  36   1     1   20 126.0  77.0  252      63
2056 33734 2018-11-23  53   1     0    0  92.0  69.0  225      68
2057 36918 2018-06-15  41   4     1    5 122.5  90.0  209      NA
2058 35638 2017-09-12  40   1     1    5 120.0  73.5  155      78
2059 33380 2017-08-21  62   1     1   20 127.5  75.5  188      72
2060 32311 2018-10-10  59   3     1   15 137.0  83.5  342     140
2061 35479 2017-08-07  45   1     0    0 128.0  79.0  258      75
2062 35419 2017-01-30  50   2     1   30 133.0  88.0  249      75
2063 33051 2018-10-07  43   1     1   20 133.5  89.5  206      89
2064 33985 2019-09-27  53   2     0    0 142.0  89.0  193      78
2065 34610 2018-09-05  45   1     0    0 120.0  80.0  285      93
2066 35153 2018-10-19  51   3     1   20 126.0  78.0  163      78
2067 32513 2019-04-13  59   1     0    0 122.0  70.0  294     100
2068 34704 2018-05-07  54   1     1   30 131.0  84.0  176      72
2069 34524 2019-10-18  57   1     0    0 147.5  87.5  176     100
2070 34971 2017-11-23  64   2     0    0 133.0  82.0  280      65
2071 33689 2019-02-18  38   2     1   12 122.5  76.5  209      73
2072 35040 2018-03-20  42   2     0    0 112.0  65.0  205      60
2073 33791 2018-08-29  46   3     0    0 108.0  81.0  165      72
2074 35139 2019-05-22  54   4     1   20 180.0  97.5  168     132
2075 34476 2018-03-04  50   1     1   30 122.0  81.5  234      76
2076 36937 2018-01-13  57   1     1    1 126.5  90.0  229      58
2077 35832 2017-02-15  52   3     0    0 175.0  85.0  350      63
2078 34184 2017-10-23  55   2     0    0 140.0  83.0  340      83
2079 35594 2018-07-19  45   3     1   30 126.0  89.5  250      92
2080 35360 2017-11-14  54   2     0    0 134.0  87.0  200      86
2081 33690 2019-10-16  44   3     1    3 164.0 119.0  352      72
2082 33079 2017-11-19  43   3     0    0 141.0  91.0  240      65
2083 33773 2019-11-13  53   2     1   20 127.5  86.0  262      73
2084 33478 2019-11-09  58   4     1   NA 195.0 117.5  270      NA
2085 35353 2017-01-10  61   1     0    0 189.0 121.0  217     100
2086 35323 2017-05-23  34   3     1   20 117.5  72.5  155      65
2087 35604 2018-10-17  47   2     1   15 137.0  87.0  253      81
2088 36848 2017-04-06  52   1     0    0 148.0  78.0  234     113
2089 32037 2019-02-26  55   2     0    0 131.0  76.0  266      84
2090 32661 2017-06-15  65   3     0    0 123.0  76.5  193      96
2091 33371 2018-10-29  44   2     1   10 130.0  86.0  222      84
2092 32481 2019-12-20  67   1     0    0 201.0  93.0  263      78
2093 34008 2019-11-29  37   2     0    0 127.0  81.0  178      NA
2094 34267 2017-10-26  45   1     1    2 125.0  82.0  291      72
2095 35166 2018-02-09  61   1     1    7 125.0  82.0  176      75
2096 34911 2019-07-18  35   3     0    0 127.5  80.0   NA      85
2097 34351 2017-11-13  60   1     1   10 167.0 109.0  217      72
2098 34170 2017-05-03  42   1     1   25 122.0  84.0  231      72
2099 35613 2018-10-01  52   1     0    0 148.0  92.0   NA      NA
2100 35198 2018-11-29  54   1     0    0 131.5  83.0  248      63
2101 33480 2017-07-29  61   4     0    0 114.0  81.0  287      68
2102 34667 2017-10-23  52   3     0    0 131.0  99.0  238      86
2103 36525 2019-07-07  42  NA     1    5 149.0  95.0  184      94
2104 36413 2017-10-25  39   1     1   20 108.0  74.0  202     104
2105 34415 2018-12-14  58   2     0    0 185.5 115.5  166      85
2106 35710 2017-12-28  47   1     1   15 122.0  70.0  285      82
2107 33601 2018-06-09  41   1     1   40 137.5  80.0  260      55
2108 33341 2019-09-03  50   2     0    0 148.5 100.0  239      90
2109 34410 2017-12-31  49   4     1    1 103.0  65.0  194      75
2110 35438 2017-12-08  49   3     1   20 132.0  76.0  189      60
2111 35858 2019-01-14  39   3     0    0 137.5 101.5  220      88
2112 32022 2018-07-25  36   4     1   15 123.0  78.0  155      78
2113 36375 2017-03-25  50   4     1   15 132.0  87.0  212      83
2114 32229 2017-10-25  52   2     0    0 128.0  87.0  210      61
2115 36125 2017-11-11  41   3     0    0 115.0  70.0  233      97
2116 32389 2017-07-08  43   3     1   30 121.0  69.0  218     103
2117 35123 2019-09-15  62   3     0    0 119.5  74.0  332      92
2118 35765 2019-12-02  67   1     0    0 144.0  85.0  228      75
2119 35988 2019-09-06  56   3     1   20 134.0  89.5  340      72
2120 33842 2018-06-04  42   2     1   15 112.5  70.0  177      83
2121 32378 2017-01-20  42  NA     1    9 139.0  91.0  165      83
2122 32443 2019-12-04  35   2     1   20 131.0  87.0  200      70
2123 32003 2017-10-16  48   3     0    0 122.0  78.0  283      87
2124 36408 2018-08-03  36   1     1   20 115.0  75.0  242      83
2125 32243 2018-09-17  38   2     1   20 123.0  69.0  180      70
2126 33786 2018-06-24  68   1     1   10 122.0  70.0  261      60
2127 35557 2019-02-14  49   2     0    0 112.0  79.0  170      80
2128 32437 2018-05-16  64   1     1   20 113.5  70.0  232      58
2129 32682 2018-02-04  38   1     1   20 123.0  86.0  265      80
2130 34904 2017-02-18  52   1     0    0 117.0  78.0  266      88
2131 35620 2017-10-08  44   1     1   20 137.5  87.5  232      70
2132 36208 2019-04-09  48   1     0    0 131.0  88.0  270      55
2133 34482 2018-05-25  42   2     0    0 132.0  89.5  240     103
2134 33827 2017-12-09  58   1     0    0 195.0  90.0  294     127
2135 35798 2019-03-01  40   1     1   35 122.5  66.5  195      72
2136 35273 2018-08-30  47   1     0    0 137.5  88.5  265      90
2137 33287 2018-11-08  41   2     1    1 113.5  61.0  189      73
2138 35226 2019-10-26  40   1     1   10  96.0  67.0  209      70
2139 33782 2019-10-18  57   1     0    0 136.5  87.0  213     119
2140 36998 2017-09-22  45   1     1   10 116.0  75.0  230      77
2141 35841 2017-11-22  44   2     0    0 138.0  92.0  210      92
2142 32832 2018-04-11  45   3     1    3 118.5  76.0  152      68
2143 32453 2019-02-15  59   1     0    0 133.0  91.0  226      79
2144 32833 2017-10-15  56   2     0    0 120.0  87.0  306      84
2145 36488 2019-12-13  41   1     1   20 135.0  81.0  190      NA
2146 34974 2017-11-16  46   2     1   43 125.0  89.0  259      57
2147 35808 2017-04-21  55   1     1    4 124.0  76.0  308      68
2148 32896 2018-03-12  48   4     0    0 129.0  86.0  241      67
2149 33910 2018-09-07  56   2     0    0 130.0  85.0  241      78
2150 35431 2019-07-15  39   2     1   20 120.0  74.0  188      80
2151 34811 2019-01-05  40   2     0    0 123.5  81.0  230      65
2152 32703 2020-01-01  66   1     0    0 132.5  85.0  275      NA
2153 32306 2018-04-29  38   4     1   15 110.0  61.0  248      55
2154 34361 2019-02-08  38   2     1   20 133.0  92.0  253      63
2155 33425 2018-08-12  56   2     1   20 116.0  67.0  186      83
2156 34015 2017-05-14  49   1     0    0 126.5  67.5  270      77
2157 33350 2019-05-08  41   1     0    0 112.0  75.5  181      95
2158 34061 2017-01-20  45   3     0    0 108.5  71.5  225      80
2159 35009 2017-04-08  46   1     0    0 118.0  79.0  212      72
2160 32329 2017-07-26  50   2     0    0 125.0  85.0  312      94
2161 36554 2018-02-01  56   2     0    0 130.0  79.0  212     100
2162 33836 2017-01-09  49   1     0    0 130.5  82.0  248     254
2163 34368 2017-01-31  56   2     0    0 113.0  75.5  225     104
2164 36716 2018-07-07  60   1     0    0 149.0 103.5  295      52
2165 32478 2017-02-20  43   1     0    0 122.0  84.0  217      88
2166 33640 2017-01-08  46   2     1   15 115.0  70.0  232      59
2167 33507 2019-01-20  40   3     0    0 141.0  98.0  185      72
2168 35591 2018-11-29  46   2     0    0 144.0  79.0  214      80
2169 36888 2019-10-13  43   2     1   20 104.5  65.0  163      71
2170 32751 2018-06-29  37   2     0    0 124.5  92.5  225      83
2171 32312 2017-12-05  42   4     0    0 115.0  79.0  250      79
2172 33073 2019-11-09  50   4     1   25 134.0  80.0  215      75
2173 32060 2019-01-10  60   1     0    0 110.0  72.5  260      NA
2174 32426 2019-01-18  43   1     0    0 160.0  85.0  257      84
2175 34445 2017-05-20  50   1     0    0 143.0  90.0  234      86
2176 36545 2017-06-10  60   2     0    0 130.0  82.5  354      79
2177 33429 2017-03-13  49   3     1   15 118.0  73.0  208      75
2178 34870 2018-05-27  67   2     1   20 154.0  90.0  239      90
2179 33340 2017-04-11  62   1     1   10 134.0  84.0  157      76
2180 36996 2017-04-03  39   1     1   15 142.0  85.5  255     108
2181 34341 2018-05-20  51   4     0    0 176.0 119.0  288      82
2182 35663 2018-01-25  48   4     0    0 116.0  72.0  323      99
2183 36723 2019-01-28  59   3     1   20 125.0  80.0  251      70
2184 33781 2019-06-19  60   2     1   15 183.0 107.0  236      NA
2185 33740 2017-12-10  64   1     0    0 156.0  69.0  189     100
2186 33635 2018-04-13  61   1     0    0 100.0  65.0  214      66
2187 32692 2018-05-24  52   1     0    0 159.0  95.0  225     114
2188 32108 2018-01-08  48   1     0    0 110.0  84.0  274      78
2189 35330 2017-01-13  58   2     0    0  98.0  60.0  149      71
2190 35067 2017-12-30  41   1     1   40 126.0  79.0  224      68
2191 34028 2017-11-10  52   2     0    0 135.0  89.0  310      74
2192 33589 2018-06-12  49   1     1   20 128.0  82.0  155      77
2193 32568 2018-08-03  39   2     1    9 110.0  78.0  270      68
2194 33579 2018-01-27  39   2     0    0 120.0  79.5  337      77
2195 32452 2017-10-15  46   1     1   10 113.0  68.0  392      63
2196 36246 2019-05-16  36   4     1   35 102.0  68.0  295      63
2197 35464 2018-06-23  44   1     0    0 142.0  92.0  229      76
2198 35497 2018-08-01  40   3     1   20 118.0  79.0  210      84
2199 33486 2017-05-19  40   4     0    0 141.5 108.5  192      78
2200 36532 2019-12-05  63   1     0    0 155.5  98.0  260     109
2201 33521 2018-07-19  44   4     1   25 111.0  79.0  200      74
2202 35799 2017-03-24  51   3     1   10  98.0  68.0  234      NA
2203 34955 2017-04-19  44   1     0    0 129.0  90.0  219      73
2204 34892 2019-07-25  59  NA     0    0 139.0  82.0  281      75
2205 34282 2017-01-12  61   3     0    0 133.0  83.0  189      NA
2206 32127 2018-09-15  64   2     0    0 129.0  61.0  217      81
2207 36759 2018-09-28  41   2     1    2  99.0  62.0  159      67
2208 33543 2019-01-30  60   1     0    0 132.0  75.5  318      82
2209 36277 2019-12-11  52   2     0    0 157.5  80.5  225      NA
2210 32126 2017-11-27  57   1     1   30 140.0  88.0  225      78
2211 34172 2018-08-19  63   2     1   30 172.0  95.0  213      67
2212 36989 2019-06-29  38   1     1   20 117.0  83.0  268      NA
2213 35176 2019-01-07  50   1     1    3 158.0  74.0  238      98
2214 33343 2019-04-13  56   1     0    0 127.0  83.0  194      73
2215 32343 2019-06-21  64   1     0    0 127.0  77.0  280      78
2216 33839 2019-09-19  46   2     1   15 106.0  60.0  233     348
2217 33201 2019-01-13  54   4     1   15 128.0  80.0  300      NA
2218 33249 2018-03-22  51   3     1    5 139.0  81.0  248      95
2219 33142 2017-08-12  39   1     0    0 124.0  80.0  186     102
2220 36680 2018-01-02  40   2     0    0 111.0  79.0  185      81
2221 32542 2019-08-07  57   1     1   20 150.0  95.5  235      73
2222 33598 2019-12-26  60   1     1   20 200.0 122.5  180     150
2223 33246 2019-10-26  58   1     0    0 181.0  74.0  279      65
2224 32036 2018-09-27  49   4     0    0 127.5  81.0  264      70
2225 33116 2019-08-03  58   1     1   40 171.0  95.0  231      77
2226 33146 2019-08-28  52   1     0    0 131.0  80.0  245      81
2227 32841 2018-02-15  52   1     1    3 134.0  98.0  199      89
2228 35623 2017-09-22  44   1     1   20 132.5  82.5  205      66
2229 35000 2018-05-06  37   1     0    0 118.5  85.5  300      82
2230 33255 2017-03-13  60   2     1   19 122.0  78.0  231      67
2231 36136 2019-08-17  55   2     0    0 158.0  97.0  220      86
2232 32932 2018-05-03  57   3     0    0 146.5  80.0  366      73
2233 33305 2018-05-10  42   3     0    0 108.0  70.5  204      65
2234 32663 2018-12-05  65   1     1    9 144.5  88.0  271     116
2235 33137 2018-06-22  66   1     0    0 175.0  67.5  200      93
2236 36875 2019-01-02  48   3     1   10 138.0  90.0  232      72
2237 33815 2019-07-01  58   1     1   20 146.0  85.0  235      71
2238 33038 2017-07-28  53   2     0    0 117.0  71.0  303      85
2239 34750 2017-02-12  52   1     1   15 120.0  77.0  240      62
2240 36724 2019-09-01  38   2     1    1 124.0  84.0  200      75
2241 32878 2019-08-02  47  NA     0    0 154.5 103.5  279      60
2242 34307 2017-06-21  40   2     1   20 119.0  86.0  152      66
2243 33508 2019-02-07  48  NA     1   60 136.0  81.0  232      78
2244 35672 2019-05-26  48   1     0    0 117.5  80.0  201      85
2245 34698 2017-03-24  57   1     1   30 139.0  83.0  249      76
2246 35237 2018-02-09  41   2     0    0 112.0  73.0  213      74
2247 33663 2018-02-05  51   3     1   43 122.0  76.0   NA      NA
2248 36236 2017-10-24  46   1     0    0 162.0  87.5  238      93
2249 36147 2018-03-28  44   1     1    9 114.0  83.0  273      65
2250 32067 2019-05-07  54   1     0    0 158.0  89.0  207     112
2251 35249 2018-05-17  42   3     0    0 126.0  86.0  270      77
2252 33329 2019-06-29  45   3     1   20 147.0  88.0  184      76
2253 33354 2017-09-20  61  NA     0    0 161.5  88.0  231     166
2254 32892 2018-06-18  44   3     0    0 132.5  87.0  244      86
2255 35408 2019-09-19  39   2     0    0 122.5  77.0  216      67
2256 34046 2019-11-16  37   3     0    0 105.0  70.0  257      80
2257 36972 2019-12-10  41   4     1   10 120.0  78.0  213      70
2258 35447 2019-05-23  52   3     0    0 122.0  73.0  205      85
2259 35952 2017-03-26  53   2     1   10 136.0  99.0  261      94
2260 34784 2019-03-02  53   3     0    0 125.0  80.0  218      NA
2261 34676 2017-02-08  47   2     1   20 130.0  78.0  237      75
2262 33392 2019-05-17  58   3     0    0 136.0  86.0  189      60
2263 32890 2018-02-23  52   2     1   20 116.0  64.0  243      70
2264 35910 2018-03-16  57   4     1   30 135.0  88.0  256      75
2265 33963 2017-05-03  56   1     0    0 127.5  91.5  301      74
2266 35579 2017-06-17  65   1     0    0 162.0  98.0  244      82
2267 33584 2017-03-28  58   1     1   20 124.0  76.0  290      81
2268 36923 2017-12-21  52   1     0    0 125.0  87.0  292      67
2269 32167 2020-01-01  51   1     0    0 130.0  89.5   NA      NA
2270 32480 2019-10-08  47   1     0    0 115.0  81.0  197      66
2271 34523 2018-05-24  64   3     0    0 151.0  90.0  200      87
2272 35269 2018-04-09  39   1     1   20 106.0  80.0  195     132
2273 33090 2019-05-21  67   2     0    0 144.0  89.0  292      NA
2274 33110 2019-01-29  43   3     1    8 119.5  69.5  192      83
2275 34124 2019-12-04  48   2     1   17 113.0  79.0  218      73
2276 35778 2019-10-25  44   3     1   23 115.0  76.0  272      77
2277 32672 2019-04-17  64   1     1   10 160.0  98.0   NA      NA
2278 33856 2017-08-22  54   2     0    0 143.5  92.0  228      74
2279 36784 2018-03-06  40   3     0    0 149.0  83.0  213      94
2280 34301 2018-11-22  54   3     0    0 148.0  93.0  258      95
2281 34854 2017-04-24  39   2     0    0 151.0  94.0  201      74
2282 33411 2019-02-03  40   2     1   20 112.5  85.0  275      71
2283 36575 2017-05-08  39   3     0    0 104.0  72.0  209     103
2284 34876 2019-05-14  59   4     0    0 186.5  99.0  313      84
2285 35962 2017-09-22  50   2     0    0 148.0  92.5  190      90
2286 34146 2017-04-17  45   4     1   30 110.0  78.0  307      69
2287 36650 2017-09-06  62   1     1   20 151.5  88.0  194     105
2288 33987 2019-04-29  47   2     1   10 150.0  85.0  186      93
2289 32020 2019-06-15  59   3     1   40 162.0  91.0  243      81
2290 33670 2019-09-24  54   4     1   20 125.0  76.0  242      87
2291 34348 2019-05-04  45   4     1   20 119.0  75.0  226      66
2292 36775 2018-08-01  48   2     1   20 150.0 105.0  258      60
2293 32902 2019-02-09  55   3     0    0 122.5  84.0  262      76
2294 34882 2017-03-02  40   4     1    3 107.5  75.0  230      76
2295 33967 2019-06-17  34  NA     1   10 108.5  86.0  185      NA
2296 35012 2017-02-22  58   2     0    0 188.0 102.0  345      NA
2297 33387 2018-05-14  39   1     1   40 115.0  77.0  251      98
2298 36096 2018-01-15  52   1     1    3 185.0 114.0  210      83
2299 36040 2017-08-07  45   1     0    0 123.5  80.5  219      83
2300 34678 2017-02-01  40   4     1   15 110.0  73.0  244      67
2301 36312 2018-12-30  43   2     0    0 127.0  88.0  234      NA
2302 35007 2018-06-13  40   1     1   43 112.0  67.0  325      94
2303 33150 2017-01-31  67   4     0    0 101.0  59.0  281      85
2304 34573 2017-01-14  39   4     1   20 107.0  73.0  217      67
2305 36379 2018-12-05  50   1     1   10 121.0  67.0  177      77
2306 35968 2018-09-12  59   2     1   20 154.5  93.0  254      89
2307 33776 2018-09-03  58   1     0    0 137.5  89.5  234      72
2308 35020 2018-02-06  38   3     0    0 100.0  72.0  185      83
2309 36621 2017-01-10  40   3     0    0 136.0  80.5  220      70
2310 35180 2019-02-02  42   2     0    0 134.0  82.0  211      80
2311 36440 2017-06-23  67   2     0    0 170.0  89.0  295      63
2312 35022 2019-12-12  41   2     1   15 107.0  81.0  155     191
2313 34718 2018-01-08  49   1     0    0 144.0  91.0  286      67
2314 36324 2018-02-23  50   2     1   30 145.5  96.0  308      NA
2315 34632 2019-11-10  47   1     0    0 146.5  97.5  283      73
2316 35173 2018-04-02  63   1     0    0 166.0  92.0  258      NA
2317 33282 2017-02-08  49   2     0    0 116.0  84.0  239      76
2318 35868 2017-09-01  40   2     0    0  97.0  63.0  205      80
2319 33946 2017-01-19  60   1     0    0 123.5  79.0  261     103
2320 33072 2019-10-14  39   1     1   15 152.0 104.0  280      82
2321 34162 2017-12-05  36   1     0    0 155.0  74.0  167      81
2322 34675 2017-04-22  55   1     1   30 130.0  85.0  230     108
2323 33695 2017-03-31  48   1     0    0 120.0  77.5  255      75
2324 35532 2018-04-22  39   1     0    0 130.0  72.0  213      78
2325 35730 2018-06-23  41   1     1   NA 135.0  82.5  171      82
2326 34025 2018-09-09  58   1     0    0 116.5  71.0   NA      86
2327 32458 2019-02-26  42   1     1   NA 119.0  80.0  226      98
2328 33936 2019-04-21  43   2     1   40 165.0 105.0  220     114
2329 36082 2018-02-19  50   4     1   30  96.5  62.5  165      78
2330 32812 2019-01-10  58   1     1   30 180.0 109.5  279      82
2331 35278 2018-02-05  36   1     1    5 118.0  80.0  180      84
2332 32226 2017-02-07  47   2     0    0 140.0  94.0  221      85
2333 33642 2019-06-15  61   1     0    0 110.0  78.5  311      77
2334 35369 2019-02-07  54   2     1   10 153.0  80.0  246      74
2335 33632 2019-08-29  57   1     1   30 127.0  69.0  167     107
2336 33286 2018-08-09  49   2     1   17 128.0  89.0  211      76
2337 33779 2019-12-21  48   1     1    2 129.0  90.0   NA      NA
2338 33541 2018-07-23  57   1     1   20 104.0  64.0  193      87
2339 34521 2017-11-10  52   2     0    0 136.0  94.0  202      67
2340 34473 2019-12-22  38   1     0    0 102.0  73.0  184      78
2341 33082 2019-09-16  50   3     1    3 105.0  68.0  200      68
2342 35193 2017-05-29  39   4     0    0 119.0  63.5  229      83
2343 35602 2019-04-18  55   1     0    0 122.0  82.0  207      74
2344 36699 2017-05-19  53   1     1    9 131.0  87.0  278      74
2345 33682 2019-08-21  52   3     0    0 154.0  92.0  232      74
2346 32133 2019-01-16  51   2     1   20 129.0  72.0  244      80
2347 36836 2019-07-24  58   2     0    0 143.5  85.0  265     107
2348 34296 2019-02-14  46   1     1    7 202.0 124.0  280      63
2349 33634 2018-01-02  48   2     1   17 177.0 124.0  250      69
2350 34809 2017-11-01  56   1     0    0 126.5  76.0  260      70
2351 32390 2017-01-17  42   2     1   10 100.0  66.0  242      NA
2352 35420 2017-03-23  57   3     0    0 109.0  77.0  272      89
2353 34150 2018-01-10  47   2     1   15 113.0  75.0  246      68
2354 32860 2019-03-04  59   3     0    0 149.0  88.0  240      82
2355 36172 2017-09-04  56   3     0    0 177.5  98.0  239     105
2356 34944 2017-09-27  48   1     0    0 159.0  90.0  164      63
2357 36828 2018-08-07  40   2     1   20 104.0  74.0  250      NA
2358 34407 2018-10-13  60   2     0    0 114.0  78.0  254      84
2359 34642 2019-12-16  43   2     1   38 130.0  86.0  207     103
2360 35329 2017-11-18  48   1     0    0 125.0  84.5  204      75
2361 36971 2019-11-08  36   4     1    9 127.0  83.0  212      75
2362 32377 2019-10-29  38   3     1   15 129.5  85.5  215      NA
2363 36363 2018-11-02  55   2     1   20 139.0  90.0  246     100
2364 34535 2019-06-06  59   2     1   20 165.0  99.0  266      82
2365 33977 2019-09-24  44   1     1   15 126.5  87.0  210      NA
2366 36738 2019-06-26  44   1     1   40 150.5  87.0  158      98
2367 33880 2018-10-02  46   3     1   20 118.0  82.0  253      70
2368 35609 2017-09-06  51   1     0    0 130.0  80.0  226      63
2369 36644 2017-04-20  39   4     0    0 126.0  86.0  216      70
2370 32944 2017-06-06  47   4     1   10 132.0  95.0  214      77
2371 32142 2019-11-04  48   3     0    0 150.5  98.0  235      92
2372 35725 2018-12-08  55   1     0    0 109.0  70.0  230      73
2373 35107 2018-08-03  62   1     0    0 154.0  92.0  240      67
2374 36941 2017-01-02  36   4     1   40 103.0  67.5  200      72
2375 34178 2018-07-04  45   4     0    0 132.0  78.0  189     177
2376 33143 2019-05-12  41   3     0    0 150.0  92.0  250      85
2377 33588 2018-05-13  47   2     1   20 162.0 110.0  234      85
2378 32783 2018-05-07  57   1     0    0 125.0  83.0  219     115
2379 37000 2018-02-22  65   1     0    0 166.0  93.0  201      91
2380 34367 2019-01-08  39   2     1    1 112.0  74.0  225      85
2381 35972 2017-04-22  53   3     1    9 132.0  84.5  210      84
2382 34702 2018-12-19  54   1     0    0 103.0  73.0  179      84
2383 33674 2019-12-18  64   1     1   15 191.0  81.0  266      78
2384 36656 2019-12-02  55  NA     0    0 190.0 112.0  275      91
2385 35124 2017-01-20  47   1     0    0 107.0  77.0  266      64
2386 35767 2018-01-09  48   1     0    0 145.0  77.0  265      64
2387 34353 2018-08-12  39   4     1    1 129.0  84.0  163     120
2388 33199 2018-05-29  57   4     1   15 117.5  71.0  250      75
2389 32626 2017-07-16  51  NA     1    9 157.0  87.0  696      84
2390 35865 2018-05-02  41   1     0    0 110.0  60.0  225      58
2391 36979 2018-01-12  51   2     0    0 142.0  90.0  261      84
2392 32734 2019-07-20  45   3     0    0 157.0  98.0  347      80
2393 34783 2018-09-18  53   2     1    9 137.0  99.0  230      79
2394 33693 2017-11-28  54   1     1   17  96.0  66.0  205      75
2395 35588 2018-12-21  46   1     1    5 109.0  81.0  198      85
2396 32302 2018-02-04  51   1     0    0 128.0  90.0  198      75
2397 33899 2018-01-27  43   4     1   30 121.0  75.0  292      82
2398 33473 2019-08-12  53   1     0    0 132.0  81.0  279      77
2399 36768 2017-09-05  49   2     1    2 115.0  83.0  262      57
2400 32627 2018-01-30  39   1     1   20 141.5  91.0  222      73
2401 34832 2019-06-05  67   1     1   10 171.0  84.0  194      88

R Packages for Importing Data

readr

  • Reading tabular data from flat and rds files
  • Part of the core tidyverse package ecosystem
  • Imported data stored as tibble data frame
  • Informative error and warning messages
  • Core functions:
    • read_table(): multiple file types
    • read_csv(): comma-separated values (csv)
    • read_tsv(): tab-separated values (tsv)
    • read_delim(): delimited text files
    • read_fwf(): fixed-width text files
    • read_rds(): R data stream (rds) files
read_csv(
  file,
  col_names = TRUE,
  col_types = NULL,
  col_select = NULL,
  id = NULL,
  locale = default_locale(),
  na = c("", "NA"),
  quoted_na = TRUE,
  quote = "\"",
  comment = "",
  trim_ws = TRUE,
  skip = 0,
  n_max = Inf,
  guess_max = min(1000, n_max),
  name_repair = "unique",
  num_threads = readr_threads(),
  progress = show_progress(),
  show_col_types = should_show_types(),
  skip_empty_rows = TRUE,
  lazy = should_read_lazy()
)

Example: read_csv()

# Load readr package (not necessary if you've loaded the tidyverse)
library(readr)

# Read in data, which is stored in a csv file 
data <- read_csv("data/cvdstudy.csv", na = "")

# Look at the data
data
# A tibble: 2,401 × 10
      id survdate     age   edu smoke  cigs   sbp   dbp  chol glucose
   <dbl> <date>     <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>   <dbl>
 1 32955 2019-11-04    54     2     1    15  230  110     262      97
 2 36997 2019-10-31    49     3     1     9  110   76     281      78
 3 34659 2019-07-14    57     1     0     0  146   76     258      87
 4 36762 2019-04-18    58     2     1    60  150   97     250      65
 5 32197 2019-02-20    56     1     1     3  145  100     285      86
 6 33534 2019-07-07    45     3     1    23  115   76     263      78
 7 36763 2019-01-04    37     1     1    20  112   73.5   166      93
 8 33026 2018-09-18    48     1     1    25  102   66.5   304      66
 9 35364 2019-06-13    62     1     0     0  130   87     157      47
10 34177 2019-03-19    54     1     0     0  136.  83     254      95
# … with 2,391 more rows
  • Returns a tibble, which displays useful information about the dataset
  • Note that these functions guess data types for each column, and are not always correct
  • Let’s try explicitly defining data types for id, smoke, and edu during the import!

Example: read_csv()

# Load readr package (not necessary if you've loaded the tidyverse)
library(readr)

# Read in data and specify data types for specific columns 
data <- read_csv("data/cvdstudy.csv", na = "",
                 col_types = cols(
                   id = col_character(),
                   smoke = col_factor(levels = c("0", "1")),
                   edu = col_factor(levels = c("1", "2", "3", "4"))
                   )
                 )

# Look at the data
data
# A tibble: 2,401 × 10
   id    survdate     age edu   smoke  cigs   sbp   dbp  chol glucose
   <chr> <date>     <dbl> <fct> <fct> <dbl> <dbl> <dbl> <dbl>   <dbl>
 1 32955 2019-11-04    54 2     1        15  230  110     262      97
 2 36997 2019-10-31    49 3     1         9  110   76     281      78
 3 34659 2019-07-14    57 1     0         0  146   76     258      87
 4 36762 2019-04-18    58 2     1        60  150   97     250      65
 5 32197 2019-02-20    56 1     1         3  145  100     285      86
 6 33534 2019-07-07    45 3     1        23  115   76     263      78
 7 36763 2019-01-04    37 1     1        20  112   73.5   166      93
 8 33026 2018-09-18    48 1     1        25  102   66.5   304      66
 9 35364 2019-06-13    62 1     0         0  130   87     157      47
10 34177 2019-03-19    54 1     0         0  136.  83     254      95
# … with 2,391 more rows
  • We did it! Many read functions include arguments to define data types or address other issues
  • Always look at your data, and be vigilant about potential data import problems

Example: read_delim()

# Read in data and specify data types for specific columns and the delimiter used in the file
data <- read_delim("data/cvdstudy.txt", delim = "\t", na = "NA",
                   col_types = cols(
                     id = col_character(),
                     smoke = col_factor(levels = c("0", "1")),
                     edu = col_factor(levels = c("1", "2", "3", "4"))
                   )
                 )

# Look at the data
data
# A tibble: 2,401 × 10
   id    survdate     age edu   smoke  cigs   sbp   dbp  chol glucose
   <chr> <date>     <dbl> <fct> <fct> <dbl> <dbl> <dbl> <dbl>   <dbl>
 1 32955 2019-11-04    54 2     1        15  230  110     262      97
 2 36997 2019-10-31    49 3     1         9  110   76     281      78
 3 34659 2019-07-14    57 1     0         0  146   76     258      87
 4 36762 2019-04-18    58 2     1        60  150   97     250      65
 5 32197 2019-02-20    56 1     1         3  145  100     285      86
 6 33534 2019-07-07    45 3     1        23  115   76     263      78
 7 36763 2019-01-04    37 1     1        20  112   73.5   166      93
 8 33026 2018-09-18    48 1     1        25  102   66.5   304      66
 9 35364 2019-06-13    62 1     0         0  130   87     157      47
10 34177 2019-03-19    54 1     0         0  136.  83     254      95
# … with 2,391 more rows
  • Notice that the syntax is identical to read_csv, with the exception of the delim argument
    • \t is passed to the delim argument to indicate a tab delimiter in the file
  • We also had to indicate NA as the character string to interpret as missing values
    • The source data includes the text “NA” in place of missing values

readxl

  • Reading tabular data from Excel files
  • Part of the tidyverse package ecosystem
    • Requires separate package installation
    • Imported data stored as tibble data frame
    • Informative error and warning messages
  • Core functions:
    • read_excel(): xls or xlsx (uses file extension)
    • read_xlsx(): xlsx only
    • read_xls(): xls only
read_xlsx(
  path,
  sheet = NULL,
  range = NULL,
  col_names = TRUE,
  col_types = NULL,
  na = "",
  trim_ws = TRUE,
  skip = 0,
  n_max = Inf,
  guess_max = min(1000, n_max),
  progress = readxl_progress(),
  .name_repair = "unique"
)

Example: read_xlsx()

# Load readxl package
library(readxl)

# Read in the xlsx file, which we know is located on sheet 2 inside of the file
data <- read_xlsx("data/cvdstudy.xlsx", sheet = 2, na = "")

# Look at the data
data
# A tibble: 2,411 × 10
   `Summary statistics` ...2     ...3  ...4  ...5  ...6  ...7  ...8  ...9  ...10
   <chr>                <chr>    <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
 1 <NA>                 Age      SBP   DBP   Chol  Gluc… <NA>  <NA>  <NA>  <NA> 
 2 Mean                 49.9433… 132.… 82.8… 236.… 49.9… <NA>  <NA>  <NA>  <NA> 
 3 Std. Dev             8.65920… 21.8… 11.8… 45.4… 8.65… <NA>  <NA>  <NA>  <NA> 
 4 Min                  33       85.5  48    124   40    <NA>  <NA>  <NA>  <NA> 
 5 Max                  70       244   141   696   370   <NA>  <NA>  <NA>  <NA> 
 6 <NA>                 <NA>     <NA>  <NA>  <NA>  <NA>  <NA>  <NA>  <NA>  <NA> 
 7 <NA>                 <NA>     <NA>  <NA>  <NA>  <NA>  <NA>  <NA>  <NA>  <NA> 
 8 <NA>                 <NA>     <NA>  <NA>  <NA>  <NA>  <NA>  <NA>  <NA>  <NA> 
 9 <NA>                 <NA>     <NA>  <NA>  <NA>  <NA>  <NA>  <NA>  <NA>  <NA> 
10 id                   survdate age   edu   smoke cigs  sbp   dbp   chol  gluc…
# … with 2,401 more rows
  • Oh no! A pesky collaborator included summary statistics at the top of the excel file
  • Not to worry! Let’s take advantage of the skip argument to read in the correct data

Example: read_xlsx()

# Create a vector of column types (limited to skip, guess, logical, numeric, date, text or list)
col_types <- c("text", "date", "numeric", "guess", "guess", "numeric", 
               "numeric", "numeric", "numeric", "numeric")

# Read in the xlsx file, which we know is located on sheet 2 inside of the file
data <- read_xlsx("data/cvdstudy.xlsx", sheet = 2, skip = 10, 
                  col_names = TRUE, col_types = col_types)

# Look at the data
data
# A tibble: 2,401 × 10
   id    survdate   age   edu smoke  cigs   sbp   dbp  chol glucose
   <chr> <dttm>   <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>   <dbl>
 1 32955 NA          54     2     1    15  230  110     262      97
 2 36997 NA          49     3     1     9  110   76     281      78
 3 34659 NA          57     1     0     0  146   76     258      87
 4 36762 NA          58     2     1    60  150   97     250      65
 5 32197 NA          56     1     1     3  145  100     285      86
 6 33534 NA          45     3     1    23  115   76     263      78
 7 36763 NA          37     1     1    20  112   73.5   166      93
 8 33026 NA          48     1     1    25  102   66.5   304      66
 9 35364 NA          62     1     0     0  130   87     157      47
10 34177 NA          54     1     0     0  136.  83     254      95
# … with 2,391 more rows
  • A little better, but we introduced new problems
  • The col_types argument in this particular function is limited (subset of possible data types)
    • Moreover, our attempt to coerce the survdate variable to a date led to data loss!
  • Sometimes it’s easier to let functions guess data types and coerce them after the import

Example: read_xlsx()

# Read in the xlsx file, which we know is located on sheet 2 inside of the file
data <- read_xlsx("data/cvdstudy.xlsx", sheet = 2, skip = 10, col_names = TRUE)

# Base R approach to updating column data types (we'll learn more elegant solutions, soon!)
data$survdate <- as.Date(data$survdate)
data$edu <- factor(data$edu, levels = c("1", "2", "3", "4"))
data$smoke <- factor(data$smoke, levels = c("0", "1"))

# Look at the data
data
# A tibble: 2,401 × 10
   id    survdate     age edu   smoke  cigs   sbp   dbp  chol glucose
   <chr> <date>     <dbl> <fct> <fct> <dbl> <dbl> <dbl> <dbl>   <dbl>
 1 32955 2019-11-04    54 2     1        15  230  110     262      97
 2 36997 2019-10-31    49 3     1         9  110   76     281      78
 3 34659 2019-07-14    57 1     0         0  146   76     258      87
 4 36762 2019-04-18    58 2     1        60  150   97     250      65
 5 32197 2019-02-20    56 1     1         3  145  100     285      86
 6 33534 2019-07-07    45 3     1        23  115   76     263      78
 7 36763 2019-01-04    37 1     1        20  112   73.5   166      93
 8 33026 2018-09-18    48 1     1        25  102   66.5   304      66
 9 35364 2019-06-13    62 1     0         0  130   87     157      47
10 34177 2019-03-19    54 1     0         0  136.  83     254      95
# … with 2,391 more rows


Much better. We’ve come so far!

haven

  • Reading data formats used by other statistical packages
  • Part of the tidyverse package ecosystem
    • Requires separate package installation
    • Imported data stored as tibble data frame
    • Informative error and warning messages
    • Preserves label attributes from other software
  • Core functions:
    • read_sas(): SAS files (.sas7bdat, sas7bcat)
    • read_sav(): SPSS files (.sav)
    • read_dta(): Stata files (.dta)
read_dta(
  file,
  encoding = NULL,
  col_select = NULL,
  skip = 0,
  n_max = Inf,
  .name_repair = "unique"
)

Example: read_dta()

# Load the haven package
library(haven)

# Read in the stata (.dta) file
data <- read_dta("data/cvdstudy.dta")

# There's no built in col types argument, so we'll use the base R approach to update data types 
data$survdate <- as.Date(data$survdate)
data$edu <- factor(data$edu, levels = c("1", "2", "3", "4"))
data$smoke <- factor(data$smoke, levels = c("0", "1"))

# Look at the data
data
# A tibble: 2,401 × 10
   id    survdate     age edu   smoke  cigs   sbp   dbp  chol glucose
   <chr> <date>     <dbl> <fct> <fct> <dbl> <dbl> <dbl> <dbl>   <dbl>
 1 32955 2019-11-04    54 2     1        15  230  110     262      97
 2 36997 2019-10-31    49 3     1         9  110   76     281      78
 3 34659 2019-07-14    57 1     0         0  146   76     258      87
 4 36762 2019-04-18    58 2     1        60  150   97     250      65
 5 32197 2019-02-20    56 1     1         3  145  100     285      86
 6 33534 2019-07-07    45 3     1        23  115   76     263      78
 7 36763 2019-01-04    37 1     1        20  112   73.5   166      93
 8 33026 2018-09-18    48 1     1        25  102   66.5   304      66
 9 35364 2019-06-13    62 1     0         0  130   87     157      47
10 34177 2019-03-19    54 1     0         0  136.  83     254      95
# … with 2,391 more rows
  • Note that Stata and other statistical software packages can include variable labels
  • Let’s see if the data we just imported has these label attributes

Example: read_dta()

# Look at the structure of the data object to which we assigned the imported dataset
str(data)
tibble [2,401 × 10] (S3: tbl_df/tbl/data.frame)
 $ id      : chr [1:2401] "32955" "36997" "34659" "36762" ...
  ..- attr(*, "label")= chr "Participant ID"
  ..- attr(*, "format.stata")= chr "%-9s"
 $ survdate: Date[1:2401], format: "2019-11-04" "2019-10-31" ...
 $ age     : num [1:2401] 54 49 57 58 56 45 37 48 62 54 ...
  ..- attr(*, "label")= chr "Age at the time of survey completion"
  ..- attr(*, "format.stata")= chr "%12.0g"
 $ edu     : Factor w/ 4 levels "1","2","3","4": 2 3 1 2 1 3 1 1 1 1 ...
 $ smoke   : Factor w/ 2 levels "0","1": 2 2 1 2 2 2 2 2 1 1 ...
 $ cigs    : num [1:2401] 15 9 0 60 3 23 20 25 0 0 ...
  ..- attr(*, "label")= chr "Number of cigarettes per day"
  ..- attr(*, "format.stata")= chr "%12.0g"
 $ sbp     : num [1:2401] 230 110 146 150 145 ...
  ..- attr(*, "label")= chr "Systolic blood pressure (mmHg)"
  ..- attr(*, "format.stata")= chr "%12.0g"
 $ dbp     : num [1:2401] 110 76 76 97 100 76 73.5 66.5 87 83 ...
  ..- attr(*, "label")= chr "Diastolic blood pressure (mmHg)"
  ..- attr(*, "format.stata")= chr "%12.0g"
 $ chol    : num [1:2401] 262 281 258 250 285 263 166 304 157 254 ...
  ..- attr(*, "label")= chr "Total cholesterol (mg/dL)"
  ..- attr(*, "format.stata")= chr "%12.0g"
 $ glucose : num [1:2401] 97 78 87 65 86 78 93 66 47 95 ...
  ..- attr(*, "label")= chr "Fasting glucose (mg/dL)"
  ..- attr(*, "format.stata")= chr "%12.0g"
  • Yes! Our data do have variable labels!
  • Labels can be very helpful for providing further detail about variables in the dataset

Case Studies

Case study 1

Your non-technical colleague has reached out to you for assistance with preparing an old dataset for an upcoming project. Your colleague typically receives curated datasets and has not previously worked with data stored in a fixed width file format.

As an expert R programmer, you offer to help. Upon receiving the dataset, you read the data into R to inspect its contents and observe the following:

read_fwf("data/newstudy.txt")
# A tibble: 534 × 2
        X1 X2                  
     <dbl> <chr>               
 1 3230559 20 0244.0124.0264120
 2 3484062 11  242.0141.0206 94
 3 3568665 10 0235.0100.0240297
 4 3573556 1120200.0120.0217 72
 5 3351661 10 0200.0125.0265256
 6 3469763 30 0196.0102.0161 88
 7 3382758 10 0195.0 90.0294127
 8 3346766 30 0193.0132.0280 73
 9 3563665 2120192.5110.0212 71
10 3609445 2120189.0 87.0234 90
# … with 524 more rows


What additional information do you need from your colleague before you can provide support?

Case study 1

# Vector of column positions
col_widths <- c(5, 2, 2, 1, 2, 5, 5, 3, 3)

# Vector of column names
col_names <- c("id", "age", "edu", "smoke", "cigs", "sbp", "dbp", "chol", "glucose")

# Read in the data, specifying column names and positions
data <- read_fwf("data/newstudy.txt", fwf_widths(widths = col_widths, col_names = col_names))


# A tibble: 534 × 9
      id   age   edu smoke  cigs   sbp   dbp  chol glucose
   <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>   <dbl>
 1 32305    59     2     0     0  244    124   264     120
 2 34840    62     1     1    NA  242    141   206      94
 3 35686    65     1     0     0  235    100   240     297
 4 35735    56     1     1    20  200    120   217      72
 5 33516    61     1     0     0  200    125   265     256
 6 34697    63     3     0     0  196    102   161      88
 7 33827    58     1     0     0  195     90   294     127
 8 33467    66     3     0     0  193    132   280      73
 9 35636    65     2     1    20  192.   110   212      71
10 36094    45     2     1    20  189     87   234      90
# … with 524 more rows

Case study 2

Your colleague asks for another favor. As part of their planned analysis, the research team hopes to incorporate exercise testing data obtained from a subset of study participants who had clinical assessments. Your colleague tells you that the data are stored in a formatted excel file that’s exported directly from the exercise testing software, and their team has had trouble getting data into R to analyze. You offer to help, and your colleague provides you with a sample dataset to inspect. You observe the following:

# Read in the xlsx file
data <- read_xlsx("data/exercise.xlsx")

# Look at the data
data
# A tibble: 695 × 11
   Participant `123456` ...3  ...4  ...5  ...6     ...7  ...8  ...9  ...10 ...11
   <chr>       <chr>    <chr> <chr> <chr> <chr>    <chr> <chr> <chr> <chr> <chr>
 1 Exercise    42776    <NA>  <NA>  <NA>  <NA>     <NA>  <NA>  <NA>  <NA>  <NA> 
 2 <NA>        <NA>     <NA>  <NA>  <NA>  <NA>     <NA>  <NA>  <NA>  <NA>  <NA> 
 3 Time        Work     Speed Grade HR    VO2      RR    PETC… SpO2  sysBP diaBP
 4 (min)       (Watts)  (MPH) (%)   (BPM) (mL/kg/… (br/… (mmH… (%)   (mmH… (mmH…
 5 00:19       0        0     0.2   89    3.1      11    36    97    <NA>  <NA> 
 6 00:28       0        0     0.2   91    9.4      6     38    97    <NA>  <NA> 
 7 00:30       0        0     0.2   98    3.1      11    36    98    <NA>  <NA> 
 8 00:41       0        0     0.2   104   6.4      8     38    98    <NA>  <NA> 
 9 00:44       0        0     0.2   106   6.4      9     39    98    <NA>  <NA> 
10 00:50       0        0     0.2   113   7        10    39    98    <NA>  <NA> 
# … with 685 more rows

What problems do you see, and how should we fix them?

Case study 2 (cont.)

  • The data structure issue can be resolved fairly easily
    • Use the skip argument to skip the non-rectangular data at the top of the file
    • After rows are skipped, drop the first row of data containing units using [-1,]
# The data formatting issue can be 
library(readxl)
data <- read_xlsx("data/exercise.xlsx", skip = 3)[-1,]

# Look at the data
data
# A tibble: 691 × 11
   Time  Work  Speed Grade HR    VO2   RR    PETCO2 SpO2  sysBP diaBP
   <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>  <chr> <chr> <chr>
 1 00:19 0     0     0.2   89    3.1   11    36     97    <NA>  <NA> 
 2 00:28 0     0     0.2   91    9.4   6     38     97    <NA>  <NA> 
 3 00:30 0     0     0.2   98    3.1   11    36     98    <NA>  <NA> 
 4 00:41 0     0     0.2   104   6.4   8     38     98    <NA>  <NA> 
 5 00:44 0     0     0.2   106   6.4   9     39     98    <NA>  <NA> 
 6 00:50 0     0     0.2   113   7     10    39     98    <NA>  <NA> 
 7 00:53 0     0     0.2   110   7.6   9     39     98    120   70   
 8 00:57 0     0     0.2   109   8.6   9     39     98    120   70   
 9 01:02 0     0     0.2   105   8.6   11    39     97    120   70   
10 01:10 0     0     0.2   104   8.6   11    39     97    120   70   
# … with 681 more rows

Case study 2 (cont.)

# Coerce all but the time column to a numeric data type
data[2:11] <- sapply(data[2:11], as.numeric)

# Standardize the column names (all lower case)
colnames(data) <- tolower(colnames(data))

data
# A tibble: 691 × 11
   time   work speed grade    hr   vo2    rr petco2  spo2 sysbp diabp
   <chr> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>  <dbl> <dbl> <dbl> <dbl>
 1 00:19     0     0   0.2    89   3.1    11     36    97    NA    NA
 2 00:28     0     0   0.2    91   9.4     6     38    97    NA    NA
 3 00:30     0     0   0.2    98   3.1    11     36    98    NA    NA
 4 00:41     0     0   0.2   104   6.4     8     38    98    NA    NA
 5 00:44     0     0   0.2   106   6.4     9     39    98    NA    NA
 6 00:50     0     0   0.2   113   7      10     39    98    NA    NA
 7 00:53     0     0   0.2   110   7.6     9     39    98   120    70
 8 00:57     0     0   0.2   109   8.6     9     39    98   120    70
 9 01:02     0     0   0.2   105   8.6    11     39    97   120    70
10 01:10     0     0   0.2   104   8.6    11     39    97   120    70
# … with 681 more rows

Key takeaways

  • Reading data into R is typically the first step in a data analysis workflow
  • In addition to base R functions, many R packages include functions with more robust functionality
    • Different functions have implications for how data are handled when read into R
      • For example, whether the data are stored as a standard data frame or tibble data frame
        • Useful packages include: readr, readxl, and haven (but there are many more!)
  • Idiosyncrasies in data storage methods warrant specific considerations. For example:
    • Reading xls and xlsx excel files require specific functions, which can accommodate specific formatting issues
      • Skipping rows before reading data
      • Selecting a specific range of cells or sheets to read data
  • Always be vigilant about identifying potential issues during the data import process