607_Week2_Assignment

After discovering the link to the .data file for https://archive.ics.uci.edu/ml/datasets/Pittsburgh+Bridges, we can run the following commands:

load the .csv into a data.frame

bridges<-read.csv("https://archive.ics.uci.edu/ml/machine-learning-databases/bridges/bridges.data.version2", header= FALSE, sep=",")

rename the columns according to the data description

colnames(bridges) <- c("IDENTIF", "RIVER", "LOCATION","ERECTED","PURPOSE","LENGTH","LANES","CLEAR-G","T-OR-D","MATERIAL","SPAN","REL-L","TYPE")

create an R data frame with a subset of the columns and arbitrary rows

subset(bridges, PURPOSE == "HIGHWAY" & RIVER == "A", select = c(RIVER, ERECTED, TYPE))

##     RIVER  ERECTED     TYPE
## 2       A   CRAFTS     WOOD
## 4       A   CRAFTS     WOOD
## 6       A   CRAFTS     WOOD
## 10      A   CRAFTS     WOOD
## 13      A   CRAFTS     WOOD
## 15      A   CRAFTS   SUSPEN
## 18      A   CRAFTS     WOOD
## 19      A EMERGING     WOOD
## 22      A EMERGING     WOOD
## 28      A EMERGING   SUSPEN
## 30      A EMERGING SIMPLE-T
## 35      A   MATURE SIMPLE-T
## 38      A   MATURE SIMPLE-T
## 48      A   MATURE SIMPLE-T
## 49      A   MATURE SIMPLE-T
## 51      A   MATURE CANTILEV
## 61      A   MATURE SIMPLE-T
## 67      A   MATURE SIMPLE-T
## 71      A   MATURE     ARCH
## 72      A   MATURE     ARCH
## 73      A   MATURE   SUSPEN
## 74      A   MATURE   SUSPEN
## 76      A   MATURE     ARCH
## 79      A   MATURE     ARCH
## 81      A   MATURE   SUSPEN
## 87      A   MATURE CANTILEV
## 88      A   MODERN   CONT-T
## 90      A   MODERN   CONT-T
## 98      A   MODERN   CONT-T
## 102     A   MODERN   CONT-T
## 104     A   MODERN     ARCH
## 108     A   MODERN        ?