#Install

#install.packages("tidyverse")

#Libraries

library(tidyverse)
library(psych)
library(readr)
library(ggplot2)
library(purrr)
library(scales)
library(dplyr)

#Read File

dataRDU<- read_delim("rdu-weather-history.csv", ";", escape_double = FALSE, trim_ws = TRUE)
Rows: 1977 Columns: 7── Column specification ───────────────────────────────────────────────────────────────────
Delimiter: ";"
dbl  (6): tmin, tmax, prcp, snow, snwd, awnd
date (1): date
ℹ Use `spec()` to retrieve the full column specification for this data.
ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
head(dataRDU)

#Summarize Data

summary(dataRDU)
      date                 tmin            tmax            prcp             snow        
 Min.   :2017-01-01   Min.   : 4.00   Min.   : 27.0   Min.   :0.0000   Min.   :0.00000  
 1st Qu.:2018-05-10   1st Qu.:37.00   1st Qu.: 60.0   1st Qu.:0.0000   1st Qu.:0.00000  
 Median :2019-09-16   Median :52.00   Median : 74.0   Median :0.0000   Median :0.00000  
 Mean   :2019-09-16   Mean   :51.09   Mean   : 72.3   Mean   :0.1358   Mean   :0.01284  
 3rd Qu.:2021-01-22   3rd Qu.:66.00   3rd Qu.: 86.0   3rd Qu.:0.0600   3rd Qu.:0.00000  
 Max.   :2022-05-31   Max.   :78.00   Max.   :102.0   Max.   :4.9600   Max.   :7.00000  
                                                                                        
      snwd              awnd       
 Min.   :0.00000   Min.   : 0.000  
 1st Qu.:0.00000   1st Qu.: 3.800  
 Median :0.00000   Median : 5.800  
 Mean   :0.01695   Mean   : 6.075  
 3rd Qu.:0.00000   3rd Qu.: 7.800  
 Max.   :5.90000   Max.   :20.360  
 NA's   :1         NA's   :4       

#Hypothesis #1

dataRDU$date <- as.Date(dataRDU$date)

dataRDU$year <- as.numeric(format(dataRDU$date, "%Y"))


average_temperatures <- dataRDU %>%

  group_by(year) %>%

  summarize(avg_tmin = mean(tmin, na.rm = TRUE),

            avg_tmax = mean(tmax, na.rm = TRUE))

#Line Plot Comparison 

ggplot(average_temperatures, aes(x = year)) +

  geom_line(aes(y = avg_tmin), color = "blue") +

  geom_line(aes(y = avg_tmax), color = "red") +

  xlab("Year") +

  ylab("Average Temperature (F)") +

  ggtitle("Trend in Average Daily Temperatures Over the Years")

#Hypothesis #2

dataRDU <- dataRDU %>%
  mutate(next_day_tmin = lag(tmin))


ggplot(dataRDU, aes(x = prcp, y = next_day_tmin)) +
  geom_point() +
  xlab("Precipitation (Millimeters)") +
  ylab("Next Day's Minimum Temperature (Degrees)") +
  ggtitle("Hypothesis #2") +
  geom_smooth(method = "lm", se = FALSE, color = "blue") 

#Hypothesis #3

dataRDU$date <- as.Date(dataRDU$date)

dataRDU$month <- as.integer(format(dataRDU$date, "%m"))

average_wind_speed <- dataRDU %>%
  group_by(month) %>%
  summarize(avg_awnd = mean(awnd, na.rm = TRUE))

#Plot

ggplot(average_wind_speed, aes(x = month, y = avg_awnd)) +

  geom_line() +

  xlab("Month") +

  ylab("Average Wind Speed (Knots)") +

  ggtitle("Seasonal Variations in Wind Speed") +

  scale_x_continuous(breaks = 1:12, labels = month.abb)

#Hypothesis #4

event_subset <- dataRDU %>%

  filter(prcp == 1)  


no_event_subset <- dataRDU %>%

  filter(prcp == 0) 

