Dear Gabor,
Thanks for your help. I was trying to do what you ask me and I've found the
solution.
> with(teste,sprintf("INSERT INTO OBS (date,T_2M,TMAX_2M,TMIN_2M) VALUES
(%s, %5.2f, %5.2f, %5.2f,%s)",date2,T_2M,TMAX_2M,TMIN_2M,Station_NO))
Error in sprintf("INSERT INTO OBS (date,T_2M,TMAX_2M,TMIN_2M) VALUES (%s,
%5.2f, %5.2f, %5.2f,%s)", :
invalid format '%5.2f'; use format %s for character objects
>
>
> with(teste,sprintf("INSERT INTO OBS (date,T_2M,TMAX_2M,TMIN_2M) VALUES
(%s, %s, %s, %s,%s)",date2,T_2M,TMAX_2M,TMIN_2M,Station_NO))
[1] "INSERT INTO OBS (date,T_2M,TMAX_2M,TMIN_2M) VALUES (2011042912, 22.5,
NULL, 22.4,820420)"
[2] "INSERT INTO OBS (date,T_2M,TMAX_2M,TMIN_2M) VALUES (2011042912, 26.9,
NULL, 23.4,820980)"
[3] "INSERT INTO OBS (date,T_2M,TMAX_2M,TMIN_2M) VALUES (2011042912, 24.3,
NULL, 23.3,821130)"
[4] "INSERT INTO OBS (date,T_2M,TMAX_2M,TMIN_2M) VALUES (2011042912, 24.4,
NULL, 23.7,821410)"
[5] "INSERT INTO OBS (date,T_2M,TMAX_2M,TMIN_2M) VALUES (2011042912, 28.2,
NULL, 21.1,821450)"
[6] "INSERT INTO OBS (date,T_2M,TMAX_2M,TMIN_2M) VALUES (2011042912, 23.3,
NULL, 22.8,821810)"
On Mon, May 9, 2011 at 2:05 PM, Gabor Grothendieck
<ggrothendi...@gmail.com>wrote:
> On Mon, May 9, 2011 at 12:59 PM, Nilza BARROS <nilzabar...@gmail.com>
> wrote:
> > Hi, Thanks for your attentio.
> >
> > I have the data frame below:
> > ====
> >> head(Alldados)
> > Station_NO date1 T_2M TMAX_2M TMIN_2M TD_2M PS FF_10M DD_10M
> > 1 820420 110429/1200 22.5 NULL 22.4 22.2 NULL 0 0
> > 2 820980 110429/1200 26.9 NULL 23.4 24.1 1010.2 2.91 360
> > 3 821130 110429/1200 24.3 NULL 23.3 23.7 NULL 1.94 230
> > 4 821410 110429/1200 24.4 NULL 23.7 24.2 1011.8 2.91 270
> > 5 821450 110429/1200 28.2 NULL 21.1 25.8 1008.8 0 0
> > 6 821810 110429/1200 23.3 NULL 22.8 22.9 1001.6 0 0
> > TOT_PRCP CLCL date2
> > 1 84.00 NULL 2011042912
> > 2 2.00 NULL 2011042912
> > 3 3.00 NULL 2011042912
> > 4 12.00 NULL 2011042912
> > 5 6.00 NULL 2011042912
> > 6 38.00 NULL 2011042912
> > ====
> > Now each line will feed my database. So I need to format each line like
> > below:
> >
> > ===================================
> > [1] "INSERT INTO OBS
> >
> (date,T_2M,TMAX_2M,TMIN_2M,TD_2M,PS,FF_10M,DD_10M,TOT_PRCP,CLCL,Station_NO)
> > VALUES (2011042912, 22.50, NA, 22.40,22.20, NA, 0.00, 0.00,36.00,
> > NA,820420)"
> > [2] "INSERT INTO OBS
> >
> (date,T_2M,TMAX_2M,TMIN_2M,TD_2M,PS,FF_10M,DD_10M,TOT_PRCP,CLCL,Station_NO)
> > VALUES (2011042912, 26.90, NA, 23.40,24.10,1010.20, 2.91,360.00,16.00,
> > NA,820980)"
> > [3] "INSERT INTO OBS
> >
> (date,T_2M,TMAX_2M,TMIN_2M,TD_2M,PS,FF_10M,DD_10M,TOT_PRCP,CLCL,Station_NO)
> > VALUES (2011042912, 24.30, NA, 23.30,23.70, NA, 1.94,230.00,19.00,
> > NA,821130)"
> > [4] "INSERT INTO OBS
> >
> (date,T_2M,TMAX_2M,TMIN_2M,TD_2M,PS,FF_10M,DD_10M,TOT_PRCP,CLCL,Station_NO)
> > VALUES (2011042912, 24.40, NA, 23.70,24.20,1011.80, 2.91,270.00,12.00,
> > NA,821410)"
> > [5] "INSERT INTO OBS
> >
> (date,T_2M,TMAX_2M,TMIN_2M,TD_2M,PS,FF_10M,DD_10M,TOT_PRCP,CLCL,Station_NO)
> > VALUES (2011042912, 28.20, NA, 21.10,25.80,1008.80, 0.00, 0.00,31.00,
> > NA,821450)"
> > [6] "INSERT INTO OBS
> >
> (date,T_2M,TMAX_2M,TMIN_2M,TD_2M,PS,FF_10M,DD_10M,TOT_PRCP,CLCL,Station_NO)
> > VALUES (2011042912, 23.30, NA, 22.80,22.90,1001.60, 0.00, 0.00,24.00,
> > NA,821810)"
> > [7] "INSERT INTO OBS
> > ===============
> >
>
> Please
>
> 1. reduce Allados to a smaller number of columns and rows. Say 10
> rows and 3 columns such that it still exhibits the problem and then
> show the result of dput:
>
> dput(smallDF)
>
> 2. provide the R code that you would use with smallDF
>
> 3. explain what the problem is and how that differs from what you expect.
>
> --
> Statistics & Software Consulting
> GKX Group, GKX Associates Inc.
> tel: 1-877-GKX-GROUP
> email: ggrothendieck at gmail.com
>
--
Abraço,
Nilza Barros
[[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.
