Displaying 2 results from an estimated 2 matches for "station_no".
Did you mean:
station_id
2011 May 16
2
File to MYSQL
Dear R-user,
I have to feed my database using some SQL commands. I have already read a
data frame with the data I need but
after that these data should be write in a file wtih SQL commands.
1) My dataframe:
dput(Alldados)
structure(list(Station_NO = c(836490, 836920, 836950, 836980,
837380, 837460), TMAX_2M = c("NULL", "NULL", "NULL", "NULL",
"NULL", "NULL"), TMIN_2M = c("20.6", "15.5", "18.1", "19.9",
"17", "21.5"), TD_2M...
2011 May 09
2
Using NULL to my data?
...9/1200 26.9 NA 23.4 24.1 1010.2 2.91 2
4 360 2.00 6.0 NA NA NA NA NA 2
5 821130 110429/1200 24.3 NA 23.3 23.7 NA 1.94 3
6 230 3.00 4.0 NA NA NA NA NA 3
=============
After some procedures a have the data as 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 NA 22.4 22.2 NA 0.00 0
2 820980 110429/1200 26.9 NA 23.4 24.1 1010.2 2.91 360
3 821130 110429/1200 24.3 NA 23.3 23.7 NA 1.94 230
4 821410 110429/...