| CREATE TABLE FieldRexTemp | |
| ( | |
| id AUTOINCREMENT PRIMARY KEY , | |
| recID TEXT(10), | |
| expdID TEXT, | |
| collector TEXT, | |
| collNumFull TEXT, | |
| lnamID INTEGER, | |
| acceptDetAs TEXT, | |
| acceptDetNoAuth TEXT, |
| # open test connection | |
| source("O://CMEP\ Projects/Scriptbox/database_connections/function_TESTPadmeArabiaCon.R") | |
| TESTPadmeArabiaCon() | |
| # get column details for FieldRexTemp table | |
| tableDetails <- sqlColumns(con_TESTPadmeArabia, sqtable="FieldRexTemp", errors = FALSE, as.is = TRUE, | |
| special = FALSE, catalog = NULL, schema = NULL, | |
| literal = FALSE) | |
| # show relevant columns |
| INSERT INTO FieldRexTemp ( recID, expdID, collector, collNumFull, lnamID, acceptDetAs, acceptDetNoAuth, detAs, lat1Dir, lat1Deg, lat1Min, lat1Sec, lat1Dec, AnyLat, lon1Dir, lon1Deg, lon1Min, lon1Sec, lon1Dec, AnyLon, coordSource, coordSourcePlus, coordAccuracy, coordAccuracyUnits, dateDD, dateMM, dateYYYY, fullLocation ) | |
| SELECT | |
| 'F-' & Fiel.id AS recID, | |
| Fiel.Expedition AS expdID, | |
| Team.[name for display] AS collector, | |
| Fiel.[Collector Number] AS collNumFull, | |
| LnSy.id AS lnamID, | |
| LnSy.[Full Name] AS acceptDetAs, | |
| LnSy.sortName AS acceptDetNoAuth, | |
| Lnam.[Full Name] AS detAs, |
If you were to give recommendations to your "little brother/sister" on things that they need to do to become a data scientist, what would those things be?
I think the "Data Science Venn Diagram" (http://drewconway.com/zia/2013/3/26/the-data-science-venn-diagram) is a great place to start. You need three things to be a good data scientist:
| # Compiled source # | |
| ################### | |
| *.com | |
| *.class | |
| *.dll | |
| *.exe | |
| *.o | |
| *.so | |
| # Packages # |
| library(vegan) | |
| library(labdsv) | |
| data(varespec) | |
| data(varechem) | |
| vare.cca <- cca(varespec ~ Baresoil+Humdepth+pH+N+P+K+Ca+Mg+S+Al+Fe, data=varechem) | |
| vare.cca | |
| plot(vare.cca) | |
| summary(vare.cca) |
