Error while converting to numeric

[badluckmath]

So, i'm trying to convert some Data to numeric of Clicks, impressions, etc on ADS.

When i do this, the N/A rows are converted into Error and you can see below:

Here, you can see a converted column (Impressions) and a must-be-coverted Columns  ( Clicks,etc.)

[AnkitKukreja · Accepted solution]

Hi @badluckmath 

This is giving error because of obvious reason i.e. NA cannot be converted to number.
As a best practice I convert NA to '0' before converting it to numeric format or I give it a random number '9999' to identify these later on in your analysis.

Thanks,
Ankit Kukreja

LinkedIn