#T-Test
t_test_result <- t.test(event_subset$awnd, no_event_subset$awnd, var.equal = FALSE)

t.test(event_subset$awnd, no_event_subset$awnd)

    Welch Two Sample t-test

data:  event_subset$awnd and no_event_subset$awnd
t = -0.79095, df = 1.0095, p-value = 0.573
alternative hypothesis: true difference in means is not equal to 0
95 percent confidence interval:
 -14.83996  13.06405
sample estimates:
mean of x mean of y 
 4.700000  5.587956 
cat(t_test_result$t.statistic)

cat("p-value:", t_test_result$p.value, "\n")
p-value: 0.5729674 
cat("t-statistic:", t_test_result$statistic, "\n")
t-statistic: -0.7909505 
maxTempWind <- select(dataRDU, c("awnd", "tmax"))
pairs(maxTempWind)

ggplot(data = dataRDU, mapping = aes(x = awnd, 
                                  y = tmax))+
  geom_point()

ggplot(data = dataRDU, mapping = aes(x = awnd, 
                                  y = tmax))+
  geom_line()

ggplot(data = dataRDU, mapping = aes(x = awnd, 
                                  y = tmax))+
  geom_line()+
  labs(title = "Effect of Temperature(Degrees) on Wind Speed(Knots)",
       subtitle = "Source: fedesoriano. (April 2022). Wind Speed Prediction Dataset.",
       x= "Wind Speed in Knots",
       y= "Maximum Temperature in Degrees Degrees")

ggplot(data = dataRDU, mapping = aes(x = awnd,
                                  y = tmax))+
  geom_smooth()+
  labs(title = "Effect of Temperature(F) on Wind Speed(Kt)",
       
       x= "Wind Speed in Knots",
       y= "Maximum Temperature in Degrees ")

