All, A friend of mine would like to use this data with his stats class: http://www.worldatlas.com/aatlas/populations/usapoptable.htm I can't figure a way of capturing this data due to the mysql commands in the source code. Any thoughts? David. -- View this message in context: http://r.789695.n4.nabble.com/Downloading-a-html-table-tp4647091.html Sent from the R help mailing list archive at Nabble.com.
Downloading a html table
4 messages · David Arnold, Rolf Turner, David L Carlson +1 more
On 23/10/12 16:17, David Arnold wrote:
All, A friend of mine would like to use this data with his stats class: http://www.worldatlas.com/aatlas/populations/usapoptable.htm I can't figure a way of capturing this data due to the mysql commands in the source code. Any thoughts?
Copying and pasting, and then editing the resulting file just a wee bit
(changing
the blanks in state names to underscores) gave me a file that was readily
readable by read.table().
Is the column of state populations really blank? Or is there something
funny happening with my web browser?
cheers,
Rolf Turner
Copy the table data (leave out the column headings and the total line at the bottom) into the clipboard. Then
Dta <- read.delim("clipboard", header=FALSE, stringsAsFactors=FALSE)
colnames(Dta) <- c("No", "State", "Abbrev", "Population", "Area.km",
"PopDensity.km", "Area.mi", "PopDensity.mi")
rownames(Dta) <- Dta$No
Dta$No <- NULL
Dta <- transform(Dta, Area.km=as.numeric(gsub(",", "", Area.km)),
Area.mi=as.numeric(gsub(",", "", Area.mi)),
PopDensity.mi=as.numeric(gsub(",", "", PopDensity.mi)))
Dta <- transform(Dta, Population=Area.km*PopDensity.km)
The last line computes the Population from the Area and Population Density. ---------------------------------------------- David L Carlson Associate Professor of Anthropology Texas A&M University College Station, TX 77843-4352
-----Original Message----- From: r-help-bounces at r-project.org [mailto:r-help-bounces at r- project.org] On Behalf Of Rolf Turner Sent: Monday, October 22, 2012 10:47 PM To: David Arnold Cc: r-help at r-project.org Subject: Re: [R] Downloading a html table On 23/10/12 16:17, David Arnold wrote:
All, A friend of mine would like to use this data with his stats class: http://www.worldatlas.com/aatlas/populations/usapoptable.htm I can't figure a way of capturing this data due to the mysql commands
in the
source code. Any thoughts?
Copying and pasting, and then editing the resulting file just a wee bit
(changing
the blanks in state names to underscores) gave me a file that was
readily
readable by read.table().
Is the column of state populations really blank? Or is there something
funny happening with my web browser?
cheers,
Rolf Turner
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting- guide.html and provide commented, minimal, self-contained, reproducible code.
Rather than requiring manual tweaking,
library(XML)
readHTMLTable("http://www.worldatlas.com/aatlas/populations/usapoptable.htm")
will do the job for us.
D.
On 10/22/12 8:17 PM, David Arnold wrote:
All, A friend of mine would like to use this data with his stats class: http://www.worldatlas.com/aatlas/populations/usapoptable.htm I can't figure a way of capturing this data due to the mysql commands in the source code. Any thoughts? David. -- View this message in context: http://r.789695.n4.nabble.com/Downloading-a-html-table-tp4647091.html Sent from the R help mailing list archive at Nabble.com.
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.