[R] A simple string alienation question.

Erich Subscriptions er|ch@@ub@ @end|ng |rom neuw|rth@pr|v@@t
Tue Apr 14 17:40:45 CEST 2020


read.csv has parameters sep, quote and dec
You have to get these right to represent the structure of you input file.

> On 14.04.2020, at 11:28, Sam Charya via R-help <r-help using r-project.org> wrote:
> 
> 
> 
> Hello Dear R Community,
> I would ask a little bit of help from you please:I have a dataset, which is in a CSV file – I have read it into R as follows: 
>                  V11   tropical fruit"2       whole milk"3        pip fruit"4 other vegetables"5       whole milk"6       rolls/buns"
> The issue is: the data set in Csv file also appears with the quotation marks “. I can’t get rid of the quotation marks. I want to do it in R. The Quotes only appear at the end of the string. The dataset has many rows – this is just a copy. My intention is to be able to get rid of the quotes and then want to separate the strings with a ‘/’. i.e. rolls/buns should be rolls in one column and buns in another.
> I know this is something very simple I am lacking – but if you could please show me how to do this? If someone could throw some light please. I read the data in with a simple read.csv statement: 
>  calc <- read.csv("Fight.csv", stringsAsFactors = F, header = F)  str(x) 
> Output: > str(calc)'data.frame': 38765 obs. of  1 variable: $ V1: chr  "tropical fruit\"" "whole milk\"" "pip fruit\"" "other vegetables\"" ...
> Many Thanks in advance for your help.
> Kind Regards,
> Sam. 
> 
> 
> 
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.



More information about the R-help mailing list