How to remove empty columns in R?

Question

I have a CSV file

Identity,Number,Data,Result,Add,,,,,,,,,,,,
1,,,,4,55,,92,,,,,,,,,62,
3,,,,7,43,,12,,,,,,,,,74,
7,,,,3,58,,52,,,,,,,,,64,
0,,,,6,10,,22,,,,,,,,,96,
3,,,,8,13,,92,,,,,,,,,22,

How to remove empty columns in R?

Desired Output

Identity,Number,Data,Result,Add
1,4,55,92,62
3,7,43,12,74
7,3,58,52,64
0,6,10,22,96
3,8,13,92,22

Answer 1

After you've imported your data (using the method the other answerer suggested) run this command, substituting mydf for whatever you decide to call your data frame:

#Remove empty columns
mydf <- Filter(function(x)!all(is.na(x)), mydf)