Shifting non-NA cells to the left

by

You can use the standard apply function:

df=data.frame(x=c("l","m",NA,NA,"p"),y=c(NA,"b","c",NA,NA),z=c("u",NA,"w","x","y"))
df2 = as.data.frame(t(apply(df,1, function(x) { return(c(x[!is.na(x)],x[is.na(x)]) )} )))
colnames(df2) = colnames(df)

> df
     x    y    z
1    l <NA>    u
2    m    b <NA>
3 <NA>    c    w
4 <NA> <NA>    x
5    p <NA>    y
> df2
  x    y    z
1 l    u <NA>
2 m    b <NA>
3 c    w <NA>
4 x <NA> <NA>
5 p    y <NA>

More Related Contents:

  1. Split delimited strings in a column and insert as new rows [duplicate]
  2. Dynamically select data frame columns using $ and a character value
  3. Simultaneously merge multiple data.frames in a list
  4. Drop unused factor levels in a subsetted data frame
  5. Merging a lot of data.frames [duplicate]
  6. Create a group number for each consecutive sequence
  7. Repeat rows of a data.frame N times
  8. For each row in an R dataframe
  9. Replace all occurrences of a string in a data frame
  10. Convert Named Character Vector to data.frame
  11. How to add a cumulative column to an R dataframe using dplyr?
  12. Get last row of each group in R [duplicate]
  13. Create empty data frame with column names by assigning a string vector? [duplicate]
  14. Add extra level to factors in dataframe
  15. Dataframe create new column based on other columns
  16. What is about the first column in R’s dataset mtcars?
  17. Determine the data types of a data frame’s columns
  18. finding close match from data frame 1 in data fame 2
  19. Combine several data frames in the global environment by row (rbind)
  20. Changing Million/Billion abbreviations into actual numbers? ie. 5.12M -> 5,120,000 [duplicate]
  21. Extract text after “/” in a data frame column
  22. What is difference between dataframe and list in R?
  23. Define dimensions of an empty dataframe
  24. use multiple columns as variables with sapply
  25. Merge overlapping ranges into unique groups, in dataframe
  26. Deleting specific rows from a data frame
  27. Count number of non-NA values for every column in a dataframe [duplicate]
  28. Count unique values for every column
  29. What you can do with a data.frame that you can’t with a data.table?
  30. Override column types when importing data using readr::read_csv() when there are many columns

Leave a Comment