tag:blogger.com,1999:blog-3524617892004055830.post3015539359275228614..comments2024-02-29T10:02:38.091+01:00Comments on Wiekvoet: Unemployment of Europe in 2014 by NUTS 2 regionWingfeethttp://www.blogger.com/profile/01585623097384646816noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-3524617892004055830.post-6458708000953674202015-06-01T22:27:02.271+02:002015-06-01T22:27:02.271+02:00Many many thanks for your help, Wiekvoet. I manage...Many many thanks for your help, Wiekvoet. I managed now and am very happy to have made the map, too.Anonymoushttps://www.blogger.com/profile/13897608052686210804noreply@blogger.comtag:blogger.com,1999:blog-3524617892004055830.post-36034067380360651882015-05-31T18:57:25.225+02:002015-05-31T18:57:25.225+02:00That is indeed sometimes difficult. The A1 cell re...That is indeed sometimes difficult. The A1 cell reads: Unemployment rates by sex, age and NUTS 2 regions (%) [lfst_r_lfu3rt]<br /><br />There are 9 rows with miscellaneous information. <br />Line 11 then, reads GEO/TIME 2010 2011 2012 2013 2014 for the first six columns.<br />It is obvious that the latter columns contain the data. The GEO/TIME column contains codes for the region. It has to be codes, since that is what the shapefile has.My first row has EU28 for the whole EU. It then continues with EU27 etc. Wingfeethttps://www.blogger.com/profile/01585623097384646816noreply@blogger.comtag:blogger.com,1999:blog-3524617892004055830.post-85122021890777947102015-05-30T23:16:15.876+02:002015-05-30T23:16:15.876+02:00Hi Wingfeet,
it is me again, this time with real n...Hi Wingfeet,<br />it is me again, this time with real name, always intrigued by your nice visualisation. <br />From the Eurostat website, it seems that the file lfst_r_lfu3rt.csv is available in many variants and am not sure which is the right one. <br />Can you show me please the head of your file lfst_r_lfu3rt.csv, so that I make it like yours. Thanks in advance<br />Anonymoushttps://www.blogger.com/profile/13897608052686210804noreply@blogger.comtag:blogger.com,1999:blog-3524617892004055830.post-58060992717627231102015-05-29T20:40:55.163+02:002015-05-29T20:40:55.163+02:00Hi Wingfeet,
I found the file on the Eurostat webs...Hi Wingfeet,<br />I found the file on the Eurostat website. So thanks.<br />Anonymoushttps://www.blogger.com/profile/13897608052686210804noreply@blogger.comtag:blogger.com,1999:blog-3524617892004055830.post-32814433233969299052015-05-29T00:05:16.098+02:002015-05-29T00:05:16.098+02:00Hi Wingfeet,
yes, it helped and I was able to make...Hi Wingfeet,<br />yes, it helped and I was able to make progress, thanks a lot. <br />Unfortunately now I am stuck again because I do not know from where you get the following file from lfst_r_lfu3rt.csv<br /><br />Please help me once again. I looked on the internet, but the casual file I found does has not have the column titles set in line with the following code:<br /><br />> EUN@data = data.frame(EUN@data[,1:4], myunempl[<br />+ match(EUN@data[, "NUTS_ID"],myunempl[, "GEO.TIME"]), ])<br /><br />This is the exact point I am hanging again. Thanks again for helping thus far.Anonymoushttps://www.blogger.com/profile/13897608052686210804noreply@blogger.comtag:blogger.com,1999:blog-3524617892004055830.post-89661812675130585762015-05-28T22:04:56.394+02:002015-05-28T22:04:56.394+02:00Hi Sailor man,
I think there are two problems. On...Hi Sailor man,<br /><br />I think there are two problems. One is that I accidentally commented out a bit too much to avoid unnecessary downloading. The following three lines should not have been commented:<br /><br /> temp <- tempfile(fileext = ".zip")<br />download.file("http://ec.europa.eu/eurostat/cache/GISCO/geodatafiles/NUTS_2010_60M_SH.zip",temp)<br />unzip(temp)<br /><br />The other problem is that somehow an additional directory level is needed in that call to readOGR(). The why for that eludes me.<br /><br />EU_NUTS <- readOGR(dsn = "./NUTS_2010_60M_SH/NUTS_2010_60M_SH/data", layer = "NUTS_RG_60M_2010")<br /><br /><br />Does that help? Wingfeethttps://www.blogger.com/profile/01585623097384646816noreply@blogger.comtag:blogger.com,1999:blog-3524617892004055830.post-85949260079632692872015-05-27T22:31:36.806+02:002015-05-27T22:31:36.806+02:00Sorry, to avoid most obvious I have also just upgr...Sorry, to avoid most obvious I have also just upgraded to <br /><br />R version 3.1.3 (2015-03-09) -- "Smooth Sidewalk"<br />Copyright (C) 2015 The R Foundation for Statistical Computing<br />Platform: x86_64-apple-darwin10.8.0 (64-bit)<br /><br />but the error is still the same as above.Anonymoushttps://www.blogger.com/profile/13897608052686210804noreply@blogger.comtag:blogger.com,1999:blog-3524617892004055830.post-3975395619860234002015-05-27T22:03:52.983+02:002015-05-27T22:03:52.983+02:00Hi Wiekvoet,
thanks for sharing your interesting ...Hi Wiekvoet,<br /><br />thanks for sharing your interesting code. I have been trying to run your code, but admittedly I am a junior to R. So if you could help me out, I would appreciate it.<br /><br />It hangs very early with the following:<br />> EU_NUTS <- readOGR(dsn = "./NUTS_2010_60M_SH/data", layer = "NUTS_RG_60M_2010")<br />Error in ogrInfo(dsn = dsn, layer = layer, encoding = encoding, use_iconv = use_iconv, : <br /> Cannot open file<br /><br />The rgdal library was installed:<br /><br />> library(rgdal)<br />Loading required package: sp<br />rgdal: version: 0.9-2, (SVN revision 526)<br />Geospatial Data Abstraction Library extensions to R successfully loaded<br />Loaded GDAL runtime: GDAL 1.9.2, released 2012/10/08<br />Path to GDAL shared files: /Library/Frameworks/R.framework/Versions/3.1/Resources/library/rgdal/gdal<br />Loaded PROJ.4 runtime: Rel. 4.8.0, 6 March 2012, [PJ_VERSION: 480]<br />Path to PROJ.4 shared files: /Library/Frameworks/R.framework/Versions/3.1/Resources/library/rgdal/proj<br />Warning messages:<br />1: package ‘rgdal’ was built under R version 3.1.3 <br />2: package ‘sp’ was built under R version 3.1.3 <br /><br />I have R installed:<br />R version 3.1.2 (2014-10-31) -- "Pumpkin Helmet"<br />Copyright (C) 2014 The R Foundation for Statistical Computing<br />Platform: x86_64-apple-darwin10.8.0 (64-bit)<br /><br />Can you help, please, thanks.Anonymoushttps://www.blogger.com/profile/13897608052686210804noreply@blogger.comtag:blogger.com,1999:blog-3524617892004055830.post-27665921789037153672015-04-27T18:29:32.612+02:002015-04-27T18:29:32.612+02:00Thanks for sharing. I found this very interesting....Thanks for sharing. I found this very interesting. I would find it easier to interpret the colors with a color scheme associated with discrete steps in the data, e.g. unemployment rote between 0 and 10% in green shades, between 10% and 20% in blue shades, etc. instead of the dividsion into 4 shades you currently have. It looks like a straightforward tweak inside of the rgb() function would do it. Will report back if I can tweak that in finite time. Thanks!Patrickhttps://www.blogger.com/profile/06658507365116962150noreply@blogger.com