<div dir="ltr">Hi Dila,<div><br></div><div>I think you have the wrong mailing list; this one is specifically for the data.table package. You can see some other mailing lists here:</div><div><a href="http://r.789695.n4.nabble.com/R-f789695.subapps.html">http://r.789695.n4.nabble.com/R-f789695.subapps.html</a><br>
</div><div><br></div><div>Since you only have one year to change, you can do something like</div><div><br></div><div>dat$Year <- ifelse(dat$Year==0,2000L,as.integer(dat$Year)+1900L)</div><div><br></div><div>You should run the right-hand side on its own first to make sure that it is giving the correct result. The <- will overwrite the original column, and the L and as.integer ensure that you store the new column as an integer.</div>
<div><br></div><div>For documentation, see for example help("<-") and help("ifelse")</div><div><br></div><div>Best,</div><div><br></div><div>Frank</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">
On Mon, Oct 28, 2013 at 2:18 AM, dila radi <span dir="ltr"><<a href="mailto:dila_radi21@yahoo.com" target="_blank">dila_radi21@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi all,<br>
<br>
I have this kind of data. The data consist from year 1971-2000.<br>
<br>
Station Station ID Year Month Day Rainfall Amount(mm)<br>
Kuantan 48657 71 1 1 125<br>
Kuantan 48657 71 1 2 130.3<br>
Kuantan 48657 71 1 3 327.2<br>
Kuantan 48657 71 1 4 252.2<br>
Kuantan 48657 71 1 5 33.8<br>
Kuantan 48657 71 1 6 6.1<br>
Kuantan 48657 71 1 7 5.1<br>
<br>
................................................................<br>
..............................................................<br>
................................................................<br>
................................................................<br>
<br>
Kuantan 48657 00 12 24 0<br>
Kuantan 48657 00 12 25 2.7<br>
Kuantan 48657 00 12 26 0<br>
Kuantan 48657 00 12 27 0<br>
Kuantan 48657 00 12 28 20<br>
Kuantan 48657 00 12 29 15.5<br>
Kuantan 48657 00 12 30 6.4<br>
Kuantan 48657 00 12 31 9.3<br>
<br>
When I run for the Summary, the third column (year) give the output as<br>
below:<br>
<br>
Year<br>
Min. : 0.00<br>
1st Qu.:77.00<br>
Median :84.00<br>
Mean :82.16<br>
3rd Qu.:92.00<br>
Max. :99.00<br>
<br>
The minimum should be 1971 and maximum is 2000. But R misinterpret 2000 as<br>
00 value.<br>
How I want to solve this?<br>
<br>
Thank you in advance.<br>
<br>
Regards,<br>
Dila.<br>
<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://r.789695.n4.nabble.com/Problem-in-reading-the-data-set-tp4679156.html" target="_blank">http://r.789695.n4.nabble.com/Problem-in-reading-the-data-set-tp4679156.html</a><br>
Sent from the datatable-help mailing list archive at Nabble.com.<br>
_______________________________________________<br>
datatable-help mailing list<br>
<a href="mailto:datatable-help@lists.r-forge.r-project.org">datatable-help@lists.r-forge.r-project.org</a><br>
<a href="https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help" target="_blank">https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help</a><br>
</blockquote></div><br></div>