Re: [R] Importing data with different delimters

From: jim holtman <jholtman_at_gmail.com>
Date: Fri, 13 Jun 2008 19:28:57 -0400

Assuming that the only problem is the blank in the city names, here is one way of doing it:

> inFile <- textConnection("City State JanTemp Lat Long

+ Mobile, AL      44      31.2    88.5
+ Montgomery, AL  38      32.9    86.8
+ Phoenix, AZ     35      33.6    112.5
+ Little Rock, AR 31      35.4    92.8
+ Los Angeles, CA 47      34.3    118.7
+ San Francisco, CA       42      38.4    123.0")

> lines <- readLines(inFile)
> # get rid of blanks in city names
> newLines <- sub("(.*?) +(.*),", "\\1_\\2,", lines)
>
> x <- read.table(textConnection(newLines), header=TRUE)
> closeAllConnections()
> x
            City State JanTemp  Lat  Long
1        Mobile,    AL      44 31.2  88.5
2    Montgomery,    AL      38 32.9  86.8
3       Phoenix,    AZ      35 33.6 112.5
4   Little_Rock,    AR      31 35.4  92.8
5   Los_Angeles,    CA      47 34.3 118.7
6 San_Francisco,    CA      42 38.4 123.0

>
>

If you want, you can then go back and replace the "_" with a blank in the city name.

On Fri, Jun 13, 2008 at 7:14 PM, David Arnold <dwarnold45_at_suddenlink.net> wrote:
> All,
>
> I have a data file with 56 entries that looks like this:
>
> City State JanTemp Lat Long
> Mobile, AL 44 31.2 88.5
> Montgomery, AL 38 32.9 86.8
> Phoenix, AZ 35 33.6 112.5
> Little Rock, AR 31 35.4 92.8
> Los Angeles, CA 47 34.3 118.7
> San Francisco, CA 42 38.4 123.0
>
> I would like to "read" this data into a dataframe. Is it possible to do
> without editing the datafile?
>
> D.
>
> ______________________________________________
> R-help_at_r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

-- 
Jim Holtman
Cincinnati, OH
+1 513 646 9390

What is the problem you are trying to solve?

______________________________________________
R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Received on Fri 13 Jun 2008 - 23:59:02 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Sat 14 Jun 2008 - 01:30:40 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive