Monday, April 10, 2017

Map with R



How it really works in R ggplot2 


http://eriqande.github.io/rep-res-web/lectures/making-maps-with-R.html

You need to create data in following format:

                long      lat        group order region subregion
#> 1 -101.4078 29.74224     1     1   main      
#> 2 -101.3906 29.74224     1     2   main      
#> 3 -101.3620 29.65056     1     3   main      
#> 4 -101.3505 29.63911     1     4   main      
#> 5 -101.3219 29.63338     1     5   main      
#> 6 -101.3047 29.64484     1     6   main      


Some useful packages


  • ggmap
  • googleVis







Sunday, April 9, 2017

Teradata Tutorial




Import CSV file as a table in Teradata


1. First create the table you want with the structure of the file.

Create table dp_cad_analtyics.A
(
Testcol1 varchar(20)
, Testcol2 varchar(20)
);

2. Then modify the below query accordingly so that the number of question marks are equal to the number of columns

Insert into dp_cad_analytics.A
Values
(?,?);


3. Select the option of "import data" from the "File" menu and execute query. It will ask for the file.