I spoke at this conference this Sunday July 26, 2015 http://www.iimnetwork.com/event-delhi-26-jul-15-pan-iim-alumni
3) Use new project mode from RStudio This helps to clean workflow management
5) Avoiding duplicates , remove prior copies and use gc() Memory management is key to use of R in production analytics.
6) Think object oriented. Forget other languages Think slice and dice and using $ and  and using apply versus for loops.
7) Use ? and ?? before you google and ask for help on Stack Overflow Seriously dude R has a lot of documentation! A Lot! Use it . Also see CRAN Views!
8) You are not too old to learn dplyr on Datacamp Skilling up and reskilling is part of being a data science hacker
9) Subscribe to R-bloggers and never miss out on a new package that helps solve your problems R has 8000+ packages and 150000 + functions. All you need is one function to cut down your analysis time and go home early
10) Profiling code, benchmark functions and byte compilation seperate grown up from the kids data scientists. Hadley says- http://adv-r.had.co.nz/Rcpp.html Hadley says-http://adv-r.had.co.nz/Profiling.html Enough said!
- Install MySQL
sudo apt-get install mysql-server
- Check if Server is Running
sudo netstat -tap | grep mysql
I use the MySQL command line to check it
mysql -h localhost -u root -p
To see databases
To see tables
mysql> show tables from mysql;
To quit mysql
- Install and load RMySQL from within R
- I connect using this
mydb = dbConnect(MySQL(),
port = 8018,
- I write sql queries using this
> dbGetQuery(mydb, "select * from servers")  Server_name Host Db Username Password  Port Socket Wrapper Owner <0 rows> (or 0-length row.names) > dbGetQuery(mydb, "select * from db")  Host Db  User Select_priv  Insert_priv Update_priv  Delete_priv Create_priv  Drop_priv Grant_priv  References_priv Index_priv  Alter_priv Create_tmp_table_priv  Lock_tables_priv Create_view_priv  Show_view_priv Create_routine_priv  Alter_routine_priv Execute_priv  Event_priv Trigger_priv <0 rows> (or 0-length row.names)