Databases
StackOverflow2013
Postsdbo
POCreate World Map with Date Variable
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCreate World Map with Date Variable
    primarykey
    data
    text
    <p>I am trying to create two versions of the world map with one data table. The columns of the data table are: Country Name iso3 FormDate The FormDate variable is a date - in this case, the date the country was officially formed. (as seen here - <a href="http://en.wikipedia.org/wiki/List_of_sovereign_states_by_date_of_formation" rel="nofollow noreferrer">http://en.wikipedia.org/wiki/List_of_sovereign_states_by_date_of_formation</a>)</p> <pre><code>formdate &lt;- read.table(text=" ISO3\tCountry\tFormation Date DZA\tAlgeria\t07-03-1962 AGO\tAngola\t11-11-1975 BWA\tBotswana\t09-30-1966 CMR\tCameroon\t01-01-1960 BGD\tBangladesh\t03-26-1971 IND\tIndia\t08-15-1947 ISR\tIsrael\t05-14-1948 LOS\tLaos\t10-22-1953 MYS\tMalaysia\t09-16-1963 SGP\tSingapore\t08-09-1965" ,sep="\t",header=TRUE) &gt; formdate ISO3 Country Formation.Date 1 DZA Algeria 07-03-1962 2 AGO Angola 11-11-1975 3 BWA Botswana 09-30-1966 4 CMR Cameroon 01-01-1960 5 BGD Bangladesh 03-26-1971 6 IND India 08-15-1947 7 ISR Israel 05-14-1948 8 LOS Laos 10-22-1953 9 MYS Malaysia 09-16-1963 10 SGP Singapore 08-09-1965 </code></pre> <p>The maps I would like to create are:</p> <p>1: a summary map with each country color-coded by its year of formation, binned automatically in say 5-7 categories.</p> <p>2: a 3-fold facet map, with separate panels showing independent countries born by 1945, after 1945 up to 1965 and anytime after that. Trouble is that I would love to be able to change these cutoff years. </p> <p>This question is related to <a href="https://stackoverflow.com/questions/9096306/using-r-maps-package-colouring-in-specific-nations-on-a-world-map/9102797#9102797">Using [R] maps package - colouring in specific nations on a world map</a>, <a href="https://stackoverflow.com/questions/10423025/rscript-to-create-world-map-with-own-values">RScript to create World Map with own values</a> and <a href="https://stackoverflow.com/questions/11225343/how-to-create-a-world-map-in-r-with-specific-countries-filled-in">How to create a world map in R with specific countries filled in?</a>, like those I am also trying to create a map with own values.</p> <p>The difference here is that I need to use a date variable, and specifically, to plot binned values of those dates.</p> <p>Help and advice would be very appreciated. </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USuser2627717
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCreate World Map with Date Variable
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COYou need to show the code you've already attempted and provide your data (e.g., with `dput`).
      singulars
      1. POCreate World Map with Date Variable
      1. USThomas
    2. COThanks. I added a short version of the data table. I thought it would be easier on readers if I did not include code, I have nothing better than the ones in the links above.
      singulars
      1. POCreate World Map with Date Variable
      1. USuser2627717
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload