Unsolved
This post is more than 5 years old
3 Posts
0
1768
Download Training1 and Training2 DBs for E20-007 (EMCDSA)
Where can I get a copy of the Training1 and Training2 databases used in the Labs for the VILT course E20-007 (EMCDSA)? I've downloaded the source code and data in course resources but that doesn't include that databases.
KEHutchinson
2 Intern
2 Intern
•
633 Posts
0
December 1st, 2015 06:00
The datasets were made available for use with the textbook version of the course. You can download them from the publisher's website here: http://www.wiley.com/WileyCDA/WileyTitle/productCd-111887613X.html
You should be sure to check out the Read Me file before using them.
vfokeeffe
3 Posts
0
December 2nd, 2015 11:00
Hi Kate,
Thanks so much for your response. I followed that link but couldn't see where to download the Training1 and Training2 DB's. There is a downloads section with R Commands and CSV Files but I can't see the PostgreSQL Databases. Are they downloadable?
Regards,
Vinny
youness1
2 Posts
0
December 5th, 2015 12:00
Hi Kate,
I'm facing the same issue, could you please support, where can i find training2 and housing table?
regards
youness
youness1
2 Posts
0
December 7th, 2015 18:00
hi there
i found this
############################################################
# the following code is for illustrative purposes only
# a functioning SQL database is required
install.packages("RODBC")
library(RODBC)
conn <- odbcConnect("training2", uid="user", pwd="password")
housing_data <- sqlQuery(conn, "select serialno, state, persons, rooms
from housing
where hinc > 1000000")
head(housing_data)
# end of SQL-related R code
############################################################
so there is nothing you will find with training2 db or housing_data i think
regards
youness
vfokeeffe
3 Posts
0
December 14th, 2015 12:00
Yeah, I think you're right Youness. It's a shame the Training Databases aren't available with the rest of the content.
Vinny