Re: [R] Using NULL to my data?

From: Nilza BARROS <nilzabarros_at_gmail.com>
Date: Mon, 09 May 2011 16:42:01 -0300

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 <ggrothendieck_at_gmail.com>wrote:

> On Mon, May 9, 2011 at 12:59 PM, Nilza BARROS <nilzabarros@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_at_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.

Received on Mon 09 May 2011 - 19:44:39 GMT

This quarter's messages: by month, or sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

All messages

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Mon 09 May 2011 - 20:10:06 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive