Preventing R from interpreting text as numeric

Question

I am trying to import a CSV in R which has ZIP code information which R is interpreting as numeric when I need it to remain as character.

data = read.csv("zipCodeInformation.csv", stringsAsFactor = FALSE)

The data has the following format:

Lower.Zip, Upper.Zip, Zone
004,       005,       Zone.8
006,       007,       Zone.45
009,          ,       Zone.45
010,       089,       Zone.8
100,       339,       Zone.8

What happens right now is R interprets the first 2 columns as numeric and turns them into the following:

Lower.Zip, Upper.Zip, Zone
4,         5,         Zone.8
6,         7,         Zone.45
9,          ,         Zone.45
10,        89,        Zone.8
100,       339,       Zone.8

Joshua Ulrich · Accepted Answer · 2014-02-07 00:05:00Z

4

Use the colClasses argument to read.csv.

Data <- read.csv(text="Lower.Zip, Upper.Zip, Zone
004,       005,       Zone.8
006,       007,       Zone.45
009,          ,       Zone.45
010,       089,       Zone.8
100,       339,       Zone.8",
colClasses=rep("character",3))  # you may want to add strip.white=TRUE

answered Feb 7, 2014 at 0:05

Joshua Ulrich

177k33 gold badges357 silver badges429 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Preventing R from interpreting text as numeric

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related