Learn R Programming

expss (version 0.11.6)

text_to_columns: Make data.frame from text

Description

Convert delimited text lines to data.frame. Blank lines are always skipped, trailing whitespaces are trimmed. You can use comments with '#' inside your text. For details see read.table.

Usage

text_to_columns(
  text,
  header = TRUE,
  sep = "",
  quote = "",
  dec = ".",
  encoding = "unknown",
  ...
)

text_to_columns_csv( text, header = TRUE, sep = ",", quote = "", dec = ".", encoding = "unknown", ... )

text_to_columns_csv2( text, header = TRUE, sep = ";", quote = "", dec = ",", encoding = "unknown", ... )

text_to_columns_tab( text, header = TRUE, sep = "\t", quote = "", dec = ".", encoding = "unknown", ... )

text_to_columns_tab2( text, header = TRUE, sep = "\t", quote = "", dec = ",", encoding = "unknown", ... )

Value

data.frame

Arguments

text

character/vector of characters

header

a logical value indicating whether the text contains the names of the variables as its first line.

sep

the field separator character. Values on each line of the file are separated by this character. If sep = "" (the default for text_to_columns) the separator is 'white space', that is one or more spaces, tabs, newlines or carriage returns.

quote

the set of quoting characters. To disable quoting altogether, use quote = "".

dec

the character used in the file for decimal points.

encoding

encoding to be assumed for input strings. It is used to mark character strings as known to be in Latin-1 or UTF-8 (see read.table).

...

further parameters which will be passed to read.table.

Examples

Run this code
text_to_columns("
# simple data.frame 
     a b   c
     1 2.5 a
     4 5.5 b
     7 8.5 c
")

Run the code above in your browser using DataLab