'Importing .csv WITHOUT the NA in empty cells

Six years ago this guy asked my question...

Getting rid of NA values in R when importing a CSV file

...but no final answer showed up because he never displayed his data

Here is an image of my data in a.csv file. If you need it as code, just say so and I will supply (I just used the RAND() function in Excel to create it).

Image of Data

There are no "missing values" in the usual sense. It just that some columns have more, others less. I will never need to invert so it need not be rectangular. All the "empty" cells are always at the bottom. AND rm.na does not work as I need to operate on each column separately with a special function that does not take rm.na as an argument. How can I import this into R with NOTHING in the cells which are empty. I have tried readxl, RStudio, using Excel instead of .csv, lots of different approaches. Most of them want me to eliminate rows with NA in them. That does not work, either.

Thanks for anyone who can help

import

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Importing .csv WITHOUT the NA in empty cells

Sources

Related Questions