Introduction to Information Systems and Applications (ECON1242)

R code for 2nd Assigment

# set working folder the location of your file
# change backslash to slash
setwd("C:/Users/user/Documents/1111111/R")
#load the data file in memory
# has header and the seperator character is ;
data=read.csv('project_cost.csv',header=TRUE,sep=';',stringsAsFactors = FALSE )
# convert columns to categorical variable
data$ProjectTeam=as.factor(data$ProjectTeam)
data$Category=as.factor(data$Category)
# frequency table of categorical variable
table(data$Category)
table(data$ProjectTeam,data$Category)