https://www.r-bloggers.com/r-tutorial-series-multiple-linear-regression/

https://www.statmethods.net/stats/regression.html

https://rcompanion.org/rcompanion/e_05.html

https://docs.microsoft.com/en-us/sql/advanced-analytics/tutorials/rtsql-create-a-predictive-model-r

library(XML)
theurl <- "http://finance.yahoo.com" tables <- readHTMLTable(theurl) n.rows <- unlist(lapply(tables, function(t) dim(t)[1])) the picked table is the longest one on the page lstRes <- tables[[which.max(n.rows)]] as.data.frame(lstRes)

DFcars[-(1:2),]
mtcars[-(1:2)]
use “-” negate the rows

First install the MySQL packcages

now, run the connection command to connect MySQL db on localhost

show the tables and show selected table fields

book1:page 26:
URL http://www2.census.gov/acs2011_1yr/pums/csv_pus.zip
URL http://www2.census.gov/acs2011_1yr/pums/csv_hus.zip

data was not properly loaded, no delimiter specified in the load data infile command when we run.

need to fix this:

First truncate the table, then modify the load data infile command add Fields terminated by “,” in the loading command. Check and see the data load correctly, do the same for Hus_b, pus_a, pus_b;

back to OS to compare the lines in files

table rows are exactly one less than the lines in files for each, yeeeeeeeeeee.

install.packages(“RMySQL”)
library(RMySQL)
Connecting to MySQL:
Once the RMySQL library is installed create a database connection object.

mydb = dbConnect(MySQL(), user=’user’, password=’password’, dbname=’database_name’, host=’host’)
Listing Tables and Fields:
Now that a connection has been made we list the tables and fields in the database we connected to.

dbListTables(mydb)

This will return a list of the tables in our connection.

dbListFields(mydb, ‘some_table’)

goog_hist_prices <- read.csv("http://ichart.finance.yahoo.com/table.csv?s=GOOG", header = TRUE, quote="\"", skip=0)

R – ggplot’s qplot executed but no graph showing up on sourcing

need to Call print explicitly

#code snippet
p <-ggplot(df, aes(x = dt, y = y)) + geom_point() + geom_point(data = ds, aes(y = mean), colour = 'red', size = 3) print(p)

R Studio how to clean console screen?

CTL^ + E THEN L

How to read from a url

here is an good example

example.3 <- read.table("http://www.unt.edu/rss/class/Jon/R_SC/Module3/ExampleData3.txt", header=TRUE, sep="", na.strings="NA", dec=".", strip.white=TRUE) summary(example.3)