Hi R-users,

I have missing data for the month. My question is how do I insert the missing month and fill up the cell with 'na' for the rain amount?  Then I would like to count the percentage of missing data.

No     Year     month rain
1398 1985    10 104.2
1399 1985    11 138.0
1400 1985    12 120.4
1401 1986     1  12.6
1402 1986     2  19.4
1403 1986     3   1.0
1404 1986     4  58.8
1405 1986     5  98.4
1406 1986     6  56.6
1407 1986     7 280.4
1408 1986     8 128.2
1409 1986     9 100.0
1410 1986    10 166.0
1411 1986    12  68.1
1412 1987     2  46.0
1413 1987     3  35.0
1414 1987     4  75.0
1415 1987     5  90.8
1416 1987     6 189.0
1417 1987     7 110.6
1418 1987     8  87.2
1419 1987     9  50.0
1420 1987    10  41.8
1421 1987    11  64.0
1422 1987    12  75..6
1423 1988     1  34.6
1424 1988     2  36.0
1425 1988     3  65..6
1426 1988     4  40.0
1427 1988     5 239.8
1428 1988     6 150.8
1429 1988     7 125.8
1430 1988     8  64.4
1431 1988     9  86.0
1432 1988    10  54.0
1433 1988    11 153.4
1434 1988    12 212.0
1435 1989     1  19.6
1436 1989     2  17.4
1437 1989     3 144.6
1438 1989     4 143.8
1439 1989     5 197.4
...

Then I would like to count the percentage of missing data.  I think I can use something like:

apply(Matrix, 1, function(x) sum(is.na(x))) / ncol(Matrix) * 100 

 
Or  rowMeans(is.na(Matrix))*100 --question asked in the R forum before.



Thank you so much for any help given.


      
	[[alternative HTML version deleted]]


