rread.tableapostropheread.csv

How to account for single apostrophe/quotation in read.table?


I have the following data frame:

1            1                                        What percent of the world\xd5s population is between 15 and 64 years old?
2            2                                               What percent of the world\xd5s airports are in the United States? 
3            3                                            The area of the USA is what percent of the area of the Pacific Ocean?
4            4                                                      What percent of the earth\xd5s surface is covered by water?
5            5 What percent of the goods exported worldwide are mineral fuels (including oil, coal, gas, and refined products)?
6            6                    What percent of the world\xd5s countries have a higher fertility rate than the United States?
7            7                        What percent of the worldwide gross domestic product (GDP) comes from the service sector?
8            8                                    What percent of the worldwide income does the richest 10% of households earn?
9            9      What percent of the worldwide gross domestic product (GDP) is re-invested (\xd2gross fixed investment\xd3)?
10          10                                      What percent of the worldwide labor force works in the agricultural sector?
11          11                                             What percent of the worldwide land mass is not used for agriculture?
12          12                           What percent of the world\xd5s population speaks Mandarin Chinese as a first language?
13          13                What percentage of the world\xd5s countries have a higher life expectancy than the United States?
14          14                             What percent of the world\xd5s population aged 15 years or older can read and write?
15          15      What percent of the worldwide gross domestic product (GDP) is used for the military (military expenditure)?
16          16                                                    Saudi Arabia consumes what percentage of the oil it produces?
17          17                   What percent of the world\xd5s population lives in either China, India, or the European Union?
18          18                                                          What percent of the world\xd5s population is Christian?
19          19                                                               What percent of the world\xd5s roads are in India?
20          20                         What percent of the world\xd5s telephone lines are in China, USA, or the European Union?

There is supposed to be an apostrophe in each question for possessive words like, world's or earth's and it is reading differently than I would like, as you can see. I was trying expressions like this DF <- read.table("mydata.csv", header=TRUE, sep="\t", quote="") to no avail. Surprisingly, it is extremely difficult to find an answer to this issue.


Solution

  • I ended up finding an answer with DF1 <- read.csv("mydata.csv", header=TRUE, sep=",", quote="")