R - Remove blanks from data frame

Question

An example of the data frame I have is:

Index  TimeDifference
1        
2         
3            20
4      
5            67

I want to delete all rows that are blank (these are blank and NOT na). Hence the following data frame I want is:

Index     TimeDifference
3               20
5               67

Thanks

Please make your example reproducible. https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example — jogo, Mar 01 '18 at 13:58

DJack · Accepted Answer · 2018-03-01T14:12:02.627

3

Assuming that TimeDifference is a character column:

df <- data.frame(Index=1:5, TimeDifference=c("","","20","","67"))

Then you can use:

df[-which(df$TimeDifference==""),]

or

df[!(df$TimeDifference==""),]

or

df[df$TimeDifference!="",]

which gives:

  Index TimeDifference
3     3             20
5     5             67

edited Mar 01 '18 at 14:12

answered Mar 01 '18 at 13:58

DJack

score 0 · Answer 2 · answered Mar 01 '18 at 14:00

0

df <- df[as.character(df$TimeDifference)!= "" ,]

answered Mar 01 '18 at 14:00

Aleh

2 Answers2