Assignment 1

Read the Files

bike1 <- read.table("~/DATA4310/Datasets/bike_sharing_data.csv", sep=",", header=TRUE)
bike2 <- read.table("Datasets/bike_sharing_data.txt", sep="\t", header=TRUE)
bike3 <- read.csv("Datasets/bike_sharing_data.csv")
bike4 <- read.delim("Datasets/bike_sharing_data.txt")

Describe the Data

str(bike1)

## 'data.frame':    17379 obs. of  13 variables:
##  $ datetime  : chr  "1/1/2011 0:00" "1/1/2011 1:00" "1/1/2011 2:00" "1/1/2011 3:00" ...
##  $ season    : int  1 1 1 1 1 1 1 1 1 1 ...
##  $ holiday   : int  0 0 0 0 0 0 0 0 0 0 ...
##  $ workingday: int  0 0 0 0 0 0 0 0 0 0 ...
##  $ weather   : int  1 1 1 1 1 2 1 1 1 1 ...
##  $ temp      : num  9.84 9.02 9.02 9.84 9.84 ...
##  $ atemp     : num  14.4 13.6 13.6 14.4 14.4 ...
##  $ humidity  : chr  "81" "80" "80" "75" ...
##  $ windspeed : num  0 0 0 0 0 ...
##  $ casual    : int  3 8 5 3 0 0 2 1 1 8 ...
##  $ registered: int  13 32 27 10 1 1 0 2 7 6 ...
##  $ count     : int  16 40 32 13 1 1 2 3 8 14 ...
##  $ sources   : chr  "ad campaign" "www.yahoo.com" "www.google.fi" "AD campaign" ...

Select Data using Indexing

bike1[6251,"season"]

## [1] 4

sum(bike1$season==4)

## [1] 4232

seasons <- bike1[bike1$season %in% c(1,4), ]
sum(seasons$windspeed >= 40)

## [1] 46