Read dataframe with different number of spaces in between columns

Question

I want to import the following dataframe LINK.

It contains 8 columns that are separated by spaces. If I read it in with read.table(...,sep="") I have the problem that the 7th column contains names that can contain some white space as well, e.g. the third line: "Donaueschingen (Landeplatz)". Unfortunately column values are not quoted.

Is it still possible to import them?

Try `sep="\t"`, I downloaded the data pasted it into txt. and it worked — Adamm, Apr 01 '20 at 11:38
Does this answer your question? [Read fixed width text file](https://stackoverflow.com/questions/14383710/read-fixed-width-text-file) — broti, Apr 01 '20 at 11:50

score 0 · Accepted Answer · answered Apr 01 '20 at 11:38

0

I think you want to use read.fwf - it allows the reading of data with fixed width columns which is what you appear to have.

answered Apr 01 '20 at 11:38

James Curran

1,274
7
23

Read dataframe with different number of spaces in between columns

1 Answers1