Hello, I have a problem with using read.csv(). I want to read a table from the ONS neighborhood statistics website which has an address:
http://www.neighbourhood.statistics.gov.uk/dissemination/LeadTableView.do?a=3&b=5940246&c=Stoke&d=14&e=7&f=73&g=401878&i=1001x1003x1004x1005&l=145&o=1&m=0&r=1&s=1211997884568&enc=1&downloadTable=Download+this+table I was trying the following: #the parameter FamilyId I will need to change to get other datasets url1 <- paste(" http://www.neighbourhood.statistics.gov.uk/dissemination/LeadTableView.do?a=3&b=5940246&c=Stoke&d=14&e=7&f=73&g=401878&i=1001x1003x1004x1005&l=",FamilyId,"&o=1&m=0&r=1&s=1211997884568&enc=1&downloadTable=Download+this+table";, sep="") x <- read.csv(url1, header = FALSE, stringsAsFactors = FALSE) I was expecting x to be like this: # because that's the structure I get if I download the file to my computer and then try to use read.csv() 1 Housing Stock (UV53) 2 3 4 All Household Spaces 5 Occupied Household Spaces 6 Unoccupied Household Spaces 7 Unoccupied Household Spaces: Second residence / holiday accommodation 8 Unoccupied Household Spaces: Vacant household space 9 Housing Stock (UV53), Apr01 10 Housing Stock (UV53), Apr01 11 Housing Stock (UV53) 12 This material is Crown Copyright. Users are granted permission to reproduce Crown Copyright material provided that a Click-Use Licence has been obtained from HMSO. The Click-Use Licence can be obtained from http://www.clickanduse.hmso.gov.uk. When reproducing this material, the source should be acknowledged. V2 V3 V4 V5 V6 V7 V8 1 2 Stoke Plymouth South West England 3 Ward Unitary Authority Region Country 4 Count Households Apr01 5784 106583 2185966 21262825 5 Count Households Apr01 5472 102540 2085984 20451427 6 Count Households Apr01 312 4043 99982 811398 7 Count Households Apr01 21 336 38381 135202 8 Count Households Apr01 291 3707 61601 676196 9 LastUpdated 18 November 2004 10 Source Office for National Statistics 11 National Statistics 12 However, I get 107 lines of text. Here is a bit of it: 1 <!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01//EN http://www.w3.org/TR/html4/strict.dtd><html<http://www.w3.org/TR/html4/strict.dtd%3E%3Chtml> > 2 <head> 3 4 <meta http-equiv=Content-Type content=text/html; charset=iso-8859-1> 5 <meta name=robots content=no follow> 6 <..............> 105 </noscript> 106 </body> 107 </html> What am I doing wrong? Should this work? Thank you in advance. Aiste [[alternative HTML version deleted]] ______________________________________________ R-help@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.
