On 30.07.2011 21:58, Jeffrey Joh wrote:
Sorry about the last message. I forgot to turn the HTML off.
I would like to reorder a table by column A,
df2 <- df[order(df$A),]
then fill column B with the values above it.
for (i in 1:nrow(df2)) {
if (is.na(df2$B[i]) | df2$B[i] == "NULL") df2$
fill column B with the
> values above it. For example:
> A B
> 2 54
> 5 NA
> 8 78
> 4 NULL
> 3 26
> 9 NULL
>
> First sort by column A:
> A B
> 2 54
> 3 26
> 4 NULL
> 5 NA
> 8 78
> 9 NULL
>
> Then replace null/n
Then replace null/na values in column B with the value above it:
A B
2 54
3 26
4 26
5 26
8 78
9 78
Jeff
> CC: r-help@r-project.org
> From: dwinsem...@comcast.net
> To: johjeff...@hotmail.com
> Subject: Re: [R] Replacing null values
> Date: Sat, 30 Jul 2011
On Jul 30, 2011, at 2:25 AM, Jeffrey Joh wrote:
I would like to reorder a two-column table by column A, then fill
column B with the values above it. For example: Original:A B2
545 NA8 784 NULL3 269 NULL First sort by column A:A
B2 543 264 NULL5 NA8 7
This doesn't sound like it would be too hard to do at all, but I really
can't read your table: could you resend the table and the desired
intermediate and final steps but format them more legibly?
Something like:
A B
2 545
NA8 784
NULL 3
269 NULL
assuming that is where you are starting.
I'm not
I would like to reorder a two-column table by column A, then fill column B with
the values above it. For example: Original:A B2 545 NA8 784 NULL3
269 NULL First sort by column A:A B2 543 264 NULL5 NA8
789 NULL Then replace null/na values in column B
6 matches
Mail list logo
