填补组中的缺失值 [英] Filling missing value in group

问题描述

我有一些值缺失的数据框

I have data frame where some of the values are missing

A 1
A NA
A NA
B NA
B 2
B NA
C NA
C NA
C NA

如何填写有数据的组?

推荐答案

替代解决方案，尽管在做多少个假设方面可能存在一些缺陷:

Alternative solution, though perhaps a bit flawed in how many assumptions it makes:

library(dplyr)
y %>%
  group_by(V1) %>%
  arrange(V2) %>%
  mutate(V2 = V2[1])
# Source: local data frame [9 x 2]
# Groups: V1 [3]
#      V1    V2
#   (chr) (int)
# 1     A     1
# 2     A     1
# 3     A     1
# 4     B     2
# 5     B     2
# 6     B     2
# 7     C    NA
# 8     C    NA
# 9     C    NA

这篇关于填补组中的缺失值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！