avgTempMax<- mean(dataRDU$tmax)
avgTempMax
[1] 72.29894
avgTempMin <- mean(dataRDU$tmin)
avgTempMin
[1] 51.08801
LS0tCnRpdGxlOiAiUiBOb3RlYm9vayIKb3V0cHV0OiBodG1sX25vdGVib29rCi0tLQojSW5zdGFsbApgYGB7cn0KI2luc3RhbGwucGFja2FnZXMoInRpZHl2ZXJzZSIpCmBgYAoKI0xpYnJhcmllcwpgYGB7cn0KbGlicmFyeSh0aWR5dmVyc2UpCmxpYnJhcnkocHN5Y2gpCmxpYnJhcnkocmVhZHIpCmxpYnJhcnkoZ2dwbG90MikKbGlicmFyeShwdXJycikKbGlicmFyeShzY2FsZXMpCmxpYnJhcnkoZHBseXIpCmBgYAoKI1JlYWQgRmlsZQpgYGB7cn0KZGF0YVJEVTwtIHJlYWRfZGVsaW0oInJkdS13ZWF0aGVyLWhpc3RvcnkuY3N2IiwgIjsiLCBlc2NhcGVfZG91YmxlID0gRkFMU0UsIHRyaW1fd3MgPSBUUlVFKQpoZWFkKGRhdGFSRFUpCmBgYAoKI1N1bW1hcml6ZSBEYXRhCmBgYHtyfQpzdW1tYXJ5KGRhdGFSRFUpCmBgYAoKI0h5cG90aGVzaXMgIzEKYGBge3J9CmRhdGFSRFUkZGF0ZSA8LSBhcy5EYXRlKGRhdGFSRFUkZGF0ZSkKCmRhdGFSRFUkeWVhciA8LSBhcy5udW1lcmljKGZvcm1hdChkYXRhUkRVJGRhdGUsICIlWSIpKQoKCmF2ZXJhZ2VfdGVtcGVyYXR1cmVzIDwtIGRhdGFSRFUgJT4lCgogIGdyb3VwX2J5KHllYXIpICU+JQoKICBzdW1tYXJpemUoYXZnX3RtaW4gPSBtZWFuKHRtaW4sIG5hLnJtID0gVFJVRSksCgogICAgICAgICAgICBhdmdfdG1heCA9IG1lYW4odG1heCwgbmEucm0gPSBUUlVFKSkKCiNMaW5lIFBsb3QgQ29tcGFyaXNvbiAKCmdncGxvdChhdmVyYWdlX3RlbXBlcmF0dXJlcywgYWVzKHggPSB5ZWFyKSkgKwoKICBnZW9tX2xpbmUoYWVzKHkgPSBhdmdfdG1pbiksIGNvbG9yID0gImJsdWUiKSArCgogIGdlb21fbGluZShhZXMoeSA9IGF2Z190bWF4KSwgY29sb3IgPSAicmVkIikgKwoKICB4bGFiKCJZZWFyIikgKwoKICB5bGFiKCJBdmVyYWdlIFRlbXBlcmF0dXJlIChGKSIpICsKCiAgZ2d0aXRsZSgiVHJlbmQgaW4gQXZlcmFnZSBEYWlseSBUZW1wZXJhdHVyZXMgT3ZlciB0aGUgWWVhcnMiKQpgYGAKCiNIeXBvdGhlc2lzICMyIApgYGB7cn0KZGF0YVJEVSA8LSBkYXRhUkRVICU+JQogIG11dGF0ZShuZXh0X2RheV90bWluID0gbGFnKHRtaW4pKQoKCmdncGxvdChkYXRhUkRVLCBhZXMoeCA9IHByY3AsIHkgPSBuZXh0X2RheV90bWluKSkgKwogIGdlb21fcG9pbnQoKSArCiAgeGxhYigiUHJlY2lwaXRhdGlvbiAoTWlsbGltZXRlcnMpIikgKwogIHlsYWIoIk5leHQgRGF5J3MgTWluaW11bSBUZW1wZXJhdHVyZSAoRGVncmVlcykiKSArCiAgZ2d0aXRsZSgiSHlwb3RoZXNpcyAjMiIpICsKICBnZW9tX3Ntb290aChtZXRob2QgPSAibG0iLCBzZSA9IEZBTFNFLCBjb2xvciA9ICJibHVlIikgCmBgYAojSHlwb3RoZXNpcyAjMwpgYGB7cn0KZGF0YVJEVSRkYXRlIDwtIGFzLkRhdGUoZGF0YVJEVSRkYXRlKQoKZGF0YVJEVSRtb250aCA8LSBhcy5pbnRlZ2VyKGZvcm1hdChkYXRhUkRVJGRhdGUsICIlbSIpKQoKYXZlcmFnZV93aW5kX3NwZWVkIDwtIGRhdGFSRFUgJT4lCiAgZ3JvdXBfYnkobW9udGgpICU+JQogIHN1bW1hcml6ZShhdmdfYXduZCA9IG1lYW4oYXduZCwgbmEucm0gPSBUUlVFKSkKCiNQbG90CgpnZ3Bsb3QoYXZlcmFnZV93aW5kX3NwZWVkLCBhZXMoeCA9IG1vbnRoLCB5ID0gYXZnX2F3bmQpKSArCgogIGdlb21fbGluZSgpICsKCiAgeGxhYigiTW9udGgiKSArCgogIHlsYWIoIkF2ZXJhZ2UgV2luZCBTcGVlZCAoS25vdHMpIikgKwoKICBnZ3RpdGxlKCJTZWFzb25hbCBWYXJpYXRpb25zIGluIFdpbmQgU3BlZWQiKSArCgogIHNjYWxlX3hfY29udGludW91cyhicmVha3MgPSAxOjEyLCBsYWJlbHMgPSBtb250aC5hYmIpCmBgYAoKCiNIeXBvdGhlc2lzICM0CmBgYHtyfQpldmVudF9zdWJzZXQgPC0gZGF0YVJEVSAlPiUKCiAgZmlsdGVyKHByY3AgPT0gMSkgIAoKCm5vX2V2ZW50X3N1YnNldCA8LSBkYXRhUkRVICU+JQoKICBmaWx0ZXIocHJjcCA9PSAwKSAKCiNULVRlc3QKdF90ZXN0X3Jlc3VsdCA8LSB0LnRlc3QoZXZlbnRfc3Vic2V0JGF3bmQsIG5vX2V2ZW50X3N1YnNldCRhd25kLCB2YXIuZXF1YWwgPSBGQUxTRSkKCnQudGVzdChldmVudF9zdWJzZXQkYXduZCwgbm9fZXZlbnRfc3Vic2V0JGF3bmQpCgpjYXQodF90ZXN0X3Jlc3VsdCR0LnN0YXRpc3RpYykKCmNhdCgicC12YWx1ZToiLCB0X3Rlc3RfcmVzdWx0JHAudmFsdWUsICJcbiIpCgpjYXQoInQtc3RhdGlzdGljOiIsIHRfdGVzdF9yZXN1bHQkc3RhdGlzdGljLCAiXG4iKQoKYGBgCgoKYGBge3J9Cm1heFRlbXBXaW5kIDwtIHNlbGVjdChkYXRhUkRVLCBjKCJhd25kIiwgInRtYXgiKSkKcGFpcnMobWF4VGVtcFdpbmQpCmBgYAoKYGBge3J9CmdncGxvdChkYXRhID0gZGF0YVJEVSwgbWFwcGluZyA9IGFlcyh4ID0gYXduZCwgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB5ID0gdG1heCkpKwogIGdlb21fcG9pbnQoKQpgYGAKCmBgYHtyfQpnZ3Bsb3QoZGF0YSA9IGRhdGFSRFUsIG1hcHBpbmcgPSBhZXMoeCA9IGF3bmQsIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgeSA9IHRtYXgpKSsKICBnZW9tX2xpbmUoKQpgYGAKCmBgYHtyfQpnZ3Bsb3QoZGF0YSA9IGRhdGFSRFUsIG1hcHBpbmcgPSBhZXMoeCA9IGF3bmQsIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgeSA9IHRtYXgpKSsKICBnZW9tX2xpbmUoKSsKICBsYWJzKHRpdGxlID0gIkVmZmVjdCBvZiBUZW1wZXJhdHVyZShEZWdyZWVzKSBvbiBXaW5kIFNwZWVkKEtub3RzKSIsCiAgICAgICBzdWJ0aXRsZSA9ICJTb3VyY2U6IGZlZGVzb3JpYW5vLiAoQXByaWwgMjAyMikuIFdpbmQgU3BlZWQgUHJlZGljdGlvbiBEYXRhc2V0LiIsCiAgICAgICB4PSAiV2luZCBTcGVlZCBpbiBLbm90cyIsCiAgICAgICB5PSAiTWF4aW11bSBUZW1wZXJhdHVyZSBpbiBEZWdyZWVzIERlZ3JlZXMiKQpgYGAKCgpgYGB7cn0KZ2dwbG90KGRhdGEgPSBkYXRhUkRVLCBtYXBwaW5nID0gYWVzKHggPSBhd25kLAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgeSA9IHRtYXgpKSsKICBnZW9tX3Ntb290aCgpKwogIGxhYnModGl0bGUgPSAiRWZmZWN0IG9mIFRlbXBlcmF0dXJlKEYpIG9uIFdpbmQgU3BlZWQoS3QpIiwKICAgICAgIAogICAgICAgeD0gIldpbmQgU3BlZWQgaW4gS25vdHMiLAogICAgICAgeT0gIk1heGltdW0gVGVtcGVyYXR1cmUgaW4gRGVncmVlcyAiKQpgYGAKCmBgYHtyfQphdmdUZW1wTWF4PC0gbWVhbihkYXRhUkRVJHRtYXgpCmF2Z1RlbXBNYXgKYGBgCmBgYHtyfQphdmdUZW1wTWluIDwtIG1lYW4oZGF0YVJEVSR0bWluKQphdmdUZW1wTWluCmBgYAoKCg==