(Above is some of the data)

A. Read this file into a data frame and write R code to answer the following questions.

B. At how many different time points, the persons temperature (Temp in column 2) was taken. Ignore missing items. What are those time points?

C. At how many different time points, the persons Heart rate (HR in column 2) was measured. Ignore missing items. What are those time points?

D. Calculate the average temperature (Temp in column 2), and average Heart rate (RespRate in column 2) of the patient during the stay. Ignore missing items.

E. In the first column of the data frame, replace the values by following the rules in the table below. After modifying, write the resulting data frame to a text file.

Between 0 and 8.0 (0 included, 8.0 included) . Replace by 1

Between 8.1 and 16.0 Replace by 2

Between 16.1 and 24.0 Replace by 3

Between 24.1 and 32.0 Replace by 4

Between 32.1 and 40.0 Replace by 5

Between 40.1 and 48.0 Replace by 6

Time Value 132614 77 1 162.6 1 59 15 73 41 60 98 37.3 50 Parameter O RecordID O Age O Gender O Height O ICUType o Weight 1.17 GCS 1.17 HR 1.17 NIDiaSABP 1.17 NIMAP 1.17 NISYSABP 1.17 Temp 1.17 Urine 1.47 HR 1.47 NIDiaSABP 1.47 NIMAP 1.47 NISYSABP 2.17 HR 2.17 NIDiasABP 2.17 NIMAP 2.17 NISYSABP 2.17 Urine 2.47 HR 2.47 NIDiasABP 2.47 NIMAP 2.47 NISYSABP 3.17 Dias ABP 3.17 HR 3.17 MAP 3.17 NIDiasABP 70 49 64 94 70 42 61.33 100 65 70 34 51.33 86 0 70 32 Time Value 132614 77 1 162.6 1 59 15 73 41 60 98 37.3 50 Parameter O RecordID O Age O Gender O Height O ICUType o Weight 1.17 GCS 1.17 HR 1.17 NIDiaSABP 1.17 NIMAP 1.17 NISYSABP 1.17 Temp 1.17 Urine 1.47 HR 1.47 NIDiaSABP 1.47 NIMAP 1.47 NISYSABP 2.17 HR 2.17 NIDiasABP 2.17 NIMAP 2.17 NISYSABP 2.17 Urine 2.47 HR 2.47 NIDiasABP 2.47 NIMAP 2.47 NISYSABP 3.17 Dias ABP 3.17 HR 3.17 MAP 3.17 NIDiasABP 70 49 64 94 70 42 61.33 100 65 70 34 51.33 86 0 70 32